private void GetCGD051Data(string txtStAcceptNo, string txtStAcceptDate, string ddlTypeNo, string txtOutNo, string txtChanNo, string txtStore, string txtRoute, string txtStep, string SLP_SignDate, string txtChanSourceNo, string txtEnable, string SLP_SKU1, string txtSLP_Gift, string SLP_Period) { //抓取本頁初次登記的時間 string SessionIDName = "CGD052_01_" + Request.QueryString["SessionTimeStamp"]; CGDModel.MaintainSTStoreItemQry BCO = new CGDModel.MaintainSTStoreItemQry(ConntionDB); DataTable Dt; ParameterList.Clear(); ParameterList.Add(txtStAcceptNo.Trim()); ParameterList.Add(txtStAcceptDate.Trim()); ParameterList.Add(ddlTypeNo.Trim()); ParameterList.Add(txtOutNo.Trim()); ParameterList.Add(txtChanNo.Trim()); ParameterList.Add(txtStore.Trim()); ParameterList.Add(txtRoute.Trim()); ParameterList.Add(txtStep.Trim()); ParameterList.Add(SLP_SignDate.Trim()); ParameterList.Add(txtChanSourceNo.Trim()); ParameterList.Add("1"); ParameterList.Add(SLP_SKU1.Trim()); ParameterList.Add(txtSLP_Gift.Trim()); ParameterList.Add(SLP_Period.Trim()); Dt = BCO.QuerySwitch(CGDModel.CGDCommon.QueryType.QueryStAcceptMain, ParameterList); if (Dt.Rows.Count == 0) { ErrorMsgLabel.Text = "查無資料"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD051.aspx", "alert(' 查無資料 ');", true); } Session[SessionIDName] = Dt; }
/// <summary> /// 查詢門市進貨單是否已出庫 /// </summary> protected void checkStAcceptDate() { //抓取本頁初次登記的時間 string SessionIDName = "CGD052_" + PageTimeStamp.Value; string StAcceptDate = Convert.ToDateTime(txtStAcceptDate.Text.Trim()).ToShortDateString(); CGDModel.MaintainSTStoreItemQry BCO = new CGDModel.MaintainSTStoreItemQry(ConntionDB); DataTable Dt; ParameterList.Clear(); ParameterList.Add(StAcceptDate); ALOOutNo = BCO.CheckALOOutNO(ParameterList); if (ALOOutNo == true) { Label10.Text = "(已出庫)"; btnSave.Enabled = false; ToolBarInit(ALOOutNo); } else { Label10.Text = ""; ToolBarInit(ALOOutNo); } }
/// <summary> /// 儲存鈕 /// </summary> protected void btnSave_Click(object sender, EventArgs e) { int UpdateRecord = 0; System.IO.TextReader tr; //try //{ // string StAcceptDate = txtStAcceptDate.Text.Trim(); // CGDModel.MaintainSTStoreItemQry BCO = new CGDModel.MaintainSTStoreItemQry(ConntionDB); // DataTable Dt; // ParameterList.Clear(); // ParameterList.Add(StAcceptDate); // ALOOutNo = BCO.CheckALOOutNO(ParameterList); // if (ALOOutNo == true) // { // Label10.Text = "(門市進貨日日期已做出庫不可異動資料)"; // } // else // { // Label10.Text = ""; // } //} //catch (Exception ex) //{ // ErrorMsgLabel.Text = ex.Message; //} try { //抓取本頁初次登記的時間 string SessionIDName = "CGD052_" + PageTimeStamp.Value; CGDModel.MaintainSTStoreItemQry BCO = new CGDModel.MaintainSTStoreItemQry(ConntionDB); #region 取得畫面元件的值 string v_ST_ACCEPT_NO = txtStAcceptNo.Text.Trim(); DateTime v_UPDATEDATE = System.DateTime.Now; string v_UPDATEUID = Session["UID"].ToString(); #endregion #region 使用XML轉回DataSet , 取得更新前舊值 DataSet Ds = null; DataTable Dt = null; if (MasterOLDData.InnerHtml.ToString().Trim() != "") { Ds = new DataSet(); System.IO.StringReader sr = new System.IO.StringReader(MasterOLDData.InnerHtml); Ds.ReadXml(sr); Dt = Ds.Tables[0]; } #endregion string OLD_ST_ACCEPT_QTY = ""; string NEW_ST_ACCEPT_QTY = ""; for (int i = 0; i <= Dt.Rows.Count - 1; i++) { ParameterList.Clear(); ParameterList.Add(v_ST_ACCEPT_NO); ParameterList.Add(Dt.Rows[i]["ITEM"]); ParameterList.Add(Dt.Rows[i]["PERIOD"]); ParameterList.Add(Dt.Rows[i]["VIRTUAL_CODE"]); ParameterList.Add(Dt.Rows[i]["LOCATE_NO"]); ParameterList.Add(Dt.Rows[i]["LOCATE_SECTION"]); for (int j = 0; j <= GridView1.Rows.Count - 1; j++) { if ((((Label)(GridView1.Rows[j].FindControl("Label1"))).Text == Dt.Rows[i]["rownum"].ToString().Trim())) { if (((TextBox)(GridView1.Rows[j].FindControl("TextBox10"))).Text != "") { OLD_ST_ACCEPT_QTY = ((Label)(GridView1.Rows[j].FindControl("Label12"))).Text;//OLD_ST_ACCEPT_QTY NEW_ST_ACCEPT_QTY = ((TextBox)(GridView1.Rows[j].FindControl("TextBox10"))).Text;//NEW_ST_ACCEPT_QTY ParameterList.Add(((Label)(GridView1.Rows[j].FindControl("Label12"))).Text); //OLD_ST_ACCEPT_QTY ParameterList.Add(((TextBox)(GridView1.Rows[j].FindControl("TextBox10"))).Text);//NEW_ST_ACCEPT_QTY ((Label)(GridView1.Rows[j].FindControl("Label12"))).Text = ((TextBox)(GridView1.Rows[j].FindControl("TextBox10"))).Text;//把新值帶給舊值 } else { ParameterList.Add(0);//OLD_ST_ACCEPT_QTY ParameterList.Add(0);//NEW_ST_ACCEPT_QTY } } } ParameterList.Add(v_UPDATEDATE); ParameterList.Add(v_UPDATEUID); if (OLD_ST_ACCEPT_QTY != NEW_ST_ACCEPT_QTY) BCO.UpdateStAcceptItem(ParameterList, null); } ErrorMsgLabel.Text = "儲存完畢"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD052.aspx", "alert(' 儲存完畢 ');", true); } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }
/// <summary> /// databind 繫結查詢資料到GridView1 /// </summary> private void databind(string StAcceptNo, string strITEM, string strVIRTUAL_CODE, string strPERIOD) { //抓取本頁初次登記的時間 string SessionIDName = "CGD052_" + PageTimeStamp.Value; CGDModel.MaintainSTStoreItemQry BCO = new CGDModel.MaintainSTStoreItemQry(ConntionDB); DataTable Dt; ParameterList.Clear(); ParameterList.Add(StAcceptNo); ParameterList.Add(strITEM); ParameterList.Add(strVIRTUAL_CODE); ParameterList.Add(strPERIOD); Dt = BCO.QuerySwitch(CGDModel.CGDCommon.QueryType.QueryStAcceptItem, ParameterList); if (Dt.Rows.Count == 0) { ErrorMsgLabel.Text = "無進貨數量資料"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD052.aspx", "alert(' 無進貨數量資料 ');", true); } #region 使用XML放置到前端資料 MasterOLDData.InnerHtml = Dt.DataSet.GetXml(); #endregion checkStAcceptDate(); Session[SessionIDName] = Dt; GridView1.DataSource = Dt; //設定分頁大小 GridView1.PageIndex = 0; GridView1.DataBind(); }
/// <summary> /// databindDDL 繫結查詢資料到DropDownList /// </summary> private void databindDDL() { CGDModel.MaintainSTStoreItemQry BCO = new CGDModel.MaintainSTStoreItemQry(ConntionDB); DataTable Dt; ParameterList.Clear(); Dt = BCO.QuerySwitch(CGDModel.CGDCommon.QueryType.TypeNo, ParameterList); ddlTypeNo.DataSource = Dt; ddlTypeNo.DataTextField = "EXPLAIN"; ddlTypeNo.DataValueField = "SCODE"; ddlTypeNo.DataBind(); }
/// <summary> /// databind 繫結查詢資料到GridView1 /// </summary> private void databind() { //抓取本頁初次登記的時間 string SessionIDName = "CGD051_" + PageTimeStamp.Value; CGDModel.MaintainSTStoreItemQry BCO = new CGDModel.MaintainSTStoreItemQry(ConntionDB); DataTable Dt; ParameterList.Clear(); ParameterList.Add(txtStAcceptNo.Text.Trim()); ParameterList.Add(SLP_StAcceptDate.Text.Trim()); ParameterList.Add(ddlTypeNo.SelectedItem.Value); ParameterList.Add(txtOutNo.Text.Trim()); ParameterList.Add(txtChanNo.Text.Trim()); ParameterList.Add(txtStore.Text.Trim()); ParameterList.Add(txtRoute.Text.Trim()); ParameterList.Add(txtStep.Text.Trim()); ParameterList.Add(SLP_SignDate.Text.Trim()); ParameterList.Add(txtChanSourceNo.Text.Trim()); ParameterList.Add("1"); ParameterList.Add(SLP_SKU1.Text.Trim()); ParameterList.Add(txtSLP_Gift.Text.Trim()); ParameterList.Add(SLP_Period.Text.Trim()); Dt = BCO.QuerySwitch(CGDModel.CGDCommon.QueryType.QueryStAcceptMain, ParameterList); if (Dt.Rows.Count == 0) { ErrorMsgLabel.Text = "查無資料"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD051.aspx", "alert(' 查無資料 ');", true); } #region 使用XML放置到前端資料 MasterOLDData.InnerHtml = Dt.DataSet.GetXml(); #endregion Session[SessionIDName] = Dt; GridView1.DataSource = Dt; //設定分頁大小 GridView1.PageIndex = 0; GridView1.DataBind(); }