/// <summary> /// 輸出為EXCEL /// </summary> public void WriteToXls() { try { LogHelper LOG = new LogHelper(ConntionDB); databind(); DataTable Dt = (DataTable)GridView1.DataSource; if (Dt.Columns["ID"] != null) Dt.Columns.Remove("ID"); if (Dt.Columns["ENABLE"] != null) Dt.Columns.Remove("ENABLE"); if (Dt.Columns["ORGANIZATIONCODE"] != null) Dt.Columns.Remove("ORGANIZATIONCODE"); if (Dt.Columns["CODE"] != null) Dt.Columns["CODE"].ColumnName = "代碼"; if (Dt.Columns["NAME"] != null) Dt.Columns["NAME"].ColumnName = "名稱"; if (Dt.Columns["CREATEDATE"] != null) Dt.Columns["CREATEDATE"].ColumnName = "建立日期"; if (Dt.Columns["CREATEUID"] != null) Dt.Columns["CREATEUID"].ColumnName = "建立人員"; if (Dt.Columns["UPDATEDATE"] != null) Dt.Columns["UPDATEDATE"].ColumnName = "異動日期"; if (Dt.Columns["UPDATEUID"] != null) Dt.Columns["UPDATEUID"].ColumnName = "異動人員"; if (Dt.Columns["PASSWORD"] != null) Dt.Columns["PASSWORD"].ColumnName = "密碼"; if (Dt.Columns["MEMO"] != null) Dt.Columns["MEMO"].ColumnName = "備註"; foreach (DataRow dr in Dt.Rows) { ParameterList.Clear(); ParameterList.Add("SYS04人員");//0 ParameterList.Add(Session["UID"].ToString());//1 ParameterList.Add("O");//2 ParameterList.Add(dr["代碼"].ToString());//3 ParameterList.Add(Request.ServerVariables["Server_Name"]);//4 LOG.AddSafeLog(ParameterList); for (int i = 0; i < Dt.Columns.Count; i++) { if (Dt.Columns[i].DataType == Type.GetType("System.String")) { dr[i] = string.Format(" {0}", dr[i].ToString()); } } } Export(System.Text.Encoding.UTF8, PageProgramCode + ".xls", "application/ms-excel", Dt); } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } finally { } }
}//end EditCancelButton_Click /// <summary> /// 由新增模式,確認新增 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void InsertButton_Click(object sender, EventArgs e) { int res = 0; //int v_ID = 0; try { #region 畫面取值 string v_ID = ViewState["NEWID"].ToString(); string v_VENDOR = ((PIC.VDS2G.WebUI.SLP.SLPUnique)FormView1.FindControl("txtVENDOR")).Text.Trim(); string v_VENDOR_NAME = ((TextBox)FormView1.FindControl("txtVENDOR_NAME")).Text.Trim(); string v_BOSS = ((TextBox)FormView1.FindControl("txtBOSS")).Text.Trim(); string v_VENDOR_OPEN_DATE = ((WUI.SLP.SLPDate)FormView1.FindControl("txtVENDOR_OPEN_DATE")).Text.Trim(); string v_VENDOR_CLOSE_DATE = ((WUI.SLP.SLPDate)FormView1.FindControl("txtVENDOR_CLOSE_DATE")).Text.Trim(); string v_VENDOR_SERVICE_TEL_AREA = ((TextBox)FormView1.FindControl("txtVENDOR_SERVICE_TEL_AREA")).Text.Trim(); string v_VENDOR_SERVICE_TEL = ((TextBox)FormView1.FindControl("txtVENDOR_SERVICE_TEL")).Text.Trim(); string v_MAIL_ADDR = ((WUI.SLP.EMailAddress)FormView1.FindControl("txtMAIL_ADDR")).Text.Trim(); string v_HEAD_OFFICE_BANK = ((TextBox)FormView1.FindControl("txtHEAD_OFFICE_BANK")).Text.Trim(); string v_HEAD_BANK_NO = ((TextBox)FormView1.FindControl("txtHEAD_BANK_NO")).Text.Trim(); string v_BANK_ACCOUNT_NO = ((TextBox)FormView1.FindControl("txtBANK_ACCOUNT_NO")).Text.Trim(); string v_BRANCH_OF_BANK = ((TextBox)FormView1.FindControl("txtBRANCH_OF_BANK")).Text.Trim(); string v_BRANCH_BANK_NO = ((TextBox)FormView1.FindControl("txtBRANCH_BANK_NO")).Text.Trim(); string v_INV_PDZ_NO = ((TextBox)FormView1.FindControl("txtINV_PDZ_NO")).Text.Trim(); string v_INV_ADDR = ((TextBox)FormView1.FindControl("txtINV_ADDR")).Text.Trim(); string v_INV_TEL_AREA = ((TextBox)FormView1.FindControl("txtINV_TEL_AREA")).Text.Trim(); string v_INV_TEL = ((TextBox)FormView1.FindControl("txtINV_TEL")).Text.Trim(); string v_INV_FAX_AREA = ((TextBox)FormView1.FindControl("txtINV_FAX_AREA")).Text.Trim(); string v_INV_FAX = ((TextBox)FormView1.FindControl("txtINV_FAX")).Text.Trim(); string v_BUSINESS_PDZ_NO = ((TextBox)FormView1.FindControl("txtBUSINESS_PDZ_NO")).Text.Trim(); string v_BUSINESS_ADDR = ((TextBox)FormView1.FindControl("txtBUSINESS_ADDR")).Text.Trim(); string v_BUSINESS_TEL_AREA = ((TextBox)FormView1.FindControl("txtBUSINESS_TEL_AREA")).Text.Trim(); string v_BUSINESS_TEL = ((TextBox)FormView1.FindControl("txtBUSINESS_TEL")).Text.Trim(); string v_BUSINESS_FAX_AREA = ((TextBox)FormView1.FindControl("txtBUSINESS_FAX_AREA")).Text.Trim(); string v_BUSINESS_FAX = ((TextBox)FormView1.FindControl("txtBUSINESS_FAX")).Text.Trim(); string v_BUSINESS_CONTACT1 = ((TextBox)FormView1.FindControl("txtBUSINESS_CONTACT1")).Text.Trim(); string v_BUSINESS_EXTENSION1 = ((TextBox)FormView1.FindControl("txtBUSINESS_EXTENSION1")).Text.Trim(); string v_CELL_PHONE1 = ((TextBox)FormView1.FindControl("txtCELL_PHONE1")).Text.Trim(); string v_BUSINESS_MAIL1 = ((WUI.SLP.EMailAddress)FormView1.FindControl("txtBUSINESS_MAIL1")).Text.Trim(); //string v_BUSINESS_CONTACT2 = ((TextBox)FormView1.FindControl("txtBUSINESS_CONTACT2")).Text.Trim(); string v_BUSINESS_EXTENSION2 = ((TextBox)FormView1.FindControl("txtBUSINESS_EXTENSION2")).Text.Trim(); string v_CELL_PHONE2 = ((TextBox)FormView1.FindControl("txtCELL_PHONE2")).Text.Trim(); string v_BUSINESS_MAIL2 = ((WUI.SLP.EMailAddress)FormView1.FindControl("txtBUSINESS_MAIL2")).Text.Trim(); string v_ACCOUNT_CONTACT = ((TextBox)FormView1.FindControl("txtACCOUNT_CONTACT")).Text.Trim(); string v_ACCOUNT_EXTENSION = ((TextBox)FormView1.FindControl("txtACCOUNT_EXTENSION")).Text.Trim(); string v_ACCOUNT_MAIL = ((WUI.SLP.EMailAddress)FormView1.FindControl("txtACCOUNT_MAIL")).Text.Trim(); string v_PUB_CBRE = ((TextBox)FormView1.FindControl("txtPUB_CBRE")).Text.Trim(); string v_PUB_ENAME = ((TextBox)FormView1.FindControl("txtPUB_ENAME")).Text.Trim(); string v_PUB_NUM = ((TextBox)FormView1.FindControl("txtPUB_NUM")).Text.Trim(); string v_NOTES = ((TextBox)FormView1.FindControl("txtNOTES")).Text.Trim(); string v_RETURN_CONTACT = ((TextBox)FormView1.FindControl("txtRETURN_CONTACT")).Text.Trim(); string v_VENDOR_CODE = ((TextBox)FormView1.FindControl("txtVENDOR_CODE")).Text.Trim(); string v_COL_DAYS = ((WUI.SLP.CodeFile)FormView1.FindControl("txtCOL_DAYS")).Text.Trim(); string v_PAY_TYPE = ((WUI.SLP.EnumBase)FormView1.FindControl("txtPAY_TYPE")).Text.Trim(); string v_COM_PDZ_NO = ((TextBox)FormView1.FindControl("txtCOM_PDZ_NO")).Text.Trim(); string v_COM_ADDR = ((TextBox)FormView1.FindControl("txtCOM_ADDR")).Text.Trim(); string v_COM_TEL_AREA = ((TextBox)FormView1.FindControl("txtCOM_TEL_AREA")).Text.Trim(); string v_COM_TEL = ((TextBox)FormView1.FindControl("txtCOM_TEL")).Text.Trim(); string v_COM_FAX_AREA = ((TextBox)FormView1.FindControl("txtCOM_FAX_AREA")).Text.Trim(); string v_COM_FAX = ((TextBox)FormView1.FindControl("txtCOM_FAX")).Text.Trim(); #endregion 畫面取值 #region 資料檢查 //檢核各欄位長度 System.Text.StringBuilder sb = new System.Text.StringBuilder(); if (this.Get_Byte_Length(v_VENDOR_NAME) > 50) { sb.Append("供應商名稱欄位資料長度過長\\n"); } if (this.Get_Byte_Length(v_BOSS) > 10) { sb.Append("負責人欄位資料長度過長\\n"); } if (this.Get_Byte_Length(v_MAIL_ADDR) > 50) { sb.Append("客服EMAIL欄位資料長度過長\\n"); } if (this.Get_Byte_Length(v_HEAD_OFFICE_BANK) > 20) { sb.Append("銀行總行名稱電匯資料欄位資料長度過長\\n"); } if (this.Get_Byte_Length(v_INV_TEL) > 10) { sb.Append("電話發票資料欄位資料長度過長\\n"); } if (this.Get_Byte_Length(v_INV_FAX) > 10) { sb.Append("傳真發票資料欄位資料長度過長\\n"); } if (this.Get_Byte_Length(v_BUSINESS_CONTACT1) > 10) { sb.Append("業務連絡人欄位資料長度過長\\n"); } if (this.Get_Byte_Length(v_ACCOUNT_CONTACT) > 10) { sb.Append("財務連絡人欄位資料長度過長\\n"); } if (this.Get_Byte_Length(v_PUB_CBRE) > 8) { sb.Append("供應商簡稱欄位資料長度過長\\n"); } if (this.Get_Byte_Length(v_PUB_ENAME) > 50) { sb.Append("英文名稱欄位資料長度過長\\n"); } if (this.Get_Byte_Length(v_NOTES) > 50) { sb.Append("說明備註欄位資料長度過長\\n"); } if (this.Get_Byte_Length(v_RETURN_CONTACT) > 10) { sb.Append("廠退聯絡人資料長度過長\\n"); } if (sb.ToString().Length > 0) { Alert(sb.ToString()); return; } if (Convert.ToDateTime(v_VENDOR_OPEN_DATE).CompareTo(Convert.ToDateTime(v_VENDOR_CLOSE_DATE)) > 0) { Alert("往來開始日不可大於往來結束日"); return; } //檢核長度 if (GetStringLen(v_VENDOR) < 0 || GetStringLen(v_VENDOR) < 10) { Alert("廠商編號欄位長度不足,請重新輸入"); hiddenFocusCtrlID.Value = ((PIC.VDS2G.WebUI.SLP.SLPUnique)FormView1.FindControl("txtVENDOR")).TextBox_Code.ClientID; return; } //檢核廠商編號 if (!(checkCompanyNo(v_VENDOR.Substring(0, 8)))) { Alert("廠商編號輸入有誤,請重新輸入"); hiddenFocusCtrlID.Value = ((PIC.VDS2G.WebUI.SLP.SLPUnique)FormView1.FindControl("txtVENDOR")).TextBox_Code.ClientID; return; } //檢查廠商統編是否重覆 ParameterList.Clear(); ParameterList.Add(v_VENDOR); DataTable Q_Table = bco.QueryVendorBaseByCode(ParameterList); if (Q_Table.Rows.Count > 0) { Alert("廠商編號重覆輸入,請重新輸入"); hiddenFocusCtrlID.Value = ((PIC.VDS2G.WebUI.SLP.SLPUnique)FormView1.FindControl("txtVENDOR")).TextBox_Code.ClientID; return; } #endregion DateTime DT = DateTime.Now; ParameterList.Clear(); SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vID", v_ID); //vID SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCODE", v_VENDOR); //vCODE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vVENDOR", v_VENDOR); //vVENDOR SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vVENDOR_NAME", v_VENDOR_NAME); //vVENDOR_NAME SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vBOSS", v_BOSS); //vBOSS SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vVENDOR_OPEN_DATE", v_VENDOR_OPEN_DATE); //vVENDOR_OPEN_DATE SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vVENDOR_CLOSE_DATE", v_VENDOR_CLOSE_DATE); //vVENDOR_CLOSE_DATE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vVENDOR_SERVICE_TEL_AREA", v_VENDOR_SERVICE_TEL_AREA); //vVENDOR_SERVICE_TEL_AREA SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vVENDOR_SERVICE_TEL", v_VENDOR_SERVICE_TEL); //vVENDOR_SERVICE_TEL SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vMAIL_ADDR", v_MAIL_ADDR); //vMAIL_ADDR SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vHEAD_OFFICE_BANK", v_HEAD_OFFICE_BANK); //vHEAD_OFFICE_BANK SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vHEAD_BANK_NO", v_HEAD_BANK_NO); //vHEAD_BANK_NO SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vBANK_ACCOUNT_NO", v_BANK_ACCOUNT_NO); //vBANK_ACCOUNT_NO SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vBRANCH_OF_BANK", v_BRANCH_OF_BANK); //vBRANCH_OF_BANK SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vBRANCH_BANK_NO", v_BRANCH_BANK_NO); //vBRANCH_BANK_NO SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vINV_PDZ_NO", v_INV_PDZ_NO); //vINV_PDZ_NO SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vINV_ADDR", v_INV_ADDR); //vINV_ADDR SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vINV_TEL_AREA", v_INV_TEL_AREA); //vINV_TEL_AREA SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vINV_TEL", v_INV_TEL); //vINV_TEL SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vINV_FAX_AREA", v_INV_FAX_AREA); //vINV_FAX_AREA SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vINV_FAX", v_INV_FAX); //vINV_FAX SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vBUSINESS_PDZ_NO", v_BUSINESS_PDZ_NO); //vBUSINESS_PDZ_NO SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vBUSINESS_ADDR", v_BUSINESS_ADDR); //vBUSINESS_ADDR SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vBUSINESS_TEL_AREA", v_BUSINESS_TEL_AREA); //vBUSINESS_TEL_AREA SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vBUSINESS_TEL", v_BUSINESS_TEL); //vBUSINESS_TEL SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vBUSINESS_FAX_AREA", v_BUSINESS_FAX_AREA); //vBUSINESS_FAX_AREA SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vBUSINESS_FAX", v_BUSINESS_FAX); //vBUSINESS_FAX SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vBUSINESS_CONTACT", v_BUSINESS_CONTACT1); //vBUSINESS_CONTACT SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vBUSINESS_EXTENSION", v_BUSINESS_EXTENSION1); //vBUSINESS_EXTENSION SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vBUSINESS_MOBILE", v_CELL_PHONE1); //vBUSINESS_MOBILE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vBUSINESS_MAIL", v_BUSINESS_MAIL1); //vBUSINESS_MAIL SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vRETURN_EXTENSION", v_BUSINESS_EXTENSION2); //vRETURN_EXTENSION SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vRETURN_MOBILE", v_CELL_PHONE2); //vRETURN_MOBILE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vRETURN_MAIL", v_BUSINESS_MAIL2); //vRETURN_MAIL SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vACCOUNT_CONTACT", v_ACCOUNT_CONTACT); //vACCOUNT_CONTACT SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vACCOUNT_EXTENSION", v_ACCOUNT_EXTENSION); //vACCOUNT_EXTENSION SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vACCOUNT_MAIL", v_ACCOUNT_MAIL); //vACCOUNT_MAIL SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vPUB_CBRE", v_PUB_CBRE); //vPUB_CBRE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vPUB_ENAME", v_PUB_ENAME); //vPUB_ENAME SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vPUB_NUM", v_PUB_NUM); //vPUB_NUM SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vNOTES", v_NOTES); //vNOTES SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vRETURN_CONTACT", v_RETURN_CONTACT); //vRETURN_CONTACT SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vVENDOR_CODE", v_VENDOR_CODE); //vVENDOR_CODE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCOL_DAYS", v_COL_DAYS); //vCOL_DAYS SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vPAY_TYPE", v_PAY_TYPE); //vPAY_TYPE SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vCREATEDATE", DT); //vCREATEDATE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCREATEUID", Session["UID"].ToString()); //vCREATEUID SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vUPDATEDATE", DT); //vUPDATEDATE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vUPDATEUID", Session["UID"].ToString()); //vUPDATEUID SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCOM_PDZ_NO", v_COM_PDZ_NO); //vCOM_PDZ_NO SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCOM_ADDR", v_COM_ADDR); //vCOM_ADDR SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCOM_TEL_AREA", v_COM_TEL_AREA); //vCOM_TEL_AREA SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCOM_TEL", v_COM_TEL); //vCOM_TEL SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCOM_FAX_AREA", v_COM_FAX_AREA); //vCOM_FAX_AREA SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCOM_FAX", v_COM_FAX); //vCOM_FAX bco.CreateVendorBase(ParameterList, DBT); LogHelper LOG = new LogHelper(ConntionDB); ParameterList.Clear(); ParameterList.Add("VDM01供應商主檔");//0 ParameterList.Add(Session["UID"].ToString());//1 ParameterList.Add("I");//2 ParameterList.Add(v_VENDOR);//3 ParameterList.Add(Request.ServerVariables["Server_Name"]);//4 LOG.AddSafeLog(ParameterList); //更新母子關係設定資料 //更新母子關係設定資料 DataTable dtMotherOLD = bcoMonther.ConvertXMLToDataTable(MotherVendor.InnerHtml); DataTable dtMotherNEW = bcoMonther.ConvertXMLToDataTable(NewMotherVendor.InnerHtml); for (int i = 0; i < repMOTHER_VENDOR.Items.Count; i++) { DataRow nRow = dtMotherNEW.Rows[i]; RepeaterItem nItem = repMOTHER_VENDOR.Items[i]; if (((WUI.SLP.SLP_VendorBase)nItem.FindControl("txtMOTHER_VENDOR")).Text == "") { dtMotherNEW.Rows.RemoveAt(i); continue; } nRow["PID"] = v_ID; nRow["VENDOR_CODE"] = v_VENDOR; nRow["VENDOR"] = ((WUI.SLP.SLP_VendorBase)nItem.FindControl("txtMOTHER_VENDOR")).Text; nRow["VENDOR_NAME"] = ((TextBox)((WUI.SLP.SLP_VendorBase)nItem.FindControl("txtMOTHER_VENDOR")).FindControl("TextBoxName")).Text; CheckBox cbMOTHER_SINGLE_COST = (CheckBox)((WUI.SLP.SLP_Boolean)nItem.FindControl("txtMOTHER_SINGLE_COST")).FindControl("C1"); nRow["SINGLE_COST"] = ((cbMOTHER_SINGLE_COST.Checked) ? 1 : 0); if (((WUI.SLP.EnumBase)nItem.FindControl("txtMOTHER_PAY_TYPE")).Text != "") nRow["PAY_TYPE"] = ((WUI.SLP.EnumBase)nItem.FindControl("txtMOTHER_PAY_TYPE")).Text; } for (int i = 0; i < dtMotherOLD.Rows.Count; i++) { DataRow drMotherOld = dtMotherOLD.Rows[i]; if (dtMotherNEW.Select(string.Format("VENDOR='{0}'", drMotherOld["VENDOR"].ToString())).Length == 0) { ParameterList.Clear(); SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "OLD_ID", drMotherOld["ID"].ToString()); //OLD_ID SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "OLD_PID", drMotherOld["PID"].ToString()); //OLD_PID SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_VENDOR_CODE", drMotherOld["VENDOR_CODE"].ToString()); //OLD_VENDOR_CODE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_VENDOR", drMotherOld["VENDOR"].ToString()); //OLD_VENDOR SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_VENDOR_NAME", drMotherOld["VENDOR_NAME"].ToString()); //OLD_VENDOR_NAME SQLHelper.SQLWhere(ref ParameterList, DbType.Decimal, "OLD_SINGLE_COST", drMotherOld["SINGLE_COST"].ToString()); //OLD_SINGLE_COST SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "OLD_PAY_TYPE", drMotherOld["PAY_TYPE"].ToString()); //OLD_PAY_TYPE SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_CREATEDATE", (DateTime)drMotherOld["CREATEDATE"]); //OLD_CREATEDATE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_CREATEUID", drMotherOld["CREATEUID"].ToString()); //OLD_CREATEUID SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_UPDATEDATE", (DateTime)drMotherOld["UPDATEDATE"]); //OLD_UPDATEDATE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_UPDATEUID", drMotherOld["UPDATEUID"].ToString()); //OLD_UPDATEUID SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_UPDATEUID", Session["UID"].ToString()); //NEW_UPDATEUID SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "NEW_UPDATEDATE", DT); //NEW_UPDATEDATE bcoMonther.DeleteMontherVendor(ParameterList, DBT); } } for (int i = 0; i < dtMotherNEW.Rows.Count; i++) { DataRow drMotherNew = dtMotherNEW.Rows[i]; if (dtMotherOLD.Select(string.Format("VENDOR='{0}'", drMotherNew["VENDOR"].ToString())).Length == 0) { ParameterList.Clear(); SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vPID", drMotherNew["PID"].ToString()); //vPID SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vVENDOR_CODE", drMotherNew["VENDOR_CODE"].ToString()); //vVENDOR_CODE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vVENDOR", drMotherNew["VENDOR"].ToString()); //vVENDOR SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vVENDOR_NAME", drMotherNew["VENDOR_NAME"].ToString()); //vVENDOR_NAME SQLHelper.SQLWhere(ref ParameterList, DbType.Decimal, "vSINGLE_COST", drMotherNew["SINGLE_COST"].ToString()); //OLD_SINGLE_COST SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vPAY_TYPE", drMotherNew["PAY_TYPE"].ToString()); //vPAY_TYPE SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vCREATEDATE", DT); //vCREATEDATE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCREATEUID", Session["UID"].ToString()); //vCREATEUID SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vUPDATEDATE", DT); //vUPDATEDATE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vUPDATEUID", Session["UID"].ToString()); //vUPDATEUID if (i == (dtMotherNEW.Rows.Count - 1)) bcoMonther.CreateMontherVendor(ParameterList, DBT, true); else bcoMonther.CreateMontherVendor(ParameterList, DBT); } else { ParameterList.Clear(); DataRow[] drMotherOlds = dtMotherOLD.Select(string.Format("VENDOR='{0}'", drMotherNew["VENDOR"].ToString())); DataRow drMotherOld = drMotherOlds[0]; SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "OLD_ID", drMotherOld["ID"].ToString()); //OLD_ID SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "OLD_PID", drMotherOld["PID"].ToString()); //OLD_PID SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_VENDOR_CODE", drMotherOld["VENDOR_CODE"].ToString()); //OLD_VENDOR_CODE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_VENDOR", drMotherOld["VENDOR"].ToString()); //OLD_VENDOR SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_VENDOR_NAME", drMotherOld["VENDOR_NAME"].ToString()); //OLD_VENDOR_NAME SQLHelper.SQLWhere(ref ParameterList, DbType.Decimal, "OLD_SINGLE_COST", drMotherOld["SINGLE_COST"].ToString()); //OLD_SINGLE_COST SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "OLD_PAY_TYPE", drMotherOld["PAY_TYPE"].ToString()); //OLD_PAY_TYPE SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_CREATEDATE", (DateTime)drMotherOld["CREATEDATE"]); //OLD_CREATEDATE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_CREATEUID", drMotherOld["CREATEUID"].ToString()); //OLD_CREATEUID SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_UPDATEDATE", (DateTime)drMotherOld["UPDATEDATE"]); //OLD_UPDATEDATE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_UPDATEUID", drMotherOld["UPDATEUID"].ToString()); //OLD_UPDATEUID SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "NEW_PID", drMotherNew["PID"].ToString()); //NEW_PID SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_VENDOR_CODE", drMotherNew["VENDOR_CODE"].ToString()); //NEW_VENDOR_CODE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_VENDOR", drMotherNew["VENDOR"].ToString()); //NEW_VENDOR SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_VENDOR_NAME", drMotherNew["VENDOR_NAME"].ToString()); //NEW_VENDOR_NAME SQLHelper.SQLWhere(ref ParameterList, DbType.Decimal, "NEW_SINGLE_COST", drMotherNew["SINGLE_COST"].ToString()); //NEW_SINGLE_COST SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "NEW_PAY_TYPE", drMotherNew["PAY_TYPE"].ToString()); //NEW_PAY_TYPE SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "NEW_UPDATEDATE", DT); //NEW_UPDATEDATE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_UPDATEUID", Session["UID"].ToString()); //NEW_UPDATEUID if (i == (dtMotherNEW.Rows.Count - 1)) bcoMonther.UpdateMontherVendor(ParameterList, DBT, true); else bcoMonther.UpdateMontherVendor(ParameterList, DBT); } } //Response.Write("<script>alert('新增完成');location.replace('VDM012.aspx?ID=" + v_ID + "');</script>"); ArrayList arr = new ArrayList(); if ((ArrayList)Session[Request.QueryString["arl_Key"]] != null) arr = (ArrayList)Session[Request.QueryString["arl_Key"]]; arr.Add(v_ID.ToString()); string arl_Key = ""; if ((ArrayList)Session[Request.QueryString["arl_Key"]] != null) { arl_Key = Request.QueryString["arl_Key"]; Session[Request.QueryString["arl_Key"]] = arr; } else //從查詢頁直接按新增過來時沒有arl_Key參數,所以在這裏重做一個arl_Key參數 { arl_Key = "arl_Key" + PageTimeStamp.Value; Session[arl_Key] = arr; } Script("alert('新增完成');location.replace('VDM012.aspx?Code=VDM01&isToolBar=N&SessionName=" + Request.QueryString["SessionName"] + "&arl_Key=" + arl_Key + "&ID=" + v_ID + "');"); } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } finally { } }//end InsertButton_Click
/// <summary> /// 繫結資料到控制項 /// </summary> /// <param name="vdb"></param> private void databind(string strFLAG) { #region //抓取本頁初次登記的時間 string SessionIDName = string.Format("{0}_{1}", PAGE_DT_01, PageTimeStamp.Value); STMModel.MaintainStoreBase BCO = new STMModel.MaintainStoreBase(ConnectionDB); ParameterList.Clear(); //門市基本31 TextBox txt_TELAREA = (TextBox)this.SLP_TEL_NO.FindControl("T1"); TextBox txt_TELNO = (TextBox)this.SLP_TEL_NO.FindControl("T2"); TextBox txt_FAXAREA = (TextBox)this.SLP_FAX_NO.FindControl("T1"); TextBox txt_FAXNO = (TextBox)this.SLP_FAX_NO.FindControl("T2"); ParameterList.Add(GetValueSetParameter(this.SLP_STORE.Text.Trim(),"string",CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_MDC_START_DATE.StartDate,"string",CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_MDC_START_DATE.EndDate,"string",CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_MDC_END_DATE.StartDate, "string", CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_MDC_END_DATE.EndDate, "string", CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_CHAN_NO.Text,"string",CheckBoxLikeSearch.Checked));; ParameterList.Add(GetValueSetParameter(this.SLP_GROUP_NO.Text,"string",CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.txtOLD_STORE.Text, "string", CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_STORE_OPEN_DATE.StartDate,"string",CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_STORE_OPEN_DATE.EndDate,"string",CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_STORE_CLOSE_DATE.StartDate,"string",CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_STORE_CLOSE_DATE.EndDate,"string",CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_REOPEN_DATE.StartDate,"string",CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_REOPEN_DATE.EndDate,"string",CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_REMODEL_DATE.StartDate,"string",CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_REMODEL_DATE.EndDate,"string",CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_Z_O.Text,"string",CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_D_O.Text,"string",CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_STORE_TYPE.Text,"string",CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.txtSTORE_ZIP.Text,"string",CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(txt_TELAREA.Text,"string",CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(txt_TELNO.Text,"string",CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(txt_FAXAREA.Text,"string",CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(txt_FAXNO.Text,"string",CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.txtSTORE_ADDRESS.Text,"string",CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_CREATE_DATE.StartDate,"string",CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_CREATE_DATE.EndDate,"string",CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_CREATE_UID.Text,"string",CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_UPDATE_DATE.StartDate,"string",CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_UPDATE_DATE.EndDate, "string", CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_UPDATE_UID.Text, "string", CheckBoxLikeSearch.Checked)); //配送屬性17 RadioButtonList rdo_DIS_SW = (RadioButtonList)this.SLP_DIS_SW.FindControl("R1"); RadioButtonList rdo_MARKET_RESEARCH = (RadioButtonList)this.SLP_MARKET_RESEARCH.FindControl("R1"); RadioButtonList rdo_SING_VEN = (RadioButtonList)this.SLP_SING_VEN.FindControl("R1"); RadioButtonList rdo_MDC_TAXABLE = (RadioButtonList)this.SLP_MDC_TAXABLE.FindControl("R1"); RadioButtonList rdo_MDC_TAXFREE = (RadioButtonList)this.SLP_MDC_TAXFREE.FindControl("R1"); ParameterList.Add(GetValueSetParameter(this.SLP_AREA_NO.Text, "string", CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_AREA_CODE.Text, "string", CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_SHELVE_CM3.Text, "int", CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_ROUTE.Text, "string", CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.txtSTEP.Text, "string", CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.txtARRIVE_TIME.Text, "string", CheckBoxLikeSearch.Checked)); if (rdo_DIS_SW.SelectedValue == "") ParameterList.Add(DBNull.Value); if (rdo_DIS_SW.SelectedValue == "1") ParameterList.Add(1); if (rdo_DIS_SW.SelectedValue == "0") ParameterList.Add(0); ParameterList.Add(this.ddlALLOCATION_TIMES.Text); ParameterList.Add(GetValueSetParameter(this.SLP_ALLOCATION_TIMES.Text, "int", CheckBoxLikeSearch.Checked)); if (rdo_MARKET_RESEARCH.SelectedValue == "") ParameterList.Add(DBNull.Value); if (rdo_MARKET_RESEARCH.SelectedValue == "1") ParameterList.Add(1); if (rdo_MARKET_RESEARCH.SelectedValue == "0") ParameterList.Add(0); ParameterList.Add(GetValueSetParameter(this.SLP_AC_UID.Text, "string", CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_SAL_ID.Text, "string", CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_FEAT_GRADE.Text, "string", CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.txtPAY_RFNO.Text, "string", CheckBoxLikeSearch.Checked)); if (rdo_SING_VEN.SelectedValue == "") ParameterList.Add(DBNull.Value); if (rdo_SING_VEN.SelectedValue == "1") ParameterList.Add(1); if (rdo_SING_VEN.SelectedValue == "0") ParameterList.Add(0); if (rdo_MDC_TAXABLE.SelectedValue == "") ParameterList.Add(DBNull.Value); if (rdo_MDC_TAXABLE.SelectedValue == "1") ParameterList.Add(1); if (rdo_MDC_TAXABLE.SelectedValue == "0") ParameterList.Add(0); if (rdo_MDC_TAXFREE.SelectedValue == "") ParameterList.Add(DBNull.Value); if (rdo_MDC_TAXFREE.SelectedValue == "1") ParameterList.Add(1); if (rdo_MDC_TAXFREE.SelectedValue == "0") ParameterList.Add(0); //屬性19 CheckBox chk_W1 = (CheckBox)this.SLP_Boolean_W1.FindControl("C1"); CheckBox chk_W2 = (CheckBox)this.SLP_Boolean_W2.FindControl("C1"); CheckBox chk_W3 = (CheckBox)this.SLP_Boolean_W3.FindControl("C1"); CheckBox chk_W4 = (CheckBox)this.SLP_Boolean_W4.FindControl("C1"); CheckBox chk_W5 = (CheckBox)this.SLP_Boolean_W5.FindControl("C1"); CheckBox chk_W6 = (CheckBox)this.SLP_Boolean_W6.FindControl("C1"); CheckBox chk_W7 = (CheckBox)this.SLP_Boolean_W7.FindControl("C1"); ParameterList.Add(GetValueSetParameter(this.txtCOPY_SOURCE.Text, "string", CheckBoxLikeSearch.Checked)); ParameterList.Add(this.ddlPSM.Text); ParameterList.Add(GetValueSetParameter(this.SLP_PSM.Text, "int", CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_BUSINESS_NO.Text, "string", CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_OPEN_TIME.Text, "string", CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_CLOSE_TIME.Text, "string", CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_COMPETITION.Text, "string", CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_REMARK.Text, "string", CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_STORE_SPE.Text, "string", CheckBoxLikeSearch.Checked)); ParameterList.Add(chk_W1.Checked ? "1" : null); ParameterList.Add(chk_W2.Checked ? "1" : null); ParameterList.Add(chk_W3.Checked ? "1" : null); ParameterList.Add(chk_W4.Checked ? "1" : null); ParameterList.Add(chk_W5.Checked ? "1" : null); ParameterList.Add(chk_W6.Checked ? "1" : null); ParameterList.Add(chk_W7.Checked ? "1" : null); ParameterList.Add(GetValueSetParameter(this.SLP_SHELF_NO.Text, "string", CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_DISPLAY_NUM.Text, "int", CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.SLP_SHELVE_CM3_2.Text, "int", CheckBoxLikeSearch.Checked)); ParameterList.Add(GetValueSetParameter(this.txtStoreName.Text, "string", CheckBoxLikeSearch.Checked)); //2010/06/14新增店名查詢欄位 if (strFLAG != "EXCEL") { DataTable Dt = BCO.QuerySwitch(STMModel.MaintainStoreBase.QueryType.QueryByLike, ParameterList); int iRowCount = (this.TextBoxRowCountLimit.Text.Trim() == string.Empty) ? 9999 : int.Parse(TextBoxRowCountLimit.Text); while (Dt.Rows.Count > iRowCount) { DataRow dr = Dt.Rows[Dt.Rows.Count - 1]; dr.Delete(); Dt.AcceptChanges(); } 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)) { ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "ClientScript", "alert('查無資料');", true); } #region 將Key值存到Session中 ArrayList arl_Key = new ArrayList(); foreach (DataRow drRow in Dt.Rows) { arl_Key.Add("store=" + drRow["STORE"].ToString() + "&date=" + drRow["MDC_START_DATE"].ToString()); } Session["STM012_SortKey" + this.PageTimeStamp.Value] = arl_Key; } else { DataTable Dt1 = BCO.QuerySwitch(STMModel.MaintainStoreBase.QueryType.Excel, ParameterList); int iRowCount = (this.TextBoxRowCountLimit.Text.Trim() == string.Empty) ? 9999 : int.Parse(TextBoxRowCountLimit.Text); while (Dt1.Rows.Count > iRowCount) { DataRow dr = Dt1.Rows[Dt1.Rows.Count - 1]; dr.Delete(); Dt1.AcceptChanges(); } for (int j = 0; j < Dt1.Rows.Count; j++) { LogHelper LOG = new LogHelper(ConnectionDB); ParameterList.Clear(); ParameterList.Add("STM01門市主檔");//0 ParameterList.Add(Session["UID"].ToString());//1 ParameterList.Add("O");//2 ParameterList.Add(Dt1.Rows[j]["STORE"].ToString());//3 ParameterList.Add(Request.ServerVariables["Server_Name"]);//4 LOG.AddSafeLog(ParameterList); } Session[SessionIDName] = Dt1; } #endregion #endregion }//databind
}//ChangeFormMSTMode /// <summary> /// 繫結資料到畫面控制項 /// </summary> /// <param name=VirtualDataID></param> private void databind() { try { bool noData = false; ParameterList.Clear(); if (Request["ID"] != null) { ViewState["NEWID"] = Request["ID"].ToString(); ParameterList.Add(Request["ID"].ToString()); } else { ViewState["NEWID"] = bco.GetNewID(); ParameterList.Add("0"); } DataTable dt = bco.QueryVendorBaseByID(ParameterList); MasterOLDData.InnerHtml = bco.ConvertBetweenDataTableToXML(dt); if (dt.Rows.Count > 0 || Request["ID"] == null) { LogHelper LOG = new LogHelper(ConntionDB); ParameterList.Clear(); ParameterList.Add("VDM01供應商主檔");//0 ParameterList.Add(Session["UID"].ToString());//1 ParameterList.Add("Q");//2 ParameterList.Add(dt.Rows[0]["VENDOR"].ToString());//3 ParameterList.Add(Request.ServerVariables["Server_Name"]);//4 LOG.AddSafeLog(ParameterList); ParameterList.Clear(); SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "PID", ViewState["NEWID"].ToString(), "=", "and"); DataTable dtMother = bcoMonther.QueryMontherVendorByFind_1(ParameterList); MotherVendor.InnerHtml = bcoMonther.ConvertBetweenDataTableToXML(dtMother); NewMotherVendor.InnerHtml = bco.ConvertBetweenDataTableToXML(dtMother); if (dt.Rows.Count > 0) { txtMOTHER_VENDOR_CODE.Text = dt.Rows[0]["VENDOR"].ToString(); txtMOTHER_VENDOR_NAME.Text = dt.Rows[0]["VENDOR_NAME"].ToString(); } repMOTHER_VENDOR.DataSource = dtMother; repMOTHER_VENDOR.DataBind(); FormView1.DataSource = dt; FormView1.DataBind(); //AuthorityControls(this); } else { noData = true; if (Request.QueryString["isToolBar"] == "Y") ErrorMsgLabel.Text = "此筆資料已被其他使用者刪除,請點選上一筆/下一筆鈕繼續查詢"; else ErrorMsgLabel.Text = "無法取得資料"; } switch (FormView1.CurrentMode) { case FormViewMode.Edit: if (noData) { FormView1.ChangeMode(FormViewMode.ReadOnly); ((Button)FormView1.FindControl("EditButton")).Enabled = false; ((Button)FormView1.FindControl("DeleteButton")).Enabled = false; } else { GMToolbar1.SetupControl(null, null, (Button)FormView1.FindControl("EditCommitButton"), null, null); GMToolbar1.GMToolbarStatus = WUI_GMToolbarV.GMToolbarStatusEnum.UpdateEdit; GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Delete, false, "", (Button)FormView1.FindControl("DeleteButton"), WUI_GMToolbarV.ClickAction.ButtonClick ); } break; case FormViewMode.Insert: GMToolbar1.SetupControl(null, null, (Button)FormView1.FindControl("InsertButton"), null, null); GMToolbar1.GMToolbarStatus = WUI_GMToolbarV.GMToolbarStatusEnum.NewEdit; GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Delete, false, "", (Button)FormView1.FindControl("DeleteButton"), WUI_GMToolbarV.ClickAction.ButtonClick ); break; case FormViewMode.ReadOnly: GMToolbar1.SetupControl(null, null, null, (Button)FormView1.FindControl("DeleteButton"), (Button)FormView1.FindControl("EditButton")); GMToolbar1.GMToolbarStatus = WUI_GMToolbarV.GMToolbarStatusEnum.ViewOne; ArrayList arr = (ArrayList)Session[Request.QueryString["arl_Key"]]; if (arr.Count == 1) GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.NavigateBarJustOneRecord, false, "", null, WUI_GMToolbarV.ClickAction.ButtonClick); else if (Request["ID"] != null) { int i = GetALIndex(Request["ID"].ToString()); if (i == 0) GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.NavigateBarFirstRecord, false, "", null, WUI_GMToolbarV.ClickAction.ButtonClick); else if (i == arr.Count - 1) GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.NavigateBarLastRecord, false, "", null, WUI_GMToolbarV.ClickAction.ButtonClick); } GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Delete, true, "", (Button)FormView1.FindControl("DeleteButton"), WUI_GMToolbarV.ClickAction.ButtonClick); break; } if (noData) { GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Save, false, "", null, WUI_GMToolbarV.ClickAction.ButtonClick); GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Edit, false, "", null, WUI_GMToolbarV.ClickAction.ButtonClick); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }//databind
}//end CancelButton_Click /// <summary> /// 編輯模式,按下更新確認鈕 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void EditCommitButton_Click(object sender, EventArgs e) { int res = 0; try { this.txtMOTHER_VENDOR_CODE.Text = ((PIC.VDS2G.WebUI.SLP.SLPUnique)FormView1.FindControl("txtVENDOR")).Text.Trim(); #region 取得畫面元件的值 string v_ID = ((TextBox)FormView1.FindControl("txtID")).Text.Trim(); string v_VENDOR = ((PIC.VDS2G.WebUI.SLP.SLPUnique)FormView1.FindControl("txtVENDOR")).Text.Trim(); string v_VENDOR_NAME = ((TextBox)FormView1.FindControl("txtVENDOR_NAME")).Text.Trim(); string v_BOSS = ((TextBox)FormView1.FindControl("txtBOSS")).Text.Trim(); string v_VENDOR_OPEN_DATE = ((WUI.SLP.SLPDate)FormView1.FindControl("txtVENDOR_OPEN_DATE")).Text.Trim(); string v_VENDOR_CLOSE_DATE = ((WUI.SLP.SLPDate)FormView1.FindControl("txtVENDOR_CLOSE_DATE")).Text.Trim(); string v_VENDOR_SERVICE_TEL_AREA = ((TextBox)FormView1.FindControl("txtVENDOR_SERVICE_TEL_AREA")).Text.Trim(); string v_VENDOR_SERVICE_TEL = ((TextBox)FormView1.FindControl("txtVENDOR_SERVICE_TEL")).Text.Trim(); string v_MAIL_ADDR = ((WUI.SLP.EMailAddress)FormView1.FindControl("txtMAIL_ADDR")).Text.Trim(); string v_HEAD_OFFICE_BANK = ((TextBox)FormView1.FindControl("txtHEAD_OFFICE_BANK")).Text.Trim(); string v_HEAD_BANK_NO = ((TextBox)FormView1.FindControl("txtHEAD_BANK_NO")).Text.Trim(); string v_BANK_ACCOUNT_NO = ((TextBox)FormView1.FindControl("txtBANK_ACCOUNT_NO")).Text.Trim(); string v_BRANCH_OF_BANK = ((TextBox)FormView1.FindControl("txtBRANCH_OF_BANK")).Text.Trim(); string v_BRANCH_BANK_NO = ((TextBox)FormView1.FindControl("txtBRANCH_BANK_NO")).Text.Trim(); string v_INV_PDZ_NO = ((TextBox)FormView1.FindControl("txtINV_PDZ_NO")).Text.Trim(); string v_INV_ADDR = ((TextBox)FormView1.FindControl("txtINV_ADDR")).Text.Trim(); string v_INV_TEL_AREA = ((TextBox)FormView1.FindControl("txtINV_TEL_AREA")).Text.Trim(); string v_INV_TEL = ((TextBox)FormView1.FindControl("txtINV_TEL")).Text.Trim(); string v_INV_FAX_AREA = ((TextBox)FormView1.FindControl("txtINV_FAX_AREA")).Text.Trim(); string v_INV_FAX = ((TextBox)FormView1.FindControl("txtINV_FAX")).Text.Trim(); string v_BUSINESS_PDZ_NO = ((TextBox)FormView1.FindControl("txtBUSINESS_PDZ_NO")).Text.Trim(); string v_BUSINESS_ADDR = ((TextBox)FormView1.FindControl("txtBUSINESS_ADDR")).Text.Trim(); string v_BUSINESS_TEL_AREA = ((TextBox)FormView1.FindControl("txtBUSINESS_TEL_AREA")).Text.Trim(); string v_BUSINESS_TEL = ((TextBox)FormView1.FindControl("txtBUSINESS_TEL")).Text.Trim(); string v_BUSINESS_FAX_AREA = ((TextBox)FormView1.FindControl("txtBUSINESS_FAX_AREA")).Text.Trim(); string v_BUSINESS_FAX = ((TextBox)FormView1.FindControl("txtBUSINESS_FAX")).Text.Trim(); string v_BUSINESS_CONTACT1 = ((TextBox)FormView1.FindControl("txtBUSINESS_CONTACT1")).Text.Trim(); string v_BUSINESS_EXTENSION1 = ((TextBox)FormView1.FindControl("txtBUSINESS_EXTENSION1")).Text.Trim(); string v_CELL_PHONE1 = ((TextBox)FormView1.FindControl("txtCELL_PHONE1")).Text.Trim(); string v_BUSINESS_MAIL1 = ((WUI.SLP.EMailAddress)FormView1.FindControl("txtBUSINESS_MAIL1")).Text.Trim(); //string v_BUSINESS_CONTACT2 = ((TextBox)FormView1.FindControl("txtBUSINESS_CONTACT2")).Text.Trim(); string v_BUSINESS_EXTENSION2 = ((TextBox)FormView1.FindControl("txtBUSINESS_EXTENSION2")).Text.Trim(); string v_CELL_PHONE2 = ((TextBox)FormView1.FindControl("txtCELL_PHONE2")).Text.Trim(); string v_BUSINESS_MAIL2 = ((WUI.SLP.EMailAddress)FormView1.FindControl("txtBUSINESS_MAIL2")).Text.Trim(); string v_ACCOUNT_CONTACT = ((TextBox)FormView1.FindControl("txtACCOUNT_CONTACT")).Text.Trim(); string v_ACCOUNT_EXTENSION = ((TextBox)FormView1.FindControl("txtACCOUNT_EXTENSION")).Text.Trim(); string v_ACCOUNT_MAIL = ((WUI.SLP.EMailAddress)FormView1.FindControl("txtACCOUNT_MAIL")).Text.Trim(); string v_PUB_CBRE = ((TextBox)FormView1.FindControl("txtPUB_CBRE")).Text.Trim(); string v_PUB_ENAME = ((TextBox)FormView1.FindControl("txtPUB_ENAME")).Text.Trim(); string v_PUB_NUM = ((TextBox)FormView1.FindControl("txtPUB_NUM")).Text.Trim(); string v_NOTES = ((TextBox)FormView1.FindControl("txtNOTES")).Text.Trim(); string v_RETURN_CONTACT = ((TextBox)FormView1.FindControl("txtRETURN_CONTACT")).Text.Trim(); string v_VENDOR_CODE = ((TextBox)FormView1.FindControl("txtVENDOR_CODE")).Text.Trim(); string v_COL_DAYS = ((WUI.SLP.CodeFile)FormView1.FindControl("txtCOL_DAYS")).Text.Trim(); string v_PAY_TYPE = ((WUI.SLP.EnumBase)FormView1.FindControl("txtPAY_TYPE")).Text.Trim(); string v_COM_PDZ_NO = ((TextBox)FormView1.FindControl("txtCOM_PDZ_NO")).Text.Trim(); string v_COM_ADDR = ((TextBox)FormView1.FindControl("txtCOM_ADDR")).Text.Trim(); string v_COM_TEL_AREA = ((TextBox)FormView1.FindControl("txtCOM_TEL_AREA")).Text.Trim(); string v_COM_TEL = ((TextBox)FormView1.FindControl("txtCOM_TEL")).Text.Trim(); string v_COM_FAX_AREA = ((TextBox)FormView1.FindControl("txtCOM_FAX_AREA")).Text.Trim(); string v_COM_FAX = ((TextBox)FormView1.FindControl("txtCOM_FAX")).Text.Trim(); #endregion 取得畫面元件的值 DataTable dt = bco.ConvertXMLToDataTable(MasterOLDData.InnerHtml); DataRow dr = dt.Rows[0]; #region 新舊值比對 ParameterList.Clear(); SQLHelper.SQLWhere(ref ParameterList, DbType.String, "MA.ID", dr["ID"].ToString(), "=", "and"); SQLHelper.SQLWhere(ref ParameterList, DbType.String, "MA.ENABLE", 1, "=", "and"); DataTable dtOld = bco.QueryVendorBaseByFind_1(ParameterList); if (dtOld.Rows.Count == 0) { Alert("更新失敗,此資料已被其他使用者刪除,請重新查詢"); return; } else { DataRow drOld = dtOld.Rows[0]; if (dr["UpdateUid"].ToString() != drOld["UpdateUid"].ToString() || dr["UpdateDate"].ToString() != drOld["UpdateDate"].ToString()) { Alert("更新失敗,此資料已被其他使用者異動,請重新查詢再進行編輯"); return; } } #endregion #region 資料檢查 //檢核各欄位長度 System.Text.StringBuilder sb = new System.Text.StringBuilder(); if (this.Get_Byte_Length(v_VENDOR_NAME) > 50) { sb.Append("供應商名稱欄位資料長度過長\\n"); } if (this.Get_Byte_Length(v_BOSS) > 10) { sb.Append("負責人欄位資料長度過長\\n"); } if (this.Get_Byte_Length(v_MAIL_ADDR) > 50) { sb.Append("客服EMAIL欄位資料長度過長\\n"); } if (this.Get_Byte_Length(v_HEAD_OFFICE_BANK) > 20) { sb.Append("銀行總行名稱電匯資料欄位資料長度過長\\n"); } if (this.Get_Byte_Length(v_INV_TEL) > 10) { sb.Append("電話發票資料欄位資料長度過長\\n"); } if (this.Get_Byte_Length(v_INV_FAX) > 10) { sb.Append("傳真發票資料欄位資料長度過長\\n"); } if (this.Get_Byte_Length(v_BUSINESS_CONTACT1) > 10) { sb.Append("業務連絡人欄位資料長度過長\\n"); } if (this.Get_Byte_Length(v_ACCOUNT_CONTACT) > 10) { sb.Append("財務連絡人欄位資料長度過長\\n"); } if (this.Get_Byte_Length(v_PUB_CBRE) > 8) { sb.Append("供應商簡稱欄位資料長度過長\\n"); } if (this.Get_Byte_Length(v_PUB_ENAME) > 50) { sb.Append("英文名稱欄位資料長度過長\\n"); } if (this.Get_Byte_Length(v_NOTES) > 50) { sb.Append("說明備註欄位資料長度過長\\n"); } if (this.Get_Byte_Length(v_RETURN_CONTACT) > 10) { sb.Append("廠退聯絡人資料長度過長\\n"); } if (sb.ToString().Length > 0) { Alert(sb.ToString()); return; } // if (DateTime.Today.CompareTo(Convert.ToDateTime(v_VENDOR_OPEN_DATE)) >= 0 && dr["VENDOR"].ToString() != v_VENDOR) { Alert("系統日>=往來開始日不可修改供應商統編"); return; } // if (DateTime.Today.CompareTo(Convert.ToDateTime(v_VENDOR_CLOSE_DATE)) <= 0 && dr["VENDOR"].ToString() != v_VENDOR) { Alert("系統日<=往來結束日不可修改供應商統編"); return; } if (Convert.ToDateTime(v_VENDOR_OPEN_DATE).CompareTo(Convert.ToDateTime(v_VENDOR_CLOSE_DATE)) > 0) { Alert("往來開始日不可大於往來結束日"); return; } //檢核資料供應商合約中的有效合約 string CONTRACT_CNT = "", ITEM_CNT = ""; bco.QueryForDelete(dr["VENDOR_CODE"].ToString(), out CONTRACT_CNT, out ITEM_CNT); if ((CONTRACT_CNT != "0") && (dr["VENDOR"].ToString() != v_VENDOR)) { Alert("此廠商已有簽訂合約,不能修改供應商統編欄位"); hiddenFocusCtrlID.Value = ((PIC.VDS2G.WebUI.SLP.SLPUnique)FormView1.FindControl("txtVENDOR")).TextBox_Code.ClientID; return; } //檢核資料商品主檔中的有效商品 ParameterList.Clear(); ParameterList.Add(dr["VENDOR"].ToString()); if ((bco.CheckVendorItemExists(ParameterList) == "1") && (dr["VENDOR"].ToString() != v_VENDOR)) { Alert("此廠商還有提供商品主檔中的有效商品,不能修改供應商統編欄位"); hiddenFocusCtrlID.Value = ((PIC.VDS2G.WebUI.SLP.SLPUnique)FormView1.FindControl("txtVENDOR")).TextBox_Code.ClientID; return; } //檢核長度 if (GetStringLen(v_VENDOR) < 0 || GetStringLen(v_VENDOR) < 10) { Alert("廠商編號欄位長度不足,請重新輸入"); hiddenFocusCtrlID.Value = ((PIC.VDS2G.WebUI.SLP.SLPUnique)FormView1.FindControl("txtVENDOR")).TextBox_Code.ClientID; return; } //檢核廠商編號 if (!(checkCompanyNo(v_VENDOR.Substring(0, 8)))) { Alert("廠商編號輸入有誤,請重新輸入"); hiddenFocusCtrlID.Value = ((PIC.VDS2G.WebUI.SLP.SLPUnique)FormView1.FindControl("txtVENDOR")).TextBox_Code.ClientID; return; } if (this.LengthVaild(v_BRANCH_OF_BANK, 30) == false) { Alert("分行名稱欄位長度過長,請重新輸入"); hiddenFocusCtrlID.Value = ((TextBox)FormView1.FindControl("txtBRANCH_OF_BANK")).ClientID; return; } if (this.LengthVaild(v_INV_ADDR, 50) == false) { Alert("地址欄位長度過長,請重新輸入"); hiddenFocusCtrlID.Value = ((TextBox)FormView1.FindControl("txtINV_ADDR")).ClientID; return; } if (this.LengthVaild(v_COM_ADDR, 50) == false) { Alert("地址欄位長度過長,請重新輸入"); hiddenFocusCtrlID.Value = ((TextBox)FormView1.FindControl("txtCOM_ADDR")).ClientID; return; } if (this.LengthVaild(v_BUSINESS_ADDR, 50) == false) { Alert("地址欄位長度過長,請重新輸入"); hiddenFocusCtrlID.Value = ((TextBox)FormView1.FindControl("txtBUSINESS_ADDR")).ClientID; return; } #endregion DateTime DT = DateTime.Now; #region 更新編輯後的資料 ParameterList.Clear(); SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "OLD_ID", dr["ID"].ToString()); //OLD_ID //SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_VENDOR_CODE", dr["VENDOR_CODE"].ToString()); //OLD_VENDOR_CODE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_VENDOR_CODE", dr["VENDOR"].ToString()); //OLD_VENDOR_CODE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_VENDOR_NAME", dr["VENDOR_NAME"].ToString()); //OLD_VENDOR_NAME SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_UPDATEDATE", dr["UPDATEDATE"].ToString()); //OLD_UPDATEDATE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_UPDATEUID", dr["UPDATEUID"].ToString()); //OLD_UPDATEUID SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_CODE", v_VENDOR); //NEW_CODE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_VENDOR", v_VENDOR); //NEW_VENDOR SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_VENDOR_NAME", v_VENDOR_NAME); //NEW_VENDOR_NAME SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_BOSS", v_BOSS); //NEW_BOSS SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "NEW_VENDOR_OPEN_DATE", v_VENDOR_OPEN_DATE); //NEW_VENDOR_OPEN_DATE SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "NEW_VENDOR_CLOSE_DATE", v_VENDOR_CLOSE_DATE); //NEW_VENDOR_CLOSE_DATE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_VENDOR_SERVICE_TEL_AREA", v_VENDOR_SERVICE_TEL_AREA); //NEW_VENDOR_SERVICE_TEL_AREA SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_VENDOR_SERVICE_TEL", v_VENDOR_SERVICE_TEL); //NEW_VENDOR_SERVICE_TEL SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_MAIL_ADDR", v_MAIL_ADDR); //NEW_MAIL_ADDR SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_HEAD_OFFICE_BANK", v_HEAD_OFFICE_BANK); //NEW_HEAD_OFFICE_BANK SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_HEAD_BANK_NO", v_HEAD_BANK_NO); //NEW_HEAD_BANK_NO SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_BANK_ACCOUNT_NO", v_BANK_ACCOUNT_NO); //NEW_BANK_ACCOUNT_NO SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_BRANCH_OF_BANK", v_BRANCH_OF_BANK); //NEW_BRANCH_OF_BANK SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_BRANCH_BANK_NO", v_BRANCH_BANK_NO); //NEW_BRANCH_BANK_NO SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_INV_PDZ_NO", v_INV_PDZ_NO); //NEW_INV_PDZ_NO SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_INV_ADDR", v_INV_ADDR); //NEW_INV_ADDR SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_INV_TEL_AREA", v_INV_TEL_AREA); //NEW_INV_TEL_AREA SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_INV_TEL", v_INV_TEL); //NEW_INV_TEL SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_INV_FAX_AREA", v_INV_FAX_AREA); //NEW_INV_FAX_AREA SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_INV_FAX", v_INV_FAX); //NEW_INV_FAX SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_BUSINESS_PDZ_NO", v_BUSINESS_PDZ_NO); //NEW_BUSINESS_PDZ_NO SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_BUSINESS_ADDR", v_BUSINESS_ADDR); //NEW_BUSINESS_ADDR SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_BUSINESS_TEL_AREA", v_BUSINESS_TEL_AREA); //NEW_BUSINESS_TEL_AREA SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_BUSINESS_TEL", v_BUSINESS_TEL); //NEW_BUSINESS_TEL SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_BUSINESS_FAX_AREA", v_BUSINESS_FAX_AREA); //NEW_BUSINESS_FAX_AREA SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_BUSINESS_FAX", v_BUSINESS_FAX); //NEW_BUSINESS_FAX SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_BUSINESS_CONTACT", v_BUSINESS_CONTACT1); //NEW_BUSINESS_CONTACT SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_BUSINESS_EXTENSION", v_BUSINESS_EXTENSION1); //NEW_BUSINESS_EXTENSION SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_BUSINESS_MOBILE", v_CELL_PHONE1); //NEW_BUSINESS_MOBILE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_BUSINESS_MAIL", v_BUSINESS_MAIL1); //NEW_BUSINESS_MAIL SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_RETURN_EXTENSION", v_BUSINESS_EXTENSION2); //NEW_RETURN_EXTENSION SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_RETURN_MOBILE", v_CELL_PHONE2); //NEW_RETURN_MOBILE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_RETURN_MAIL", v_BUSINESS_MAIL2); //NEW_RETURN_MAIL SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_ACCOUNT_CONTACT", v_ACCOUNT_CONTACT); //NEW_ACCOUNT_CONTACT SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_ACCOUNT_EXTENSION", v_ACCOUNT_EXTENSION); //NEW_ACCOUNT_EXTENSION SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_ACCOUNT_MAIL", v_ACCOUNT_MAIL); //NEW_ACCOUNT_MAIL SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_PUB_CBRE", v_PUB_CBRE); //NEW_PUB_CBRE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_PUB_ENAME", v_PUB_ENAME); //NEW_PUB_ENAME SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_PUB_NUM", v_PUB_NUM); //NEW_PUB_NUM SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_NOTES", v_NOTES); //NEW_NOTES SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_RETURN_CONTACT", v_RETURN_CONTACT); //NEW_RETURN_CONTACT SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_VENDOR_CODE", v_VENDOR_CODE); //NEW_VENDOR_CODE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_COL_DAYS", v_COL_DAYS); //NEW_COL_DAYS SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_PAY_TYPE", v_PAY_TYPE); //NEW_PAY_TYPE SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "NEW_UPDATEDATE", DT); //NEW_UPDATEDATE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_UPDATEUID", Session["UID"].ToString()); //NEW_UPDATEUID SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_COM_PDZ_NO", v_COM_PDZ_NO); //NEW_COM_PDZ_NO SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_COM_ADDR", v_COM_ADDR); //NEW_COM_ADDR SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_COM_TEL_AREA", v_COM_TEL_AREA); //NEW_COM_TEL_AREA SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_COM_TEL", v_COM_TEL); //NEW_COM_TEL SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_COM_FAX_AREA", v_COM_FAX_AREA); //NEW_COM_FAX_AREA SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_COM_FAX", v_COM_FAX); //NEW_COM_FAX bco.UpdateVendorBase(ParameterList, DBT); LogHelper LOG = new LogHelper(ConntionDB); ParameterList.Clear(); ParameterList.Add("VDM01供應商主檔");//0 ParameterList.Add(Session["UID"].ToString());//1 ParameterList.Add("U");//2 ParameterList.Add(dr["VENDOR"].ToString());//3 ParameterList.Add(Request.ServerVariables["Server_Name"]);//4 LOG.AddSafeLog(ParameterList); #endregion 更新編輯後的資料 //更新母子關係設定資料 DataTable dtMotherOLD = bcoMonther.ConvertXMLToDataTable(MotherVendor.InnerHtml); DataTable dtMotherNEW = bcoMonther.ConvertXMLToDataTable(NewMotherVendor.InnerHtml); int i_dtMotherNEW = 0; for (int i = 0; i < repMOTHER_VENDOR.Items.Count; i++) { DataRow nRow = dtMotherNEW.Rows[i_dtMotherNEW]; RepeaterItem nItem = repMOTHER_VENDOR.Items[i]; if (((WUI.SLP.SLP_VendorBase)nItem.FindControl("txtMOTHER_VENDOR")).Text == "") { dtMotherNEW.Rows.RemoveAt(i_dtMotherNEW); continue; } nRow["VENDOR_CODE"] = v_VENDOR; nRow["VENDOR"] = ((WUI.SLP.SLP_VendorBase)nItem.FindControl("txtMOTHER_VENDOR")).Text; nRow["VENDOR_NAME"] = ((TextBox)((WUI.SLP.SLP_VendorBase)nItem.FindControl("txtMOTHER_VENDOR")).FindControl("TextBoxName")).Text; CheckBox cbMOTHER_SINGLE_COST = (CheckBox)((WUI.SLP.SLP_Boolean)nItem.FindControl("txtMOTHER_SINGLE_COST")).FindControl("C1"); nRow["SINGLE_COST"] = ((cbMOTHER_SINGLE_COST.Checked) ? 1 : 0); if (((WUI.SLP.EnumBase)nItem.FindControl("txtMOTHER_PAY_TYPE")).Text != "") nRow["PAY_TYPE"] = ((WUI.SLP.EnumBase)nItem.FindControl("txtMOTHER_PAY_TYPE")).Text; i_dtMotherNEW++; } for (int i = 0; i < dtMotherOLD.Rows.Count; i++) { DataRow drMotherOld = dtMotherOLD.Rows[i]; if (dtMotherNEW.Select(string.Format("VENDOR='{0}'", drMotherOld["VENDOR"].ToString())).Length == 0) { ParameterList.Clear(); SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "OLD_ID", drMotherOld["ID"].ToString()); //OLD_ID SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "OLD_PID", drMotherOld["PID"].ToString()); //OLD_PID SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_VENDOR_CODE", drMotherOld["VENDOR_CODE"].ToString()); //OLD_VENDOR_CODE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_VENDOR", drMotherOld["VENDOR"].ToString()); //OLD_VENDOR SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_VENDOR_NAME", drMotherOld["VENDOR_NAME"].ToString()); //OLD_VENDOR_NAME SQLHelper.SQLWhere(ref ParameterList, DbType.Decimal, "OLD_SINGLE_COST", drMotherOld["SINGLE_COST"].ToString()); //OLD_SINGLE_COST SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "OLD_PAY_TYPE", drMotherOld["PAY_TYPE"].ToString()); //OLD_PAY_TYPE SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_CREATEDATE", (DateTime)drMotherOld["CREATEDATE"]); //OLD_CREATEDATE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_CREATEUID", drMotherOld["CREATEUID"].ToString()); //OLD_CREATEUID SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_UPDATEDATE", (DateTime)drMotherOld["UPDATEDATE"]); //OLD_UPDATEDATE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_UPDATEUID", drMotherOld["UPDATEUID"].ToString()); //OLD_UPDATEUID SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_UPDATEUID", Session["UID"].ToString()); //NEW_UPDATEUID SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "NEW_UPDATEDATE", DT); //NEW_UPDATEDATE bcoMonther.DeleteMontherVendor(ParameterList, DBT); } } for (int i = 0; i < dtMotherNEW.Rows.Count; i++) { DataRow drMotherNew = dtMotherNEW.Rows[i]; if (dtMotherOLD.Select(string.Format("VENDOR='{0}'", drMotherNew["VENDOR"].ToString())).Length == 0) { ParameterList.Clear(); SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vPID", drMotherNew["PID"].ToString()); //vPID SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vVENDOR_CODE", drMotherNew["VENDOR_CODE"].ToString()); //vVENDOR_CODE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vVENDOR", drMotherNew["VENDOR"].ToString()); //vVENDOR SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vVENDOR_NAME", drMotherNew["VENDOR_NAME"].ToString()); //vVENDOR_NAME SQLHelper.SQLWhere(ref ParameterList, DbType.Decimal, "vSINGLE_COST", drMotherNew["SINGLE_COST"].ToString()); //OLD_SINGLE_COST SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "vPAY_TYPE", drMotherNew["PAY_TYPE"].ToString()); //vPAY_TYPE SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vCREATEDATE", DT); //vCREATEDATE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vCREATEUID", Session["UID"].ToString()); //vCREATEUID SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "vUPDATEDATE", DT); //vUPDATEDATE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "vUPDATEUID", Session["UID"].ToString()); //vUPDATEUID if (i == (dtMotherNEW.Rows.Count - 1)) bcoMonther.CreateMontherVendor(ParameterList, DBT, true); else bcoMonther.CreateMontherVendor(ParameterList, DBT); } else { ParameterList.Clear(); DataRow[] drMotherOlds = dtMotherOLD.Select(string.Format("VENDOR='{0}'", drMotherNew["VENDOR"].ToString())); DataRow drMotherOld = drMotherOlds[0]; SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "OLD_ID", drMotherOld["ID"].ToString()); //OLD_ID SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "OLD_PID", drMotherOld["PID"].ToString()); //OLD_PID SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_VENDOR_CODE", drMotherOld["VENDOR_CODE"].ToString()); //OLD_VENDOR_CODE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_VENDOR", drMotherOld["VENDOR"].ToString()); //OLD_VENDOR SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_VENDOR_NAME", drMotherOld["VENDOR_NAME"].ToString()); //OLD_VENDOR_NAME SQLHelper.SQLWhere(ref ParameterList, DbType.Decimal, "OLD_SINGLE_COST", drMotherOld["SINGLE_COST"].ToString()); //OLD_SINGLE_COST SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "OLD_PAY_TYPE", drMotherOld["PAY_TYPE"].ToString()); //OLD_PAY_TYPE SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_CREATEDATE", (DateTime)drMotherOld["CREATEDATE"]); //OLD_CREATEDATE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_CREATEUID", dr["CREATEUID"].ToString()); //OLD_CREATEUID SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "OLD_UPDATEDATE", (DateTime)dr["UPDATEDATE"]); //OLD_UPDATEDATE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "OLD_UPDATEUID", dr["UPDATEUID"].ToString()); //OLD_UPDATEUID SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "NEW_PID", drMotherNew["PID"].ToString()); //NEW_PID SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_VENDOR_CODE", drMotherNew["VENDOR_CODE"].ToString()); //NEW_VENDOR_CODE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_VENDOR", drMotherNew["VENDOR"].ToString()); //NEW_VENDOR SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_VENDOR_NAME", drMotherNew["VENDOR_NAME"].ToString()); //NEW_VENDOR_NAME SQLHelper.SQLWhere(ref ParameterList, DbType.Decimal, "NEW_SINGLE_COST", drMotherNew["SINGLE_COST"].ToString()); //NEW_SINGLE_COST SQLHelper.SQLWhere(ref ParameterList, DbType.VarNumeric, "NEW_PAY_TYPE", drMotherNew["PAY_TYPE"].ToString()); //NEW_PAY_TYPE SQLHelper.SQLWhere(ref ParameterList, DbType.DateTime, "NEW_UPDATEDATE", DT); //NEW_UPDATEDATE SQLHelper.SQLWhere(ref ParameterList, DbType.String, "NEW_UPDATEUID", Session["UID"].ToString()); //NEW_UPDATEUID if (i == (dtMotherNEW.Rows.Count - 1)) bcoMonther.UpdateMontherVendor(ParameterList, DBT, true); else bcoMonther.UpdateMontherVendor(ParameterList, DBT); } } //Response.Write(string.Format("<script>alert('更改完成');location.replace('VDM012.aspx?ID={0}');</script>", v_ID)); //Script("alert('更改完成');location.replace('VDM012.aspx?Code=VDM01&isToolBar=N&SessionName=" + Request.QueryString["SessionName"] + "&arl_Key=" + Request.QueryString["arl_Key"] + "&ID=" + v_ID + "');"); Response.Redirect("VDM012.aspx?Code=VDM01&isToolBar=N&SessionName=" + Request.QueryString["SessionName"] + "&arl_Key=" + Request.QueryString["arl_Key"] + "&ID=" + v_ID + "&P=update"); } catch (Exception ex) { if (ex.Message.IndexOf("其他使用者異動") != -1) Alert("更新失敗,此資料已被其他使用者異動,請重新查詢"); else ErrorMsgLabel.Text = ex.Message; } finally { } }//end EditCommitButton_Click
protected void btnSave_Click(object sender, EventArgs e) { STMModel.MaintainStoreBase STM = new STMModel.MaintainStoreBase(ConntionDB); #region 檢核 //檢核必輸入欄位 TextBox start_date = ((TextBox)((ASP.wui_slp_slp_slpdate_ascx)SLP_MDC_START_DATE).FindControl("TextBoxCode")); TextBox StoreChain = ((TextBox)SLP_CHAN_NO.FindControl("TextBoxCode")); TextBox StoreGroup = ((TextBox)SLP_GROUP_NO.FindControl("TextBoxCode")); TextBox tel_area = ((TextBox)((ASP.wui_slp_slp_telfax_ascx)SLP_TEL_NO).FindControl("T1")); TextBox tel_no = ((TextBox)((ASP.wui_slp_slp_telfax_ascx)SLP_TEL_NO).FindControl("T2")); TextBox fax_area = ((TextBox)((ASP.wui_slp_slp_telfax_ascx)SLP_FAX_NO).FindControl("T1")); TextBox fax_no = ((TextBox)((ASP.wui_slp_slp_telfax_ascx)SLP_FAX_NO).FindControl("T2")); TextBox AC_UID = ((TextBox)((ASP.sys_slp_slp_user_ascx)SLP_AC_UID).FindControl("TextBoxCode")); TextBox SAL_ID = ((TextBox)((ASP.sys_slp_slp_user_ascx)SLP_SAL_ID).FindControl("TextBoxCode")); TextBox[] FieldIDs ={ txtSTORE, txtSTORE_NAME, start_date, StoreChain, StoreGroup, txtSTORE_ZIP, tel_area, tel_no, fax_area, fax_no, txtSTORE_ADDRESS, AC_UID, SAL_ID }; string[] FieldNames ={ "店號", "店名", "DC適用開始日", "配本通路", "店群", "郵遞區號", "電話區碼", "電話號碼", "傳真區碼", "傳真號碼", "地址", "帳務人員", "營業人員" }; int i = 0; foreach (TextBox FieldName in FieldIDs) { if (FieldName.Text.Trim().Length == 0) { ErrorMsgLabel.Text = "必須輸入「" + FieldNames[i] + "」欄位"; return; } i++; } //20130828 純萍 異動判斷=>特定店群不判斷店號規則 //判斷店群 ParameterList.Clear(); ParameterList.Add(StoreGroup.Text.Trim()); if (STM.ExceptionStoreGroup(ParameterList) == "0") { if (!IsNumber(txtSTORE.Text.Substring(1)) || !IsWord(txtSTORE.Text.Substring(0, 1))) { ErrorMsgLabel.Text = "店號第一碼是英文字或數字,第二碼後都要是數字 !!"; return; } } //檢核長度 if (GetStringLen(txtSTORE.Text.Trim()) > 10) { ErrorMsgLabel.Text = "店號長度限制10位 !!"; return; } if (GetStringLen(txtSTORE_NAME.Text.Trim()) > 12) { ErrorMsgLabel.Text = "店名長度限制12位 !!"; return; } if (GetStringLen(txtSTORE_ADDRESS.Text.Trim()) > 50) { ErrorMsgLabel.Text = "地址長度限制50位 !!"; return; } if (GetStringLen(txtOLD_STORE.Text.Trim()) > 10) { ErrorMsgLabel.Text = "舊店號長度限制10位 !!"; return; } //DC適用開始日檢核 if (SLP_MDC_END_DATE.Text.Trim().Length > 0) { if (DateTime.Parse(SLP_MDC_START_DATE.Text) >= DateTime.Parse(SLP_MDC_END_DATE.Text)) { ErrorMsgLabel.Text = "DC適用開始日須小於DC適用結束日 !!"; return; } if ((SLP_MDC_END_DATE.Text.Trim().Length == 0 ? DateTime.Parse("9999/12/31") : DateTime.Parse(SLP_MDC_END_DATE.Text)) <= DateTime.Today) { ErrorMsgLabel.Text = "DC適用結束日須大於系統日 !!"; return; } } //開店日期須小於關店日期 if ((SLP_STORE_OPEN_DATE.Text != "") && (SLP_STORE_CLOSE_DATE.Text != "")) { if (DateTime.Parse(SLP_STORE_OPEN_DATE.Text) >= DateTime.Parse(SLP_STORE_CLOSE_DATE.Text)) { ErrorMsgLabel.Text = "開店日期須小於關店日期 !!"; return; } } //判斷配本通路 ParameterList.Clear(); ParameterList.Add(StoreChain.Text.Trim()); if (STM.ValidateStoreChan(ParameterList) == "0") { ErrorMsgLabel.Text = "配本通路錯誤 !!"; return; } //判斷店群 ParameterList.Clear(); ParameterList.Add(StoreGroup.Text.Trim()); if (STM.ValidateStoreGroup(ParameterList) == "0") { ErrorMsgLabel.Text = "店群錯誤 !!"; return; } //取得結帳統編 if (txtPAY_RFNO.Text.Trim().Length == 0) txtPAY_RFNO.Text = STM.GetViutualPayRFNO(); //取得舊店號 if (txtOLD_STORE.Text.Trim().Length != 0) { ParameterList.Clear(); ParameterList.Add(txtOLD_STORE.Text.Trim());//舊門市 ParameterList.Add(txtSTORE.Text.Trim());//門市 if (STM.GetChargestore(ParameterList) == "0") { ErrorMsgLabel.Text = "舊店號錯誤 !!"; return; } } //取得審核狀態 if (txtPAY_RFNO.Text.Trim().Length != 0) { ParameterList.Clear(); ParameterList.Add(txtSTORE.Text.Trim());//門市 lblARMK.Text = "未審核"; if (STM.GetStoreAccountInfo(ParameterList) == "1") lblARMK.Text = "已審核"; } #endregion #region 新增儲存 if (Request.QueryString["mode"] == "insert") { //判斷DC適用開始日與門市的DC適用開始日是否重疊 ParameterList.Clear(); ParameterList.Add(txtSTORE.Text.Trim());//門市 ParameterList.Add(SLP_MDC_START_DATE.Text.Trim());//DC適用開始日 if (STM.CheckDcStartData(ParameterList) == "0") { ErrorMsgLabel.Text = "門市的DC生效區間重疊 !!"; return; } //儲存作業 int res = 0; int v_ID = 0; #region try { #region 取得畫面元件的值 TextBox txt_TELAREA = (TextBox)this.SLP_TEL_NO.FindControl("T1"); TextBox txt_TELNO = (TextBox)this.SLP_TEL_NO.FindControl("T2"); TextBox txt_FAXAREA = (TextBox)this.SLP_FAX_NO.FindControl("T1"); TextBox txt_FAXNO = (TextBox)this.SLP_FAX_NO.FindControl("T2"); CheckBox chk_DIS_SW = (CheckBox)this.SLP_DIS_SW.FindControl("C1"); CheckBox chk_MARKET_RESEARCH = (CheckBox)this.SLP_MARKET_RESEARCH.FindControl("C1"); CheckBox chk_SING_VEN = (CheckBox)this.SLP_SING_VEN.FindControl("C1"); RadioButtonList rdo_MDC_TAXABLE = (RadioButtonList)this.SLP_MDC_TAXABLE.FindControl("R1"); RadioButtonList rdo_MDC_TAXFREE = (RadioButtonList)this.SLP_MDC_TAXFREE.FindControl("R1"); CheckBox chk_W1 = (CheckBox)this.SLP_Boolean1.FindControl("C1"); CheckBox chk_W2 = (CheckBox)this.SLP_Boolean2.FindControl("C1"); CheckBox chk_W3 = (CheckBox)this.SLP_Boolean3.FindControl("C1"); CheckBox chk_W4 = (CheckBox)this.SLP_Boolean4.FindControl("C1"); CheckBox chk_W5 = (CheckBox)this.SLP_Boolean5.FindControl("C1"); CheckBox chk_W6 = (CheckBox)this.SLP_Boolean6.FindControl("C1"); CheckBox chk_W7 = (CheckBox)this.SLP_Boolean7.FindControl("C1"); DateTime processtime = DateTime.Now; #endregion #region 門市基本,配送屬性 ParameterList.Clear(); ParameterList.Add(string.Format("{0}{1}", this.txtSTORE.Text.Trim(), Convert.ToDateTime(this.SLP_MDC_START_DATE.Text).Year.ToString() + Convert.ToDateTime(this.SLP_MDC_START_DATE.Text).Month.ToString().PadLeft(2, '0') + Convert.ToDateTime(this.SLP_MDC_START_DATE.Text).Day.ToString().PadLeft(2, '0'))); ParameterList.Add(GetValueSetParameter(this.txtSTORE_NAME.Text.Trim(), "string", false)); 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.txtSTORE.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_MDC_START_DATE.Text, "date", false)); ParameterList.Add(GetValueSetParameter(this.SLP_MDC_END_DATE.Text, "date", false)); ParameterList.Add(GetValueSetParameter(this.txtSTORE_NAME.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_CHAN_NO.Text, "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_GROUP_NO.Text, "string", false)); ParameterList.Add(GetValueSetParameter(this.txtOLD_STORE.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_STORE_OPEN_DATE.Text, "date", false)); ParameterList.Add(GetValueSetParameter(this.SLP_STORE_CLOSE_DATE.Text, "date", false)); ParameterList.Add(GetValueSetParameter(this.SLP_REOPEN_DATE.Text, "date", false)); ParameterList.Add(GetValueSetParameter(this.SLP_REMODEL_DATE.Text, "date", false)); ParameterList.Add(GetValueSetParameter(this.SLP_Z_O.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_D_O.Text.Trim(), "string", false)); ; ParameterList.Add(GetValueSetParameter(this.SLP_STORE_TYPE.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.txtSTORE_ZIP.Text.Trim(), "string", false)); ParameterList.Add(txt_TELAREA.Text.Trim()); ParameterList.Add(txt_TELNO.Text.Trim()); ParameterList.Add(txt_FAXAREA.Text.Trim()); ParameterList.Add(txt_FAXNO.Text.Trim()); ParameterList.Add(GetValueSetParameter(this.txtSTORE_ADDRESS.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_AREA_NO.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_AREA_CODE.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_SHELVE_CM3.Text, "int", false)); ParameterList.Add(chk_DIS_SW.Checked ? 1 : 0); ParameterList.Add(GetValueSetParameter(this.SLP_ALLOCATION_TIMES.Text, "int", false)); ParameterList.Add(chk_MARKET_RESEARCH.Checked ? 1 : 0); ParameterList.Add(this.SLP_AC_UID.Text.Trim()); ParameterList.Add(this.SLP_SAL_ID.Text.Trim()); ParameterList.Add(this.SLP_FEAT_GRADE.Text.Trim()); ParameterList.Add(GetValueSetParameter(this.txtPAY_RFNO.Text.Trim(), "string", false)); ParameterList.Add(chk_SING_VEN.Checked ? 1 : 0); if (rdo_MDC_TAXABLE.SelectedValue == "1") ParameterList.Add(1); else ParameterList.Add(0); if (rdo_MDC_TAXFREE.SelectedValue == "1") ParameterList.Add(1); else ParameterList.Add(0); ParameterList.Add(this.txtVIRTUAL_FLAG.Text.Trim()); #endregion #region 屬性 ParameterList.Add(this.txtSTORE.Text.Trim()); ParameterList.Add(this.txtSTORE_NAME.Text.Trim()); ParameterList.Add(processtime); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(processtime); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(this.txtSTORE.Text.Trim()); ParameterList.Add(this.txtCOPY_SOURCE.Text.Trim()); ParameterList.Add(GetValueSetParameter(this.SLP_PSM.Text, "int", false)); ParameterList.Add(this.SLP_BUSINESS_NO.Text.Trim()); ParameterList.Add(this.SLP_OPEN_TIME.Text.Trim()); ParameterList.Add(this.SLP_CLOSE_TIME.Text.Trim()); ParameterList.Add(this.SLP_COMPETITION.Text.Trim()); ParameterList.Add(this.SLP_REMARK.Text.Trim()); ParameterList.Add(this.SLP_STORE_SPE.Text.Trim()); ParameterList.Add(chk_W1.Checked ? 1 : 0); ParameterList.Add(chk_W2.Checked ? 1 : 0); ParameterList.Add(chk_W3.Checked ? 1 : 0); ParameterList.Add(chk_W4.Checked ? 1 : 0); ParameterList.Add(chk_W5.Checked ? 1 : 0); ParameterList.Add(chk_W6.Checked ? 1 : 0); ParameterList.Add(chk_W7.Checked ? 1 : 0); #endregion #region 貨架設置 DataSet ds = (DataSet)Session["STM012_" + PageTimeStamp.Value]; foreach (DataRow dr in ds.Tables[0].Rows) { if (dr.RowState != DataRowState.Deleted) { dr.BeginEdit(); dr["CODE"] = txtSTORE.Text + dr["SHELF_NO"].ToString(); dr["NAME"] = txtSTORE_NAME.Text; dr["STORE"] = txtSTORE.Text; dr.EndEdit(); } } #endregion STMModel.MaintainStoreBase BCO = new STMModel.MaintainStoreBase(ConnectionDB); v_ID = BCO.CreateStoreBase(ParameterList, null, ds.Tables[0]); LogHelper LOG = new LogHelper(ConnectionDB); ParameterList.Clear(); ParameterList.Add("STM01門市主檔");//0 ParameterList.Add(Session["UID"].ToString());//1 ParameterList.Add("I");//2 ParameterList.Add(txtSTORE.Text.Trim());//3 ParameterList.Add(Request.ServerVariables["Server_Name"]);//4 LOG.AddSafeLog(ParameterList); if (v_ID == 0) { throw new Exception("新增0筆資料!"); } else { ScriptManager.RegisterStartupScript(UpdatePanel11, this.GetType(), "ClientScript", "alert('新增完成');location.replace('STM012.aspx?mode=view&store=" + txtSTORE.Text + "&date=" + SLP_MDC_START_DATE.Text + "&Code=STM01');", true); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個 } #endregion } #endregion #region 更新儲存 else if (Request.QueryString["mode"] == "view") { //儲存作業 int res = 0; int v_ID = 0; int v_Code = 0; //0:nothing 1:insert 2:update #region try { #region 取得畫面元件的值 TextBox txt_TELAREA = (TextBox)this.SLP_TEL_NO.FindControl("T1"); TextBox txt_TELNO = (TextBox)this.SLP_TEL_NO.FindControl("T2"); TextBox txt_FAXAREA = (TextBox)this.SLP_FAX_NO.FindControl("T1"); TextBox txt_FAXNO = (TextBox)this.SLP_FAX_NO.FindControl("T2"); CheckBox chk_DIS_SW = (CheckBox)this.SLP_DIS_SW.FindControl("C1"); CheckBox chk_MARKET_RESEARCH = (CheckBox)this.SLP_MARKET_RESEARCH.FindControl("C1"); CheckBox chk_SING_VEN = (CheckBox)this.SLP_SING_VEN.FindControl("C1"); RadioButtonList rdo_MDC_TAXABLE = (RadioButtonList)this.SLP_MDC_TAXABLE.FindControl("R1"); RadioButtonList rdo_MDC_TAXFREE = (RadioButtonList)this.SLP_MDC_TAXFREE.FindControl("R1"); CheckBox chk_W1 = (CheckBox)this.SLP_Boolean1.FindControl("C1"); CheckBox chk_W2 = (CheckBox)this.SLP_Boolean2.FindControl("C1"); CheckBox chk_W3 = (CheckBox)this.SLP_Boolean3.FindControl("C1"); CheckBox chk_W4 = (CheckBox)this.SLP_Boolean4.FindControl("C1"); CheckBox chk_W5 = (CheckBox)this.SLP_Boolean5.FindControl("C1"); CheckBox chk_W6 = (CheckBox)this.SLP_Boolean6.FindControl("C1"); CheckBox chk_W7 = (CheckBox)this.SLP_Boolean7.FindControl("C1"); DateTime processtime = DateTime.Now; #endregion #region 門市基本,配送屬性 ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(ds_Data.Tables["VDS_STM_STORE"].Rows[0]["CREATEDATE"].ToString(), "datetime", false)); ParameterList.Add(GetValueSetParameter(ds_Data.Tables["VDS_STM_STORE"].Rows[0]["CREATEUID"].ToString(), "string", false)); ParameterList.Add(GetValueSetParameter(ds_Data.Tables["VDS_STM_STORE"].Rows[0]["UPDATEDATE"].ToString(), "datetime", false)); ParameterList.Add(GetValueSetParameter(ds_Data.Tables["VDS_STM_STORE"].Rows[0]["UPDATEUID"].ToString(), "string", false)); ParameterList.Add(GetValueSetParameter(ds_Data.Tables["VDS_STM_STORE"].Rows[0]["STORE"].ToString(), "string", false)); ParameterList.Add(GetValueSetParameter(ds_Data.Tables["VDS_STM_STORE"].Rows[0]["MDC_START_DATE"].ToString(), "date", false)); ParameterList.Add(string.Format("{0}{1}", this.txtSTORE.Text.Trim(), Convert.ToDateTime(this.SLP_MDC_START_DATE.Text).Year.ToString() + Convert.ToDateTime(this.SLP_MDC_START_DATE.Text).Month.ToString().PadLeft(2, '0') + Convert.ToDateTime(this.SLP_MDC_START_DATE.Text).Day.ToString().PadLeft(2, '0'))); ParameterList.Add(GetValueSetParameter(this.txtSTORE_NAME.Text.Trim(), "string", false)); ParameterList.Add(processtime); ParameterList.Add(GetValueSetParameter(Session["UID"].ToString(), "string", false)); ParameterList.Add(GetValueSetParameter(this.txtSTORE.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_MDC_START_DATE.Text, "date", false)); ParameterList.Add(GetValueSetParameter(this.SLP_MDC_END_DATE.Text, "date", false)); ParameterList.Add(GetValueSetParameter(this.txtSTORE_NAME.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_CHAN_NO.Text, "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_GROUP_NO.Text, "string", false)); ParameterList.Add(GetValueSetParameter(this.txtOLD_STORE.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_STORE_OPEN_DATE.Text, "date", false)); ParameterList.Add(GetValueSetParameter(this.SLP_STORE_CLOSE_DATE.Text, "date", false)); ParameterList.Add(GetValueSetParameter(this.SLP_REOPEN_DATE.Text, "date", false)); ParameterList.Add(GetValueSetParameter(this.SLP_REMODEL_DATE.Text, "date", false)); ParameterList.Add(GetValueSetParameter(this.SLP_Z_O.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_D_O.Text.Trim(), "string", false)); ; ParameterList.Add(GetValueSetParameter(this.SLP_STORE_TYPE.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.txtSTORE_ZIP.Text.Trim(), "string", false)); ParameterList.Add(txt_TELAREA.Text.Trim()); ParameterList.Add(txt_TELNO.Text.Trim()); ParameterList.Add(txt_FAXAREA.Text.Trim()); ParameterList.Add(txt_FAXNO.Text.Trim()); ParameterList.Add(GetValueSetParameter(this.txtSTORE_ADDRESS.Text.Trim(), "string", false)); ParameterList.Add(this.txtVIRTUAL_FLAG.Text.Trim()); ParameterList.Add(GetValueSetParameter(this.SLP_AREA_NO.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_AREA_CODE.Text.Trim(), "string", false)); ParameterList.Add(GetValueSetParameter(this.SLP_SHELVE_CM3.Text, "int", false)); ParameterList.Add(chk_DIS_SW.Checked ? 1 : 0); ParameterList.Add(GetValueSetParameter(this.SLP_ALLOCATION_TIMES.Text, "int", false)); ParameterList.Add(chk_MARKET_RESEARCH.Checked ? 1 : 0); ParameterList.Add(this.SLP_AC_UID.Text.Trim()); ParameterList.Add(this.SLP_SAL_ID.Text.Trim()); ParameterList.Add(this.SLP_FEAT_GRADE.Text.Trim()); ParameterList.Add(GetValueSetParameter(this.txtPAY_RFNO.Text.Trim(), "string", false)); ParameterList.Add(chk_SING_VEN.Checked ? 1 : 0); if (rdo_MDC_TAXABLE.SelectedValue == "1") ParameterList.Add(1); else ParameterList.Add(0); if (rdo_MDC_TAXFREE.SelectedValue == "1") ParameterList.Add(1); else ParameterList.Add(0); #endregion #region 屬性 //判斷屬性是否有資料 if (ds_Data.Tables["VDS_STM_STORE_PROPERTY"].Rows.Count == 0) { //判斷是否有輸入資料 if (this.txtCOPY_SOURCE.Text.Trim() != "" || this.SLP_PSM.Text != "" || this.SLP_BUSINESS_NO.Text != "" || this.SLP_OPEN_TIME.Text != "" || this.SLP_CLOSE_TIME.Text != "" || this.SLP_COMPETITION.Text != "" || this.SLP_REMARK.Text != "" || this.SLP_STORE_SPE.Text != "" || chk_W1.Checked || chk_W2.Checked || chk_W3.Checked || chk_W4.Checked || chk_W5.Checked || chk_W6.Checked || chk_W7.Checked) { //新增資料 v_Code = 1; ParameterList.Add(this.txtSTORE.Text.Trim()); ParameterList.Add(this.txtSTORE_NAME.Text.Trim()); ParameterList.Add(processtime); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(processtime); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(this.txtSTORE.Text.Trim()); ParameterList.Add(this.txtCOPY_SOURCE.Text.Trim()); ParameterList.Add(GetValueSetParameter(this.SLP_PSM.Text, "int", false)); ParameterList.Add(this.SLP_BUSINESS_NO.Text.Trim()); ParameterList.Add(this.SLP_OPEN_TIME.Text.Trim()); ParameterList.Add(this.SLP_CLOSE_TIME.Text.Trim()); ParameterList.Add(this.SLP_COMPETITION.Text.Trim()); ParameterList.Add(this.SLP_REMARK.Text.Trim()); ParameterList.Add(this.SLP_STORE_SPE.Text.Trim()); ParameterList.Add(chk_W1.Checked ? 1 : 0); ParameterList.Add(chk_W2.Checked ? 1 : 0); ParameterList.Add(chk_W3.Checked ? 1 : 0); ParameterList.Add(chk_W4.Checked ? 1 : 0); ParameterList.Add(chk_W5.Checked ? 1 : 0); ParameterList.Add(chk_W6.Checked ? 1 : 0); ParameterList.Add(chk_W7.Checked ? 1 : 0); } } else { //更新資料 v_Code = 2; ParameterList.Add(GetValueSetParameter(ds_Data.Tables["VDS_STM_STORE_PROPERTY"].Rows[0]["CREATEDATE"].ToString(), "datetime", false)); ParameterList.Add(GetValueSetParameter(ds_Data.Tables["VDS_STM_STORE_PROPERTY"].Rows[0]["CREATEUID"].ToString(), "string", false)); ParameterList.Add(GetValueSetParameter(ds_Data.Tables["VDS_STM_STORE_PROPERTY"].Rows[0]["UPDATEDATE"].ToString(), "datetime", false)); ParameterList.Add(GetValueSetParameter(ds_Data.Tables["VDS_STM_STORE_PROPERTY"].Rows[0]["UPDATEUID"].ToString(), "string", false)); ParameterList.Add(GetValueSetParameter(ds_Data.Tables["VDS_STM_STORE_PROPERTY"].Rows[0]["STORE"].ToString(), "string", false)); ParameterList.Add(this.txtSTORE_NAME.Text.Trim()); ParameterList.Add(processtime); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(this.txtSTORE.Text.Trim()); ParameterList.Add(this.txtCOPY_SOURCE.Text.Trim()); ParameterList.Add(GetValueSetParameter(this.SLP_PSM.Text, "int", false)); ParameterList.Add(this.SLP_BUSINESS_NO.Text.Trim()); ParameterList.Add(this.SLP_OPEN_TIME.Text.Trim()); ParameterList.Add(this.SLP_CLOSE_TIME.Text.Trim()); ParameterList.Add(this.SLP_COMPETITION.Text.Trim()); ParameterList.Add(this.SLP_REMARK.Text.Trim()); ParameterList.Add(this.SLP_STORE_SPE.Text.Trim()); ParameterList.Add(chk_W1.Checked ? 1 : 0); ParameterList.Add(chk_W2.Checked ? 1 : 0); ParameterList.Add(chk_W3.Checked ? 1 : 0); ParameterList.Add(chk_W4.Checked ? 1 : 0); ParameterList.Add(chk_W5.Checked ? 1 : 0); ParameterList.Add(chk_W6.Checked ? 1 : 0); ParameterList.Add(chk_W7.Checked ? 1 : 0); } #endregion #region 貨架設置 DataSet ds = (DataSet)Session["STM012_" + PageTimeStamp.Value]; foreach (DataRow dr in ds.Tables[0].Rows) { if (dr.RowState != DataRowState.Deleted) { dr.BeginEdit(); dr["NAME"] = txtSTORE_NAME.Text; dr.EndEdit(); } } #endregion STMModel.MaintainStoreBase BCO = new STMModel.MaintainStoreBase(ConnectionDB); BCO.UpdateStoreBase(ParameterList, null, ds.Tables[0], v_Code); LogHelper LOG = new LogHelper(ConnectionDB); ParameterList.Clear(); ParameterList.Add("STM01門市主檔");//0 ParameterList.Add(Session["UID"].ToString());//1 ParameterList.Add("U");//2 ParameterList.Add(GetValueSetParameter(ds_Data.Tables["VDS_STM_STORE"].Rows[0]["STORE"].ToString(), "string", false));//3 ParameterList.Add(Request.ServerVariables["Server_Name"]);//4 LOG.AddSafeLog(ParameterList); int i_Count = 0; string s_Request_Key = ""; if (Request.QueryString["STM012_COUNT"] != null) { i_Count = int.Parse(Request.QueryString["STM012_COUNT"]); s_Request_Key = Request.QueryString["STM012_PageTimeStamp"]; } ScriptManager.RegisterStartupScript(UpdatePanel11, this.GetType(), "ClientScript", "alert('更新完成');location.replace('STM012.aspx?mode=view&store=" + txtSTORE.Text + "&date=" + SLP_MDC_START_DATE.Text + "&Code=STM01&STM012_COUNT=" + i_Count.ToString() + "&STM012_PageTimeStamp=" + s_Request_Key + "');", true); } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個 } #endregion } #endregion //儲存完成後變成檢視模式 ReadOnlyMode(false); GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Find, true, "STM011.aspx?Code=STM01", null, WUI_GMToolbarV.ClickAction.LinkURL); GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.FindExport, true, "", this.btnStorePrint, WUI_GMToolbarV.ClickAction.ButtonClick); GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.New, false, string.Empty, this.btnEdt, WUI_GMToolbarV.ClickAction.ButtonClick); GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Save, false, string.Empty, this.btnSave, WUI_GMToolbarV.ClickAction.ButtonClick); GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Edit, true, string.Empty, this.btnEdt, WUI_GMToolbarV.ClickAction.ButtonClick); GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Delete, true, string.Empty, this.btnDelete, WUI_GMToolbarV.ClickAction.ButtonClick); GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Copy, true, string.Empty, this.btnCopy, WUI_GMToolbarV.ClickAction.ButtonClick); }
protected void Page_Load(object sender, EventArgs e) { try { ErrorMsgLabel.Text = ""; //驗證SESSION過期和登入狀態 //this.CheckLogin(ref vdb); AuthorityControls(this); SetAuthCRUD(); SetAuthority();//判斷功能權限 if (!IsPostBack) { //TextBox txtD_O = (TextBox)this.SLP_D_O.FindControl("TextBoxCode"); //DropDownList ddlSTORE_TYPE = (DropDownList)this.SLP_STORE_TYPE.FindControl("D1"); //txtD_O.Attributes["onblur"] = "document.getElementById('" + ddlSTORE_TYPE.ClientID + "').focus();"; //寫入首次載入Page TimeStamp PageTimeStamp.Value = string.Format("{0}{1}{2}{3}{4}{5}", DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString().PadLeft(2, '0'), DateTime.Now.Day.ToString().PadLeft(2, '0'), DateTime.Now.Hour.ToString().PadLeft(2, '0'), DateTime.Now.Minute.ToString().PadLeft(2, '0'), DateTime.Now.Second.ToString().PadLeft(2, '0') ); SLP_SHELF_NO_Add.ReadOnly = true; SLP_SHELVE_CM3_Add.ReadOnly = true; SLP_DISPLAY_NUM_Add.ReadOnly = true; ToolBarInit(); this.btnDelete.Attributes.Add("onclick", "return Check_Store_Save();"); #region 新增DataSet //新增DataSet DataSet ds = new DataSet(); DataTable dt = new DataTable(); DataColumn[] keys = new DataColumn[2]; ds.Tables.Add(dt); dt.Columns.Add("CODE", Type.GetType("System.String"));//VARCHAR2(50)代號(STORE+SHELF_NO) dt.Columns.Add("NAME", Type.GetType("System.String"));//VARCHAR2(50)名稱(店名) dt.Columns.Add("STORE", Type.GetType("System.String"));//VARCHAR2(10)門市@ dt.Columns.Add("SHELF_NO", Type.GetType("System.String"));//VARCHAR2(2)貨架代號@ dt.Columns.Add("SHELVE_CM3", Type.GetType("System.Int16"));//NUMBER(3)貨架尺寸@個貨架長cm*寬cm*高cm合計 dt.Columns.Add("DISPLAY_NUM", Type.GetType("System.Int16"));//NUMBER(3)可陳列數 dt.Columns.Add("CREATEDATE"); dt.Columns.Add("CREATEUID"); dt.Columns.Add("UPDATEDATE"); dt.Columns.Add("UPDATEUID"); dt.Columns["STORE"].AllowDBNull = false; dt.Columns["SHELF_NO"].AllowDBNull = false; keys[0] = dt.Columns["STORE"]; keys[1] = dt.Columns["SHELF_NO"]; dt.PrimaryKey = keys; string SessionIDName = "STM012_" + PageTimeStamp.Value; Session[SessionIDName] = ds; #endregion //模式指定 string mode = ""; mode = Request.QueryString["mode"].ToString(); if (mode == "view") { QueryData(Request.QueryString["store"].ToString(), Request.QueryString["date"].ToString()); LogHelper LOG = new LogHelper(ConnectionDB); ParameterList.Clear(); ParameterList.Add("STM01門市主檔");//0 ParameterList.Add(Session["UID"].ToString());//1 ParameterList.Add("Q");//2 ParameterList.Add(Request.QueryString["store"].ToString());//3 ParameterList.Add(Request.ServerVariables["Server_Name"]);//4 LOG.AddSafeLog(ParameterList); ReadOnlyMode(false); btnConfirm.Enabled = false; //確認 btnCancle.Enabled = false; //取消 lblEFF_DATE_TO.Visible = true; txtEFF_DATE_TO.Visible = true; } if (mode == "insert") { if (Request.QueryString["store"] != null && Request.QueryString["date"] != null) //複製新增 { QueryData(Request.QueryString["store"].ToString(), Request.QueryString["date"].ToString()); this.txtSTORE.Text = string.Empty; SetClinetFocus(txtSTORE.ClientID); } ReadOnlyMode(true); btnCancel.Visible = false;//取消 btnAcctCancle.Visible = true; //取消(回查詢頁 lblEFF_DATE_TO.Visible = false; txtEFF_DATE_TO.Visible = false; txtVIRTUAL_FLAG.Text = "0"; } if (lblARMK.Text == "已審核") { btnEdt.Enabled = false; //編輯 btnDelete.Enabled = false; //刪除 } } #region 重取DO NAME if (SLP_D_O.Text.Length > 0) { string strDoName = GetDoName(); TextBox txtDoName = ((TextBox)SLP_D_O.FindControl("TextBoxName")); string strJS = @"function CAACommon_set_Focus() { try { document.getElementById('" + txtDoName.ClientID + "').value='" + strDoName + "';"; strJS += @" } catch(err){setTimeout('CAACommon_set_Focus()', 100);} } CAACommon_set_Focus( );"; ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, typeof(UpdatePanel), "", strJS, true); } #endregion #region 預設Focus欄位 STMModel.STMCommon STMComm = new STMModel.STMCommon(); string s_ScriptManager_Script = STMComm.ToMakeUp_SetFocus_Script(txtSTORE.ClientID, false); ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(UpdatePanel), "STM012", s_ScriptManager_Script, true); #endregion } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個 } finally { Finally_Function(); } }//Page_Load
protected void btnExport_Click(object sender, EventArgs e) { try { Add_Parameter("EXPORT"); MaintainVendorBase BCO = new MaintainVendorBase(ConntionDB); LogHelper LOG = new LogHelper(ConntionDB); DataTable Dt = BCO.QueryVendorBaseByFind_2(ParameterList); if (Dt.Rows.Count > 0) { if (Dt.Columns["ID"] != null) Dt.Columns.Remove("ID"); if (Dt.Columns["CODE"] != null) Dt.Columns.Remove("CODE"); if (Dt.Columns["ENABLE"] != null) Dt.Columns.Remove("ENABLE"); foreach (DataRow dr in Dt.Rows) { ParameterList.Clear(); ParameterList.Add("VDM01供應商主檔");//0 ParameterList.Add(Session["UID"].ToString());//1 ParameterList.Add("O");//2 ParameterList.Add(dr["廠商編號"].ToString());//3 ParameterList.Add(Request.ServerVariables["Server_Name"]);//4 LOG.AddSafeLog(ParameterList); for (int i = 0; i < Dt.Columns.Count; i++) { if (Dt.Columns[i].DataType == Type.GetType("System.String")) { dr[i] = string.Format(" {0}", dr[i].ToString()); } } } Export(System.Text.Encoding.UTF8, "供應商主檔_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls", "application/ms-excel", Dt); } else { Alert("查無資料"); return; } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } finally { } }
/// <summary> /// 於檢視模式,按下刪除鈕 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void DeleteButton_Click(object sender, EventArgs e) { try { ErrorMsgLabel.Text = ""; int DeleteRecord = 0; #region 取得畫面元件的值 DateTime processtime = DateTime.Now; #endregion #region 取得刪除前舊值 #region 使用XML轉回DataSet DataSet Ds = new DataSet(); DataTable Dt = dt_Result; #endregion if (Dt.Rows.Count == 0) { throw new Exception("抓取不到舊值,更新失敗!"); } #endregion #region 加入更新條件 ParameterList.Clear(); //舊值 ParameterList.Add(Dt.Rows[0]["ID"]); ParameterList.Add(Dt.Rows[0]["CODE"]); ParameterList.Add(Dt.Rows[0]["NAME"]); ParameterList.Add(Dt.Rows[0]["CREATEDATE"]); ParameterList.Add(Dt.Rows[0]["CREATEUID"]); ParameterList.Add(Dt.Rows[0]["UPDATEDATE"]); ParameterList.Add(Dt.Rows[0]["UPDATEUID"]); ParameterList.Add(Dt.Rows[0]["ENABLE"]); ParameterList.Add(Dt.Rows[0]["PASSWORD"]); ParameterList.Add(Dt.Rows[0]["MEMO"]); //需要更新值 ParameterList.Add(processtime); ParameterList.Add(Session["UID"].ToString()); #endregion SYSModel.MaintainUser BCO = new SYSModel.MaintainUser(ConnectionDB); DeleteRecord = BCO.DeleteUser(ParameterList, null); if (DeleteRecord == 0) { throw new Exception("刪除失敗!"); } else { LogHelper LOG = new LogHelper(ConnectionDB); ParameterList.Clear(); ParameterList.Add("SYS04人員");//0 ParameterList.Add(Session["UID"].ToString());//1 ParameterList.Add("U");//2 ParameterList.Add(Dt.Rows[0]["CODE"].ToString());//3 ParameterList.Add(Request.ServerVariables["Server_Name"]);//4 LOG.AddSafeLog(ParameterList); Response.Write("<script>alert('刪除完成');location.replace('SYS041.aspx?Code=SYS04');</script>"); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }
}//end EditCancelButton_Click /// <summary> /// 編輯模式,按下更新確認鈕 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void EditCommitButton_Click(object sender, EventArgs e) { try { ErrorMsgLabel.Text = ""; int UpdateRecord = 0; #region 取得畫面元件的值 string v_Name = ((TextBox)FormView1.FindControl("TextBoxName")).Text.Trim(); DateTime processtime = DateTime.Now; string v_Memo = ((TextBox)FormView1.FindControl("TextBoxMemo")).Text.Trim(); string v_Password = ((TextBox)FormView1.FindControl("TextBoxPassword")).Text.Trim(); if (v_Password.Length <8) throw new Exception("密碼長度不足8碼!"); //密碼加密 SYSModel.CryptographyHelper Cry = new SYSModel.CryptographyHelper(); string CryPassword = Cry.Encrypt(v_Password); #endregion #region 取得更新前舊值 #region 使用XML轉回DataSet DataSet Ds = new DataSet(); DataTable Dt = dt_Result; #endregion if (Dt.Rows.Count == 0) { throw new Exception("抓取不到舊值,更新失敗!"); } #endregion #region 加入更新條件 ParameterList.Clear(); //舊值 ParameterList.Add(Dt.Rows[0]["ID"]); ParameterList.Add(Dt.Rows[0]["CODE"]); ParameterList.Add(Dt.Rows[0]["NAME"]); ParameterList.Add(Dt.Rows[0]["CREATEDATE"]); ParameterList.Add(Dt.Rows[0]["CREATEUID"]); ParameterList.Add(Dt.Rows[0]["UPDATEDATE"]); ParameterList.Add(Dt.Rows[0]["UPDATEUID"]); ParameterList.Add(Dt.Rows[0]["ENABLE"]); ParameterList.Add(Dt.Rows[0]["PASSWORD"]); ParameterList.Add(Dt.Rows[0]["MEMO"]); //需要更新值 ParameterList.Add(v_Name); ParameterList.Add(processtime); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(CryPassword); ParameterList.Add(v_Memo); #endregion SYSModel.MaintainUser BCO = new SYSModel.MaintainUser(ConnectionDB); UpdateRecord = BCO.UpdateUser(ParameterList, null); if (UpdateRecord == 0) { throw new Exception("更新0筆資料!"); } else { LogHelper LOG = new LogHelper(ConnectionDB); ParameterList.Clear(); ParameterList.Add("SYS04人員");//0 ParameterList.Add(Session["UID"].ToString());//1 ParameterList.Add("U");//2 ParameterList.Add(Dt.Rows[0]["CODE"].ToString());//3 ParameterList.Add(Request.ServerVariables["Server_Name"]);//4 LOG.AddSafeLog(ParameterList); //ScriptManager.RegisterStartupScript(this.up_Msg, typeof(UpdatePanel), "SYS042", string.Format("<script>alert('更改完成');location.replace('SYS042.aspx?mode=readonly&ID={0}');</script>", Dt.Rows[0]["ID"].ToString()),false); Response.Write(string.Format("<script>alert('更改完成');location.replace('SYS042.aspx?mode=readonly&ID={0}');</script>", Dt.Rows[0]["ID"].ToString())); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }
}//end InsertCancelButton_Click /// <summary> /// 由新增模式,確認新增 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void InsertButton_Click(object sender, EventArgs e) { try { int AddRecord = 0; ErrorMsgLabel.Text = ""; #region 取得畫面元件的值 string v_Code = ((WUI.SLP.SLPUnique)FormView1.FindControl("TextBoxCode")).Text.Trim(); string v_Name = ((TextBox)FormView1.FindControl("TextBoxName")).Text.Trim(); DateTime processtime = DateTime.Now; //string v_Organizationcode = ((WUI.SLP.Organization)FormView1.FindControl("TextBoxOrganizationCode")).Text.Trim(); string v_Password = ((TextBox)FormView1.FindControl("TextBoxPassword")).Text.Trim(); string v_Memo = ((TextBox)FormView1.FindControl("TextBoxMemo")).Text.Trim(); if (v_Password.Length < 8) throw new Exception("密碼長度不足8碼!"); //密碼加密 SYSModel.CryptographyHelper Cry = new SYSModel.CryptographyHelper(); string CryPassword = Cry.Encrypt(v_Password); ParameterList.Clear(); SYSModel.MaintainProgram Uniq = new SYSModel.MaintainProgram(ConnectionDB); ParameterList.Add(v_Code); ParameterList.Add("SYS_USER"); ParameterList.Add("CODE"); ParameterList.Add(""); DataTable Dup = Uniq.QuerySwitch(SYSModel.MaintainProgram.QueryType.Duplicate, ParameterList ); if (Dup.Rows.Count > 0) { if (Dup.Rows[0]["ENABLE"].ToString() == "1") { throw new Exception("資料重覆!"); } } #endregion #region 加入輸入條件 ParameterList.Clear(); ParameterList.Add(v_Code); ParameterList.Add(v_Name); ParameterList.Add(processtime); //vCreateDate ParameterList.Add(Session["UID"].ToString()); //vCreateUID ParameterList.Add(processtime); //vUpdateDate ParameterList.Add(Session["UID"].ToString()); //vUpdateUID //ParameterList.Add(v_Organizationcode); ParameterList.Add(CryPassword); ParameterList.Add(v_Memo); #endregion SYSModel.MaintainUser BCO = new SYSModel.MaintainUser(ConnectionDB); AddRecord = BCO.CreateUser(ParameterList, null); if (AddRecord == 0) { throw new Exception("新增0筆資料!"); } else { LogHelper LOG = new LogHelper(ConnectionDB); ParameterList.Clear(); ParameterList.Add("SYS04人員");//0 ParameterList.Add(Session["UID"].ToString());//1 ParameterList.Add("I");//2 ParameterList.Add(v_Code);//3 ParameterList.Add(Request.ServerVariables["Server_Name"]);//4 LOG.AddSafeLog(ParameterList); Response.Write("<script>alert('新增完成');location.replace('SYS042.aspx?mode=readonly&ID=" + AddRecord + "');</script>"); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }
/// <summary> /// 繫結資料 /// </summary> /// <param name=VirtualDataID></param> private void databind(FormViewMode fvm) { try { SYSModel.MaintainUser BCO = new SYSModel.MaintainUser(ConnectionDB); ParameterList.Clear(); if (Request["ID"] != null) ParameterList.Add(Request["ID"].ToString()); else ParameterList.Add("0"); dt_Result = BCO.QuerySwitch(SYSModel.MaintainUser.QueryType.ID, ParameterList ); if (dt_Result.Rows.Count > 0) { this.hiddenID.Value = dt_Result.Rows[0]["ID"].ToString(); FormView1.DataSource = dt_Result; FormView1.DataBind(); if (dt_Result.Rows[0]["ENABLE"].ToString() == "0") { ((Button)FormView1.FindControl("EditButton")).Visible = false; ((Button)FormView1.FindControl("DeleteButton")).Visible = false; } LogHelper LOG = new LogHelper(ConnectionDB); ParameterList.Clear(); ParameterList.Add("SYS04人員");//0 ParameterList.Add(Session["UID"].ToString());//1 ParameterList.Add("Q");//2 ParameterList.Add(dt_Result.Rows[0]["CODE"].ToString());//3 ParameterList.Add(Request.ServerVariables["Server_Name"]);//4 LOG.AddSafeLog(ParameterList); } AuthorityControls(this); //ToolBarStatus switch (fvm) { case FormViewMode.Edit: ToolBarStatus("edit"); TextBox txtname = ((TextBox)this.FormView1.FindControl("TextBoxCode").FindControl("TextBoxName")); txtname.Visible = false; break; case FormViewMode.Insert: ToolBarStatus("insert"); break; case FormViewMode.ReadOnly: ToolBarStatus("readonly"); TextBox txtname1 = ((TextBox)this.FormView1.FindControl("TextBoxCode").FindControl("TextBoxName")); txtname1.Visible = false; break; } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }//databind