protected void but_Save_Click(object sender, EventArgs e) { try { #region 檢查必填欄位 System.Text.StringBuilder sb = new System.Text.StringBuilder(); if (this.SLP_STORE.Text.Trim() == string.Empty) { sb.Append("[店號]欄位不可空白<br/>"); } if (this.SLP_EFF_DATE_FROM.Text.Trim() == string.Empty) { sb.Append("[舊履歷結束日]欄位不可空白<br/>"); } if (this.SLP_EFF_DATE_TO.Text.Trim() == string.Empty) { sb.Append("[新履歷結束日]欄位不可空白<br/>"); } if (this.SLP_EFF_DATE_TO.Text.Trim() == string.Empty) { sb.Append("[新履歷結束日]欄位不可空白<br/>"); } if (this.SLP_EFF_DATE_FROM.Text.Trim() != string.Empty && this.SLP_EFF_DATE_TO.Text.Trim() != string.Empty) { if (DateTime.Parse(this.SLP_EFF_DATE_TO.Text.Trim()) <= DateTime.Parse(this.SLP_OLD_EFF_DATE_TO.Text.Trim())) { sb.Append("[新履歷結束日]需大於[舊履歷結束日]<br/>"); } } if (sb.ToString() != string.Empty) { ErrorMsgLabel.Text = sb.ToString(); return; } #endregion ArrayList ParameterList = new ArrayList(); ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(this.SLP_STORE.Text, "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_EFF_DATE_FROM.Text, "date", false)); ParameterList.Add(GetValueSetParameter(this.SLP_EFF_DATE_TO.Text, "date", false)); ParameterList.Add(GetValueSetParameter(Session["UID"].ToString(), "string", false)); string Msg; #region 儲存單筆修改資料 BCO.MaintainStoreAccount bco = new BCO.MaintainStoreAccount(ConntionDB); bco.UpdateEffDateTo(ParameterList, null,out Msg); #endregion System.Web.UI.ScriptManager.RegisterStartupScript(this.but_Save, this.GetType(), "TO_STM25A.aspx", "alert('"+Msg+"');window.opener.location.reload();window.close();", true); } catch (Exception ex) { WaringLogProcess(ex.Message); this.ErrorMsgLabel.Text = ex.Message; } finally { } }
private void QueryData(string v_store, string v_eff_date_from) { try { #region 將變數資料清空 ds_Data.Tables.Clear(); #endregion #region 門市帳務主檔 STMModel.MaintainStoreAccount BCO = new STMModel.MaintainStoreAccount(ConnectionDB); DataTable Dt; ParameterList.Clear(); for (int i = 0; i <= 47; i++) { if (i == 8) ParameterList.Add(v_store); else if (i == 9 || i == 10) ParameterList.Add((DateTime.Parse(v_eff_date_from)).ToString("yyyy/MM/dd")); else ParameterList.Add(DBNull.Value); } //筆數為1 ParameterList.Add(1); Dt = BCO.QuerySwitch(STMModel.MaintainStoreAccount.QueryType.QueryByLike, ParameterList); if (Dt == null || (Dt != null && Dt.Rows.Count <= 0)) { ErrorMsgLabel.Text = "查無資料"; return; } this.SLP_STORE.Text = Dt.Rows[0]["STORE"].ToString(); this.SLP_EFF_DATE_FROM.Text = Dt.Rows[0].IsNull("EFF_DATE_FROM") ? "" : Convert.ToDateTime(Dt.Rows[0]["EFF_DATE_FROM"]).ToShortDateString(); this.SLP_EFF_DATE_TO.Text = Dt.Rows[0].IsNull("EFF_DATE_TO") ? "" : Convert.ToDateTime(Dt.Rows[0]["EFF_DATE_TO"]).ToShortDateString(); this.txtGROUP_NO.Text = Dt.Rows[0]["GROUP_NO"].ToString(); this.txtSAL_ID.Text = Dt.Rows[0]["SAL_UID"].ToString(); this.txtAC_UID.Text = Dt.Rows[0]["AC_UID"].ToString(); this.txtPAY_RFNO.Text = Dt.Rows[0]["PAY_RFNO"].ToString(); this.radSTORE_TYPE_HEAD.Checked = false; this.radSTORE_TYPE_STORE.Checked = false; if (Dt.Rows[0]["STORE_TYPE"].ToString() == "1") this.radSTORE_TYPE_HEAD.Checked = true; else this.radSTORE_TYPE_STORE.Checked = true; this.txtRFNO.Text = Dt.Rows[0]["RFNO"].ToString(); this.txtTITLE.Text = Dt.Rows[0]["TITLE"].ToString(); this.txtINV_ADDR.Text = Dt.Rows[0]["INV_ADDR"].ToString(); this.txtPERSON.Text = Dt.Rows[0]["PERSON"].ToString(); this.SLP_PROFIT_NO.Text = Dt.Rows[0]["PROFIT_NO"].ToString(); this.SLP_FEET.Text = Dt.Rows[0]["FEET"].ToString(); this.txtPAY_ACCOUNT.Text = Dt.Rows[0]["PAY_ACCOUNT"].ToString(); this.radDEPOSIT_NO_HEAD.Checked = false; this.radDEPOSIT_NO_STORE.Checked = false; if (Dt.Rows[0]["DEPOSIT_NO"].ToString() == "1") this.radDEPOSIT_NO_HEAD.Checked = true; else this.radDEPOSIT_NO_STORE.Checked = true; this.ddlDEPOSIT_TYPE.SelectedValue = Dt.Rows[0]["DEPOSIT_TYPE"].ToString(); this.SLP_DEPOSIT.Text = Dt.Rows[0]["DEPOSIT"].ToString(); this.SLP_DEPOSIT_DATE_FROM.Text = Dt.Rows[0].IsNull("DEPOSIT_DATE_FROM") ? "" : Convert.ToDateTime(Dt.Rows[0]["DEPOSIT_DATE_FROM"]).ToShortDateString(); this.SLP_DEPOSIT_DATE_TO.Text = Dt.Rows[0].IsNull("DEPOSIT_DATE_TO") ? "" : Convert.ToDateTime(Dt.Rows[0]["DEPOSIT_DATE_TO"]).ToShortDateString(); this.SLP_DUIT_UNIT.Text = Dt.Rows[0]["DUTY_UNIT"].ToString(); this.ddlPAYMENT_STORE.SelectedValue = Dt.Rows[0]["PAYMENT_STORE"].ToString(); this.txtAC_NAME.Text = Dt.Rows[0]["AC_NAME"].ToString(); this.txtINVOICE_MAILADD.Text = Dt.Rows[0]["INVOICE_MAIL_ADD"].ToString(); this.SLP_INVOICE_SEND.Text = Dt.Rows[0]["INVOICE_SEND"].ToString(); this.SLP_INVOICE_TYPE.Text = Dt.Rows[0]["INVOICE_TYPE"].ToString(); this.ddlPAY_TYPE.SelectedValue = Dt.Rows[0]["PAY_TYPE"].ToString(); this.SLP_CLS_DATE.Text = Dt.Rows[0]["CLS_DATE"].ToString(); if (Dt.Rows[0]["ARMK"].ToString() == "1") this.txtARMK.Text = "已審核"; else this.txtARMK.Text = "未審核"; this.txtPID.Text = Dt.Rows[0]["ID"].ToString(); if (this.txtARMK.Text == "已審核") btnPASS.Enabled = false; if (this.txtARMK.Text == "未審核") btnNOPASS.Enabled = false; #endregion #region 設定屬性 STMModel.MaintainStoreAccount BCO_root = new STMModel.MaintainStoreAccount(ConnectionDB); DataTable Dt_root; ParameterList.Clear(); ParameterList.Add(v_store); ParameterList.Add((DateTime.Parse(v_eff_date_from)).ToString("yyyy/MM/dd")); Dt_root = BCO_root.QuerySwitch(STMModel.MaintainStoreAccount.QueryType.ROOT, ParameterList); GridView1.DataSource = Dt_root; string SessionIDName_root = string.Format("{0}_{1}", PAGE_DT_01, PageTimeStamp.Value); Session[SessionIDName_root] = Dt_root; //設定分頁大小 GridView1.PageIndex = 0; GridView1.DataBind(); this.txtCount_Store.Text = GridView1.Rows.Count.ToString(); #endregion #region 收款天數 STMModel.MaintainStoreAccount BCO_Charge = new STMModel.MaintainStoreAccount(ConnectionDB); DataTable Dt_charge; ParameterList.Clear(); ParameterList.Add(v_store); ParameterList.Add((DateTime.Parse(v_eff_date_from)).ToString("yyyy/MM/dd")); Dt_charge = BCO_Charge.QuerySwitch(STMModel.MaintainStoreAccount.QueryType.CHARGE, ParameterList); GridView2.DataSource = Dt_charge; string SessionIDName = string.Format("{0}_{1}", PAGE_DT_02, PageTimeStamp.Value); Session[SessionIDName] = Dt_charge; //設定分頁大小 GridView2.PageIndex = 0; GridView2.DataBind(); #endregion #region 店群折扣-商品大分類 STMModel.MaintainStoreAccount BCO_Group1 = new STMModel.MaintainStoreAccount(ConnectionDB); DataTable Dt_Group1; ParameterList.Clear(); ParameterList.Add(this.txtGROUP_NO.Text); Dt_Group1 = BCO_Group1.GetQueryGroupDiscountPMA(ParameterList); GridView3_1.DataSource = Dt_Group1; string SessionIDName3_1 = string.Format("{0}_{1}", PAGE_DT_031, PageTimeStamp.Value); Session[SessionIDName3_1] = Dt_Group1; //設定分頁大小 GridView3_1.PageIndex = 0; GridView3_1.DataBind(); #endregion #region 店群折扣-商品中分類 STMModel.MaintainStoreAccount BCO_Group2 = new STMModel.MaintainStoreAccount(ConnectionDB); DataTable Dt_Group2; ParameterList.Clear(); ParameterList.Add(this.txtGROUP_NO.Text); Dt_Group2 = BCO_Group2.GetQueryGroupDiscountCategory(ParameterList); GridView3_2.DataSource = Dt_Group2; string SessionIDName3_2 = string.Format("{0}_{1}", PAGE_DT_032, PageTimeStamp.Value); Session[SessionIDName3_2] = Dt_Group2; //設定分頁大小 GridView3_2.PageIndex = 0; GridView3_2.DataBind(); #endregion #region 店群折扣-商品 STMModel.MaintainStoreAccount BCO_Group3 = new STMModel.MaintainStoreAccount(ConnectionDB); DataTable Dt_Group3; ParameterList.Clear(); ParameterList.Add(this.txtGROUP_NO.Text); Dt_Group3 = BCO_Group3.GetQueryGroupDiscountItem(ParameterList); GridView3_3.DataSource = Dt_Group3; string SessionIDName3_3 = string.Format("{0}_{1}", PAGE_DT_033, PageTimeStamp.Value); Session[SessionIDName3_3] = Dt_Group3; //設定分頁大小 GridView3_3.PageIndex = 0; GridView3_3.DataBind(); #endregion #region 門市折扣-商品大分類 STMModel.MaintainStoreAccount BCO_Store1 = new STMModel.MaintainStoreAccount(ConnectionDB); DataTable Dt_Store1; ParameterList.Clear(); ParameterList.Add(v_store); Dt_Store1 = BCO_Store1.GetQueryStoreDiscountPMA(ParameterList); GridView4_1.DataSource = Dt_Store1; string SessionIDName4_1 = string.Format("{0}_{1}", PAGE_DT_041, PageTimeStamp.Value); Session[SessionIDName4_1] = Dt_Store1; //設定分頁大小 GridView4_1.PageIndex = 0; GridView4_1.DataBind(); #endregion #region 門市折扣-商品中分類 STMModel.MaintainStoreAccount BCO_Store2 = new STMModel.MaintainStoreAccount(ConnectionDB); DataTable Dt_Store2; ParameterList.Clear(); ParameterList.Add(v_store); Dt_Store2 = BCO_Store2.GetQueryStoreDiscountCategory(ParameterList); GridView4_2.DataSource = Dt_Store2; string SessionIDName4_2 = string.Format("{0}_{1}", PAGE_DT_042, PageTimeStamp.Value); Session[SessionIDName4_2] = Dt_Store2; //設定分頁大小 GridView4_2.PageIndex = 0; GridView4_2.DataBind(); #endregion #region 門市折扣-商品 STMModel.MaintainStoreAccount BCO_Store3 = new STMModel.MaintainStoreAccount(ConnectionDB); DataTable Dt_Store3; ParameterList.Clear(); ParameterList.Add(v_store); Dt_Store3 = BCO_Store3.GetQueryStoreDiscountItem(ParameterList); GridView4_3.DataSource = Dt_Store3; string SessionIDName4_3 = string.Format("{0}_{1}", PAGE_DT_043, PageTimeStamp.Value); Session[SessionIDName4_3] = Dt_Store3; //設定分頁大小 GridView4_3.PageIndex = 0; GridView4_3.DataBind(); #endregion if (Dt == null || (Dt != null && Dt.Rows.Count <= 0)) { return; } #region 將資料寫入變數 Dt.TableName = "VDS_STM_ACCOUNT_PROPERTY"; Dt_root.TableName = "VDS_STM_ACCOUNT_ROOT"; Dt_charge.TableName = "VDS_STM_ACCOUNT_CHARGE"; ds_Data.Tables.Add(Dt.Copy()); ds_Data.Tables.Add(Dt_root.Copy()); ds_Data.Tables.Add(Dt_charge.Copy()); //設定屬性 DataSet ds_root = new DataSet(); ds_root.Tables.Add(Dt_root.Copy()); DataColumn[] keys_root = new DataColumn[3]; keys_root[0] = ds_root.Tables[0].Columns["STORE"]; keys_root[1] = ds_root.Tables[0].Columns["ROOT_NO"]; keys_root[2] = ds_root.Tables[0].Columns["EFF_DATE_FROM"]; ds_root.Tables[0].PrimaryKey = keys_root; Session["STM252_root" + PageTimeStamp.Value] = ds_root; //收款天數 DataSet ds = new DataSet(); ds.Tables.Add(Dt_charge.Copy()); //DataColumn[] keys = new DataColumn[4]; //keys[0] = ds.Tables[0].Columns["STORE"]; //keys[1] = ds.Tables[0].Columns["EFF_DATE_FROM"]; //keys[2] = ds.Tables[0].Columns["ROOT_NO"]; // keys[3] = ds.Tables[0].Columns["PMA"]; DataColumn[] keys = new DataColumn[1]; keys[0] = ds.Tables[0].Columns["ID"]; ds.Tables[0].PrimaryKey = keys; Session["STM252_" + PageTimeStamp.Value] = ds; #endregion //UpdatePanel12.Update(); } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個 } finally { } }
private DataTable Check_Root() { STMModel.MaintainStoreAccount BCO_root = new STMModel.MaintainStoreAccount(ConnectionDB); DataTable Dt_root; ParameterList.Clear(); ParameterList.Add(SLP_STORE.Text); ParameterList.Add((DateTime.Parse(this.SLP_EFF_DATE_FROM.Text)).ToString("yyyy/MM/dd")); ParameterList.Add(txtPAY_RFNO.Text); Dt_root = BCO_root.QuerySwitch(STMModel.MaintainStoreAccount.QueryType.HeadROOT, ParameterList); return Dt_root; }
protected void btnClose_Click(object sender, EventArgs e) { STMModel.MaintainStoreAccount BCO = new STMModel.MaintainStoreAccount(ConnectionDB); ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(this.SLP_STORE.Text, "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_EFF_DATE_FROM.Text, "date", false)); ParameterList.Add(GetValueSetParameter(Session["UID"].ToString(), "string", false)); BCO.UpdateDeposit(ParameterList, null); ScriptManager.RegisterStartupScript(UpdatePanel11, this.GetType(), "ClientScript", "alert('結清質押金成功');location.replace('STM252.aspx?mode=view&store=" + SLP_STORE.Text + "&eff_date_from=" + SLP_EFF_DATE_FROM.Text.ToString() + "&Code=STM25');", true); }
/// <summary> /// 元件顯示及使用屬性初始設定 /// </summary> private void Initialization_Component() { #region 權限設定 #region STM26功能權限設定 AuthorityControls(this); this.btnNOPASS.Visible = CanUpdate; this.btnPASS.Visible = AuthUpdate; #endregion #endregion #region 取得登入使用者名稱 DataTable dt_name = new DataTable(); dt_name = (DataTable)Session["UserInfo"]; Login_Name = dt_name.Rows[0]["Name"].ToString(); #endregion #region 設定屬性新增DataSet //新增DataSet DataSet ds_root = new DataSet(); DataTable dt_root = new DataTable(); DataColumn[] keys_root = new DataColumn[3]; ds_root.Tables.Add(dt_root); dt_root.Columns.Add("STORE", Type.GetType("System.String")); dt_root.Columns.Add("ROOT_NO", Type.GetType("System.String")); dt_root.Columns.Add("ROOT_NO_EXPLAIN", Type.GetType("System.String")); dt_root.Columns.Add("EFF_DATE_FROM", Type.GetType("System.String")); dt_root.Columns.Add("HEAD_DOC", Type.GetType("System.String")); dt_root.Columns.Add("HEAD_DOC_EXPLAIN", Type.GetType("System.String")); dt_root.Columns.Add("SINGLE_DOC", Type.GetType("System.String")); dt_root.Columns.Add("SINGLE_DOC_EXPLAIN", Type.GetType("System.String")); dt_root.Columns.Add("PAYMENT_TYPE", Type.GetType("System.String")); dt_root.Columns.Add("PAYMENT_TYPE_EXPLAIN", Type.GetType("System.String")); dt_root.Columns.Add("CREATEDATE"); dt_root.Columns.Add("CREATEUID"); dt_root.Columns.Add("UPDATEDATE"); dt_root.Columns.Add("UPDATEUID"); dt_root.Columns["STORE"].AllowDBNull = false; dt_root.Columns["ROOT_NO"].AllowDBNull = false; dt_root.Columns["EFF_DATE_FROM"].AllowDBNull = false; keys_root[0] = dt_root.Columns["STORE"]; keys_root[1] = dt_root.Columns["ROOT_NO"]; keys_root[2] = dt_root.Columns["EFF_DATE_FROM"]; dt_root.PrimaryKey = keys_root; string SessionIDName_root = "STM252_root" + PageTimeStamp.Value; Session[SessionIDName_root] = ds_root; #endregion #region 收款天數新增DataSet //新增DataSet DataSet ds = new DataSet(); DataTable dt = new DataTable(); DataColumn[] keys = new DataColumn[1]; ds.Tables.Add(dt); dt.Columns.Add("ID", Type.GetType("System.String")); dt.Columns.Add("STORE", Type.GetType("System.String")); dt.Columns.Add("EFF_DATE_FROM", Type.GetType("System.String")); dt.Columns.Add("ROOT_NO", Type.GetType("System.String")); dt.Columns.Add("ROOT_NO_EXPLAIN", Type.GetType("System.String")); dt.Columns.Add("PMA", Type.GetType("System.String")); dt.Columns.Add("PMA_EXPLAIN", Type.GetType("System.String")); dt.Columns.Add("COL_DAYS", Type.GetType("System.String")); dt.Columns.Add("COL_DAYS_EXPLAIN", Type.GetType("System.String")); dt.Columns.Add("CREATEDATE"); dt.Columns.Add("CREATEUID"); dt.Columns.Add("UPDATEDATE"); dt.Columns.Add("UPDATEUID"); dt.Columns["STORE"].AllowDBNull = false; dt.Columns["EFF_DATE_FROM"].AllowDBNull = false; //dt.Columns["ROOT_NO"].AllowDBNull = false; //dt.Columns["PMA"].AllowDBNull = false; keys[0] = dt.Columns["ID"]; //keys[1] = dt.Columns["EFF_DATE_FROM"]; //keys[2] = dt.Columns["ROOT_NO"]; //keys[3] = dt.Columns["PMA"]; dt.PrimaryKey = keys; string SessionIDName = "STM252_" + PageTimeStamp.Value; Session[SessionIDName] = ds; #endregion #region 預設欄位值 //模式指定 string mode = ""; mode = Request.QueryString["mode"].ToString(); if (mode == "view") { QueryData(Request.QueryString["store"].ToString(), Request.QueryString["eff_date_from"].ToString()); ReadOnlyMode(false); if (this.txtARMK.Text == "已審核") { btnEdit_M.Enabled = false; //編輯 btnPASS.Enabled = false; btnNOPASS.Enabled = true; } if (this.txtARMK.Text == "未審核") { btnEdit_M.Enabled = true; //編輯 btnPASS.Enabled = true; btnNOPASS.Enabled = false; btnExtend.Visible = false; } if (SLP_EFF_DATE_TO.Text.Length > 0) { if (Convert.ToDateTime(this.SLP_EFF_DATE_TO.Text).CompareTo(System.DateTime.Today) == -1) { btnEdit_M.Enabled = false;//編輯 btnPASS.Enabled = false; //審核 btnNOPASS.Enabled = false;//審核解除 if (CanUpdate && this.txtARMK.Text == "已審核") { STMModel.MaintainStoreAccount BCO = new STMModel.MaintainStoreAccount(ConnectionDB); ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(this.SLP_STORE.Text, "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_EFF_DATE_FROM.Text, "date", false)); if (BCO.QueryIsLatest(ParameterList).Rows.Count == 0) { btnExtend.Visible = true; if (SLP_DEPOSIT.Text.Trim()!="") { if (int.Parse(SLP_DEPOSIT.Text.Trim()) > 0) { btnClose.Visible = true; } } } } } } } if (mode == "insert") { ReadOnlyMode(true); btnCopy.Visible = false; btnSave.Visible = true; //確定新增 btnAddCancle.Visible = true; //取消(回查詢頁) btnEdt.Visible = false; //確定更新 btnUpdateCancel.Visible = false; //取消(回檢視頁) btnPASS.Visible = false; //審核 btnNOPASS.Visible = false; //審核解除 radSTORE_TYPE_HEAD.Checked = false; radSTORE_TYPE_STORE.Checked = true; txtPAY_RFNO.ReadOnly = true; txtPAY_RFNO.CssClass = "readtxtbox"; txtARMK.Text = "未審核"; this.SLP_EFF_DATE_TO.Text = "9999/12/31"; } #endregion #region 註冊JavaScript TextBox txt_STORE_ID = (TextBox)this.SLP_STORE.FindControl("TextBoxCode"); txt_STORE_ID.Attributes["onblur"] += "if ( document.getElementById('" + txt_STORE_ID.ClientID + "').readOnly == false && document.getElementById('" + txt_STORE_ID.ClientID + "').value.length!=0){__doPostBack('" + UpdatePanel12.ClientID + "','txt_STORE_Onblur');}"; txtPAY_RFNO.Attributes["onblur"] += "if ( document.getElementById('" + txtPAY_RFNO.ClientID + "').readOnly == false){__doPostBack('" + UpdatePanel12.ClientID + "','txt_PAY_RFNO_Onblur');}"; txtRFNO.Attributes["onblur"] += "if ( document.getElementById('" + txtRFNO.ClientID + "').readOnly == false){__doPostBack('" + UpdatePanel12.ClientID + "','txt_RFNO_Onblur');}"; #endregion }
protected void btnPASS_Click(object sender, EventArgs e) { #region 檢查判斷 //檢核必輸入欄位 TextBox STORE = ((TextBox)((ASP.stm_slp_slp_store_ascx)SLP_STORE).FindControl("TextBoxCode")); TextBox EFF_DATE_FROM = ((TextBox)((ASP.wui_slp_slp_slpdate_ascx)SLP_EFF_DATE_FROM).FindControl("TextBoxCode")); TextBox EFF_DATE_TO = ((TextBox)((ASP.wui_slp_slp_slpdate_ascx)SLP_EFF_DATE_TO).FindControl("TextBoxCode")); TextBox PROFIT_NO = ((TextBox)((ASP.stm_slp_slp_profitcenter_ascx)SLP_PROFIT_NO).FindControl("TextBoxCode")); TextBox DUTY_UNIT = ((TextBox)((ASP.sys_slp_slp_role_ascx)SLP_DUIT_UNIT).FindControl("TextBoxCode")); TextBox[] FieldIDs ={ STORE, EFF_DATE_FROM, EFF_DATE_TO, txtPAY_RFNO, txtRFNO, txtTITLE, txtINV_ADDR, txtPERSON, PROFIT_NO, DUTY_UNIT }; string[] FieldNames ={ "店號", "履歷開始日", "履歷結束日", "結帳統編", "單店統編", "發票抬頭", "發票登記地址", "負責人", "利潤中心", "權責單位" }; int i = 0; foreach (TextBox FieldName in FieldIDs) { if (FieldName.Text.Trim().Length == 0) { ErrorMsgLabel.Text = "必須輸入「" + FieldNames[i] + "」欄位"; return; } i++; } #endregion DateTime processtime = DateTime.Now; STMModel.MaintainStoreAccount STM = new STMModel.MaintainStoreAccount(ConntionDB); ParameterList.Clear(); ParameterList.Add(this.SLP_STORE.Text); //V_STORE ParameterList.Add(GetValueSetParameter(this.SLP_EFF_DATE_FROM.Text, "date", false)); //D_EFF_DATE_FROM ParameterList.Add(processtime); //D_NEW_UPDATEDATE ParameterList.Add(GetValueSetParameter(Session["UID"].ToString(), "string", false)); //V_NEW_UPDATEUID STM.ConfirmStoreARMK(ParameterList); int i_Count = 0; string s_Request_Key = ""; if (Request.QueryString["STM252_COUNT"] == null) { i_Count = 0; s_Request_Key = ""; } else { i_Count = int.Parse(Request.QueryString["STM252_COUNT"]); s_Request_Key = Request.QueryString["STM252_PageTimeStamp"]; } ScriptManager.RegisterStartupScript(UpdatePanel11, this.GetType(), "ClientScript", "alert('審核成功');", true); QueryData(this.SLP_STORE.Text, this.SLP_EFF_DATE_FROM.Text); ReadOnlyMode(false); if (this.txtARMK.Text == "已審核") { btnEdit_M.Enabled = false; //編輯 btnPASS.Enabled = false; btnNOPASS.Enabled = true; } if (this.txtARMK.Text == "未審核") { btnEdit_M.Enabled = true; //編輯 btnPASS.Enabled = true; btnNOPASS.Enabled = false; } if (SLP_EFF_DATE_TO.Text.Length > 0) { if (Convert.ToDateTime(this.SLP_EFF_DATE_TO.Text).CompareTo(System.DateTime.Today) == -1) { btnEdit_M.Enabled = false;//編輯 btnPASS.Enabled = false; //審核 btnNOPASS.Enabled = false;//審核解除 } } }
protected void btnNOPASS_Click(object sender, EventArgs e) { try { string Msg = ""; DateTime processtime = DateTime.Now; STMModel.MaintainStoreAccount STM = new STMModel.MaintainStoreAccount(ConntionDB); ParameterList.Clear(); ParameterList.Add(this.SLP_STORE.Text); //V_STORE ParameterList.Add(GetValueSetParameter(this.SLP_EFF_DATE_FROM.Text, "date", false)); //D_EFF_DATE_FROM ParameterList.Add(processtime); //D_NEW_UPDATEDATE ParameterList.Add(GetValueSetParameter(Session["UID"].ToString(), "string", false)); //V_NEW_UPDATEUID STM.UnConfirmStoreARMK(ParameterList, out Msg); if (Msg != "") { throw new Exception(Msg); } else { int i_Count = 0; string s_Request_Key = ""; if (Request.QueryString["STM252_COUNT"] == null) { i_Count = 0; s_Request_Key = ""; } else { i_Count = int.Parse(Request.QueryString["STM252_COUNT"]); s_Request_Key = Request.QueryString["STM252_PageTimeStamp"]; } ScriptManager.RegisterStartupScript(UpdatePanel11, this.GetType(), "ClientScript", "alert('審核解除成功');", true); QueryData(this.SLP_STORE.Text, this.SLP_EFF_DATE_FROM.Text); ReadOnlyMode(false); if (this.txtARMK.Text == "已審核") { btnEdit_M.Enabled = false; //編輯 btnPASS.Enabled = false; btnNOPASS.Enabled = true; } if (this.txtARMK.Text == "未審核") { btnEdit_M.Enabled = true; //編輯 btnPASS.Enabled = true; btnNOPASS.Enabled = false; } if (SLP_EFF_DATE_TO.Text.Length > 0) { if (Convert.ToDateTime(this.SLP_EFF_DATE_TO.Text).CompareTo(System.DateTime.Today) == -1) { btnEdit_M.Enabled = false;//編輯 btnPASS.Enabled = false; //審核 btnNOPASS.Enabled = false;//審核解除 } } } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個 } }
protected void btnEdit_M_Click(object sender, EventArgs e) { //預設欄位Focus SetClinetFocus(SLP_STORE.ClientID); ReadOnlyMode(true); btnSave.Visible = false; btnPASS.Visible = false; btnNOPASS.Visible = false; btnCopy.Visible = false; GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Find, true, "STM251.aspx?Code=STM25", null, WUI_GMToolbarV.ClickAction.LinkURL); GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.FindExport, false, "", this.btnEdit_M, WUI_GMToolbarV.ClickAction.ButtonClick); GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.New, false, string.Empty, this.btnEdit_M, WUI_GMToolbarV.ClickAction.ButtonClick); GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Save, true, string.Empty, this.btnEdt, WUI_GMToolbarV.ClickAction.ButtonClick); GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Edit, false, string.Empty, this.btnEdit_M, WUI_GMToolbarV.ClickAction.ButtonClick); GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Delete, false, string.Empty, this.btnEdit_M, WUI_GMToolbarV.ClickAction.ButtonClick); GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Copy, false, string.Empty, this.btnCopy, WUI_GMToolbarV.ClickAction.ButtonClick); if (txtPAY_RFNO.Text == txtRFNO.Text && radSTORE_TYPE_STORE.Checked) { #region 總部門市資料唯讀 STMModel.MaintainStoreAccount BCO = new STMModel.MaintainStoreAccount(ConnectionDB); DataTable Dt_rtn; ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(this.SLP_STORE.Text, "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_EFF_DATE_FROM.Text, "date", false)); ParameterList.Add(GetValueSetParameter(this.txtPAY_RFNO.Text, "string", false)); ParameterList.Add(GetValueSetParameter(this.txtRFNO.Text, "string", false)); Dt_rtn = BCO.QueryAccountHead(ParameterList); if (Dt_rtn != null && Dt_rtn.Rows.Count > 0) { #region 總部資料唯讀 SLP_STORE.ReadOnly = true; txtPAY_RFNO.ReadOnly = true; txtPAY_RFNO.CssClass = "readtxtbox"; txtRFNO.ReadOnly = true; txtRFNO.CssClass = "readtxtbox"; this.radSTORE_TYPE_HEAD.Enabled = false; this.radSTORE_TYPE_STORE.Enabled = false; this.SLP_EFF_DATE_FROM.ReadOnly = true; this.radSTORE_TYPE_HEAD.Enabled = false; this.radSTORE_TYPE_STORE.Enabled = false; this.txtTITLE.ReadOnly = true; txtTITLE.CssClass = "readtxtbox"; this.txtINV_ADDR.ReadOnly = true; txtINV_ADDR.CssClass = "readtxtbox"; this.txtPERSON.ReadOnly = true; txtPERSON.CssClass = "readtxtbox"; this.SLP_PROFIT_NO.ReadOnly = true; this.txtPAY_ACCOUNT.ReadOnly = true; txtPAY_ACCOUNT.CssClass = "readtxtbox"; this.SLP_DUIT_UNIT.ReadOnly = true; this.ddlPAYMENT_STORE.Enabled = false; this.txtAC_NAME.ReadOnly = true; txtAC_NAME.CssClass = "readtxtbox"; this.txtINVOICE_MAILADD.ReadOnly = true; txtINVOICE_MAILADD.CssClass = "readtxtbox"; this.SLP_INVOICE_SEND.ReadOnly = true; this.SLP_INVOICE_TYPE.ReadOnly = true; this.ddlPAY_TYPE.Enabled = false; this.SLP_CLS_DATE.ReadOnly = true; if (GridView1.Rows.Count > 0) { foreach (GridViewRow dr in GridView1.Rows) { ((Button)dr.FindControl("btnDel")).Enabled = false; //GRID刪除 ((Button)dr.FindControl("btnEdit")).Enabled = false; //GRID編輯 } } btnAdd.Enabled = false;//新增 #endregion } #endregion } else if (radSTORE_TYPE_HEAD.Checked) { txtPAY_RFNO.ReadOnly = true; txtPAY_RFNO.CssClass = "readtxtbox"; txtRFNO.ReadOnly = true; txtRFNO.CssClass = "readtxtbox"; } }
protected void btnEdt_Click(object sender, EventArgs e) { //檢核必輸入欄位 TextBox STORE = ((TextBox)((ASP.stm_slp_slp_store_ascx)SLP_STORE).FindControl("TextBoxCode")); TextBox EFF_DATE_FROM = ((TextBox)((ASP.wui_slp_slp_slpdate_ascx)SLP_EFF_DATE_FROM).FindControl("TextBoxCode")); TextBox EFF_DATE_TO = ((TextBox)((ASP.wui_slp_slp_slpdate_ascx)SLP_EFF_DATE_TO).FindControl("TextBoxCode")); TextBox PROFIT_NO = ((TextBox)((ASP.stm_slp_slp_profitcenter_ascx)SLP_PROFIT_NO).FindControl("TextBoxCode")); TextBox DUTY_UNIT = ((TextBox)((ASP.sys_slp_slp_role_ascx)SLP_DUIT_UNIT).FindControl("TextBoxCode")); TextBox[] FieldIDs ={ STORE, EFF_DATE_FROM, EFF_DATE_TO, txtPAY_RFNO, txtRFNO, txtTITLE, txtINV_ADDR, txtPERSON, PROFIT_NO, DUTY_UNIT }; string[] FieldNames ={ "店號", "履歷開始日", "履歷結束日", "結帳統編", "單店統編", "發票抬頭", "發票登記地址", "負責人", "利潤中心", "權責單位" }; int i = 0; foreach (TextBox FieldName in FieldIDs) { if (FieldName.Text.Trim().Length == 0) { ErrorMsgLabel.Text = "必須輸入「" + FieldNames[i] + "」欄位"; return; } i++; } //履歷開始日須小於履歷結束日 if ((SLP_EFF_DATE_FROM.Text != "") || (SLP_EFF_DATE_TO.Text != "")) { if (DateTime.Parse(SLP_EFF_DATE_FROM.Text) > DateTime.Parse(SLP_EFF_DATE_TO.Text)) { ErrorMsgLabel.Text = "履歷開始日須小於履歷結束日 !!"; return; } } if (ddlDEPOSIT_TYPE.SelectedValue == "2" || ddlDEPOSIT_TYPE.SelectedValue == "3") { if (SLP_DEPOSIT_DATE_FROM.Text == "") { ErrorMsgLabel.Text = "必須輸入「質押金起日」欄位"; return; } if (SLP_DEPOSIT_DATE_TO.Text == "") { ErrorMsgLabel.Text = "必須輸入「質押金迄日」欄位"; return; } if (ddlDEPOSIT_TYPE.SelectedValue == "3" && SLP_DEPOSIT.Text == "") { ErrorMsgLabel.Text = "必須輸入「質押金額」欄位"; return; } } else if (ddlDEPOSIT_TYPE.SelectedValue == "1" ) { if (SLP_DEPOSIT.Text == "") { ErrorMsgLabel.Text = "必須輸入「質押金額」欄位"; return; } } if (radSTORE_TYPE_HEAD.Checked && ddlPAYMENT_STORE.SelectedValue != "1") { ErrorMsgLabel.Text = "門市類型等於總店時,付款對象限只能選總部"; return; } DataSet ds_root1 = (DataSet)Session["STM252_root" + PageTimeStamp.Value]; DataTable DtHeadRoot = Check_Root(); if (DtHeadRoot.Rows.Count > 0) { foreach (DataRow dr in ds_root1.Tables[0].Rows) { if (dr.RowState != DataRowState.Deleted) { DataRow[] dr2 = DtHeadRoot.Select(string.Format("ROOT_NO = '{0}' and (HEAD_DOC='{1}' or SINGLE_DOC ='{2}')", dr["ROOT_NO"].ToString(), dr["HEAD_DOC"].ToString(), dr["SINGLE_DOC"].ToString())); if (dr2.Length == 0) { ErrorMsgLabel.Text = "總部下的門市:群分類設定的內容(憑証開立、付款方式)需和總部相同!! "; return; } } } } //儲存作業 int v_ID = 0; #region try { #region 取得畫面元件的值 DateTime processtime = DateTime.Now; #endregion #region 門市帳務主檔 ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(ds_Data.Tables["VDS_STM_ACCOUNT_PROPERTY"].Rows[0]["CREATEDATE"].ToString(), "datetime", false)); ParameterList.Add(GetValueSetParameter(ds_Data.Tables["VDS_STM_ACCOUNT_PROPERTY"].Rows[0]["CREATEUID"].ToString(), "string", false)); ParameterList.Add(GetValueSetParameter(ds_Data.Tables["VDS_STM_ACCOUNT_PROPERTY"].Rows[0]["UPDATEDATE"].ToString(), "datetime", false)); ParameterList.Add(GetValueSetParameter(ds_Data.Tables["VDS_STM_ACCOUNT_PROPERTY"].Rows[0]["UPDATEUID"].ToString(), "string", false)); ParameterList.Add(GetValueSetParameter(ds_Data.Tables["VDS_STM_ACCOUNT_PROPERTY"].Rows[0]["STORE"].ToString(), "string", false)); ParameterList.Add(GetValueSetParameter(ds_Data.Tables["VDS_STM_ACCOUNT_PROPERTY"].Rows[0]["EFF_DATE_FROM"].ToString(), "string", false)); ParameterList.Add(string.Format("{0}{1}", this.SLP_STORE.Text.Trim(), this.SLP_EFF_DATE_FROM.Text)); //V_CODE ParameterList.Add(processtime); ParameterList.Add(GetValueSetParameter(Session["UID"].ToString(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_STORE.Text, "string", false)); //V_STORE ParameterList.Add(GetValueSetParameter(this.SLP_EFF_DATE_FROM.Text, "date", false)); //D_EFF_DATE_FROM ParameterList.Add(GetValueSetParameter(this.SLP_EFF_DATE_TO.Text, "date", false)); //D_EFF_DATE_TO ParameterList.Add(GetValueSetParameter(this.txtPAY_RFNO.Text, "string", false)); //V_PAY_RFNO if (this.radSTORE_TYPE_HEAD.Checked == true) ParameterList.Add("1"); //V_STORE_TYPE else ParameterList.Add("2"); //V_STORE_TYPE ParameterList.Add(GetValueSetParameter(this.txtRFNO.Text, "string", false)); //V_RFNO ParameterList.Add(GetValueSetParameter(this.txtTITLE.Text, "string", false)); //V_TITLE ParameterList.Add(GetValueSetParameter(this.txtINV_ADDR.Text, "string", false)); //V_INV_ADDR ParameterList.Add(GetValueSetParameter(this.txtPERSON.Text, "string", false)); //V_PERSON ParameterList.Add(GetValueSetParameter(this.SLP_PROFIT_NO.Text, "string", false)); //V_PROFIT_NO ParameterList.Add(GetValueSetParameter(this.SLP_FEET.Text, "int", false)); //N_FEET ParameterList.Add(GetValueSetParameter(this.txtPAY_ACCOUNT.Text, "string", false)); //PAY_ACCOUNT if (this.radDEPOSIT_NO_HEAD.Checked == true) ParameterList.Add("1"); //V_DEPOSIT_NO else ParameterList.Add("2"); //V_DEPOSIT_NO ParameterList.Add(GetValueSetParameter(this.ddlDEPOSIT_TYPE.SelectedValue, "string", false)); //N_DEPOSIT ParameterList.Add(GetValueSetParameter(this.SLP_DEPOSIT.Text, "int", false)); //N_DEPOSIT ParameterList.Add(GetValueSetParameter(this.SLP_DEPOSIT_DATE_FROM.Text, "date", false)); //D_DEPOSIT_DATE_FROM ParameterList.Add(GetValueSetParameter(this.SLP_DEPOSIT_DATE_TO.Text, "date", false)); //D_DEPOSIT_DATE_TO ParameterList.Add(GetValueSetParameter(this.SLP_DUIT_UNIT.Text, "string", false)); //V_DUTY_UNIT ParameterList.Add(GetValueSetParameter(this.ddlPAYMENT_STORE.SelectedValue, "string", false)); //V_PAYMENT_STORE ParameterList.Add(GetValueSetParameter(this.txtAC_NAME.Text, "string", false)); //V_AC_NAME ParameterList.Add(GetValueSetParameter(this.txtINVOICE_MAILADD.Text, "string", false)); //V_INVOICE_MAIL_ADD ParameterList.Add(GetValueSetParameter(this.SLP_INVOICE_SEND.Text, "string", false)); //V_INVOICE_SEND ParameterList.Add(GetValueSetParameter(this.SLP_INVOICE_TYPE.Text, "string", false)); //V_INVOICE_TYPE ParameterList.Add(GetValueSetParameter(this.ddlPAY_TYPE.SelectedValue, "string", false)); //V_PAY_TYPE ParameterList.Add(GetValueSetParameter(this.SLP_CLS_DATE.Text, "string", false)); //V_CLS_DATE if (this.txtARMK.Text == "已審核") ParameterList.Add(1); //N_ARMK else ParameterList.Add(0); //N_ARMK #endregion #region 設定屬性 DataSet ds_root = (DataSet)Session["STM252_root" + PageTimeStamp.Value]; #endregion #region 收款天數 DataSet ds = (DataSet)Session["STM252_" + PageTimeStamp.Value]; #endregion STMModel.MaintainStoreAccount BCO = new STMModel.MaintainStoreAccount(ConnectionDB); string Msg = ""; BCO.UpdateStoreBase(ParameterList, null, ds_root.Tables[0], ds.Tables[0], txtPID.Text, out Msg); if (Msg != "") { throw new Exception(Msg); } else { int i_Count = 0; string s_Request_Key = ""; if (Request.QueryString["STM252_COUNT"] == null) { i_Count = 0; s_Request_Key = ""; } else { i_Count = int.Parse(Request.QueryString["STM252_COUNT"]); s_Request_Key = Request.QueryString["STM252_PageTimeStamp"]; } ScriptManager.RegisterStartupScript(UpdatePanel11, this.GetType(), "ClientScript", "alert('更新完成');", true); QueryData(SLP_STORE.Text, SLP_EFF_DATE_FROM.Text); ReadOnlyMode(false); if (this.txtARMK.Text == "已審核") { btnEdit_M.Enabled = false; //編輯 btnPASS.Enabled = false; btnNOPASS.Enabled = true; } if (this.txtARMK.Text == "未審核") { btnEdit_M.Enabled = true; //編輯 btnPASS.Enabled = true; btnNOPASS.Enabled = false; } if (SLP_EFF_DATE_TO.Text.Length > 0) { if (Convert.ToDateTime(this.SLP_EFF_DATE_TO.Text).CompareTo(System.DateTime.Today) == -1) { btnEdit_M.Enabled = false;//編輯 btnPASS.Enabled = false; //審核 btnNOPASS.Enabled = false;//審核解除 } } btnPASS.Visible = true && AuthUpdate; btnNOPASS.Visible = true && CanUpdate; this.Panel2.Visible = false; this.Panel4.Visible = false; GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Save, false, string.Empty, this.btnEdt, WUI_GMToolbarV.ClickAction.ButtonClick); GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Edit, true, string.Empty, this.btnEdit_M, WUI_GMToolbarV.ClickAction.ButtonClick); GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Copy, true, string.Empty, this.btnCopy, WUI_GMToolbarV.ClickAction.ButtonClick); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個 } #endregion }
protected void btnSave_Click(object sender, EventArgs e) { STMModel.MaintainStoreAccount STM = new STMModel.MaintainStoreAccount(ConntionDB); //檢核必輸入欄位 TextBox STORE = ((TextBox)((ASP.stm_slp_slp_store_ascx)SLP_STORE).FindControl("TextBoxCode")); TextBox EFF_DATE_FROM = ((TextBox)((ASP.wui_slp_slp_slpdate_ascx)SLP_EFF_DATE_FROM).FindControl("TextBoxCode")); TextBox EFF_DATE_TO = ((TextBox)((ASP.wui_slp_slp_slpdate_ascx)SLP_EFF_DATE_TO).FindControl("TextBoxCode")); TextBox PROFIT_NO = ((TextBox)((ASP.stm_slp_slp_profitcenter_ascx)SLP_PROFIT_NO).FindControl("TextBoxCode")); TextBox DUTY_UNIT = ((TextBox)((ASP.sys_slp_slp_role_ascx)SLP_DUIT_UNIT).FindControl("TextBoxCode")); TextBox[] FieldIDs ={ STORE, EFF_DATE_FROM, EFF_DATE_TO, txtPAY_RFNO, txtRFNO, txtTITLE, txtINV_ADDR, txtPERSON, PROFIT_NO, DUTY_UNIT }; string[] FieldNames ={ "店號", "履歷開始日", "履歷結束日", "結帳統編", "單店統編", "發票抬頭", "發票登記地址", "負責人", "利潤中心", "權責單位" }; int i = 0; foreach (TextBox FieldName in FieldIDs) { if (FieldName.Text.Trim().Length == 0) { ErrorMsgLabel.Text = "必須輸入「" + FieldNames[i] + "」欄位"; return; } i++; } if (txtGROUP_NO.Text.Length == 0) { ErrorMsgLabel.Text = "無門市唯一檔,無法建立門市帳務主檔"; return; } if (ddlDEPOSIT_TYPE.SelectedValue == "2" || ddlDEPOSIT_TYPE.SelectedValue == "3") { if (SLP_DEPOSIT_DATE_FROM.Text == "") { ErrorMsgLabel.Text = "必須輸入「質押金起日」欄位"; return; } if (SLP_DEPOSIT_DATE_TO.Text == "") { ErrorMsgLabel.Text = "必須輸入「質押金迄日」欄位"; return; } if (ddlDEPOSIT_TYPE.SelectedValue == "3" && SLP_DEPOSIT.Text == "") { ErrorMsgLabel.Text = "必須輸入「質押金額」欄位"; return; } } else if (ddlDEPOSIT_TYPE.SelectedValue == "1") { if (SLP_DEPOSIT.Text == "") { ErrorMsgLabel.Text = "必須輸入「質押金額」欄位"; return; } } //履歷開始日須小於履歷結束日 if ((SLP_EFF_DATE_FROM.Text != "") || (SLP_EFF_DATE_TO.Text != "")) { if (DateTime.Parse(SLP_EFF_DATE_FROM.Text) > DateTime.Parse(SLP_EFF_DATE_TO.Text)) { ErrorMsgLabel.Text = "履歷開始日須小於履歷結束日 !!"; return; } } if (radSTORE_TYPE_HEAD.Checked && ddlPAYMENT_STORE.SelectedValue != "1") { ErrorMsgLabel.Text = "門市類型等於總店時,付款對象限只能選總部"; return; } DataSet ds_root1 = (DataSet)Session["STM252_root" + PageTimeStamp.Value]; DataTable DtHeadRoot = Check_Root(); if (DtHeadRoot.Rows.Count > 0) { foreach (DataRow dr in ds_root1.Tables[0].Rows) { if (dr.RowState != DataRowState.Deleted) { DataRow[] dr2 = DtHeadRoot.Select(string.Format("ROOT_NO = '{0}' and (HEAD_DOC='{1}' or SINGLE_DOC ='{2}')", dr["ROOT_NO"].ToString(), dr["HEAD_DOC"].ToString(), dr["SINGLE_DOC"].ToString())); if (dr2.Length == 0) { ErrorMsgLabel.Text = "總部下的門市:群分類設定的內容(憑証開立、付款方式)需和總部相同!! "; return; } } } } //儲存作業 string v_ID = ""; #region try { #region 取得畫面元件的值 DateTime processtime = DateTime.Now; #endregion #region 門市帳務 ParameterList.Clear(); ParameterList.Add(string.Format("{0}{1}", this.SLP_STORE.Text.Trim(), this.SLP_EFF_DATE_FROM.Text)); //V_CODE ParameterList.Add(processtime); ParameterList.Add(GetValueSetParameter(Session["UID"].ToString(), "string", false)); ParameterList.Add(processtime); ParameterList.Add(GetValueSetParameter(Session["UID"].ToString(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_STORE.Text, "string", false)); //V_STORE ParameterList.Add(GetValueSetParameter(this.SLP_EFF_DATE_FROM.Text, "date", false)); //D_EFF_DATE_FROM ParameterList.Add(GetValueSetParameter(this.SLP_EFF_DATE_TO.Text, "date", false)); //D_EFF_DATE_TO ParameterList.Add(GetValueSetParameter(this.txtPAY_RFNO.Text, "string", false)); //V_PAY_RFNO if (this.radSTORE_TYPE_HEAD.Checked == true) ParameterList.Add("1"); //V_STORE_TYPE else ParameterList.Add("2"); //V_STORE_TYPE ParameterList.Add(GetValueSetParameter(this.txtRFNO.Text, "string", false)); //V_RFNO ParameterList.Add(GetValueSetParameter(this.txtTITLE.Text, "string", false)); //V_TITLE ParameterList.Add(GetValueSetParameter(this.txtINV_ADDR.Text, "string", false)); //V_INV_ADDR ParameterList.Add(GetValueSetParameter(this.txtPERSON.Text, "string", false)); //V_PERSON ParameterList.Add(GetValueSetParameter(this.SLP_PROFIT_NO.Text, "string", false)); //V_PROFIT_NO ParameterList.Add(GetValueSetParameter(this.SLP_FEET.Text, "int", false)); //N_FEET if (this.radDEPOSIT_NO_HEAD.Checked == true) ParameterList.Add("1"); //V_DEPOSIT_NO else ParameterList.Add("2"); //V_DEPOSIT_NO ParameterList.Add(GetValueSetParameter(this.ddlDEPOSIT_TYPE.SelectedValue, "string", false)); //N_DEPOSIT ParameterList.Add(GetValueSetParameter(this.SLP_DEPOSIT.Text, "int", false)); //N_DEPOSIT ParameterList.Add(GetValueSetParameter(this.SLP_DEPOSIT_DATE_FROM.Text, "date", false)); //D_DEPOSIT_DATE_FROM ParameterList.Add(GetValueSetParameter(this.SLP_DEPOSIT_DATE_TO.Text, "date", false)); //D_DEPOSIT_DATE_TO ParameterList.Add(GetValueSetParameter(this.SLP_DUIT_UNIT.Text, "string", false)); //V_DUTY_UNIT ParameterList.Add(GetValueSetParameter(this.ddlPAYMENT_STORE.SelectedValue, "string", false)); //V_PAYMENT_STORE ParameterList.Add(GetValueSetParameter(this.txtAC_NAME.Text, "string", false)); //V_AC_NAME ParameterList.Add(GetValueSetParameter(this.txtINVOICE_MAILADD.Text, "string", false)); //V_INVOICE_MAIL_ADD ParameterList.Add(GetValueSetParameter(this.SLP_INVOICE_SEND.Text, "string", false)); //V_INVOICE_SEND ParameterList.Add(GetValueSetParameter(this.SLP_INVOICE_TYPE.Text, "string", false)); //V_INVOICE_TYPE ParameterList.Add(GetValueSetParameter(this.ddlPAY_TYPE.SelectedValue, "string", false)); //V_PAY_TYPE ParameterList.Add(GetValueSetParameter(this.SLP_CLS_DATE.Text, "string", false)); //V_CLS_DATE if (this.txtARMK.Text == "已審核") ParameterList.Add(1); //N_ARMK else ParameterList.Add(0); //N_ARMK #endregion #region 設定屬性 DataSet ds_root = (DataSet)Session["STM252_root" + PageTimeStamp.Value]; #endregion #region 收款天數 DataSet ds = (DataSet)Session["STM252_" + PageTimeStamp.Value]; #endregion STMModel.MaintainStoreAccount BCO = new STMModel.MaintainStoreAccount(ConnectionDB); string Msg = ""; v_ID = BCO.CreateStoreBase(ParameterList, null, ds_root.Tables[0], ds.Tables[0], out Msg); if (Msg != "") { throw new Exception(Msg); } else { if ((v_ID == "") || (v_ID == null)) { throw new Exception("新增0筆資料!"); } else { ScriptManager.RegisterStartupScript(UpdatePanel11, this.GetType(), "ClientScript", "alert('新增完成');location.replace('STM252.aspx?mode=view&store=" + SLP_STORE.Text + "&eff_date_from=" + SLP_EFF_DATE_FROM.Text.ToString() + "&Code=STM25');", true); } } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個 } #endregion }
protected void txt_RFNO_Onblur() { if (txtPAY_RFNO.Text == txtRFNO.Text) { string mode = ""; string v_STORE = ""; string v_eff_date_from = ""; #region 帶出總部資料 STMModel.MaintainStoreAccount BCO = new STMModel.MaintainStoreAccount(ConnectionDB); DataTable Dt_rtn; ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(this.SLP_STORE.Text, "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_EFF_DATE_FROM.Text, "date", false)); ParameterList.Add(GetValueSetParameter(this.txtPAY_RFNO.Text, "string", false)); ParameterList.Add(GetValueSetParameter(this.txtRFNO.Text, "string", false)); Dt_rtn = BCO.QueryAccountHead(ParameterList); if (Dt_rtn == null || (Dt_rtn != null && Dt_rtn.Rows.Count <= 0)) { //無資料 } else { #region 帶出總部資料 v_STORE = Dt_rtn.Rows[0]["STORE"].ToString(); v_eff_date_from = Dt_rtn.Rows[0]["EFF_DATE_FROM"].ToString(); this.SLP_EFF_DATE_TO.Text = Dt_rtn.Rows[0]["EFF_DATE_TO"].ToString(); this.radSTORE_TYPE_HEAD.Checked = false; this.radSTORE_TYPE_STORE.Checked = true; this.txtTITLE.Text = Dt_rtn.Rows[0]["TITLE"].ToString(); this.txtINV_ADDR.Text = Dt_rtn.Rows[0]["INV_ADDR"].ToString(); this.txtPERSON.Text = Dt_rtn.Rows[0]["PERSON"].ToString(); this.SLP_PROFIT_NO.Text = Dt_rtn.Rows[0]["PROFIT_NO"].ToString(); this.txtPAY_ACCOUNT.Text = Dt_rtn.Rows[0]["PAY_ACCOUNT"].ToString(); this.SLP_DUIT_UNIT.Text = Dt_rtn.Rows[0]["DUTY_UNIT"].ToString(); this.ddlPAYMENT_STORE.SelectedValue = Dt_rtn.Rows[0]["PAYMENT_STORE"].ToString(); this.txtAC_NAME.Text = Dt_rtn.Rows[0]["AC_NAME"].ToString(); this.txtINVOICE_MAILADD.Text = Dt_rtn.Rows[0]["INVOICE_MAIL_ADD"].ToString(); this.SLP_INVOICE_SEND.Text = Dt_rtn.Rows[0]["INVOICE_SEND"].ToString(); this.SLP_INVOICE_TYPE.Text = Dt_rtn.Rows[0]["INVOICE_TYPE"].ToString(); this.ddlPAY_TYPE.SelectedValue = Dt_rtn.Rows[0]["PAY_TYPE"].ToString(); this.SLP_CLS_DATE.Text = Dt_rtn.Rows[0]["CLS_DATE"].ToString(); #endregion #region 帶出總部資料唯讀 SLP_STORE.ReadOnly = true; txtPAY_RFNO.ReadOnly = true; txtPAY_RFNO.CssClass = "readtxtbox"; txtRFNO.ReadOnly = true; txtRFNO.CssClass = "readtxtbox"; this.radSTORE_TYPE_HEAD.Enabled = false; this.radSTORE_TYPE_STORE.Enabled = false; this.SLP_EFF_DATE_FROM.ReadOnly = true; this.radSTORE_TYPE_HEAD.Enabled = false; this.radSTORE_TYPE_STORE.Enabled = false; this.txtTITLE.ReadOnly = true; txtTITLE.CssClass = "readtxtbox"; this.txtINV_ADDR.ReadOnly = true; txtINV_ADDR.CssClass = "readtxtbox"; this.txtPERSON.ReadOnly = true; txtPERSON.CssClass = "readtxtbox"; this.SLP_PROFIT_NO.ReadOnly = true; this.txtPAY_ACCOUNT.ReadOnly = true; txtPAY_ACCOUNT.CssClass = "readtxtbox"; this.SLP_DUIT_UNIT.ReadOnly = true; this.ddlPAYMENT_STORE.Enabled = false; this.txtAC_NAME.ReadOnly = true; txtAC_NAME.CssClass = "readtxtbox"; this.txtINVOICE_MAILADD.ReadOnly = true; txtINVOICE_MAILADD.CssClass = "readtxtbox"; this.SLP_INVOICE_SEND.ReadOnly = true; this.SLP_INVOICE_TYPE.ReadOnly = true; this.ddlPAY_TYPE.Enabled = false; this.SLP_CLS_DATE.ReadOnly = true; #endregion } #endregion #region 帶出設定屬性 if (v_STORE.Length != 0 && v_eff_date_from.Length != 0) { STMModel.MaintainStoreAccount BCO_root = new STMModel.MaintainStoreAccount(ConnectionDB); DataTable Dt_root; ParameterList.Clear(); ParameterList.Add(v_STORE); ParameterList.Add((DateTime.Parse(v_eff_date_from)).ToString("yyyy/MM/dd")); Dt_root = BCO_root.QuerySwitch(STMModel.MaintainStoreAccount.QueryType.ROOT, ParameterList); if (Dt_root == null || (Dt_root != null && Dt_root.Rows.Count <= 0)) { //無資料 } else { DataSet ds_root = (DataSet)Session["STM252_root" + PageTimeStamp.Value]; ds_root.Clear(); for (int i = 0; i < Dt_root.Rows.Count; i++) { DataRow dr = ds_root.Tables[0].NewRow(); dr["STORE"] = this.SLP_STORE.Text; dr["EFF_DATE_FROM"] = this.SLP_EFF_DATE_FROM.Text; dr["ROOT_NO"] = Dt_root.Rows[i]["ROOT_NO"].ToString(); dr["ROOT_NO_EXPLAIN"] = Dt_root.Rows[i]["ROOT_NO_EXPLAIN"].ToString(); dr["HEAD_DOC"] = Dt_root.Rows[i]["HEAD_DOC"].ToString(); dr["HEAD_DOC_EXPLAIN"] = Dt_root.Rows[i]["HEAD_DOC_EXPLAIN"].ToString(); dr["SINGLE_DOC"] = Dt_root.Rows[i]["SINGLE_DOC"].ToString(); dr["SINGLE_DOC_EXPLAIN"] = Dt_root.Rows[i]["SINGLE_DOC_EXPLAIN"].ToString(); dr["PAYMENT_TYPE"] = Dt_root.Rows[i]["PAYMENT_TYPE"].ToString(); dr["PAYMENT_TYPE_EXPLAIN"] = Dt_root.Rows[i]["PAYMENT_TYPE_EXPLAIN"].ToString(); ds_root.Tables[0].Rows.Add(dr); } GridView1.DataSource = ds_root; string SessionIDName_root = string.Format("{0}_{1}", PAGE_DT_01, PageTimeStamp.Value); Session[SessionIDName_root] = ds_root; GridView1.DataBind(); Session["STM252_root" + PageTimeStamp.Value] = ds_root; if (GridView1.Rows.Count > 0) { foreach (GridViewRow dr in GridView1.Rows) { ((Button)dr.FindControl("btnDel")).Enabled = false; //GRID刪除 ((Button)dr.FindControl("btnEdit")).Enabled = false; //GRID編輯 } } btnAdd.Enabled = false;//新增 } } #endregion #region 帶出收款天數 if (v_STORE.Length != 0 && v_eff_date_from.Length != 0) { STMModel.MaintainStoreAccount BCO_Charge = new STMModel.MaintainStoreAccount(ConnectionDB); DataTable Dt_charge; ParameterList.Clear(); ParameterList.Add(v_STORE); ParameterList.Add((DateTime.Parse(v_eff_date_from)).ToString("yyyy/MM/dd")); Dt_charge = BCO_Charge.QuerySwitch(STMModel.MaintainStoreAccount.QueryType.CHARGE, ParameterList); if (Dt_charge == null || (Dt_charge != null && Dt_charge.Rows.Count <= 0)) { //無資料 } else { DataSet ds = (DataSet)Session["STM252_" + PageTimeStamp.Value]; ds.Clear(); for (int i = 0; i < Dt_charge.Rows.Count; i++) { DataRow dr = ds.Tables[0].NewRow(); dr["ID"] = DateTime.Now.ToFileTime().ToString() + i.ToString(); dr["STORE"] = this.SLP_STORE.Text; dr["EFF_DATE_FROM"] = this.SLP_EFF_DATE_FROM.Text; dr["ROOT_NO"] = Dt_charge.Rows[i]["ROOT_NO"].ToString(); dr["ROOT_NO_EXPLAIN"] = Dt_charge.Rows[i]["ROOT_NO_EXPLAIN"].ToString(); dr["PMA"] = Dt_charge.Rows[i]["PMA"].ToString(); dr["PMA_EXPLAIN"] = Dt_charge.Rows[i]["PMA_EXPLAIN"].ToString(); dr["COL_DAYS"] = Dt_charge.Rows[i]["COL_DAYS"].ToString(); dr["COL_DAYS_EXPLAIN"] = Dt_charge.Rows[i]["COL_DAYS_EXPLAIN"].ToString(); ds.Tables[0].Rows.Add(dr); } Session["STM252_" + PageTimeStamp.Value] = ds; GridView2.DataSource = ds; string SessionIDName2 = string.Format("{0}_{1}", PAGE_DT_02, PageTimeStamp.Value); Session[SessionIDName2] = ds; GridView2.DataBind(); } } #endregion UpdatePanelLineItem.Update(); UpdatePanel3.Update(); UpdatePanel4.Update(); UpdatePanel7.Update(); } }
}//GridView4_3_PageIndexChanging #endregion #endregion ------------------------------------------------------------------------------------------------------------------ #region ------------------------TextBox動作區---------------------------------------------------------------------------- /// <summary> /// 欄位[店號]TextChanged事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void txt_STORE_Onblur() { try { #region 門市資料 string[] strResult = new string[4]; this.SLP_EFF_DATE_FROM.Text = ""; this.txtGROUP_NO.Text = ""; this.txtAC_UID.Text = ""; this.txtSAL_ID.Text = ""; if (this.SLP_STORE.Text.Length > 0) { STMModel.MaintainStoreAccount BCO = new STMModel.MaintainStoreAccount(ConnectionDB); ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(this.SLP_STORE.Text, "string", false)); //V_CODE strResult = BCO.GetStoreAcctEndDate(ParameterList); if (strResult[0] == "0") { txtPAY_RFNO.ReadOnly = true; txtPAY_RFNO.CssClass = "readtxtbox"; txtRFNO.ReadOnly = true; txtRFNO.CssClass = "readtxtbox"; ErrorMsgLabel.Text = "此店號前履歷生效迄日未定"; return; } else { this.SLP_EFF_DATE_FROM.Text = Convert.ToDateTime(strResult[0]).ToShortDateString(); this.txtGROUP_NO.Text = strResult[1]; this.txtAC_UID.Text = strResult[2]; this.txtSAL_ID.Text = strResult[3]; if (txtGROUP_NO.Text.Length == 0) { txtPAY_RFNO.ReadOnly = true; txtPAY_RFNO.CssClass = "readtxtbox"; txtRFNO.ReadOnly = true; txtRFNO.CssClass = "readtxtbox"; ErrorMsgLabel.Text = "門市檔無資料"; return; } else { txtPAY_RFNO.ReadOnly = false; txtPAY_RFNO.CssClass = ""; txtRFNO.ReadOnly = false; txtRFNO.CssClass = ""; } } } else { txtPAY_RFNO.ReadOnly = true; txtPAY_RFNO.CssClass = "readtxtbox"; txtRFNO.ReadOnly = true; txtRFNO.CssClass = "readtxtbox"; } #endregion #region 設定屬性 DataSet ds_root = (DataSet)Session["STM252_root" + PageTimeStamp.Value]; foreach (DataRow dr1 in ds_root.Tables[0].Rows) { object[] findPKs = new object[3]; findPKs[0] = dr1["STORE"].ToString(); findPKs[1] = dr1["ROOT_NO"].ToString(); findPKs[2] = dr1["EFF_DATE_FROM"].ToString(); DataRow dr = ds_root.Tables[0].Rows.Find(findPKs); if (dr != null) { dr["STORE"] = this.SLP_STORE.Text; dr["EFF_DATE_FROM"] = this.SLP_EFF_DATE_FROM.Text; } GridView1.DataSource = ds_root; GridView1.DataBind(); Session["STM252_root" + PageTimeStamp.Value] = ds_root; } #endregion #region 收款天數 DataSet ds = (DataSet)Session["STM252_" + PageTimeStamp.Value]; foreach (DataRow dr2 in ds.Tables[0].Rows) { object[] findPKs_1 = new object[1]; findPKs_1[0] = dr2["ID"].ToString(); DataRow dr3 = ds.Tables[0].Rows.Find(findPKs_1); if (dr3 != null) { dr3["STORE"] = this.SLP_STORE.Text; dr3["EFF_DATE_FROM"] = this.SLP_EFF_DATE_FROM.Text; } GridView2.DataSource = ds; GridView2.DataBind(); Session["STM252_" + PageTimeStamp.Value] = ds; } #endregion ScriptManager.RegisterClientScriptBlock(this.UpdatePanel12, typeof(UpdatePanel), "", @" document.getElementById('" + txtPAY_RFNO.ClientID + @"').select(); document.getElementById('" + txtPAY_RFNO.ClientID + @"').focus();", true); } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個 } finally { } }
// 刪除作業 protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { try { #region 檢查判斷 #endregion DateTime processtime = DateTime.Now; #region 門市帳務主檔 ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(((Label)GridView1.Rows[e.RowIndex].FindControl("lblCREATEDATE")).Text, "datetime", false)); //D_OLD_CREATEDATE ParameterList.Add(GetValueSetParameter(((Label)GridView1.Rows[e.RowIndex].FindControl("lblCREATEUID")).Text, "string", false)); //V_OLD_CREATEUID ParameterList.Add(GetValueSetParameter(((Label)GridView1.Rows[e.RowIndex].FindControl("lblUPDATEDATE")).Text, "datetime", false)); //D_OLD_UPDATEDATE ParameterList.Add(GetValueSetParameter(((Label)GridView1.Rows[e.RowIndex].FindControl("lblUPDATEUID")).Text, "string", false)); //V_OLD_UPDATEUID ParameterList.Add(GetValueSetParameter(GridView1.Rows[e.RowIndex].Cells[0].Text, "string", false)); //V_OLD_STORE ParameterList.Add(GetValueSetParameter(((Label)GridView1.Rows[e.RowIndex].FindControl("lblEFF_DATE_FROM")).Text, "datetime", false)); //D_OLD_EFF_DATE_FROM ParameterList.Add(GetValueSetParameter(Session["UID"].ToString(), "string", false)); ParameterList.Add(processtime); #endregion STMModel.MaintainStoreAccount BCO = new STMModel.MaintainStoreAccount(ConnectionDB); BCO.DeleteStoreBase(ParameterList, null); ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "ClientScript", "alert('刪除完成');", true); databind(); } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個 } }
/// <summary> /// 繫結資料到控制項 /// </summary> /// <param name="vdb"></param> private void databind() { #region //抓取本頁初次登記的時間 string SessionIDName = string.Format("{0}_{1}", PAGE_DT_01, PageTimeStamp.Value); STMModel.MaintainStoreAccount BCO = new STMModel.MaintainStoreAccount(ConnectionDB); //門市帳務主檔 ParameterList.Clear(); ParameterList.Add(DBNull.Value); //N_ID ParameterList.Add(DBNull.Value); //V_CODE ParameterList.Add(GetValueSetParameter(this.SLP_CREATEDATE.StartDate, "string", CheckBoxLikeSearch.Checked)); //V_CREATEDATE_S ParameterList.Add(GetValueSetParameter(this.SLP_CREATEDATE.EndDate, "string", CheckBoxLikeSearch.Checked)); //V_CREATEDATE_E ParameterList.Add(GetValueSetParameter(this.SLP_CREATEUI.Text, "string", CheckBoxLikeSearch.Checked)); //V_CREATEUID ParameterList.Add(GetValueSetParameter(this.SLP_UPDATEDATE.StartDate, "string", CheckBoxLikeSearch.Checked)); //V_UPDATEDATE_S ParameterList.Add(GetValueSetParameter(this.SLP_UPDATEDATE.EndDate, "string", CheckBoxLikeSearch.Checked)); //V_UPDATEDATE_E ParameterList.Add(GetValueSetParameter(this.SLP_UPDATEUI.Text, "string", CheckBoxLikeSearch.Checked)); //V_UPDATEUID ParameterList.Add(GetValueSetParameter(this.SLP_STORE.Text, "string", CheckBoxLikeSearch.Checked)); //V_STORE ParameterList.Add(GetValueSetParameter(this.SLP_EFF_DATE_FROM.StartDate, "string", CheckBoxLikeSearch.Checked)); //V_EFF_DATE_FROM_S ParameterList.Add(GetValueSetParameter(this.SLP_EFF_DATE_FROM.EndDate, "string", CheckBoxLikeSearch.Checked)); //V_EFF_DATE_FROM_E ParameterList.Add(GetValueSetParameter(this.SLP_EFF_DATE_TO.StartDate, "string", CheckBoxLikeSearch.Checked)); //V_EFF_DATE_TO_S ParameterList.Add(GetValueSetParameter(this.SLP_EFF_DATE_TO.EndDate, "string", CheckBoxLikeSearch.Checked)); //V_EFF_DATE_TO_E ParameterList.Add(GetValueSetParameter(this.txtPAY_RFNO.Text, "string", CheckBoxLikeSearch.Checked)); //V_PAY_RFNO if (radSTORE_TYPE_ALL.Checked) ParameterList.Add(DBNull.Value); //V_STORE_TYPE if (radSTORE_TYPE_HEAD.Checked) ParameterList.Add("1"); //V_STORE_TYPE if (radSTORE_TYPE_STORE.Checked) ParameterList.Add("2"); //V_STORE_TYPE ParameterList.Add(GetValueSetParameter(this.txtRFNO.Text, "string", CheckBoxLikeSearch.Checked)); //V_RFNO ParameterList.Add(GetValueSetParameter(this.txtTITLE.Text, "string", CheckBoxLikeSearch.Checked)); //V_TITLE ParameterList.Add(GetValueSetParameter(this.txtINV_ADDR.Text, "string", CheckBoxLikeSearch.Checked)); //V_INV_ADDR ParameterList.Add(GetValueSetParameter(this.txtPERSON.Text, "string", CheckBoxLikeSearch.Checked)); //V_PERSON ParameterList.Add(GetValueSetParameter(this.SLP_PROFIT_NO.Text, "string", CheckBoxLikeSearch.Checked)); //V_PROFIT_NO ParameterList.Add(GetValueSetParameter(this.SLP_FEET.Text, "int", CheckBoxLikeSearch.Checked)); //N_FEET ParameterList.Add(GetValueSetParameter(this.txtPAY_ACCOUNT.Text, "string", CheckBoxLikeSearch.Checked)); //V_PAY_ACCOUNT if (this.radDEPOSIT_NO_ALL.Checked) ParameterList.Add(DBNull.Value); //V_DEPOSIT_NO if (this.radDEPOSIT_NO_HEAD.Checked) ParameterList.Add("1"); //V_DEPOSIT_NO if (this.radDEPOSIT_NO_STORE.Checked) ParameterList.Add("2"); //V_DEPOSIT_NO ParameterList.Add(GetValueSetParameter(this.ddlDEPOSIT_TYPE.SelectedValue, "string", CheckBoxLikeSearch.Checked)); //N_DEPOSIT ParameterList.Add(GetValueSetParameter(this.SLP_DEPOSIT.Text, "int", CheckBoxLikeSearch.Checked)); //N_DEPOSIT ParameterList.Add(GetValueSetParameter(this.SLP_DEPOSIT_DATE_FROM.StartDate, "string", CheckBoxLikeSearch.Checked)); //V_DEPOSIT_DATE_FROM_S ParameterList.Add(GetValueSetParameter(this.SLP_DEPOSIT_DATE_FROM.EndDate, "string", CheckBoxLikeSearch.Checked)); //V_DEPOSIT_DATE_FROM_E ParameterList.Add(GetValueSetParameter(this.SLP_DEPOSIT_DATE_TO.StartDate, "string", CheckBoxLikeSearch.Checked)); //V_DEPOSIT_DATE_TO_S ParameterList.Add(GetValueSetParameter(this.SLP_DEPOSIT_DATE_TO.EndDate, "string", CheckBoxLikeSearch.Checked)); //V_DEPOSIT_DATE_TO_E ParameterList.Add(GetValueSetParameter(this.SLP_DUTY_UNIT.Text, "string", CheckBoxLikeSearch.Checked)); //V_DUTY_UNIT if (this.ddlPAYMENT_STORE.SelectedValue == "0") ParameterList.Add(DBNull.Value); else ParameterList.Add(GetValueSetParameter(this.ddlPAYMENT_STORE.SelectedValue, "string", CheckBoxLikeSearch.Checked)); //V_PAYMENT_STORE ParameterList.Add(GetValueSetParameter(this.txtAC_NAME.Text, "string", CheckBoxLikeSearch.Checked)); //V_AC_NAME ParameterList.Add(GetValueSetParameter(this.txtINVOICE_MAILADD.Text, "string", CheckBoxLikeSearch.Checked)); //V_INVOICE_MAIL_ADD ParameterList.Add(GetValueSetParameter(this.SLP_INVOICE_SEND.Text, "string", CheckBoxLikeSearch.Checked)); //V_INVOICE_SEND ParameterList.Add(GetValueSetParameter(this.SLP_INVOICE_TYPE.Text, "string", CheckBoxLikeSearch.Checked)); //V_INVOICE_TYPE if (this.ddlPAY_TYPE.SelectedValue == "0") //modify by jsy 2011.02.21 修正欄位對應 ParameterList.Add(DBNull.Value); else //modify by jsy 2011.02.21 修正欄位對應 ParameterList.Add(GetValueSetParameter(this.ddlPAY_TYPE.SelectedValue, "string", CheckBoxLikeSearch.Checked)); //V_PAY_TYPE ParameterList.Add(GetValueSetParameter(this.SLP_CLS_DATE.Text, "string", CheckBoxLikeSearch.Checked)); //V_CLS_DATE if (this.ddlARMK.SelectedValue == "2") ParameterList.Add(DBNull.Value); else ParameterList.Add(GetValueSetParameter(this.ddlARMK.SelectedValue, "int", CheckBoxLikeSearch.Checked)); //N_ARMK //設定屬性 ParameterList.Add(GetValueSetParameter(this.SLP_ROOT_NO1.Text, "string", CheckBoxLikeSearch.Checked)); //V_ROOT_NO if (this.ddlHEAD_DOC.SelectedValue == "000") ParameterList.Add(DBNull.Value); else ParameterList.Add(GetValueSetParameter(this.ddlHEAD_DOC.SelectedValue, "string", CheckBoxLikeSearch.Checked)); //V_HEAD_DOC if (this.ddlSINGLE_DOC.SelectedValue == "000") ParameterList.Add(DBNull.Value); else ParameterList.Add(GetValueSetParameter(this.ddlSINGLE_DOC.SelectedValue, "string", CheckBoxLikeSearch.Checked)); //V_SINGLE_DOC if (this.ddlPAYMENT_TYPE.SelectedValue == "0") ParameterList.Add(DBNull.Value); else ParameterList.Add(GetValueSetParameter(this.ddlPAYMENT_TYPE.SelectedValue, "string", CheckBoxLikeSearch.Checked)); //V_PAYMENT_TYPE //收款天數 ParameterList.Add(GetValueSetParameter(this.SLP_ROOT_NO2.Text, "string", CheckBoxLikeSearch.Checked)); //V_CHARGE_ROOT_NO ParameterList.Add(GetValueSetParameter(this.SLP_PMA.Text, "string", CheckBoxLikeSearch.Checked)); //V_CHARGE_PMA if (this.SLP_COL_DAYS.Text == "") ParameterList.Add(DBNull.Value); else ParameterList.Add(GetValueSetParameter(this.SLP_COL_DAYS.Text, "string", CheckBoxLikeSearch.Checked)); //V_CHARGE_COL_DAYS ParameterList.Add(GetValueSetParameter(this.SLP_GROUP_NO.Text, "string", CheckBoxLikeSearch.Checked)); //V_GROUP_NO ParameterList.Add(GetValueSetParameter(this.SLP_AC_UID.Text, "string", CheckBoxLikeSearch.Checked)); //V_AC_UID ParameterList.Add(GetValueSetParameter(this.SLP_SAL_ID.Text, "string", CheckBoxLikeSearch.Checked)); //V_SAL_ID ParameterList.Add(GetValueSetParameter(TextBoxRowCountLimit.Text,"int",false)); DataTable Dt = BCO.QuerySwitch(STMModel.MaintainStoreAccount.QueryType.QueryByLike, ParameterList); Session[SessionIDName] = Dt; GridView1.DataSource = Dt; //設定分頁大小 GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text); GridView1.PageIndex = 0; GridView1.DataBind(); LabelQueryRecordCount.Text = string.Format(" {0} Rows ", Dt.Rows.Count.ToString()); if (Dt == null || (Dt != null && Dt.Rows.Count <= 0)) { ErrorMsgLabel.Text = "查無資料"; } #region 將Key值存到Session中 ArrayList arl_Key = new ArrayList(); foreach (DataRow drRow in Dt.Rows) { arl_Key.Add("store=" + drRow["STORE"].ToString() + "&eff_date_from=" + drRow["EFF_DATE_FROM"].ToString()); } Session["STM252_SortKey" + this.PageTimeStamp.Value] = arl_Key; #endregion #endregion }//databind