protected void ImgModifybtn_Click(object sender, ImageClickEventArgs e)
{
try
{
string CKDH = this.txtCKDH.Text.Trim();
string CK = this.drpFHCK.SelectedValue;
if (string.IsNullOrEmpty(CKDH))
{
this.PrintfError("请选择要修改的单据");
return;
}
int status = QTCKQuery.GetStatus(CKDH);
if (status > 0)
{
this.PrintfError("该单据已经执行，不能修改");
return;
}
this.hidZT.Value = "Modify";
ChangeStatus();
DataSet ds = QTCKQuery.GetItem(CKDH);
Session["QTCKITEM"] = null;
Session["QTCKITEM"] = ds;
this.frameItem.Attributes["src"] = "QTCKD_item.aspx?FHCK=" + CK;
}
catch
{
this.PrintfError("数据访问错误");
return;
}
}
protected void imgMDButton_Click(object sender, ImageClickEventArgs e)
{
try
{
if (string.IsNullOrEmpty(txtCKDH.Text))
{
this.PrintfError("请先选择要修改单据");
return;
}
DataSet ds = QTCKQuery.GetQTCKstatus("ckdh", this.txtCKDH.Text);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
this.PrintfError("该单据已经执行，不能修改");
return;
}
}
}
catch
{
this.PrintfError("获得单据状态时出错");
return;
}
}
protected void ImgCZDJbtn_Click(object sender, ImageClickEventArgs e)
{
try
{
string CKDH = this.txtCKDH.Text.Trim();
if (string.IsNullOrEmpty(CKDH))
{
this.PrintfError("请选择要重置的单据");
return;
}
int status = QTCKQuery.GetStatus(CKDH);
if (status > 1)
{
this.PrintfError("该单据已经执行完成，不能重置");
return;
}
if (status == 0)
{
this.PrintfError("不用重置");
return;
}
string result = QTCKQuery.CZDJ(CKDH);
if (result != "success")
{
this.PrintfError("重置过程出现异常，请重试");
return;
}
this.txtStatus.Text = "新建";
}
catch
{
this.PrintfError("重置过程出现异常，请重试");
return;
}
}
protected void ImgNewButton_Click(object sender, ImageClickEventArgs e)
{
ChangeStatus();
this.hidZT.Value = "Add";
string CKDH = GetCKDJH();
txtCKDH.Text = CKDH;
txtZDR.Text = CUSER.UserID;
string strdate = DateTime.Now.ToShortDateString();
txtZDRQ.Text = strdate;
txtFYRQ.Text = strdate;
this.drpFHCK.SelectedValue = "请选择";
this.drpCYS.SelectedValue = "请选择";
this.drpCKLX.SelectedValue = "请选择";
this.drpSHDW.SelectedValue = "请选择";
this.txtCPH.Text = "";
this.txtMDD.Text = "";
this.txtNCDJ.Text = "";
this.txtStatus.Text = "新建";
try
{
DataSet ds = QTCKQuery.GetItemJieGou();
Session["QTCKITEM"] = ds;
}
catch
{
this.PrintfError("新建时获得表结构出现错误，请重试");
return;
}
}
protected void ImgQXWCbtn_Click(object sender, ImageClickEventArgs e)
{
try
{
string CKDH = this.txtCKDH.Text.Trim();
string CK = this.drpFHCK.SelectedValue;
if (string.IsNullOrEmpty(CKDH))
{
this.PrintfError("请选择要重置的单据");
return;
}
int status = QTCKQuery.GetStatus(CKDH);
if (status < 2)
{
this.PrintfError("不用取消");
return;
}
if (status == 2)
{
int result = QTCKQuery.QXWC(CKDH, CK, this.CUSER.UserID);
if (result == 1)
{
this.txtStatus.Text = "正在执行";
}
}
}
catch
{
this.PrintfError("取消完成过程出现错误，请重试");
return;
}
}
/// <summary>
/// 根据出库单号查询其它出库单概要及明细并赋值给Session,并给各个文本框赋值，并向子页面发送当前状态是浏览状态的信息，子页面会获得Session并绑定明细Grid
/// </summary>
private void InitAllByCKDH(string CKDH)
{
try
{
this.txtCKDH.Text = CKDH;
DataSet ds = QTCKQuery.GetItem(CKDH);
Session["QTCKITEM"] = ds;
this.frameItem.Attributes["src"] = "QTCKD_item.aspx?ZT=Browse";
if (ds != null && ds.Tables[1].Rows.Count > 0)
{
this.drpFHCK.SelectedValue = ds.Tables[1].Rows[0]["CK"].ToString();
if (ds.Tables[1].Rows[0]["CPH"] != null)
{
this.txtCPH.Text = ds.Tables[1].Rows[0]["CPH"].ToString();
}
if (ds.Tables[1].Rows[0]["AimAdress"] != null)
{
this.txtMDD.Text = ds.Tables[1].Rows[0]["AimAdress"].ToString();
}
if (ds.Tables[1].Rows[0]["ZDR"] != null)
{
this.txtZDR.Text = ds.Tables[1].Rows[0]["ZDR"].ToString();
}
if (ds.Tables[1].Rows[0]["ZDRQ"] != null)
{
this.txtZDRQ.Text = ds.Tables[1].Rows[0]["ZDRQ"].ToString();
}
if (ds.Tables[1].Rows[0]["statusName"] != null)
{
this.txtStatus.Text = ds.Tables[1].Rows[0]["statusName"].ToString();
}
if (ds.Tables[1].Rows[0]["CKLX"] != null)
{
this.drpCKLX.Text = ds.Tables[1].Rows[0]["CKLX"].ToString();
}
if (ds.Tables[1].Rows[0]["NCDJ"] != null)
{
this.txtNCDJ.Text = ds.Tables[1].Rows[0]["NCDJ"].ToString();
}
if (ds.Tables[1].Rows[0]["CYS"] != null)
{
this.drpCYS.SelectedValue = ds.Tables[1].Rows[0]["CYS"].ToString();
}
if (ds.Tables[1].Rows[0]["FYSJ"] != null)
{
this.txtFYRQ.Text = ds.Tables[1].Rows[0]["FYSJ"].ToString();
}
if (ds.Tables[1].Rows[0]["SHDW"] != null)
{
this.drpSHDW.Text = ds.Tables[1].Rows[0]["SHDW"].ToString();
}
}
}
catch
{
this.PrintfError("查询后给父窗体赋值时出现错误，请重试");
return;
}
}
/// <summary>
/// 获得出库单据号
/// </summary>
/// <returns></returns>
private string GetCKDJH()
{
string str = "";
DataSet ds = QTCKQuery.execQCDH();
if (ds != null)
{
string str1 = ds.Tables[0].Rows[0][0].ToString();
string str2 = ds.Tables[0].Rows[0][1].ToString();
str = "CK" + str1 + Convert.ToDouble(str2).ToString("000");
return(str);
}
return(str);
}
private void BindDJMX(string CKDH)
{
try
{
DataSet ds = QTCKQuery.GetPrintDJMX(CKDH);
this.grvDJMX.DataSource = ds;
this.grvDJMX.DataBind();
}
catch
{
this.PrintfError("数据访问错误");
return;
}
}
protected void btnQuery_Click(object sender, ImageClickEventArgs e)
{
try
{
string strWhere = GetStrWhere();
DataSet ds = QTCKQuery.GetPrintDS(strWhere);
this.grvPrintCKDMX.DataSource = ds;
this.grvPrintCKDMX.DataBind();
}
catch
{
this.PrintfError("查询出现错误");
return;
}
}
//绑定gvdview
private void BindgrvCKDMX()
{
try
{
string sql = GetQueryStr();
DataSet liuds = QTCKQuery.QTCK_Query(sql);
this.grvCKDMX.DataSource = liuds;
this.grvCKDMX.DataBind();
}
catch
{
this.PrintfError("数据访问错误");
return;
}
}
protected void ImgDeleteCKD_Click(object sender, ImageClickEventArgs e)
{
try
{
string CKDH = this.txtCKDH.Text.Trim();
if (string.IsNullOrEmpty(CKDH))
{
this.PrintfError("请选择要修改的单据");
return;
}
int status = QTCKQuery.GetStatus(CKDH);
if (status > 0)
{
this.PrintfError("该单据已经执行，不能删除");
return;
}
string result = QTCKQuery.DeleteCKD(CKDH);
if (result != "success")
{
this.PrintfError("删除过程中发生异常");
return;
}
txtCKDH.Text = "";
this.hidZT.Value = "";
ReturnStatus();
this.drpFHCK.SelectedIndex = -1;
this.txtCPH.Text = "";
this.drpCKLX.Text = "";
this.txtNCDJ.Text = "";
this.txtFYRQ.Text = "";
this.txtMDD.Text = "";
this.drpCYS.SelectedIndex = -1;
this.drpSHDW.Text = "";
this.txtStatus.Text = "";
this.txtZDR.Text = "";
this.txtZDRQ.Text = "";
Session["QTCKITEM"] = null;
this.frameItem.Attributes["src"] = "QTCKD_item.aspx";
}
catch
{
this.PrintfError("删除过程出现错误，请重试");
return;
}
}
//#region 批次号下拉列表改变时绑定属性下拉列表
//protected void drpPCH_SelectedIndexChanged(object sender, EventArgs e)
//{
// try
// {
// if (!string.IsNullOrEmpty(this.drpPCH.SelectedValue))
// {
// string CK = this.hidCK.Value.Trim();
// string PCH = this.drpPCH.SelectedValue;
// DataSet ds = QTCKQuery.GetSXbyPCH(PCH, CK);
// if (ds != null)
// {
// this.drpSX.DataSource = ds;
// this.drpSX.DataTextField = "SX";
// this.drpSX.ToolTip = "属性";
// this.drpSX.DataValueField = "SX";
// this.drpSX.DataBind();
// this.txtWLH.Text = ds.Tables[0].Rows[0]["WLH"].ToString();
// this.txtWLMC.Text = ds.Tables[0].Rows[0]["WLMC"].ToString();
// this.txtPH.Text = ds.Tables[0].Rows[0]["PH"].ToString();
// this.txtGG.Text = ds.Tables[0].Rows[0]["GG"].ToString();
// }
// }
// }
// catch
// {
// this.PrintfError("数据访问错误");
// return;
// }
//}
//#endregion
#region 属性下拉列表改变时给规格等几个文本框赋值
protected void drpSX_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrEmpty(this.drpSX.SelectedValue))
{
string CK = this.hidCK.Value.Trim();
//string PCH = this.drpPCH.SelectedValue;
string PCH = this.txtPCH.Text.Trim();
string SX = this.drpSX.SelectedValue;
DataSet ds = QTCKQuery.GetWLHbySX(SX, PCH, CK);
if (ds != null)
{
this.drpFree1.DataSource = ds;
this.drpFree1.DataTextField = "vfree1";
this.drpFree1.ToolTip = "自由项1";
this.drpFree1.DataValueField = "vfree1";
this.drpFree1.DataBind();
this.drpFree2.DataSource = ds;
this.drpFree2.DataTextField = "vfree2";
this.drpFree2.ToolTip = "自由项2";
this.drpFree2.DataValueField = "vfree2";
this.drpFree2.DataBind();
this.drpFree3.DataSource = ds;
this.drpFree3.DataTextField = "vfree3";
this.drpFree3.ToolTip = "自由项3";
this.drpFree3.DataValueField = "vfree3";
this.drpFree3.DataBind();
this.txtWLH.Text = ds.Tables[0].Rows[0]["WLH"].ToString();
this.txtWLMC.Text = ds.Tables[0].Rows[0]["WLMC"].ToString();
this.txtPH.Text = ds.Tables[0].Rows[0]["PH"].ToString();
this.txtGG.Text = ds.Tables[0].Rows[0]["GG"].ToString();
}
}
}
catch
{
this.PrintfError("数据访问错误");
return;
}
}
private void BinddrpSHDW()
{
try
{
DataSet ds3 = QTCKQuery.GetCHE_QTCK("shdw", "shdw");
if (ds3 != null)
{
this.drpSHDW.DataSource = ds3;
this.drpSHDW.DataTextField = "shdw";
this.drpSHDW.DataValueField = "shdw";
this.drpSHDW.DataBind();
}
this.drpSHDW.Items.Insert(0, "请选择");
}
catch
{
this.PrintfError("数据访问错误");
return;
}
}
private void BinddrpZDR()
{
try
{
DataSet ds = QTCKQuery.GetCHE_QTCK("ZDR", "");
if (ds != null)
{
this.drpZDR.DataSource = ds;
this.drpZDR.DataTextField = "ZDR";
this.drpZDR.DataValueField = "ZDR";
this.drpZDR.DataBind();
}
this.drpZDR.Items.Insert(0, "请选择");
}
catch
{
this.PrintfError("访问数据出错！");
return;
}
}
private void BinddrpCYS()
{
try
{
DataSet ds2 = QTCKQuery.GetCHE_QTCK("cys", "cys");
if (ds2 != null)
{
this.drpCYS.DataSource = ds2;
this.drpCYS.DataTextField = "cys";
this.drpCYS.DataValueField = "cys";
this.drpCYS.DataBind();
}
this.drpCYS.Items.Insert(0, "请选择");
}
catch
{
this.PrintfError("访问数据出错");
return;
}
}
private void BinddrpCK()
{
try
{
DataSet ds = QTCKQuery.GetCKID();
if (ds != null)
{
this.drpCK.DataSource = ds;
this.drpCK.DataTextField = "CKID";
this.drpCK.ToolTip = "请选择仓库类型";
this.drpCK.DataValueField = "CKID";
this.drpCK.DataBind();
}
this.drpCK.Items.Insert(0, "请选择");
}
catch
{
this.PrintfError("访问数据出错！");
return;
}
}
/// <summary>
/// 页面加载时收货单位
/// </summary>
private void BinddrpSHDW()
{
try
{
DataSet ds3 = QTCKQuery.GetCHE_QTCK("shdw", "shdw");
if (ds3 != null)
{
this.drpSHDW.DataSource = ds3;
this.drpSHDW.DataTextField = "shdw";
this.drpSHDW.DataValueField = "shdw";
this.drpSHDW.DataBind();
Bestcomy.Web.UI.WebControls.ComboItem value = new Bestcomy.Web.UI.WebControls.ComboItem("请选择");
this.drpSHDW.Items.Insert(0, value);
}
}
catch
{
this.PrintfError("加载收货单位时出错");
return;
}
}
private void BinddrpCKLX()
{
try
{
DataSet ds = QTCKQuery.GetCHE_QTCK("cklx", "");
if (ds != null)
{
this.drpCKLX.DataSource = ds;
this.drpCKLX.DataTextField = "cklx";
this.drpCKLX.ToolTip = "请选择出库类型";
this.drpCKLX.DataValueField = "cklx";
this.drpCKLX.DataBind();
}
this.drpCKLX.Items.Insert(0, "请选择");
}
catch
{
this.PrintfError("访问数据出错！");
return;
}
}
private void BinddrpNCDJ()
{
try
{
DataSet ds = QTCKQuery.GetCHE_QTCK("ncdj", "");
if (ds != null)
{
this.drpNCDJ.DataSource = ds;
this.drpNCDJ.DataTextField = "ncdj";
this.drpNCDJ.DataValueField = "ncdj";
this.drpNCDJ.DataBind();
}
Bestcomy.Web.UI.WebControls.ComboItem value = new Bestcomy.Web.UI.WebControls.ComboItem("请选择");
this.drpNCDJ.Items.Insert(0, value);
}
catch
{
this.PrintfError("访问数据出错！");
return;
}
}
/// <summary>
/// 页面加载时绑定出库类型
/// </summary>
private void BinddrpCKLX()
{
try
{
DataSet ds1 = QTCKQuery.GetCHE_QTCK("cklx", "");
if (ds1 != null)
{
this.drpCKLX.DataSource = ds1;
this.drpCKLX.DataTextField = "cklx";
this.drpCKLX.DataValueField = "cklx";
this.drpCKLX.DataBind();
Bestcomy.Web.UI.WebControls.ComboItem value = new Bestcomy.Web.UI.WebControls.ComboItem("请选择");
this.drpCKLX.Items.Insert(0, value);
}
}
catch
{
this.PrintfError("加载出库类型时出错");
return;
}
}
/// <summary>
/// 绑定属性及自由项下拉列表
/// </summary>
/// <param name="PCH"></param>
/// <param name="CK"></param>
private void BindSX(string PCH, string CK)
{
try
{
DataSet ds = QTCKQuery.GetSXbyPCH(PCH, CK);
if (ds != null)
{
this.drpSX.DataSource = ds;
this.drpSX.DataTextField = "SX";
this.drpSX.ToolTip = "属性";
this.drpSX.DataValueField = "SX";
this.drpSX.DataBind();
this.drpFree1.DataSource = ds;
this.drpFree1.DataTextField = "Vfree1";
this.drpFree1.ToolTip = "自由项1";
this.drpFree1.DataValueField = "Vfree1";
this.drpFree1.DataBind();
this.drpFree2.DataSource = ds;
this.drpFree2.DataTextField = "Vfree2";
this.drpFree2.ToolTip = "自由项2";
this.drpFree2.DataValueField = "Vfree2";
this.drpFree2.DataBind();
this.drpFree3.DataSource = ds;
this.drpFree3.DataTextField = "Vfree3";
this.drpFree3.ToolTip = "自由项3";
this.drpFree3.DataValueField = "Vfree3";
this.drpFree3.DataBind();
}
}
catch
{
this.PrintfError("数据访问错误");
return;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BinddrpCK();
BinddrpCKLX();
BinddrpNCDJ();
BinddrpCYS();
BinddrpZDR();
BinddrpSHDW();
string strdate = DateTime.Now.ToShortDateString();
txtZDRQ1.Text = strdate;
txtZDRQ2.Text = strdate;
this.hidCKDH.Value = Request["CKDH"];
if (!string.IsNullOrEmpty(this.hidCKDH.Value))
{
string CKDH = this.hidCKDH.Value.Trim();
DataSet ds = QTCKQuery.GetPrintDS("and CKDH = '" + CKDH + "'");
this.grvPrintCKDMX.DataSource = ds;
this.grvPrintCKDMX.DataBind();
this.frameItem.Attributes["src"] = "PrintQTCKItem.aspx?CKDH=" + CKDH;
}
}
}
protected void imgSave_Click(object sender, ImageClickEventArgs e)
{
try
{
if (!CheckInfo())
{
return;
}
int i = QTCKQuery.GetRecordCount(this.txtCKDH.Text);
if (i > 0)
{
this.PrintfError("该单据已经执行，不能修改");
return;
}
string DJZT = this.hidZT.Value.Trim();
if (DJZT == "Add")//保存新建的单据
{
DataSet ds = (DataSet)Session["QTCKITEM"];
if (ds == null || ds.Tables[0].Rows.Count < 1)
{
this.PrintfError("未添加任何明细，请进行添加！");
return;
}
string CKDH = this.txtCKDH.Text.Trim();
string CK = this.drpFHCK.SelectedValue;
string CPH = this.txtCPH.Text.Trim();
string MDD = this.txtMDD.Text.Trim();
string ZDR = this.txtZDR.Text.Trim();
string ZDRQ = this.txtZDRQ.Text.Trim();
string CKLX = this.drpCKLX.Text.Trim();
string NCDJ = this.txtNCDJ.Text.Trim();
string CYS = this.drpCYS.SelectedValue;
string FYSJ = this.txtFYRQ.Text.Trim();
string SHDW = this.drpSHDW.Text.Trim();
DataRow row = ds.Tables[1].NewRow();//CKDH,CK,CKLX,NCDJ
row["CKDH"] = CKDH;
row["CK"] = CK;
row["CPH"] = CPH;
row["AimAdress"] = MDD;
row["ZDR"] = ZDR;
row["ZDRQ"] = DateTime.Now;
row["STATUS"] = "0";
row["CKLX"] = CKLX;
row["NCDJ"] = NCDJ;
if (CYS != "请选择")
{
row["CYS"] = CYS;
}
row["FYSJ"] = Convert.ToDateTime(FYSJ);
if (SHDW != "请选择" || !string.IsNullOrEmpty(SHDW))
{
row["SHDW"] = SHDW;
}
ds.Tables[1].Rows.Add(row);
QTCKQuery.AddQTCKD(ds);
this.hidZT.Value = "";
ReturnStatus();
}
if (DJZT == "Modify")//保存修改的单据
{
DataSet ds = (DataSet)Session["QTCKITEM"];
if (ds == null || ds.Tables[0].Rows.Count < 1)
{
this.PrintfError("未添加任何明细，请进行添加！");
return;
}
string CKDH = this.txtCKDH.Text.Trim();
string CK = this.drpFHCK.SelectedValue;
string CPH = this.txtCPH.Text.Trim();
string MDD = this.txtMDD.Text.Trim();
string ZDR = this.txtZDR.Text.Trim();
string ZDRQ = this.txtZDRQ.Text.Trim();
string CKLX = this.drpCKLX.Text.Trim();
string NCDJ = this.txtNCDJ.Text.Trim();
string CYS = this.drpCYS.SelectedValue;
string FYSJ = this.txtFYRQ.Text.Trim();
string SHDW = this.drpSHDW.Text.Trim();
ds.Tables[1].Rows[0]["CK"] = CK;
ds.Tables[1].Rows[0]["CPH"] = CPH;
ds.Tables[1].Rows[0]["AimAdress"] = MDD;
ds.Tables[1].Rows[0]["ZDR"] = ZDR;
ds.Tables[1].Rows[0]["ZDRQ"] = ZDRQ;
ds.Tables[1].Rows[0]["CKLX"] = CKLX;
ds.Tables[1].Rows[0]["NCDJ"] = NCDJ;
ds.Tables[1].Rows[0]["CYS"] = CYS;
ds.Tables[1].Rows[0]["FYSJ"] = FYSJ;
ds.Tables[1].Rows[0]["SHDW"] = SHDW;
QTCKQuery.AddQTCKD(ds);
this.hidZT.Value = "";
ReturnStatus();
}
this.frameItem.Attributes["src"] = "QTCKD_item.aspx?ZT=Browse";
}
catch
{
this.PrintfError("保存过程出现错误，请重试");
return;
}
}
protected void Page_Load(object sender, EventArgs e)
{
string action = Request.QueryString["action"];
switch (action)
{
case "deldj":
string delckdh = Request.QueryString["ckdh"];
DataSet ds3 = QTCKQuery.GetQTCKstatus("ckdh", delckdh);
if (ds3 != null)
{
if (ds3.Tables[0].Rows.Count > 0)
{
Response.Write("NotDel");
//this.PrintfError("该单据已经执行，不能删除");
return;
}
}
Response.Write("false");
//Response.Write("<script>if (!confirm('确实要删除此出库单吗?')) return false;</script>");
break;
case "zaideldj":
string zaicdelkdh = Request.QueryString["ckdh"];
QTCKQuery delqtck = new QTCKQuery();
delqtck.CKDHDel(zaicdelkdh);
break;
case "ChongZhi":
string chongzhickdh = Request.QueryString["ckdh"];
DataSet ds4 = QTCKQuery.GetQTCKstatus("ckdh", chongzhickdh);
if (ds4 != null)
{
if (ds4.Tables[0].Rows.Count >= 1)
{
//this.PrintfError("该单据已经执行完成，不能重置");
Response.Write("NotChongZhi");
return;
}
if (ds4.Tables[0].Rows.Count == 0)
{
//this.PrintfError("不用重置");
Response.Write("NoYong");
return;
}
Response.Write("false");
}
break;
case "ZaiChongZhi":
string zaickdh = Request.QueryString["ckdh"];
QTCKQuery czqtck = new QTCKQuery();
czqtck.CKDHChongZhi(zaickdh);
czqtck.ChongZhiStatus(zaickdh);
Response.Write("new");
break;
case "CancelDJ":
string cancelckdh = Request.QueryString["ckdh"];
int i = QTCKQuery.GetRecordCount(cancelckdh);
if (i < 2)
{
//this.PrintfError("不用取消");
Response.Write("NoCancel");
return;
}
if (i == 2)
{
Response.Write("false");
}
break;
case "zaiCancelDJ":
string zaiCancelckdh = Request.QueryString["ckdh"];
string fhck = Request.QueryString["fhck"];
int j = QTCKQuery.Exec_cancelqtck(zaiCancelckdh, fhck, CUSER.UserID);
if (j == 1)
{
Response.Write("zhixing"); //正在执行
}
else
{
Response.Write("wrong"); //取消完成失败！
}
break;
case "SaveDJ":
string saveckdh = Request.QueryString["ckdh"];
string Current = Request.QueryString["Current"];
string status = Request.QueryString["status"];
string ck = Request.QueryString["ck"];
string ncdj = Request.QueryString["ncdj"];
string cph = Request.QueryString["cph"];
string txtTARGET = Request.QueryString["txtTARGET"];
string CYS = Request.QueryString["CYS"];
string SHDW = Request.QueryString["SHDW"];
string ZDR = Request.QueryString["ZDR"];
string ZDRQ = Request.QueryString["ZDRQ"];
int k = QTCKQuery.GetRecordCount(saveckdh);
if (k > 0)
{
Response.Write("NoMODI");
//this.PrintfError("该单据已经执行，不能修改");
return;
}
if (Current == "new")
{
}
break;
case "ModiMX":
string MXckdh = Request.QueryString["ckdh"];
DataSet dsmx = QTCKQuery.GetQTCKitem("ckdh", MXckdh);
if (dsmx == null)
{
Response.Write("wrongmx");
}
break;
case "DelMX":
string delmxckdh = Request.QueryString["ckdh"];
DataSet deldsmx = QTCKQuery.GetQTCKitem("ckdh", delmxckdh);
if (deldsmx == null)
{
Response.Write("Delmx");
}
break;
case "zaiDelMX":
string zaidelmx = Request.QueryString["ckdh"];
QTCKQuery dsdel = new QTCKQuery();
dsdel.CKDHDel(zaidelmx);
Response.Write("success");
break;
case "add":
string strFCKDH = Request.QueryString["fckdh"];
string strFCK = Request.QueryString["fhck"];
string strPCH = Request.QueryString["pch"];
string strSX = Request.QueryString["sx"];
string strWLH = Request.QueryString["wlh"];
string strWLMC = Request.QueryString["wlmc"];
string strPH = Request.QueryString["ph"];
string strGG = Request.QueryString["gg"];
string strSLDW = Request.QueryString["sldw"];
string strZLDW = Request.QueryString["zldw"];
string strJHSL = Request.QueryString["jhsl"];
string strJHZL = Request.QueryString["jhzl"];
QTCKQuery qtckquery = new QTCKQuery();
qtckquery.Add(strFCKDH, strPCH, strSX, strWLH, strWLMC, strPH, strGG, strJHSL, strJHZL, 0, 0, strSLDW, strZLDW);
Response.Write("ins_suss");
break;
}
}
private string GetQueryStr()
{
string Querystr = "";
if (!string.IsNullOrEmpty(txtCKDH.Text))
{
Querystr += " and ckdh like '%" + txtCKDH.Text + "%'";
}
if (!string.IsNullOrEmpty(txtCPH.Text))
{
Querystr += " and cph like '%" + txtCPH.Text + "%'";
}
if (drpMDD.SelectedValue != "请选择" && !string.IsNullOrEmpty(drpMDD.SelectedValue))
{
Querystr += " and AimAdress like '%" + drpMDD.SelectedValue.ToString() + "%'";
}
if (drpCK.SelectedValue != "请选择" && !string.IsNullOrEmpty(drpCK.SelectedValue))
{
Querystr += " and ck='" + drpCK.SelectedValue.ToString() + "'";
}
if (drpStatus.SelectedValue != "请选择" && !string.IsNullOrEmpty(drpStatus.SelectedValue))
{
Querystr += " and STATUS=" + drpStatus.SelectedValue.ToString();
}
if (drpZDR.SelectedValue != "请选择" && !string.IsNullOrEmpty(drpZDR.SelectedValue))
{
Querystr += " and zdr='" + drpZDR.SelectedValue.ToString() + "'";
}
if (drpCKLX.SelectedValue != "请选择" && !string.IsNullOrEmpty(drpCKLX.SelectedValue))
{
Querystr += " and cklx='" + drpCKLX.SelectedValue.ToString() + "'";
}
if (drpNCDJ.SelectedValue != "请选择" && !string.IsNullOrEmpty(drpNCDJ.SelectedValue))
{
Querystr += " and NCDJ='" + drpNCDJ.SelectedValue.ToString() + "'";
}
if (!string.IsNullOrEmpty(this.hidZDRQ.Value))
{
string ZDRQ1 = txtZDRQ1.Text + " 00:00:00";
string ZDRQ2 = txtZDRQ2.Text + " 23:59:59";
Querystr += " and (zdrq>='" + ZDRQ1 + "' and zdrq<='" + ZDRQ2 + "')";
}
if (drpPCH.SelectedValue != "请选择")
{
string strpch = "";
DataSet ds = QTCKQuery.GetCHE_QTCKPCH("ckdh", "pch", this.drpPCH.SelectedValue);
if (ds != null)
{
int i = 0;
while (i < ds.Tables[0].Rows.Count)
{
strpch += ds.Tables[0].Rows[i][0].ToString() + ",";
i++;
}
strpch = strpch.Remove(strpch.Length - 1, 1);
if (ds.Tables[0].Rows.Count >= 1)
{
Querystr += " and ckdh in('" + strpch + "')";
}
}
}
return(Querystr);
}
protected void txtPCH_TextChanged(object sender, EventArgs e)
{
try
{
string CK = this.hidCK.Value.Trim();
string PCH = this.txtPCH.Text.Trim();
if (!string.IsNullOrEmpty(PCH))
{
DataSet ds = QTCKQuery.GetSXbyPCH(PCH, CK);
DataSet dsSX = QTCKQuery.GetSXbyPCHNEW(PCH, CK);
if (dsSX != null && dsSX.Tables[0].Rows.Count > 0)
{
this.drpSX.DataSource = dsSX;
this.drpSX.DataTextField = "SX";
this.drpSX.ToolTip = "属性";
this.drpSX.DataValueField = "SX";
this.drpSX.DataBind();
DataSet dsFree1 = QTCKQuery.GetFree1BySX(this.drpSX.SelectedValue, PCH, CK);
this.drpFree1.DataSource = dsFree1;
this.drpFree1.DataTextField = "vfree1";
this.drpFree1.ToolTip = "自由项1";
this.drpFree1.DataValueField = "vfree1";
this.drpFree1.DataBind();
DataSet dsFree2 = QTCKQuery.GetFree2BySX(this.drpSX.SelectedValue, PCH, CK);
this.drpFree2.DataSource = dsFree2;
this.drpFree2.DataTextField = "vfree2";
this.drpFree2.ToolTip = "自由项2";
this.drpFree2.DataValueField = "vfree2";
this.drpFree2.DataBind();
DataSet dsFree3 = QTCKQuery.GetFree3BySX(this.drpSX.SelectedValue, PCH, CK);
this.drpFree3.DataSource = dsFree3;
this.drpFree3.DataTextField = "vfree3";
this.drpFree3.ToolTip = "自由项3";
this.drpFree3.DataValueField = "vfree3";
this.drpFree3.DataBind();
this.txtWLH.Text = ds.Tables[0].Rows[0]["WLH"].ToString();
this.txtWLMC.Text = ds.Tables[0].Rows[0]["WLMC"].ToString();
this.txtPH.Text = ds.Tables[0].Rows[0]["PH"].ToString();
this.txtGG.Text = ds.Tables[0].Rows[0]["GG"].ToString();
}
else
{
this.drpSX.Items.Clear();
this.drpFree1.Items.Clear();
this.drpFree2.Items.Clear();
this.drpFree3.Items.Clear();
this.txtWLH.Text = "";
this.txtWLMC.Text = "";
this.txtPH.Text = "";
this.txtGG.Text = "";
this.txtJHSL.Text = "";
this.txtJHZL.Text = "";
}
}
}
catch (Exception ex)
{
this.PrintfError(ex.Message);
return;
}
}
//设置报表
private void SetReport()
{
this.ReportView1.ServerUrl = this.ReportURL;
string Type = Request["TYPE"];
string hidCKDH = Request["hidCKDH"];
switch (Type)
{
case "0":
if (Common.IsOldData)
{
this.ReportView1.ReportPath = "/XGReportO/ReportQTCK";
}
else
{
this.ReportView1.ReportPath = "/XGReportC/ReportQTCK";
}
break;
case "1":
if (Common.IsOldData)
{
this.ReportView1.ReportPath = "/XGReportO/ReportQTCKDJHJ";
}
else
{
this.ReportView1.ReportPath = "/XGReportC/ReportQTCKDJHJ";
}
break;
case "2":
if (Common.IsOldData)
{
this.ReportView1.ReportPath = "/XGReportO/ReportQTCKHJ";
}
else
{
this.ReportView1.ReportPath = "/XGReportC/ReportQTCKHJ";
}
break;
}
ReportView1.Parameters = Acctrue.WM_WES.ReportingServices.ReportView.multiState.False;
ReportView1.DocMap = Acctrue.WM_WES.ReportingServices.ReportView.multiState.False;
ReportView1.Toolbar = Acctrue.WM_WES.ReportingServices.ReportView.multiState.True;
switch (Type)
{
case "0":
DataSet ds = QTCKQuery.GetPrintDS("and CKDH='" + hidCKDH + "'");
if (!string.IsNullOrEmpty(hidCKDH))
{
ReportView1.SetParameter("CKDH", hidCKDH);
}
if (ds.Tables[0].Rows[0]["CPH"] != null)
{
ReportView1.SetParameter("CPH", Server.UrlEncode(ds.Tables[0].Rows[0]["CPH"].ToString()));
}
if (ds.Tables[0].Rows[0]["SHDW"] != null)
{
ReportView1.SetParameter("SHDW", Server.UrlEncode(ds.Tables[0].Rows[0]["SHDW"].ToString()));
}
if (ds.Tables[0].Rows[0]["ZDR"] != null)
{
ReportView1.SetParameter("ZDR", Server.UrlEncode(ds.Tables[0].Rows[0]["ZDR"].ToString()));
}
if (ds.Tables[0].Rows[0]["FYSJ"] != null)
{
ReportView1.SetParameter("FYRQ", ds.Tables[0].Rows[0]["FYSJ"].ToString());
}
if (ds.Tables[0].Rows[0]["NCDJ"] != null)
{
ReportView1.SetParameter("NCDJ", ds.Tables[0].Rows[0]["NCDJ"].ToString());
}
if (ds.Tables[0].Rows[0]["CYS"] != null)
{
ReportView1.SetParameter("CYS", Server.UrlEncode(ds.Tables[0].Rows[0]["CYS"].ToString()));
}
if (ds.Tables[0].Rows[0]["AimAdress"] != null)
{
ReportView1.SetParameter("MDD", Server.UrlEncode(ds.Tables[0].Rows[0]["AimAdress"].ToString()));
}
if (ds.Tables[0].Rows[0]["ZDRQ"] != null)
{
ReportView1.SetParameter("ZDRQ", ds.Tables[0].Rows[0]["ZDRQ"].ToString());
}
if (ds.Tables[0].Rows[0]["CK"] != null)
{
ReportView1.SetParameter("CK", ds.Tables[0].Rows[0]["CK"].ToString());
}
if (ds.Tables[0].Rows[0]["CKLX"] != null)
{
ReportView1.SetParameter("CKLX", Server.UrlEncode(ds.Tables[0].Rows[0]["CKLX"].ToString()));
}
break;
case "1":
if (!string.IsNullOrEmpty(Request["CKDH"]))
{
ReportView1.SetParameter("CKDH", Request["CKDH"]);
}
if (!string.IsNullOrEmpty(Request["CPH"]))
{
ReportView1.SetParameter("CPH", Request["CPH"]);
}
if (!string.IsNullOrEmpty(Request["ncdj"]))
{
ReportView1.SetParameter("ncdj", Request["ncdj"]);
}
if (!string.IsNullOrEmpty(Request["CKLX"]))
{
ReportView1.SetParameter("CKLX", Request["CKLX"]);
}
if (!string.IsNullOrEmpty(Request["CYS"]))
{
ReportView1.SetParameter("CYS", Request["CYS"]);
}
if (!string.IsNullOrEmpty(Request["CK"]))
{
ReportView1.SetParameter("CK", Request["CK"]);
}
if (!string.IsNullOrEmpty(Request["status"]))
{
ReportView1.SetParameter("status", Request["status"]);
}
if (!string.IsNullOrEmpty(Request["ZDR"]))
{
ReportView1.SetParameter("ZDR", Request["ZDR"]);
}
if (!string.IsNullOrEmpty(Request["SHDW"]))
{
ReportView1.SetParameter("SHDW", Request["SHDW"]);
}
if (!string.IsNullOrEmpty(Request["ZDRQfrom"]))
{
ReportView1.SetParameter("ZDRQfrom", Request["ZDRQfrom"]);
}
if (!string.IsNullOrEmpty(Request["ZDRQto"]))
{
ReportView1.SetParameter("ZDRQto", Request["ZDRQto"]);
}
break;
case "2":
if (!string.IsNullOrEmpty(Request["CKDH"]))
{
ReportView1.SetParameter("CKDH", Request["CKDH"]);
}
if (!string.IsNullOrEmpty(Request["CPH"]))
{
ReportView1.SetParameter("CPH", Request["CPH"]);
}
if (!string.IsNullOrEmpty(Request["ncdj"]))
{
ReportView1.SetParameter("ncdj", Request["ncdj"]);
}
if (!string.IsNullOrEmpty(Request["CKLX"]))
{
ReportView1.SetParameter("CKLX", Request["CKLX"]);
}
if (!string.IsNullOrEmpty(Request["CYS"]))
{
ReportView1.SetParameter("CYS", Request["CYS"]);
}
if (!string.IsNullOrEmpty(Request["CK"]))
{
ReportView1.SetParameter("CK", Request["CK"]);
}
if (!string.IsNullOrEmpty(Request["status"]))
{
ReportView1.SetParameter("status", Request["status"]);
}
if (!string.IsNullOrEmpty(Request["ZDR"]))
{
ReportView1.SetParameter("ZDR", Request["ZDR"]);
}
if (!string.IsNullOrEmpty(Request["SHDW"]))
{
ReportView1.SetParameter("SHDW", Request["SHDW"]);
}
if (!string.IsNullOrEmpty(Request["ZDRQfrom"]))
{
ReportView1.SetParameter("ZDRQfrom", Request["ZDRQfrom"]);
}
if (!string.IsNullOrEmpty(Request["ZDRQto"]))
{
ReportView1.SetParameter("ZDRQto", Request["ZDRQto"]);
}
break;
}
}
