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