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