/// <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 { } }
/// <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 { } }