/// <summary> /// 初始檢視&編輯模式 /// </summary> private void Page_Status_VIEW_EDIT_LOAD() { if (hid_Page_Status.Value == "VIEW" || hid_Page_Status.Value == "EDIT") { #region 清空所有欄位 RadioButtonList radio_down_GRADE = (RadioButtonList)((ASP.sys_slp_slp_enumbase_ascx)slp_down_GRADE).FindControl("R1"); //來電紀錄TAB this.slp_up_CHAN_NO.Text = string.Empty;//通路 this.slp_up_Z_O.Text = string.Empty;//營業所 this.txt_up_CODE.Text = string.Empty;//流水編號 this.slp_up_STORE.Text = string.Empty;//門市 this.slp_up_BUSDATE.Text = string.Empty;//處理日期 this.txt_up_ANSWER_TIME.Text = string.Empty;//接聽時間 this.slp_up_SAL_ID.Text = string.Empty;//營業人員 this.slp_up_BUSUID.Text = string.Empty;//處理人員 this.txt_up_ROUTE_ID.Text = string.Empty;//路線 this.txt_up_ROUTE_STEP.Text = string.Empty;//路順 this.txt_up_STORE_TEL_AREA.Text = string.Empty;//電話-區域號碼 this.txt_up_STORE_TEL_NO.Text = string.Empty;//電話號碼 this.txt_up_FAX_AREA.Text = string.Empty;//傳真-區域號碼 this.txt_up_FAX_NO.Text = string.Empty;//傳真號碼 this.txt_up_STORE_ADDRESS.Text = string.Empty;//地址 //客服單TAB this.txt_down_CODE.Text = string.Empty;//客服單號 this.slp_down_PROC_UNIT.Text = string.Empty;//負責單位 //this.slp_down_PROC_MAN.Text = string.Empty;//負責人 //this.txt_down_REQUEST_NO.Text = string.Empty;//原因代號 this.slp_down_REQUEST_NO.Text = string.Empty;//原因代號 this.slp_down_GRADE.Text = //string.Empty;//等級 //radio_down_GRADE.SelectedIndex = 0; //等級 this.txt_down_REQUEST_STATEMENT.Text = string.Empty;//問題陳述 this.slp_down_CLOSE_DATE.Text = string.Empty;//處理日期 this.txt_down_CLOSE_TIME.Text = string.Empty;//處理時間 this.slp_down_ANSWER_USER.Text = string.Empty;//處理人員 this.slp_down_PROC_FLAG.Text = string.Empty;//處理狀態 this.txt_down_PROC_STATEMENT.Text = string.Empty;//處理敘述 this.chb_down_CRM_CONFIRM_DATE.Checked = false;//主管簽核日 this.slp_down_CRM_CONFIRM_DATE.Text = string.Empty;//主管簽核日 this.chb_down_UNIT_CONFIRM_DATE.Checked = false;//客服單位簽核日 this.slp_down_UNIT_CONFIRM_DATE.Text = string.Empty;//客服單位簽核日 //2010/01/07 this.SLP_UpdateUser.Text = string.Empty;//異動人員 this.SLP_UpdateDate.Text = string.Empty;//異動日期 #endregion #region 取得檢視資料 int i_Id = 0; string s_Crm_No = string.Empty; DataTable dt_VDS_CRM_TICKET = new DataTable(); DataSet ds_Return = new DataSet(); try { if (Request["ID"] == null) { throw new Exception("載入頁面失敗!"); } else { i_Id = int.Parse(Request["ID"].ToString()); } } catch { } ArrayList ParameterList = new ArrayList();//20091117 ParameterList.Clear(); ParameterList.Add(i_Id); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(DateTime.Now); BCO.RecordCRMTicket bco_TICKET = new BCO.RecordCRMTicket(ConntionDB); dt_VDS_CRM_TICKET = bco_TICKET.QueryCRMRecordByFind(ParameterList); s_Crm_No = dt_VDS_CRM_TICKET.Rows[0]["CRM_NO"].ToString(); ParameterList.Clear(); ParameterList.Add(s_Crm_No); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(DateTime.Now); BCO.RecordCRMRecord bco_Record = new BCO.RecordCRMRecord(ConntionDB); ds_Return = bco_Record.QueryCRMRecordByCode(ParameterList); ds_Return.Tables.Add(dt_VDS_CRM_TICKET.Copy()); dt_VDS_CRM_TICKET.Clear(); dt_VDS_CRM_TICKET.Dispose(); #endregion #region 使用XML放置到前端資料 xml_OLDData.InnerHtml = ds_Return.GetXml(); #endregion #region 將資料寫入頁面 //來電紀錄TAB this.slp_up_CHAN_NO.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["CHAN_NO"].ToString();//通路 this.slp_up_Z_O.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["Z_O"].ToString();//營業所 this.txt_up_CODE.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["CODE"].ToString();//流水編號 this.slp_up_STORE.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["STORE"].ToString();//門市 this.slp_up_BUSDATE.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["BUSDATE"].ToString();//處理日期 this.txt_up_ANSWER_TIME.Text = DateTime.Parse(ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["ANSWER_TIME"].ToString()).ToString("HHmm");//接聽時間 this.slp_up_SAL_ID.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["SAL_ID"].ToString();//營業人員 this.slp_up_BUSUID.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["BUSUID"].ToString();//處理人員 this.txt_up_ROUTE_ID.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["ROUTE_ID"].ToString();//路線 this.txt_up_ROUTE_STEP.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["ROUTE_STEP"].ToString();//路順 this.txt_up_STORE_TEL_AREA.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["STORE_TEL_AREA"].ToString();//電話-區域號碼 this.txt_up_STORE_TEL_NO.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["STORE_TEL_NO"].ToString();//電話號碼 this.txt_up_FAX_AREA.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["FAX_AREA"].ToString();//傳真-區域號碼 this.txt_up_FAX_NO.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["FAX_NO"].ToString();//傳真號碼 this.txt_up_STORE_ADDRESS.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["STORE_ADDRESS"].ToString();//地址 //客服單TAB this.txt_down_CODE.Text = ds_Return.Tables["VDS_CRM_TICKET"].Rows[0]["CODE"].ToString();//客服單號 this.slp_down_PROC_UNIT.Text = ds_Return.Tables["VDS_CRM_TICKET"].Rows[0]["PROC_UNIT"].ToString();//負責單位 //this.slp_down_PROC_MAN.Text = ds_Return.Tables["VDS_CRM_TICKET"].Rows[0]["PROC_MAN"].ToString();//負責人 RetrievePROC_MAN(slp_down_PROC_UNIT.Text, "", "");//取得負責人資料置入DropDownList裏 foreach (ListItem li in slp_down_PROC_MAN.Items) { li.Selected = (li.Value == ds_Return.Tables["VDS_CRM_TICKET"].Rows[0]["PROC_MAN"].ToString() ? true : false); if (li.Selected) break; } //this.txt_down_REQUEST_NO.Text = ds_Return.Tables["VDS_CRM_TICKET"].Rows[0]["REQUEST_NO"].ToString();//原因代號 this.slp_down_REQUEST_NO.Text = ds_Return.Tables["VDS_CRM_TICKET"].Rows[0]["REQUEST_NO"].ToString();//原因代號 string str1 = ds_Return.Tables["VDS_CRM_TICKET"].Rows[0]["GRADE"].ToString();//等級 this.slp_down_GRADE.Text = str1; this.txt_down_REQUEST_STATEMENT.Text = ds_Return.Tables["VDS_CRM_TICKET"].Rows[0]["REQUEST_STATEMENT"].ToString();//問題陳述 this.slp_down_CLOSE_DATE.Text = ds_Return.Tables["VDS_CRM_TICKET"].Rows[0]["CLOSE_DATE"].ToString();//處理日期 if (ds_Return.Tables["VDS_CRM_TICKET"].Rows[0]["CLOSE_TIME"].ToString() == string.Empty) { this.txt_down_CLOSE_TIME.Text = string.Empty; } else { this.txt_down_CLOSE_TIME.Text = DateTime.Parse(ds_Return.Tables["VDS_CRM_TICKET"].Rows[0]["CLOSE_TIME"].ToString()).ToString("HH:mm"); }//處理時間 this.slp_down_ANSWER_USER.Text = ds_Return.Tables["VDS_CRM_TICKET"].Rows[0]["ANSWER_USER"].ToString();//處理人員 this.slp_down_PROC_FLAG.Text = ds_Return.Tables["VDS_CRM_TICKET"].Rows[0]["PROC_FLAG"].ToString();//處理狀態 this.txt_down_PROC_STATEMENT.Text = ds_Return.Tables["VDS_CRM_TICKET"].Rows[0]["PROC_STATEMENT"].ToString();//處理敘述 //2010/01/07 this.SLP_UpdateUser.Text = ds_Return.Tables["VDS_CRM_TICKET"].Rows[0]["UPDATEUID"].ToString();//異動人員 this.SLP_UpdateDate.Text = ds_Return.Tables["VDS_CRM_TICKET"].Rows[0]["UPDATEDATE"].ToString();//異動日期 if (ds_Return.Tables["VDS_CRM_TICKET"].Rows[0]["CRM_CONFIRM_DATE"].ToString() == string.Empty) { this.chb_down_CRM_CONFIRM_DATE.Checked = false; }//主管簽核日 else { this.chb_down_CRM_CONFIRM_DATE.Checked = true; } this.slp_down_CRM_CONFIRM_DATE.Text = ds_Return.Tables["VDS_CRM_TICKET"].Rows[0]["CRM_CONFIRM_DATE"].ToString();//主管簽核日 if (ds_Return.Tables["VDS_CRM_TICKET"].Rows[0]["UNIT_CONFIRM_DATE"].ToString() == string.Empty) { this.chb_down_UNIT_CONFIRM_DATE.Checked = false; } else { this.chb_down_UNIT_CONFIRM_DATE.Checked = true; }//客服單位簽核日 this.slp_down_UNIT_CONFIRM_DATE.Text = ds_Return.Tables["VDS_CRM_TICKET"].Rows[0]["UNIT_CONFIRM_DATE"].ToString();//客服單位簽核日 ViewState["CRM_CONFIRM"] = ds_Return.Tables["VDS_CRM_TICKET"].Rows[0]["CRM_CONFIRM_DATE"].ToString(); ViewState["UNIT_CONFIRM"] = ds_Return.Tables["VDS_CRM_TICKET"].Rows[0]["UNIT_CONFIRM_DATE"].ToString(); #endregion #region 設定ReadOnly //來電紀錄TAB this.slp_up_CHAN_NO.ReadOnly = true;//通路 this.slp_up_Z_O.ReadOnly = true;//營業所 this.txt_up_CODE.ReadOnly = true;//流水編號 this.txt_up_CODE.CssClass = "readtxtbox"; this.slp_up_STORE.ReadOnly = true;//門市 this.slp_up_BUSDATE.ReadOnly = true;//處理日期 this.txt_up_ANSWER_TIME.ReadOnly = true;//接聽時間 this.slp_up_SAL_ID.ReadOnly = true;//營業人員 this.slp_up_BUSUID.ReadOnly = true;//處理人員 this.txt_up_ROUTE_ID.ReadOnly = true;//路線 this.txt_up_ROUTE_ID.CssClass = "readtxtbox"; this.txt_up_ROUTE_STEP.ReadOnly = true;//路順 this.txt_up_ROUTE_STEP.CssClass = "readtxtbox"; this.txt_up_STORE_TEL_AREA.ReadOnly = true;//電話-區域號碼 this.txt_up_STORE_TEL_AREA.CssClass = "readtxtbox"; this.txt_up_STORE_TEL_NO.ReadOnly = true;//電話號碼 this.txt_up_STORE_TEL_NO.CssClass = "readtxtbox"; this.txt_up_FAX_AREA.ReadOnly = true;//傳真-區域號碼 this.txt_up_FAX_AREA.CssClass = "readtxtbox"; this.txt_up_FAX_NO.ReadOnly = true;//傳真號碼 this.txt_up_FAX_NO.CssClass = "readtxtbox"; this.txt_up_STORE_ADDRESS.ReadOnly = true;//地址 this.txt_up_STORE_ADDRESS.CssClass = "readtxtbox"; if (this.hid_Page_Status.Value == "VIEW") { #region 檢視模式 //客服單TAB this.txt_down_CODE.ReadOnly = true;//客服單號 this.txt_down_CODE.CssClass = "readtxtbox"; this.slp_down_PROC_UNIT.ReadOnly = true;//負責單位 this.slp_down_PROC_MAN.Enabled = false;//負責人 slp_down_PROC_MAN.CssClass = "readtxtbox"; //this.txt_down_REQUEST_NO.ReadOnly = true;//原因代號 this.slp_down_REQUEST_NO.ReadOnly = true;//原因代號 this.slp_down_GRADE.ReadOnly = true;//等級 this.slp_down_GRADE.IsRequired = true; this.txt_down_REQUEST_STATEMENT.ReadOnly = true;//問題陳述 this.txt_down_REQUEST_STATEMENT.CssClass = "readtxtbox"; this.slp_down_CLOSE_DATE.ReadOnly = true;//處理日期 this.txt_down_CLOSE_TIME.ReadOnly = true;//處理時間 this.slp_down_ANSWER_USER.ReadOnly = true;//處理人員 this.slp_down_ANSWER_USER.CssClass = "readtxtbox"; this.slp_down_PROC_FLAG.ReadOnly = true;//處理狀態 this.slp_down_PROC_FLAG.IsRequired = true; this.txt_down_PROC_STATEMENT.ReadOnly = true;//處理敘述 this.txt_down_PROC_STATEMENT.CssClass = "readtxtbox"; this.chb_down_CRM_CONFIRM_DATE.Enabled = false;//主管簽核日 //this.slp_down_CRM_CONFIRM_DATE.ReadOnly = true;//主管簽核日 this.chb_down_UNIT_CONFIRM_DATE.Enabled = false;//客服單位簽核日 //this.slp_down_UNIT_CONFIRM_DATE.ReadOnly = true;//客服單位簽核日 #endregion } if (this.hid_Page_Status.Value == "EDIT") { #region 編輯模式 RadioButtonList rad_down_PROC_FLAG = (RadioButtonList)this.slp_down_PROC_FLAG.FindControl("R1"); //客服單TAB this.txt_down_CODE.ReadOnly = true;//客服單號 this.slp_down_PROC_UNIT.ReadOnly = false;//負責單位 this.slp_down_PROC_MAN.Enabled = true;//負責人 slp_down_PROC_MAN.CssClass = ""; //this.txt_down_REQUEST_NO.ReadOnly = false;//原因代號 this.slp_down_REQUEST_NO.ReadOnly = false;//原因代號 this.slp_down_GRADE.ReadOnly = false;//等級 this.txt_down_REQUEST_STATEMENT.ReadOnly = false;//問題陳述 this.slp_down_CLOSE_DATE.ReadOnly = false;//處理日期 this.txt_down_CLOSE_TIME.ReadOnly = false;//處理時間 this.slp_down_ANSWER_USER.ReadOnly = false;//處理人員 this.slp_down_ANSWER_USER.CssClass = ""; this.slp_down_PROC_FLAG.ReadOnly = false;//處理狀態 this.txt_down_PROC_STATEMENT.ReadOnly = false;//處理敘述 //if (rad_down_PROC_FLAG.SelectedIndex == 2) // this.chb_down_CRM_CONFIRM_DATE.Enabled = true;//主管簽核日 //else // this.chb_down_CRM_CONFIRM_DATE.Enabled = false;//主管簽核日 //this.slp_down_CRM_CONFIRM_DATE.ReadOnly = false;//主管簽核日 //if (rad_down_PROC_FLAG.SelectedIndex == 2) // this.chb_down_UNIT_CONFIRM_DATE.Enabled = true;//客服單位簽核日 //else // this.chb_down_UNIT_CONFIRM_DATE.Enabled = false;//客服單位簽核日 //this.slp_down_UNIT_CONFIRM_DATE.ReadOnly = false;//客服單位簽核日 if (chb_down_CRM_CONFIRM_DATE.Checked || chb_down_UNIT_CONFIRM_DATE.Checked) //slp_down_PROC_FLAG.ReadOnly = true; System.Web.UI.ScriptManager.RegisterStartupScript(this.but_Cancel, this.GetType(), "CRM032", "lockProcessField();", true); else //slp_down_PROC_FLAG.ReadOnly = false; System.Web.UI.ScriptManager.RegisterStartupScript(this.but_Cancel, this.GetType(), "CRM032", "unlockProcessField();", true); #endregion } #endregion } }
/// <summary> /// BUTTON 存檔 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void but_Save_Click(object sender, EventArgs e) { //System.Threading.Thread.Sleep(2000); try { #region 新增和更改前檢查 System.Text.StringBuilder sb = new System.Text.StringBuilder(); //來電紀錄必填欄位 if (this.slp_up_CHAN_NO.Text.Trim() == string.Empty) { sb.Append("[通路]欄位不可空白\\r\\n"); } if (this.slp_up_Z_O.Text.Trim() == string.Empty) { sb.Append("[營業所]欄位不可空白\\r\\n"); } if (this.txt_up_CODE.Text.Trim() == string.Empty) { sb.Append("[流水編號]欄位不可空白\\r\\n"); } if (this.slp_up_STORE.Text.Trim() == string.Empty) { sb.Append("[門市]欄位不可空白\\r\\n"); } if (this.slp_up_BUSDATE.Text.Trim() == string.Empty) { sb.Append("[處理日期]欄位不可空白\\r\\n"); } if (this.txt_up_ANSWER_TIME.Text.Trim() == string.Empty) { sb.Append("[接聽時間]欄位不可空白\\r\\n"); } if (this.slp_up_SAL_ID.Text.Trim() == string.Empty) { sb.Append("[營業人員]欄位不可空白\\r\\n"); } //if (this.slp_up_SAL_ID.Name == "查無資料") //{ sb.AppendFormat("輸入的[營業人員]{0}不存在\\r\\n", slp_up_SAL_ID.Text); } if (this.slp_up_BUSUID.Text.Trim() == string.Empty) { sb.Append("[處理人員]欄位不可空白\\r\\n"); } if (this.slp_up_BUSUID.Name == "查無資料") { sb.AppendFormat("輸入的[處理人員]{0}不存在\\r\\n", slp_up_BUSUID.Text); } if (this.txt_up_ROUTE_ID.Text.Trim() == string.Empty) { sb.Append("[路線]欄位不可空白\\r\\n"); } if (this.txt_up_ROUTE_STEP.Text.Trim() == string.Empty) { sb.Append("[路順]欄位不可空白\\r\\n"); } //客服單必填欄位 if (this.slp_down_PROC_UNIT.Text.Trim() == string.Empty) { sb.Append("[負責單位]欄位不可空白\\r\\n"); } if (this.slp_down_PROC_UNIT.Name == "查無資料") { sb.AppendFormat("輸入的[負責單位]{0}不存在\\r\\n", slp_down_PROC_UNIT.Text); } //if (this.slp_down_PROC_MAN.Name == "查無資料") //改用下拉選單 //{ sb.AppendFormat("輸入的[負責人員]{0}不存在\\r\\n", slp_down_PROC_MAN.Text); } //if (this.slp_down_ANSWER_USER.Name == "查無資料") //{ sb.AppendFormat("輸入的[處理人員]{0}不存在\\r\\n", slp_down_ANSWER_USER.Text); } if (GetStringLen(this.slp_down_ANSWER_USER.Text) > this.slp_down_ANSWER_USER.MaxLength) { sb.Append("[負責人員]資料長度太長\\r\\n"); } //if (this.txt_down_REQUEST_NO.Text.Trim() == string.Empty) //{ sb.Append("[原因代號]欄位不可空白\\r\\n"); } if (this.slp_down_REQUEST_NO.Text.Trim() == string.Empty) { sb.Append("[原因代號]欄位不可空白\\r\\n"); } if (this.slp_down_GRADE.Text.Trim() == string.Empty) { sb.Append("[等級]欄位不可空白\\r\\n"); } if (this.txt_down_REQUEST_STATEMENT.Text.Trim() == string.Empty) { sb.Append("[問題陳述]欄位不可空白\\r\\n"); } if (GetStringLen(txt_down_REQUEST_STATEMENT.Text) > txt_down_REQUEST_STATEMENT.MaxLength) //500 { sb.Append("[問題陳述]欄位資料太長\\r\\n"); } if (GetStringLen(txt_down_PROC_STATEMENT.Text) > txt_down_PROC_STATEMENT.MaxLength) //500 { sb.Append("[處理敘述]欄位資料太長\\r\\n"); } //[處理狀態]為[已處理]則[處理敘述]不可為null if (this.slp_down_PROC_FLAG.Text == "2" && this.txt_down_PROC_STATEMENT.Text == string.Empty) { sb.Append("[處理狀態]為[已處理]則[處理敘述]不可空白\\r\\n"); } if (sb.ToString() != string.Empty) { ScriptManager.RegisterStartupScript(Page, this.GetType(), "CRM032", "alert('" + sb.ToString() + "');but_Save_OR_Edit_Check_Fail();", true); return; } #region 確認審核日期 if (this.chb_down_CRM_CONFIRM_DATE.Checked) { this.slp_down_CRM_CONFIRM_DATE.Text = DateTime.Today.ToString("yyyy/MM/dd"); } if (this.chb_down_UNIT_CONFIRM_DATE.Checked) { this.slp_down_UNIT_CONFIRM_DATE.Text = DateTime.Today.ToString("yyyy/MM/dd"); } #endregion #endregion if (this.hid_Page_Status.Value == "INSERT") { #region 設定預設資料 DataTable dt_VDS_CRM_TICKET = new DataTable(); string s_LoginUser = string.Empty; DateTime d_Now = DateTime.Now; int i_Return_Id = 0; s_LoginUser = Session["UID"].ToString(); ArrayList ParameterList = new ArrayList();//20091117 ParameterList.Clear(); ParameterList.Add(s_LoginUser); ParameterList.Add(d_Now); BCO.RecordCRMTicket bco = new BCO.RecordCRMTicket(ConntionDB); dt_VDS_CRM_TICKET = bco.GET_VDS_CRM_TICKET_SCHEMA(ParameterList); DataRow dRow = dt_VDS_CRM_TICKET.NewRow(); dRow["BUSUID"] = Session["UID"].ToString(); dRow["CREATEDATE"] = d_Now; dRow["CREATEUID"] = s_LoginUser; dRow["UPDATEDATE"] = d_Now; dRow["UPDATEUID"] = s_LoginUser; dRow["CHAN_NO"] = this.slp_up_CHAN_NO.Text.Trim();//畫面上[通路] dRow["STORE"] = this.slp_up_STORE.Text.Trim();//畫面上[門市] dRow["CRM_DATE"] = DateTime.ParseExact(this.slp_up_BUSDATE.Text.Trim(), "yyyy/MM/dd", null);//畫面上[處理日期 ] dRow["CRM_NO"] = this.txt_up_CODE.Text.Trim();//畫面上[流水編號] dRow["PROC_UNIT"] = this.slp_down_PROC_UNIT.Text.Trim();//畫面上[負責單位] dRow["PROC_MAN"] = this.slp_down_PROC_MAN.SelectedValue;//畫面上[負責人] //dRow["REQUEST_NO"] = this.txt_down_REQUEST_NO.Text.Trim();//畫面上[原因代號] dRow["REQUEST_NO"] = this.slp_down_REQUEST_NO.Text.Trim();//畫面上[原因代號] dRow["GRADE"] = this.slp_down_GRADE.Text.Trim();//畫面上[等級] dRow["REQUEST_STATEMENT"] = this.txt_down_REQUEST_STATEMENT.Text.Trim();//畫面上[問題陳述] if (this.slp_down_CLOSE_DATE.Text.Trim() == string.Empty)// { dRow["CLOSE_DATE"] = DBNull.Value; } else { dRow["CLOSE_DATE"] = DateTime.ParseExact(this.slp_down_CLOSE_DATE.Text.Trim(), "yyyy/MM/dd", null); }//畫面上[處理日期] if (this.txt_down_CLOSE_TIME.Text.Trim() == string.Empty) { dRow["CLOSE_TIME"] = DBNull.Value; } else { dRow["CLOSE_TIME"] = DateTime.ParseExact(slp_down_CLOSE_DATE.Text + " " + txt_down_CLOSE_TIME.Text.Trim() + "00", "yyyy/MM/dd HH:mm:ss", null); }//畫面上[處理時間] dRow["ANSWER_USER"] = this.slp_down_ANSWER_USER.Text.Trim();//畫面上[處理人員] dRow["PROC_FLAG"] = int.Parse(this.slp_down_PROC_FLAG.Text.Trim());//畫面上[處理狀態] dRow["PROC_STATEMENT"] = this.txt_down_PROC_STATEMENT.Text.Trim();//畫面上[處理敘述] dRow["CRM_CONFIRM_DATE"] = DBNull.Value;//畫面上[主管簽核日] dRow["UNIT_CONFIRM_DATE"] = DBNull.Value;//畫面上[客服單位簽核日] dt_VDS_CRM_TICKET.Rows.Add(dRow); ParameterList.Clear(); ParameterList.Add(s_LoginUser); ParameterList.Add(d_Now); #endregion #region 儲存新增資料 i_Return_Id = bco.CreateCRMRecord(ParameterList, null, dt_VDS_CRM_TICKET); this.hid_Page_Status.Value = "VIEW"; System.Web.UI.ScriptManager.RegisterStartupScript(this.but_Save, this.GetType(), "CRM032", "alert('新增完成');location.replace('CRM032.aspx?Code=CRM03&ID=" + i_Return_Id.ToString() + "&mode=VIEW');", true); #endregion } else if (this.hid_Page_Status.Value == "EDIT") { DataTable dt_VDS_CRM_TICKET = new DataTable(); int i_Return_Id = 0; #region 舊資料 #region 使用XML轉回DataSet DataSet ds_OldData = new DataSet(); System.IO.StringReader sr_OldData = new System.IO.StringReader(xml_OLDData.InnerHtml); ds_OldData.ReadXml(sr_OldData); #endregion ArrayList ParameterList = new ArrayList();//20091117 ParameterList.Clear(); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(DateTime.Now); BCO.RecordCRMTicket bco = new BCO.RecordCRMTicket(ConntionDB); dt_VDS_CRM_TICKET = bco.GET_VDS_CRM_TICKET_SCHEMA(ParameterList); DataRow dRow = dt_VDS_CRM_TICKET.NewRow(); if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("ID") == true) { dRow["ID"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["ID"]; } else { dRow["ID"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("CODE") == true) { dRow["CODE"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["CODE"]; } else { dRow["CODE"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("NAME") == true) { dRow["NAME"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["NAME"]; } else { dRow["NAME"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("BUSDATE") == true) { dRow["BUSDATE"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["BUSDATE"]; } else { dRow["BUSDATE"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("BUSUID") == true) { dRow["BUSUID"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["BUSUID"]; } else { dRow["BUSUID"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("CREATEDATE") == true) { dRow["CREATEDATE"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["CREATEDATE"]; } else { dRow["CREATEDATE"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("CREATEUID") == true) { dRow["CREATEUID"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["CREATEUID"]; } else { dRow["CREATEUID"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("UPDATEDATE") == true) { dRow["UPDATEDATE"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["UPDATEDATE"]; } else { dRow["UPDATEDATE"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("UPDATEUID") == true) { dRow["UPDATEUID"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["UPDATEUID"]; } else { dRow["UPDATEUID"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("ENABLE") == true) { dRow["ENABLE"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["ENABLE"]; } else { dRow["ENABLE"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("STATUS") == true) { dRow["STATUS"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["STATUS"]; } else { dRow["STATUS"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("CHAN_NO") == true) { dRow["CHAN_NO"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["CHAN_NO"]; } else { dRow["CHAN_NO"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("STORE") == true) { dRow["STORE"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["STORE"]; } else { dRow["STORE"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("CRM_DATE") == true) { dRow["CRM_DATE"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["CRM_DATE"]; } else { dRow["CRM_DATE"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("CRM_NO") == true) { dRow["CRM_NO"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["CRM_NO"]; } else { dRow["CRM_NO"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("GRADE") == true) { dRow["GRADE"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["GRADE"]; } else { dRow["GRADE"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("CLOSE_TIME") == true) { dRow["CLOSE_TIME"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["CLOSE_TIME"]; } else { dRow["CLOSE_TIME"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("REQUEST_SCRIPT") == true) { dRow["REQUEST_SCRIPT"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["REQUEST_SCRIPT"]; } else { dRow["REQUEST_SCRIPT"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("PROC_FLAG") == true) { dRow["PROC_FLAG"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["PROC_FLAG"]; } else { dRow["PROC_FLAG"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("PROC_UNIT") == true) { dRow["PROC_UNIT"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["PROC_UNIT"]; } else { dRow["PROC_UNIT"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("PROC_MAN") == true) { dRow["PROC_MAN"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["PROC_MAN"]; } else { dRow["PROC_MAN"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("CLOSE_DATE") == true) { dRow["CLOSE_DATE"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["CLOSE_DATE"]; } else { dRow["CLOSE_DATE"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("REQUEST_STATEMENT") == true) { dRow["REQUEST_STATEMENT"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["REQUEST_STATEMENT"]; } else { dRow["REQUEST_STATEMENT"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("PROC_STATEMENT") == true) { dRow["PROC_STATEMENT"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["PROC_STATEMENT"]; } else { dRow["PROC_STATEMENT"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("REQUEST_NO") == true) { dRow["REQUEST_NO"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["REQUEST_NO"]; } else { dRow["REQUEST_NO"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("ANSWER_USER") == true) { dRow["ANSWER_USER"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["ANSWER_USER"]; } else { dRow["ANSWER_USER"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("CRM_CONFIRM_DATE") == true) { dRow["CRM_CONFIRM_DATE"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["CRM_CONFIRM_DATE"]; } else { dRow["CRM_CONFIRM_DATE"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("UNIT_CONFIRM_DATE") == true) { dRow["UNIT_CONFIRM_DATE"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["UNIT_CONFIRM_DATE"]; } else { dRow["UNIT_CONFIRM_DATE"] = DBNull.Value; } dt_VDS_CRM_TICKET.Rows.Add(dRow); #endregion #region 新資料 ParameterList.Clear(); ParameterList.Add(this.slp_down_PROC_UNIT.Text.Trim());//負責單位 if (this.slp_down_PROC_MAN.SelectedValue == "") { ParameterList.Add(DBNull.Value); }//負責人 else { ParameterList.Add(this.slp_down_PROC_MAN.SelectedValue); } //ParameterList.Add(this.txt_down_REQUEST_NO.Text.Trim());//原因代號 ParameterList.Add(this.slp_down_REQUEST_NO.Text.Trim());//原因代號 ParameterList.Add(this.slp_down_GRADE.Text.Trim());//等級 ParameterList.Add(this.txt_down_REQUEST_STATEMENT.Text.Trim());//問題陳述 if (this.slp_down_CLOSE_DATE.Text.Trim() == string.Empty) { ParameterList.Add(DBNull.Value); } else { ParameterList.Add(this.slp_down_CLOSE_DATE.Text.Trim()); }//處理日期 if (this.txt_down_CLOSE_TIME.Text.Trim() == string.Empty) { ParameterList.Add(DBNull.Value); } else //{ ParameterList.Add(this.txt_down_CLOSE_TIME.Text.Trim()); }//處理時間 { ParameterList.Add(DateTime.ParseExact(slp_down_CLOSE_DATE.Text + " " + txt_down_CLOSE_TIME.Text.Trim() + "00", "yyyy/MM/dd HHmmss", null)); }//處理時間 if (this.slp_down_ANSWER_USER.Text.Trim() == string.Empty) { ParameterList.Add(DBNull.Value); } else { ParameterList.Add(this.slp_down_ANSWER_USER.Text.Trim()); }//處理人員 if (this.slp_down_PROC_FLAG.Text.Trim() == string.Empty) { ParameterList.Add(DBNull.Value); } else { ParameterList.Add(this.slp_down_PROC_FLAG.Text.Trim()); }//處理狀態 if (this.txt_down_PROC_STATEMENT.Text.Trim() == string.Empty) { ParameterList.Add(DBNull.Value); } else { ParameterList.Add(this.txt_down_PROC_STATEMENT.Text.Trim()); }//處理敘述 if (this.slp_down_CRM_CONFIRM_DATE.Text.Trim() == string.Empty) { ParameterList.Add(DBNull.Value); } else { ParameterList.Add(this.slp_down_CRM_CONFIRM_DATE.Text.Trim()); }//主管簽核日 if (this.slp_down_UNIT_CONFIRM_DATE.Text.Trim() == string.Empty) { ParameterList.Add(DBNull.Value); } else { ParameterList.Add(this.slp_down_UNIT_CONFIRM_DATE.Text.Trim()); }//客服單位簽核日 ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(DateTime.Now); #endregion i_Return_Id = bco.UpdateCRMRecord(ParameterList, null, dt_VDS_CRM_TICKET); this.hid_Page_Status.Value = "VIEW"; System.Web.UI.ScriptManager.RegisterStartupScript(this.but_Save, this.GetType(), "CRM032", "alert('更新成功');location.replace('CRM032.aspx?Code=CRM03&ID=" + i_Return_Id.ToString() + "&mode=VIEW');", true); } } catch (Exception ex) { WaringLogProcess(ex.Message); this.ErrorMsgLabel.Text = ex.Message; } finally { } }
/// <summary> /// BUTTON 刪除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void but_Delete_Click(object sender, EventArgs e) { System.Threading.Thread.Sleep(2000); try { if (this.hid_Page_Status.Value == "VIEW") { #region 使用XML轉回DataSet DataSet ds_OldData = new DataSet(); System.IO.StringReader sr_OldData = new System.IO.StringReader(xml_OLDData.InnerHtml); ds_OldData.ReadXml(sr_OldData); #endregion #region 將刪除資料寫入 TEMP TABLE ArrayList ParameterList = new ArrayList();//20091117 ParameterList.Clear(); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(DateTime.Now); DataTable dt_VDS_CRM_TICKET = new DataTable(); BCO.RecordCRMTicket bco = new BCO.RecordCRMTicket(ConntionDB); dt_VDS_CRM_TICKET = bco.GET_VDS_CRM_TICKET_SCHEMA(ParameterList); DataRow dRow = dt_VDS_CRM_TICKET.NewRow(); if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("ID") == true) { dRow["ID"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["ID"]; } else { dRow["ID"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("CODE") == true) { dRow["CODE"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["CODE"]; } else { dRow["CODE"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("NAME") == true) { dRow["NAME"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["NAME"]; } else { dRow["NAME"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("BUSDATE") == true) { dRow["BUSDATE"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["BUSDATE"]; } else { dRow["BUSDATE"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("BUSUID") == true) { dRow["BUSUID"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["BUSUID"]; } else { dRow["BUSUID"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("CREATEDATE") == true) { dRow["CREATEDATE"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["CREATEDATE"]; } else { dRow["CREATEDATE"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("CREATEUID") == true) { dRow["CREATEUID"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["CREATEUID"]; } else { dRow["CREATEUID"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("UPDATEDATE") == true) { dRow["UPDATEDATE"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["UPDATEDATE"]; } else { dRow["UPDATEDATE"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("UPDATEUID") == true) { dRow["UPDATEUID"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["UPDATEUID"]; } else { dRow["UPDATEUID"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("ENABLE") == true) { dRow["ENABLE"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["ENABLE"]; } else { dRow["ENABLE"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("STATUS") == true) { dRow["STATUS"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["STATUS"]; } else { dRow["STATUS"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("CHAN_NO") == true) { dRow["CHAN_NO"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["CHAN_NO"]; } else { dRow["CHAN_NO"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("STORE") == true) { dRow["STORE"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["STORE"]; } else { dRow["STORE"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("CRM_DATE") == true) { dRow["CRM_DATE"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["CRM_DATE"]; } else { dRow["CRM_DATE"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("CRM_NO") == true) { dRow["CRM_NO"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["CRM_NO"]; } else { dRow["CRM_NO"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("GRADE") == true) { dRow["GRADE"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["GRADE"]; } else { dRow["GRADE"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("CLOSE_TIME") == true) { dRow["CLOSE_TIME"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["CLOSE_TIME"]; } else { dRow["CLOSE_TIME"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("REQUEST_SCRIPT") == true) { dRow["REQUEST_SCRIPT"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["REQUEST_SCRIPT"]; } else { dRow["REQUEST_SCRIPT"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("PROC_FLAG") == true) { dRow["PROC_FLAG"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["PROC_FLAG"]; } else { dRow["PROC_FLAG"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("PROC_UNIT") == true) { dRow["PROC_UNIT"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["PROC_UNIT"]; } else { dRow["PROC_UNIT"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("PROC_MAN") == true) { dRow["PROC_MAN"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["PROC_MAN"]; } else { dRow["PROC_MAN"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("CLOSE_DATE") == true) { dRow["CLOSE_DATE"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["CLOSE_DATE"]; } else { dRow["CLOSE_DATE"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("REQUEST_STATEMENT") == true) { dRow["REQUEST_STATEMENT"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["REQUEST_STATEMENT"]; } else { dRow["REQUEST_STATEMENT"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("PROC_STATEMENT") == true) { dRow["PROC_STATEMENT"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["PROC_STATEMENT"]; } else { dRow["PROC_STATEMENT"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("REQUEST_NO") == true) { dRow["REQUEST_NO"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["REQUEST_NO"]; } else { dRow["REQUEST_NO"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("ANSWER_USER") == true) { dRow["ANSWER_USER"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["ANSWER_USER"]; } else { dRow["ANSWER_USER"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("CRM_CONFIRM_DATE") == true) { dRow["CRM_CONFIRM_DATE"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["CRM_CONFIRM_DATE"]; } else { dRow["CRM_CONFIRM_DATE"] = DBNull.Value; } if (ds_OldData.Tables["VDS_CRM_TICKET"].Columns.Contains("UNIT_CONFIRM_DATE") == true) { dRow["UNIT_CONFIRM_DATE"] = ds_OldData.Tables["VDS_CRM_TICKET"].Rows[0]["UNIT_CONFIRM_DATE"]; } else { dRow["UNIT_CONFIRM_DATE"] = DBNull.Value; } dt_VDS_CRM_TICKET.Rows.Add(dRow); #endregion #region 刪除資料 ParameterList.Clear(); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(DateTime.Now); bco.DeletCRMRecord(ParameterList, null, dt_VDS_CRM_TICKET); System.Web.UI.ScriptManager.RegisterStartupScript(this.but_Delete, this.GetType(), "CRM032", "alert('刪除完成');location.replace('CRM031.aspx?Code=CRM03');", true); #endregion } } catch (Exception ex) { WaringLogProcess(ex.Message); this.ErrorMsgLabel.Text = ex.Message; } finally { } }
private DataTable databind() { #region 傳入參數 string s_slp_GRADE_String = string.Empty; string s_slp_PROC_FLAG_String = string.Empty; BCO.CRMCommon CRMComm = new BCO.CRMCommon(); ArrayList ParameterList = new ArrayList();//20091117 ParameterList.Clear(); ParameterList.Add(CRMComm.GetValueSetParameter(this.slp_CHAN_NO.Text, "string", this.chb_Like_Search.Checked)); ParameterList.Add(CRMComm.GetValueSetParameter(this.slp_STORE.Text, "string", this.chb_Like_Search.Checked)); ParameterList.Add(CRMComm.GetValueSetParameter(this.slp_CRM_DATE.Text, "date", false)); ParameterList.Add(CRMComm.GetValueSetParameter(this.txt_CRM_NO.Text, "string", this.chb_Like_Search.Checked)); ParameterList.Add(CRMComm.GetValueSetParameter(this.txt_CODE.Text, "string", this.chb_Like_Search.Checked)); //客服單號 //ParameterList.Add(CRMComm.GetValueSetParameter(this.txt_REQUEST_NO.Text, "string", this.chb_Like_Search.Checked)); ParameterList.Add(CRMComm.GetValueSetParameter(this.slp_REQUEST_NO.Text, "string", this.chb_Like_Search.Checked)); ParameterList.Add(CRMComm.GetValueSetParameter(this.slp_GRADE.Text, "int", false)); ParameterList.Add(CRMComm.GetValueSetParameter(this.slp_PROC_FLAG.Text, "int", false)); //ParameterList.Add(CRMComm.GetValueSetParameter(this.txt_PROC_UNIT.Text, "string", this.chb_Like_Search.Checked)); ParameterList.Add(CRMComm.GetValueSetParameter(this.slp_PROC_UNIT.Text, "string", this.chb_Like_Search.Checked)); ParameterList.Add(CRMComm.GetValueSetParameter(this.slp_PROC_MAN.Text, "string", this.chb_Like_Search.Checked)); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(DateTime.Now); ParameterList.Add(TextBoxRowCountLimit.Text.Trim().Length == 0 ? "10" : TextBoxRowCountLimit.Text); #endregion #region 讀取資料 DataTable dt_Ticket = new DataTable(); BCO.RecordCRMTicket bco = new BCO.RecordCRMTicket(ConntionDB); dt_Ticket = bco.QueryByFind(ParameterList); #endregion #region 資料與GridView繫結 //抓取本頁初次登記的時間 string SessionIDName = "CRM031_" + PageTimeStamp.Value; Session["SessionID"] = SessionIDName; Session[SessionIDName] = dt_Ticket; this.gv_Ticket.DataSource = dt_Ticket.DefaultView; this.gv_Ticket.PageSize = (this.TextBoxPagesize.Text == string.Empty) ? 10 : (int.Parse(this.TextBoxPagesize.Text) < 0) ? 10 : int.Parse(this.TextBoxPagesize.Text); this.gv_Ticket.PageIndex = 0; this.gv_Ticket.DataBind(); #endregion return dt_Ticket; }