|
|
using System;
|
|
|
using System.Collections.Generic;
|
|
|
using System.Data;
|
|
|
using System.Linq;
|
|
|
using System.Web;
|
|
|
using System.Web.UI;
|
|
|
using System.Web.UI.WebControls;
|
|
|
using BLL.CardBill;
|
|
|
using BLL.Sys;
|
|
|
using CPCBILLSYS.Common;
|
|
|
using Ext.Net;
|
|
|
using Model;
|
|
|
|
|
|
namespace CPCBILLSYS
|
|
|
{
|
|
|
public partial class PaperPanCunMg : System.Web.UI.Page
|
|
|
{
|
|
|
LogClass log = new LogClass();
|
|
|
/// <summary>
|
|
|
/// 基础
|
|
|
/// </summary>
|
|
|
DictionaryBLL dicbll = new DictionaryBLL(CommonHelper._dbType, CommonHelper.DbConStr);
|
|
|
/// <summary>
|
|
|
/// 纸券
|
|
|
/// </summary>
|
|
|
PaperBLL paperbll = new PaperBLL(CommonHelper._dbType, CommonHelper.DbConStr);
|
|
|
protected void Page_Load(object sender, EventArgs e)
|
|
|
{
|
|
|
if (!IsPostBack)
|
|
|
{
|
|
|
if (CommonHelper._userType == "3")
|
|
|
{
|
|
|
if (string.IsNullOrEmpty(Request.QueryString["userId"]) || string.IsNullOrEmpty(Request.QueryString["userName"]))
|
|
|
{
|
|
|
Response.Write("<script>alert('错误的访问！');window.location.href='http://10.15.0.36:9996'</script>");
|
|
|
return;
|
|
|
}
|
|
|
try
|
|
|
{
|
|
|
hdUserId.Value = Request.QueryString["userId"].ToString();
|
|
|
hdMan.Value = HttpUtility.UrlDecode(Request.QueryString["userName"].ToString());
|
|
|
}
|
|
|
catch
|
|
|
{
|
|
|
Response.Write("<script>alert('数据库访问异常！');window.location.href='http://10.15.0.36:9996'</script>");
|
|
|
return;
|
|
|
}
|
|
|
|
|
|
//hdUserId.Value = "1";
|
|
|
//hdMan.Value = "武俊涛";
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
if (Session["UserID"] == null || Session["SysID"] == null || Session["MAN"] == null)
|
|
|
{
|
|
|
Response.Write("<script>alert('错误的访问！');window.location.href='../Default.aspx'</script>");
|
|
|
return;
|
|
|
}
|
|
|
hdUserId.Value = Session["UserID"].ToString();
|
|
|
hdMan.Value = Session["MAN"].ToString();
|
|
|
}
|
|
|
|
|
|
s_txtPcStDt.Value = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
|
|
|
s_txtPcEndDt.Value = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
|
|
|
s_txtStartDt.Value = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
|
|
|
s_txtEndDt.Value = DateTime.Now.AddDays(1).ToString("yyyy-MM-dd");
|
|
|
StPCInfo.AutoLoadParams.Add(new Ext.Net.Parameter("Start", "0"));
|
|
|
StPCInfo.AutoLoadParams.Add(new Ext.Net.Parameter("Limit", Paging.PageSize.ToString()));
|
|
|
|
|
|
BindSub();
|
|
|
//BindBillType();
|
|
|
//if (CommonHelper._userType == "1")
|
|
|
//{
|
|
|
// btnDelete.Hide();
|
|
|
//}
|
|
|
}
|
|
|
}
|
|
|
|
|
|
#region 绑定数据
|
|
|
/// <summary>
|
|
|
/// 票据类型
|
|
|
/// </summary>
|
|
|
public void BindBillType()
|
|
|
{
|
|
|
stBillType.DataSource = dicbll.GetCBKind(" and VALUE in(3,4)");
|
|
|
stBillType.DataBind();
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 绑定站
|
|
|
/// </summary>
|
|
|
public void BindSub()
|
|
|
{
|
|
|
if (CommonHelper._userType == "1")
|
|
|
{
|
|
|
//s_cmbSubcom.Disabled = true;
|
|
|
//s_cmbSta.Disabled = true;
|
|
|
s_cmbSubcom.Hidden = true;
|
|
|
s_cmbSta.Hidden = true;
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
DataTable dt = dicbll.GetSubCompany("");
|
|
|
DataRow dr = dt.NewRow();
|
|
|
dr["SUBCOMNO"] = 1;
|
|
|
dr["SUBCOMNAME"] = "总公司";
|
|
|
dt.Rows.Add(dr);
|
|
|
storeSubCompany.DataSource = dt;
|
|
|
}
|
|
|
storeSubCompany.DataBind();
|
|
|
}
|
|
|
|
|
|
protected void s_cmbSubcom_Select(object sender, Ext.Net.DirectEventArgs e)
|
|
|
{
|
|
|
if (s_cmbSubcom.SelectedItem.Value == "1")
|
|
|
{
|
|
|
DataTable dt = new DataTable();
|
|
|
dt.Columns.Add("STANO", typeof(int));
|
|
|
dt.Columns.Add("STANAME", typeof(string));
|
|
|
DataRow dr = dt.NewRow();
|
|
|
dr["STANO"] = 1;
|
|
|
dr["STANAME"] = "总公司";
|
|
|
dt.Rows.Add(dr);
|
|
|
stSta.DataSource = dt;
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
stSta.DataSource = dicbll.GetStaAllInfo(" and SUBCOMNO='" + s_cmbSubcom.SelectedItem.Value + "'");
|
|
|
}
|
|
|
stSta.DataBind();
|
|
|
}
|
|
|
#endregion 绑定数据
|
|
|
|
|
|
#region 首次盘存
|
|
|
/// <summary>
|
|
|
/// 校验是否第一次盘存登记
|
|
|
/// </summary>
|
|
|
[DirectMethod]
|
|
|
public void CheckFirstPancun()
|
|
|
{
|
|
|
try
|
|
|
{
|
|
|
//if (string.IsNullOrEmpty(cmbBIllType.SelectedItem.Value))
|
|
|
//{
|
|
|
// CommonHelper.MsgShowInfo("请选择，盘存票据类型....");
|
|
|
// return;
|
|
|
//}
|
|
|
int billType = CommonHelper._BillType_Paper;//int.Parse(cmbBIllType.SelectedItem.Value);
|
|
|
int type = CommonHelper._PaperType;
|
|
|
//if (cmbBIllType.SelectedItem.Value == CommonHelper._BillType_Paper.ToString())
|
|
|
//{
|
|
|
// type = CommonHelper._PaperType;
|
|
|
//}
|
|
|
//else
|
|
|
//{
|
|
|
// type = CommonHelper._CardType;
|
|
|
//}
|
|
|
int ct = paperbll.GetPanctOrderCt(" and TYPE=" + type + " and KIND='" + billType + "' and USERTYPE='" + CommonHelper._userType + "'");
|
|
|
if (ct > 0)
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("首次-已盘存！");
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
wdFirst.Show();
|
|
|
}
|
|
|
}
|
|
|
catch (Exception ex)
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("首次盘存异常：" + ex.Message);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 第一次盘存
|
|
|
/// </summary>
|
|
|
/// <param name="sender"></param>
|
|
|
/// <param name="e"></param>
|
|
|
protected void btnFirstPc_Click(object sender, Ext.Net.DirectEventArgs e)
|
|
|
{
|
|
|
if (hdUserId.Value == null || hdUserId.Value.ToString().ToLower() == "admin")
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("用户过期或者ADMIN用户禁止使用，重新登录...");
|
|
|
return;
|
|
|
}
|
|
|
//if (string.IsNullOrEmpty(cmbBIllType.SelectedItem.Value))
|
|
|
//{
|
|
|
// CommonHelper.MsgShowInfo("请选择预盘存，票据类型...");
|
|
|
// return;
|
|
|
//}
|
|
|
try
|
|
|
{
|
|
|
DataTable dt = null;
|
|
|
CBPanCunModel mdl = new CBPanCunModel();
|
|
|
if (CommonHelper._userType == "1")
|
|
|
{
|
|
|
dt = dicbll.GetSubCompanyBySta(" and STANO='" + CommonHelper._userStaNo + "'");
|
|
|
mdl.SUBCOMNO = int.Parse(dt.Rows[0]["SUBCOMNO"].ToString());
|
|
|
mdl.SUBCOMNAME = dt.Rows[0]["SUBCOMNAME"].ToString();
|
|
|
|
|
|
dt = dicbll.GetStaAllInfo(" and STANO='" + CommonHelper._userStaNo + "'");
|
|
|
mdl.UNITNO = int.Parse(dt.Rows[0]["STANO"].ToString());
|
|
|
mdl.UNITNAME = dt.Rows[0]["STANAME"].ToString();
|
|
|
}
|
|
|
else if (CommonHelper._userType == "2")
|
|
|
{
|
|
|
dt = dicbll.GetSubCompany(" and SUBCOMNO='" + CommonHelper._userStaNo + "'");
|
|
|
mdl.SUBCOMNO = int.Parse(dt.Rows[0]["SUBCOMNO"].ToString());
|
|
|
mdl.SUBCOMNAME = dt.Rows[0]["SUBCOMNAME"].ToString();
|
|
|
mdl.UNITNO = int.Parse(dt.Rows[0]["SUBCOMNO"].ToString());
|
|
|
mdl.UNITNAME = dt.Rows[0]["SUBCOMNAME"].ToString();
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
mdl.SUBCOMNO = 1;
|
|
|
mdl.SUBCOMNAME = "总公司";
|
|
|
mdl.UNITNO = 1;
|
|
|
mdl.UNITNAME = "总公司";
|
|
|
}
|
|
|
string subno = "000" + mdl.SUBCOMNO;
|
|
|
string stano = "000" + mdl.UNITNO;
|
|
|
mdl.PCNO = "P" + subno.Substring(subno.Length - 4) + stano.Substring(stano.Length - 4) + DateTime.Now.AddDays(-2).ToString("yyyyMMdd");
|
|
|
mdl.TYPE = CommonHelper._PaperType;
|
|
|
//if (cmbBIllType.SelectedItem.Value == CommonHelper._BillType_Paper.ToString())
|
|
|
//{
|
|
|
// mdl.PCNO = "P" + subno.Substring(subno.Length - 4) + stano.Substring(stano.Length - 4) + DateTime.Now.AddDays(-1).ToString("yyyyMMdd");
|
|
|
// mdl.TYPE = CommonHelper._PaperType;
|
|
|
//}
|
|
|
//else
|
|
|
//{
|
|
|
// mdl.PCNO = "C" + subno.Substring(subno.Length - 4) + stano.Substring(stano.Length - 4) + DateTime.Now.AddDays(-1).ToString("yyyyMMdd");
|
|
|
// mdl.TYPE = CommonHelper._CardType;
|
|
|
//}
|
|
|
mdl.KIND = CommonHelper._BillType_Paper;//int.Parse(cmbBIllType.SelectedItem.Value);
|
|
|
mdl.MKDT = DateTime.Now;
|
|
|
mdl.DT = Convert.ToDateTime(DateTime.Now.AddDays(-2).ToShortDateString());
|
|
|
mdl.PRECOUNT = 0;
|
|
|
mdl.ALLOTCT = 0;
|
|
|
mdl.YKCT = 0;
|
|
|
mdl.COUNT = int.Parse(txtCt.Text.Trim());
|
|
|
mdl.ADMANNO = int.Parse(hdUserId.Value.ToString());
|
|
|
mdl.ADMAN = hdMan.Value.ToString();
|
|
|
mdl.DATEMARK = DateTime.Now;
|
|
|
mdl.MKDT = DateTime.Now;
|
|
|
mdl.USERTYPE = int.Parse(CommonHelper._userType);
|
|
|
bool _f = paperbll.AddPancun(mdl);
|
|
|
if (_f)
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("首次盘存成功！！！");
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("首次盘存失败！！！");
|
|
|
}
|
|
|
}
|
|
|
catch (Exception ex)
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("首次盘存异常：" + ex.Message);
|
|
|
}
|
|
|
wdFirst.Hide();
|
|
|
StPCInfo.DataBind();
|
|
|
}
|
|
|
#endregion 首次盘存
|
|
|
|
|
|
#region 盘存
|
|
|
/// <summary>
|
|
|
/// 创建预盘存单
|
|
|
/// </summary>
|
|
|
/// <param name="sender"></param>
|
|
|
/// <param name="e"></param>
|
|
|
protected void btnPrePanCun_Click(object sender, Ext.Net.DirectEventArgs e)
|
|
|
{
|
|
|
if (hdUserId.Value.ToString().ToLower() == "admin")
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("ADMIN用户禁止使用...");
|
|
|
return;
|
|
|
}
|
|
|
//if (string.IsNullOrEmpty(cmbBIllType.SelectedItem.Value))
|
|
|
//{
|
|
|
// CommonHelper.MsgShowInfo("请选择预盘存，票据类型...");
|
|
|
// return;
|
|
|
//}
|
|
|
try
|
|
|
{
|
|
|
int type = CommonHelper._PaperType;
|
|
|
//if (cmbBIllType.SelectedItem.Value == CommonHelper._BillType_Paper.ToString())
|
|
|
//{
|
|
|
// type = CommonHelper._PaperType;
|
|
|
//}
|
|
|
//else
|
|
|
//{
|
|
|
// type = CommonHelper._CardType;
|
|
|
//}
|
|
|
int ct = paperbll.GetPanctOrderCt(" and TYPE=" + type + " and KIND='" + CommonHelper._BillType_Paper + "' and USERTYPE='" + CommonHelper._userType + "'");
|
|
|
if (ct <= 0)
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("首次-未盘存，请首次盘存！");
|
|
|
return;
|
|
|
}
|
|
|
}
|
|
|
catch (Exception ex)
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("校验首次盘存失败：" + ex.Message);
|
|
|
return;
|
|
|
}
|
|
|
if (s_txtPcStDt.Value == null || s_txtPcEndDt.Value == null)
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("请选择盘存日期");
|
|
|
return;
|
|
|
}
|
|
|
string resultStr = string.Empty;
|
|
|
|
|
|
DateTime dtSt = Convert.ToDateTime(s_txtPcStDt.Value).Date;
|
|
|
DateTime dtEnd = Convert.ToDateTime(s_txtPcEndDt.Value).Date;
|
|
|
DateTime dt = dtEnd;
|
|
|
//从开始日期的前一个月。
|
|
|
var startDt = dtSt.AddMonths(-2).AddDays(1 - dtSt.Day).Date;
|
|
|
//收费条件
|
|
|
string sqlwhere = string.Empty;
|
|
|
//调拨条件
|
|
|
string allotStr = string.Empty;
|
|
|
//盘存条件
|
|
|
string pcStr = string.Empty;
|
|
|
int billType = CommonHelper._BillType_Paper;
|
|
|
try
|
|
|
{
|
|
|
//卡盘存-判断前两天盘存单是否生成-如果生成-继续做今天 反之，补做前一天
|
|
|
if (CommonHelper._dbType == "1")
|
|
|
{
|
|
|
sqlwhere += " and classdate>='" + dtSt + "' and classdate<='" + dtEnd + "'";
|
|
|
allotStr += " and ALLOTDT>='" + dtSt + "' and ALLOTDT<='" + dtEnd.AddDays(1).AddSeconds(-1) + "'";
|
|
|
pcStr += " and DT>='" + startDt.ToString("yyyy-MM-dd") + "' and DT<='" + dtEnd.ToString("yyyy-MM-dd") + "' and TYPE=" + CommonHelper._PaperType + " and KIND=" + billType + "";
|
|
|
}
|
|
|
else if (CommonHelper._dbType == "4")
|
|
|
{
|
|
|
sqlwhere += " and classdate>=date_format('" + dtSt + "','%Y-%m-%d %H:%i:%s') and classdate<=date_format('" + dtEnd + "','%Y-%m-%d %H:%i:%s')";
|
|
|
allotStr += " and ALLOTDT>=DATE_FORMAT('" + dtSt + "','%Y-%m-%d %H:%i:%s') and ALLOTDT<=DATE_FORMAT('" + dtEnd.AddDays(1).AddSeconds(-1) + "','%Y-%m-%d %H:%i:%s')";
|
|
|
pcStr += " and DT>=date_format('" + startDt.ToString("yyyy-MM-dd") + "','%Y-%m-%d %H:%i:%s') and DT<=date_format('" + dtEnd.ToString("yyyy-MM-dd") + "','%Y-%m-%d %H:%i:%s') and TYPE=" + CommonHelper._PaperType + " and KIND=" + billType + "";
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
sqlwhere += " and classdate=to_date('" + dtSt.ToString("yyyy-MM-dd") + "','yyyy-MM-dd') and classdate<=to_date('" + dtEnd.ToString("yyyy-MM-dd") + "','yyyy-MM-dd')";
|
|
|
allotStr += " and ALLOTDT=to_date('" + dtSt.ToString("yyyy-MM-dd") + "','yyyy-MM-dd') and ALLOTDT<=to_date('" + dtEnd.AddDays(1).AddSeconds(-1) + "','yyyy-MM-dd HH24:mi:ss')";
|
|
|
pcStr += " and DT>=to_date('" + startDt.ToString("yyyy-MM-dd") + "','yyyy-MM-dd') and DT<=to_date('" + dtEnd.ToString("yyyy-MM-dd") + "','yyyy-MM-dd') and TYPE=" + CommonHelper._PaperType + " and KIND=" + billType + "";
|
|
|
}
|
|
|
if (CommonHelper._userType == "1")
|
|
|
{
|
|
|
resultStr = paperbll.GetPrePancunForSta(sqlwhere, allotStr, pcStr, CommonHelper._userStaNo, CommonHelper._PaperType, CommonHelper._BillType_Paper, hdUserId.Value.ToString(), hdMan.Value.ToString(), CommonHelper._userType, dt.ToShortDateString());
|
|
|
}
|
|
|
else if (CommonHelper._userType == "2")
|
|
|
{
|
|
|
resultStr = paperbll.GetPrePancunForCenter(allotStr, pcStr, CommonHelper._userStaNo, CommonHelper._PaperType, CommonHelper._BillType_Paper, int.Parse(hdUserId.Value.ToString()), hdMan.Value.ToString(), CommonHelper._userType, dt.ToShortDateString());
|
|
|
}
|
|
|
else//公投总公司 单位号=1
|
|
|
{
|
|
|
resultStr = paperbll.GetPrePancunForCenter(allotStr, pcStr, "1", CommonHelper._PaperType, CommonHelper._BillType_Paper, int.Parse(hdUserId.Value.ToString()), hdMan.Value.ToString(), CommonHelper._userType, dt.ToShortDateString());
|
|
|
}
|
|
|
CommonHelper.MsgShowInfo(resultStr);
|
|
|
}
|
|
|
catch (Exception ex)
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("预盘存单生成异常：" + ex.Message);
|
|
|
}
|
|
|
StPCInfo.DataBind();
|
|
|
}
|
|
|
#endregion 盘存
|
|
|
|
|
|
#region 增删改查
|
|
|
/// <summary>
|
|
|
/// 查询
|
|
|
/// </summary>
|
|
|
/// <param name="sender"></param>
|
|
|
/// <param name="e"></param>
|
|
|
protected void btnSearch_Click(object sender, Ext.Net.DirectEventArgs e)
|
|
|
{
|
|
|
Paging.SetPageIndex(1);
|
|
|
StPCInfo.DataBind();
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 数据列表
|
|
|
/// </summary>
|
|
|
/// <param name="sender"></param>
|
|
|
/// <param name="e"></param>
|
|
|
protected void StPCInfo_RefreshData(object sender, Ext.Net.StoreRefreshDataEventArgs e)
|
|
|
{
|
|
|
int start; int limit;
|
|
|
if (!string.IsNullOrEmpty(e.Parameters["Start"]) && !string.IsNullOrEmpty(e.Parameters["Limit"]))
|
|
|
{
|
|
|
start = int.Parse(e.Parameters["Start"]);
|
|
|
limit = int.Parse(e.Parameters["Limit"]);
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
start = e.Start;
|
|
|
limit = e.Limit;
|
|
|
}
|
|
|
if (s_txtStartDt.Value == null || string.IsNullOrEmpty(s_txtStartDt.Value.ToString()) || s_txtEndDt.Value == null)
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("请选择查询日期！");
|
|
|
return;
|
|
|
}
|
|
|
string sqlwhere = string.Empty;
|
|
|
TimeSpan ts = Convert.ToDateTime(s_txtEndDt.Value) - Convert.ToDateTime(s_txtStartDt.Value);
|
|
|
if (ts.Days < 0)
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("开始日期不大于结束日期！");
|
|
|
return;
|
|
|
}
|
|
|
if (CommonHelper._dbType == "1")
|
|
|
{
|
|
|
sqlwhere += " and DT>='" + Convert.ToDateTime(s_txtStartDt.Value).AddDays(-2).ToString("yyyy-MM-dd ") + "' and DT<='" + Convert.ToDateTime(s_txtEndDt.Value).AddDays(1).ToString("yyyy-MM-dd ") + "'";
|
|
|
}
|
|
|
else if (CommonHelper._dbType == "4")
|
|
|
{
|
|
|
sqlwhere += " and DT>=DATE_FORMAT('" + Convert.ToDateTime(s_txtStartDt.Value).AddDays(-2).ToString("yyyy-MM-dd HH:mm:ss") + "','%Y-%m-%d %H:%i:%s') and DT<=DATE_FORMAT('" + Convert.ToDateTime(s_txtEndDt.Value).AddDays(1).ToString("yyyy-MM-dd ") + "','%Y-%m-%d %H:%i:%s')";
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
sqlwhere += " and DT>=to_date('" + Convert.ToDateTime(s_txtStartDt.Value).AddDays(-2).ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-MM-dd HH24:mi:ss') and DT<=to_date('" + Convert.ToDateTime(s_txtEndDt.Value).AddDays(1).ToString("yyyy-MM-dd ") + "','yyyy-MM-dd HH24:mi:ss')";
|
|
|
}
|
|
|
if (!string.IsNullOrEmpty(s_cmbSubcom.SelectedItem.Value))
|
|
|
{
|
|
|
sqlwhere += " and SUBCOMNO='" + s_cmbSubcom.SelectedItem.Value + "'";
|
|
|
}
|
|
|
if (!string.IsNullOrEmpty(s_cmbSta.SelectedItem.Value))
|
|
|
{
|
|
|
sqlwhere += " and UNITNO='" + s_cmbSta.SelectedItem.Value + "'";
|
|
|
}
|
|
|
if (s_chk.Checked)
|
|
|
{
|
|
|
sqlwhere += " and USERTYPE=" + CommonHelper._userType + "";
|
|
|
}
|
|
|
sqlwhere += " and TYPE=" + CommonHelper._PaperType + "";
|
|
|
try
|
|
|
{
|
|
|
log.Down("",sqlwhere);
|
|
|
int ct = paperbll.GetPanctOrderCt(sqlwhere);
|
|
|
DataTable dt = paperbll.GetPancunOderLst(sqlwhere, start, start + limit);
|
|
|
e.Total = ct;
|
|
|
StPCInfo.DataSource = dt;
|
|
|
}
|
|
|
catch (Exception ex)
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("盘存异常：" + ex.Message);
|
|
|
}
|
|
|
StPCInfo.DataBind();
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 编辑
|
|
|
/// </summary>
|
|
|
/// <param name="sender"></param>
|
|
|
/// <param name="e"></param>
|
|
|
protected void btnEidt_Click(object sender, Ext.Net.DirectEventArgs e)
|
|
|
{
|
|
|
try
|
|
|
{
|
|
|
if (hdPcNo.Value == null || hdType.Value == null || hdBillType.Value == null)
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("数据过期，请重新选择操作数据！！！");
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
DataTable dt;
|
|
|
if (hdPcNo.Value == null || hdType.Value == null || hdBillType.Value == null || hdDt.Value == null || hdMKDt.Value == null || hdMKDt.Value.ToString() == "")
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("数据过期，请重新选择操作数据！！！");
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
if (hdoldManNo.Value != null && !string.IsNullOrEmpty(hdoldManNo.Value.ToString()))
|
|
|
{
|
|
|
if (!hdoldManNo.Value.Equals(hdUserId.Value.ToString()) || !hdoldUType.Value.ToString().Equals(CommonHelper._userType))
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("非本人/非本单位录入数据，不允许更改...");
|
|
|
return;
|
|
|
}
|
|
|
}
|
|
|
//启用修改指令
|
|
|
//if (CommonHelper._updateflag == CommonHelper._UpdateOrder_Flag.ToString())
|
|
|
//{
|
|
|
// string djDt = hdMKDt.Value.ToString();
|
|
|
// TimeSpan ts = DateTime.Now - Convert.ToDateTime(djDt);
|
|
|
// if ((ts.TotalMinutes > 60 && ts.Days == 0) || ts.Days >= 1)
|
|
|
// {
|
|
|
// if (!CommonHelper.CheckUpdate(out dt, Convert.ToDateTime(hdMKDt.Value).Date))
|
|
|
// {
|
|
|
// CommonHelper.MsgShowInfo("未收到-修改指令，不允许更改数据，请提交修改申请...");
|
|
|
// return;
|
|
|
// }
|
|
|
// }
|
|
|
//}
|
|
|
//else
|
|
|
//{
|
|
|
// string djDt = hdMKDt.Value.ToString();
|
|
|
// TimeSpan ts = DateTime.Now - Convert.ToDateTime(djDt);
|
|
|
// if ((ts.Hours > 1 && ts.Days == 0) || ts.Days >= 1)
|
|
|
// {
|
|
|
// CommonHelper.MsgShowInfo("数据已超过1小时，不允许修改...");
|
|
|
// return;
|
|
|
// }
|
|
|
//}
|
|
|
}
|
|
|
}
|
|
|
int ct = 0;
|
|
|
if (string.IsNullOrEmpty(txtEditCt.Text.Trim()))
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("盘存总量不能为空，请输入正确的盘存数量！！！");
|
|
|
return;
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
bool _f = int.TryParse(txtEditCt.Text.Trim(), out ct);
|
|
|
if (!_f)
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("请输入正确的盘存总量！！！");
|
|
|
return;
|
|
|
}
|
|
|
}
|
|
|
string setStr = string.Empty;
|
|
|
if (CommonHelper._userType == "1")
|
|
|
{
|
|
|
setStr = " COUNT=" + txtEditCt.Text.Trim() + ",DATEMARK='" + DateTime.Now + "'";
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
setStr = " COUNT=" + txtEditCt.Text.Trim() + ",DATEMARK=to_date('" + DateTime.Now + "','yyyy-MM-dd HH24:mi:ss')";
|
|
|
}
|
|
|
CBPanCunModel mdl = new CBPanCunModel();
|
|
|
mdl.COUNT = int.Parse(txtEditCt.Text.Trim());
|
|
|
mdl.PCNO = hdPcNo.Value.ToString();
|
|
|
mdl.KIND = int.Parse(hdBillType.Value.ToString());
|
|
|
mdl.TYPE = int.Parse(hdType.Value.ToString());
|
|
|
mdl.DT = Convert.ToDateTime(hdDt.Value.ToString());
|
|
|
mdl.ADMANNO = int.Parse(hdUserId.Value.ToString());
|
|
|
mdl.ADMAN = hdMan.Value.ToString();
|
|
|
mdl.DATEMARK = DateTime.Now;
|
|
|
bool f = paperbll.UpdatePancun(mdl, CreateLog());
|
|
|
if (f)
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("盘存确认信息更新成功！");
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("盘存确认信息更新失败！");
|
|
|
}
|
|
|
}
|
|
|
catch (Exception ex)
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("盘存确认异常：" + ex.Message);
|
|
|
}
|
|
|
wdEdit.Hide();
|
|
|
StPCInfo.DataBind();
|
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
|
/// 上级单位清除-下级单位盘存单
|
|
|
/// </summary>
|
|
|
/// <param name="pcno"></param>
|
|
|
/// <param name="dt"></param>
|
|
|
/// <param name="type"></param>
|
|
|
/// <param name="kind"></param>
|
|
|
/// <param name="billname"></param>
|
|
|
/// <param name="billkind"></param>
|
|
|
/// <param name="billseqno"></param>
|
|
|
[DirectMethod]
|
|
|
public void PcDelete(string pcno, string dt, string type, string kind, string billname, string billkind, string billseqno)
|
|
|
{
|
|
|
try
|
|
|
{
|
|
|
string sqlwhere = " and PCNO='" + pcno + "' and TYPE='" + type + "' and KIND='" + kind + "' and BILLNAME='" + billname + "' and BILLKIND='" + billkind + "' and BILLSEQNO='" + billseqno + "'";
|
|
|
if (CommonHelper._dbType == "1")
|
|
|
{
|
|
|
sqlwhere += " and DT='" + dt + "'";
|
|
|
}
|
|
|
else if (CommonHelper._dbType == "4")
|
|
|
{
|
|
|
sqlwhere += " and DT=date_format('" + dt + "','%y-%m-%d %h-%i-%s')";
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
sqlwhere += " and DT=to_date('" + dt + "','yyyy-MM-dd HH24:mi:ss')";
|
|
|
}
|
|
|
if (paperbll.DeleteBillPc(sqlwhere))
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("删除成功");
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("删除失败");
|
|
|
}
|
|
|
}
|
|
|
catch (Exception ex)
|
|
|
{
|
|
|
CommonHelper.MsgShowInfo("清除盘存(" + pcno + ")异常:" + ex.Message);
|
|
|
}
|
|
|
StPCInfo.DataBind();
|
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
|
/// 构建日志
|
|
|
/// </summary>
|
|
|
/// <returns></returns>
|
|
|
public CB_OP_LOG CreateLog()
|
|
|
{
|
|
|
bool f = false;
|
|
|
CB_OP_LOG mdl = new CB_OP_LOG();
|
|
|
try
|
|
|
{
|
|
|
string new_sub = "0000" + hdSubComno.Value.ToString();
|
|
|
string new_sta = "0000" + CommonHelper._userStaNo;
|
|
|
string new_kind = "00" + hdBillType.Value.ToString();
|
|
|
string new_type = "00" + hdType.Value.ToString();
|
|
|
string new_dt = "00000000" + Convert.ToDateTime(hdDt.Value.ToString()).ToString("yyyyMMdd");
|
|
|
mdl.ID = CommonHelper._Prmis_Paper_Pc + new_sub.Substring(new_sub.Length - 4) + new_sta.Substring(new_sta.Length - 4) + DateTime.Now.ToString("yyyyMMddHHmmss");
|
|
|
mdl.KEYLISTNO = new_dt.Substring(new_dt.Length - 8) + new_kind.Substring(new_kind.Length - 2) + new_type.Substring(new_type.Length - 2) + hdPcNo.Value.ToString();
|
|
|
mdl.TBNAME = CommonHelper.GetTbNameByPrmisid(CommonHelper._Prmis_Paper_Pc);//对应的表名称
|
|
|
mdl.TYPE = CommonHelper._OpLog_Jx;//1-根据字典表解析KEYLISTNO 2-不需要解析
|
|
|
mdl.PRMISID = CommonHelper._Prmis_Paper_Pc;//模块号
|
|
|
mdl.SUBCOMNO = int.Parse(hdSubComno.Value.ToString());
|
|
|
mdl.STANO = int.Parse(CommonHelper._userStaNo);
|
|
|
mdl.OPTYPE = 1;//产生日志类型 1-修改
|
|
|
mdl.OLDT = Convert.ToDateTime(hdoldDt.Value.ToString());
|
|
|
mdl.OLMANNO = int.Parse(hdoldManNo.Value.ToString());
|
|
|
mdl.OLMAN = hdoldMan.Value.ToString();
|
|
|
mdl.OLUSERTYPE = int.Parse(hdoldUType.Value.ToString());
|
|
|
mdl.DATETIME = DateTime.Now;
|
|
|
mdl.UPMANNO = int.Parse(hdUserId.Value.ToString());
|
|
|
mdl.UPMAN = hdMan.Value.ToString();
|
|
|
mdl.UPUSERTYPE = int.Parse(CommonHelper._userType);
|
|
|
mdl.BAK1 = 0;
|
|
|
mdl.BAK2 = 0;
|
|
|
mdl.BAK3 = 0;
|
|
|
mdl.BAK4 = string.Empty;
|
|
|
mdl.BAK5 = string.Empty;
|
|
|
mdl.BAK6 = string.Empty;
|
|
|
}
|
|
|
catch (Exception ex)
|
|
|
{
|
|
|
mdl = null;
|
|
|
}
|
|
|
return mdl;
|
|
|
}
|
|
|
#endregion 增删改查
|
|
|
}
|
|
|
} |