protected void btnAdd_B_Click(object sender, EventArgs e) { try { #region 檢查條件 this.ErrorMsgLabel.Text = ""; string s_CheckPage = CheckPage(sender, "B"); if (s_CheckPage != string.Empty) { this.ErrorMsgLabel.Text = s_CheckPage; return; } #endregion string SessionIDName = "STM193_gvB" + PageTimeStamp.Value; DataTable dtB = new DataTable(); if (Session[SessionIDName] == null) { dtB = this.MakeDTForPriceDis(); } else { dtB = (DataTable)Session[SessionIDName]; } DataRow[] drB2 = (DataRow[])dtB.Select("ID=" + (this.HidIDB.Value == "" ? "0" : this.HidIDB.Value) + " AND EFF_START =CONVERT('" + Convert.ToDateTime(SLP_SLPDate1.Text).ToShortDateString() + "','System.DateTime')"); if (drB2.Length == 0) { #region 檢查生效日期 DataRow[] drB1 = (DataRow[])dtB.Select("STORE='" + SLP_Store1.Text.Trim() + "' AND ROOT_NO ='" + SLP_RootNo_B.Text.Trim() + "' AND PMA ='" + SLP_PMA_B.Text.Trim() + "' AND CATEGORY ='" + SLP_Category_B.Text.Trim() + "'" + " AND EFF_END >=CONVERT('" + Convert.ToDateTime(SLP_SLPDate1.Text).ToShortDateString() + "','System.DateTime')"); if (drB1.Length > 0) { ErrorMsgLabel.Text = "有效開始日期輸入有誤,應大於相同中分類折扣的有效結束日"; return; } ArrayList ArrPar = new ArrayList(); ArrPar.Add(this.SLP_Store1.Text.Trim()); ArrPar.Add(16); ArrPar.Add(Convert.ToDateTime(this.SLP_SLPDate1.Text.Trim())); ArrPar.Add(this.SLP_RootNo_B.Text.Trim()); ArrPar.Add(this.SLP_PMA_B.Text.Trim()); ArrPar.Add(this.SLP_Category_B.Text.Trim()); ArrPar.Add(System.DBNull.Value); ArrPar.Add(System.DBNull.Value); BCO.MaintainStoreDiscount bco = new BCO.MaintainStoreDiscount(ConnectionDB); int iResult; bco.QueryDisCountStartDate(ArrPar, out iResult); if (iResult > 0) { ErrorMsgLabel.Text = "有效開始日期輸入有誤,應大於相同中分類折扣的有效結束日"; return; } #endregion } if (this.HidIDB.Value != "") { DataRow drB = dtB.Select("ID=" + this.HidIDB.Value)[0]; drB["PRICE_DISCOUNT"] = this.SLP_SLPNumber1.Text.Trim(); drB["FIX_PRICE_DISCOUNT"] = System.DBNull.Value; if (this.SLP_SLPDate1.Text.Trim() != "") drB["EFF_START"] = Convert.ToDateTime(this.SLP_SLPDate1.Text.Trim()); else drB["EFF_START"] = System.DBNull.Value; if (this.SLP_SLPDate2.Text.Trim() != "") drB["EFF_END"] = Convert.ToDateTime(this.SLP_SLPDate2.Text.Trim()); else drB["EFF_END"] = System.DBNull.Value; drB["UPDATEUID"] = Session["UID"].ToString(); drB["FUN_TYPE"] = "U"; } else { DataView dv = dtB.DefaultView; dv.Sort = "ID desc"; DataRow drB = dtB.NewRow(); drB["ID"] = Convert.ToInt64(dv.Count == 0 ? 0 : dv[0]["ID"]) + 1; drB["STORE"] = this.SLP_Store1.Text.Trim(); drB["ROOT_NO"] = this.SLP_RootNo_B.Text.Trim(); drB["PMA"] = this.SLP_PMA_B.Text.Trim(); drB["CATEGORY"] = this.SLP_Category_B.Text.Trim(); drB["PRICE_DISCOUNT"] = this.SLP_SLPNumber1.Text.Trim(); if (this.SLP_SLPDate1.Text.Trim() != "") drB["EFF_START"] = Convert.ToDateTime(this.SLP_SLPDate1.Text.Trim()); else drB["EFF_START"] = System.DBNull.Value; if (this.SLP_SLPDate2.Text.Trim() != "") drB["EFF_END"] = Convert.ToDateTime(this.SLP_SLPDate2.Text.Trim()); else drB["EFF_END"] = System.DBNull.Value; drB["DISCOUNT_KIND"] = 16; drB["CONFIRM_CODE"] = 0; drB["FUN_TYPE"] = "A"; dtB.Rows.Add(drB); } this.GridViewB.Visible = true; DataView dvB = dtB.DefaultView; dvB.Sort = "ROOT_NO,PMA,CATEGORY"; Session["SessionID"] = SessionIDName; Session[SessionIDName] = dtB; this.GridViewB.DataSource = dvB; this.GridViewB.DataBind(); SLP_RootNo_B.Text = ""; SLP_PMA_B.Text = ""; SLP_Category_B.Text = ""; SLP_SLPNumber1.Text = ""; this.SLP_SLPDate1.Text = DateTime.Today.ToString("yyyy/MM/dd"); this.SLP_SLPDate2.Text = "9999/12/31"; if (this.HidIDB.Value != "") { this.panB.Visible = false; } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個 } }
protected void btnAdd_C_Click(object sender, EventArgs e) { try { #region 檢查條件 this.ErrorMsgLabel.Text = ""; string strROOT_NO = ""; string strPMA = ""; string strCATEGORY = ""; string s_CheckPage = CheckPage(sender, "C"); if (s_CheckPage != string.Empty) { this.ErrorMsgLabel.Text = s_CheckPage; return; } #endregion string SessionIDName = "STM193_gvC" + PageTimeStamp.Value; DataTable dtC = new DataTable(); if (Session[SessionIDName] == null) { dtC = this.MakeDTForPriceDis(); } else { dtC = (DataTable)Session[SessionIDName]; } //取得ROOT_NO,PMA,CATEGORY的值 DataTable dtItem = new DataTable(); dtItem = this.GetItem(this.SLP_SKU_C.Text.Trim()); if (dtItem.Rows.Count > 0) { for (int i = 0; i < dtItem.Rows.Count; i++) { strROOT_NO = dtItem.Rows[i]["ROOT_NO"].ToString(); strPMA = dtItem.Rows[i]["PMA"].ToString(); strCATEGORY = dtItem.Rows[i]["CATEGORY"].ToString(); } } DataRow[] drC2 = (DataRow[])dtC.Select("ID=" + (this.HidIDC.Value == "" ? "0" : this.HidIDC.Value) + " AND EFF_START =CONVERT('" + Convert.ToDateTime(SLP_SLPDate3.Text).ToShortDateString() + "','System.DateTime')"); if (drC2.Length == 0) { #region 檢查生效日期 //DataRow[] drC1 = (DataRow[])dtC.Select("STORE='" + SLP_Store1.Text.Trim() + "' AND ROOT_NO ='" + strROOT_NO + "' AND PMA ='" + strPMA // + "' AND CATEGORY ='" + strCATEGORY + "' AND ITEM ='" + SLP_SKU_C.Text.Trim() + "' AND PERIOD ='" + SLP_ItemPeriod_C.Text.Trim() // + "' AND EFF_END >=CONVERT('" + Convert.ToDateTime(SLP_SLPDate3.Text).ToShortDateString() + "','System.DateTime')"); //string strCn = "STORE='" + SLP_Store1.Text.Trim() + "' AND ITEM ='" + SLP_SKU_C.Text.Trim() // + @"' AND PERIOD ='" + SLP_ItemPeriod_C.Text.Trim() // + "' AND EFF_END >=CONVERT('" + Convert.ToDateTime(SLP_SLPDate3.Text).ToShortDateString() + "','System.DateTime')"; //DataRow[] drC1 = (DataRow[])dtC.Select(strCn); //if (drC1.Length > 0) //{ // ErrorMsgLabel.Text = "a有效開始日期輸入有誤,應大於相同商品期別折扣的有效結束日" + strCn; // return; //} //檢查生效日期 ArrayList ArrPar = new ArrayList(); ArrPar.Add(this.SLP_Store1.Text.Trim()); ArrPar.Add(32); ArrPar.Add(Convert.ToDateTime(this.SLP_SLPDate3.Text.Trim())); ArrPar.Add(strROOT_NO); ArrPar.Add(strPMA); ArrPar.Add(strCATEGORY); ArrPar.Add(this.SLP_SKU_C.Text.Trim()); ArrPar.Add(SLP_ItemPeriod_C.Text.Trim()); BCO.MaintainStoreDiscount bco = new BCO.MaintainStoreDiscount(ConnectionDB); int iResult; bco.QueryDisCountStartDate(ArrPar, out iResult); if (iResult > 0) { ErrorMsgLabel.Text = "有效開始日期輸入有誤,應大於相同商品期別折扣的有效結束日"; return; } #endregion } if (this.HidIDC.Value != "") { DataRow drC = dtC.Select("ID=" + this.HidIDC.Value)[0]; drC["PERIOD"] = this.SLP_ItemPeriod_C.Text.Trim(); drC["PERIOD_END"] = this.txtItemPeriod_END_C.Text.Trim(); drC["PRICE_DISCOUNT"] = GetValueSetParameter(this.SLP_SLPNumber_C.Text.Trim(), "string", false); drC["FIX_PRICE_DISCOUNT"] = GetValueSetParameter(this.SLP_SLPNumber_C2.Text.Trim(), "string", false); drC["VENDOR_SUBSIDY_PERCENT"] = GetValueSetParameter(this.SLP_SLPNumber2.Text.Trim(), "string", false); drC["COST_PERCENT"] = GetValueSetParameter(this.SLP_SLPNumber3.Text.Trim(), "string", false); if (this.SLP_SLPDate3.Text.Trim() != "") drC["EFF_START"] = Convert.ToDateTime(this.SLP_SLPDate3.Text.Trim()); else drC["EFF_START"] = System.DBNull.Value; if (this.SLP_SLPDate4.Text.Trim() != "") drC["EFF_END"] = Convert.ToDateTime(this.SLP_SLPDate4.Text.Trim()); else drC["EFF_END"] = System.DBNull.Value; drC["UPDATEUID"] = Session["UID"].ToString(); drC["FUN_TYPE"] = "U"; } else { DataView dv = dtC.DefaultView; dv.Sort = "ID desc"; DataRow drC = dtC.NewRow(); drC["ID"] = Convert.ToInt64(dv.Count == 0 ? 0 : dv[0]["ID"]) + 1; drC["STORE"] = this.SLP_Store1.Text.Trim(); drC["ROOT_NO"] = strROOT_NO; drC["PMA"] = strPMA; drC["CATEGORY"] = strCATEGORY; drC["ITEM"] = this.SLP_SKU_C.Text.Trim(); drC["PERIOD"] = this.SLP_ItemPeriod_C.Text.Trim(); drC["PERIOD_END"] = this.txtItemPeriod_END_C.Text.Trim(); drC["PRICE_DISCOUNT"] = GetValueSetParameter(this.SLP_SLPNumber_C.Text.Trim(), "string", false); drC["FIX_PRICE_DISCOUNT"] = GetValueSetParameter(this.SLP_SLPNumber_C2.Text.Trim(), "string", false); drC["VENDOR_SUBSIDY_PERCENT"] = GetValueSetParameter(this.SLP_SLPNumber2.Text.Trim(), "string", false); drC["COST_PERCENT"] = GetValueSetParameter(this.SLP_SLPNumber3.Text.Trim(), "string", false); if (this.SLP_SLPDate3.Text.Trim() != "") drC["EFF_START"] = Convert.ToDateTime(this.SLP_SLPDate3.Text.Trim()); else drC["EFF_START"] = System.DBNull.Value; if (this.SLP_SLPDate4.Text.Trim() != "") drC["EFF_END"] = Convert.ToDateTime(this.SLP_SLPDate4.Text.Trim()); else drC["EFF_END"] = System.DBNull.Value; drC["DISCOUNT_KIND"] = 32; drC["CONFIRM_CODE"] = 0; drC["FUN_TYPE"] = "A"; dtC.Rows.Add(drC); } this.GridViewC.Visible = true; DataView dvC = dtC.DefaultView; dvC.Sort = "EFF_START DESC,ROOT_NO,PMA,CATEGORY,ITEM,PERIOD desc"; Session["SessionID"] = SessionIDName; Session[SessionIDName] = dtC; this.GridViewC.DataSource = dvC; this.GridViewC.DataBind(); SLP_SKU_C.Text = ""; SLP_ItemPeriod_C.Text = ""; txtItemPeriod_END_C.Text = ""; SLP_SLPNumber_C2.Text = ""; SLP_SLPNumber_C.Text = ""; SLP_SLPNumber2.Text = ""; SLP_SLPNumber3.Text = ""; this.SLP_SLPDate3.Text = string.Empty;//DateTime.Today.ToString("yyyy/MM/dd"); this.SLP_SLPDate4.Text = string.Empty;//"9999/12/31"; if (this.HidIDC.Value != "") { this.panC.Visible = false; } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個 } }
protected void btnAdd_A_Click(object sender, EventArgs e) { try { #region 檢查條件 this.ErrorMsgLabel.Text = ""; string s_CheckPage = CheckPage(sender, "A"); if (s_CheckPage != string.Empty) { this.ErrorMsgLabel.Text = s_CheckPage; return; } string SessionIDName = "STM192_gvA" + PageTimeStamp.Value; DataTable dtA = new DataTable(); if (Session[SessionIDName] == null) { dtA = this.MakeDTForPriceDis(); } else { dtA = (DataTable)Session[SessionIDName]; } #endregion DataRow[] drA1 = (DataRow[])dtA.Select("STORE='" + SLP_Store1.Text.Trim() + "' AND ROOT_NO ='" + SLP_RootNo_A.Text.Trim() + "' AND PMA ='" + SLP_PMA_A.Text.Trim() + "' AND CATEGORY IS NULL AND ITEM IS NULL AND PERIOD IS NULL" + " AND EFF_START =CONVERT('" + Convert.ToDateTime(SLP_SLPDate_EFF_S_A.Text).ToShortDateString() + "','System.DateTime')"); if (drA1.Length > 0) { drA1[0].BeginEdit(); drA1[0]["STORE"] = this.SLP_Store1.Text.Trim(); drA1[0]["ROOT_NO"] = this.SLP_RootNo_A.Text.Trim(); drA1[0]["PMA"] = this.SLP_PMA_A.Text.Trim(); drA1[0]["PRICE_DISCOUNT"] = this.SLP_SLPNumber_PRICE_DIS_A.Text.Trim(); if (this.SLP_SLPDate_EFF_S_A.Text.Trim() != "") drA1[0]["EFF_START"] = Convert.ToDateTime(this.SLP_SLPDate_EFF_S_A.Text.Trim()); else drA1[0]["EFF_START"] = System.DBNull.Value; if (this.SLP_SLPDate_EFF_S_B.Text.Trim() != "") drA1[0]["EFF_END"] = Convert.ToDateTime(this.SLP_SLPDate_EFF_S_B.Text.Trim()); else drA1[0]["EFF_END"] = System.DBNull.Value; drA1[0].EndEdit(); } else { DataRow[] drA2 = (DataRow[])dtA.Select("STORE='" + SLP_Store1.Text.Trim() + "' AND ROOT_NO ='" + SLP_RootNo_A.Text.Trim() + "' AND PMA ='" + SLP_PMA_A.Text.Trim() + "' AND EFF_END >=CONVERT('" + Convert.ToDateTime(SLP_SLPDate_EFF_S_A.Text).ToShortDateString() + "','System.DateTime')"); if (drA2.Length > 0) { ErrorMsgLabel.Text = "有效開始日期輸入有誤,應大於相同大分類折扣的有效結束日"; return; } //檢查生效日期 ArrayList ArrPar = new ArrayList(); ArrPar.Add(this.SLP_Store1.Text.Trim()); ArrPar.Add(8); ArrPar.Add(Convert.ToDateTime(this.SLP_SLPDate_EFF_S_A.Text.Trim())); ArrPar.Add(this.SLP_RootNo_A.Text.Trim()); ArrPar.Add(this.SLP_PMA_A.Text.Trim()); ArrPar.Add(System.DBNull.Value); ArrPar.Add(System.DBNull.Value); ArrPar.Add(System.DBNull.Value); BCO.MaintainStoreDiscount bco = new BCO.MaintainStoreDiscount(ConnectionDB); int iResult; bco.QueryDisCountStartDate(ArrPar, out iResult); if (iResult > 0) { ErrorMsgLabel.Text = "有效開始日期輸入有誤,應大於相同大分類折扣的有效結束日"; return; } DataRow drA = dtA.NewRow(); drA["STORE"] = this.SLP_Store1.Text.Trim(); drA["ROOT_NO"] = this.SLP_RootNo_A.Text.Trim(); drA["PMA"] = this.SLP_PMA_A.Text.Trim(); drA["PRICE_DISCOUNT"] = this.SLP_SLPNumber_PRICE_DIS_A.Text.Trim(); if (this.SLP_SLPDate_EFF_S_A.Text.Trim() != "") drA["EFF_START"] = Convert.ToDateTime(this.SLP_SLPDate_EFF_S_A.Text.Trim()); else drA["EFF_START"] = System.DBNull.Value; if (this.SLP_SLPDate_EFF_S_B.Text.Trim() != "") drA["EFF_END"] = Convert.ToDateTime(this.SLP_SLPDate_EFF_S_B.Text.Trim()); else drA["EFF_END"] = System.DBNull.Value; drA["DISCOUNT_KIND"] = 8; drA["CONFIRM_CODE"] = 0; drA["FUN_TYPE"] = "A"; dtA.Rows.Add(drA); } this.GridViewA.Visible = true; DataView dvA = dtA.DefaultView; dvA.Sort = "ROOT_NO,PMA"; Session["SessionID"] = SessionIDName; Session[SessionIDName] = dtA; this.GridViewA.DataSource = dvA; this.GridViewA.DataBind(); SLP_RootNo_A.Text = ""; SLP_PMA_A.Text = ""; SLP_SLPNumber_PRICE_DIS_A.Text = ""; this.SLP_SLPDate_EFF_S_A.Text = DateTime.Today.ToString("yyyy/MM/dd"); this.SLP_SLPDate_EFF_S_B.Text = "9999/12/31"; } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個 } }