/// <summary> /// 將變更後的內部變量this.CallBackValue返回給前台JavaScript方法ReceiveServerData(string Value)。 /// </summary> /// <returns></returns> string ICallbackEventHandler.GetCallbackResult() { if (CallBackValue != string.Empty) { try { #region 取得頁面元件 TextBox txt_up_CHAN_NO = (TextBox)((ASP.stm_slp_slp_storechain_ascx)slp_up_CHAN_NO).FindControl("TextBoxCode");//通路 TextBox txt_up_CHAN_NAME = (TextBox)((ASP.stm_slp_slp_storechain_ascx)slp_up_CHAN_NO).FindControl("TextBoxName");//通路名稱 TextBox txt_up_STORE = (TextBox)((ASP.stm_slp_slp_store_ascx)slp_up_STORE).FindControl("TextBoxCode");//門市 TextBox txt_up_Z_O = (TextBox)((ASP.sys_slp_slp_codefile_ascx)slp_up_Z_O).FindControl("TextBoxCode");//營業所 TextBox txt_up_Z_O_NAME = (TextBox)((ASP.sys_slp_slp_codefile_ascx)slp_up_Z_O).FindControl("TextBoxName");//營業所名稱 TextBox txt_up_BUSDATE = (TextBox)((ASP.wui_slp_slp_slpdate_ascx)slp_up_BUSDATE).FindControl("TextBoxCode");//訂單日期 TextBox txt_up_SALE_ID = (TextBox)((ASP.sys_slp_slp_user_ascx)slp_up_SALE_ID).FindControl("TextBoxCode");//營業人員 TextBox txt_up_SALE_NAME = (TextBox)((ASP.sys_slp_slp_user_ascx)slp_up_SALE_ID).FindControl("TextBoxName");//營業人員名稱 TextBox txt_up_BUSUID = (TextBox)((ASP.sys_slp_slp_user_ascx)slp_up_BUSUID).FindControl("TextBoxCode");//訂單維護者 Image img_up_CHAN_NO = (Image)((ASP.stm_slp_slp_storechain_ascx)slp_up_CHAN_NO).FindControl("Image1");//通路img Image img_up_STORE = (Image)((ASP.stm_slp_slp_store_ascx)slp_up_STORE).FindControl("Image1");//門市img Image img_up_BUSDATE = (Image)((ASP.wui_slp_slp_slpdate_ascx)slp_up_BUSDATE).FindControl("Image1");//訂單日期img Image img_up_SALE_ID = (Image)((ASP.sys_slp_slp_user_ascx)slp_up_SALE_ID).FindControl("Image1");//營業人員img Image img_up_BUSUID = (Image)((ASP.sys_slp_slp_user_ascx)slp_up_BUSUID).FindControl("Image1");//訂單維護者img Image img_down_ITEM = (Image)((ASP.itm_slp_slp_sku_ascx)slp_down_ITEM).FindControl("Image1");//品號img Image img_down_REQUEST_QTY = (Image)((ASP.wui_slp_slp_slpquantity_ascx)slp_down_REQUEST_QTY).FindControl("Image1");//訂貨量img Image img_down_RTN_DDL = (Image)((ASP.wui_slp_slp_slpdate_ascx)slp_down_RTN_DDL).FindControl("Image1");//退書截止日img TextBox txt_down_ITEM = (TextBox)((ASP.itm_slp_slp_sku_ascx)slp_down_ITEM).FindControl("TextBoxCode");//品號 TextBox txt_down_ITEM_NAME = (TextBox)((ASP.itm_slp_slp_sku_ascx)slp_down_ITEM).FindControl("TextBoxName");//品名 TextBox txt_down_REQUEST_QTY = (TextBox)((ASP.wui_slp_slp_slpquantity_ascx)slp_down_REQUEST_QTY).FindControl("TextBoxCode");//訂貨量 TextBox txt_down_REQUEST_QTY_NAME = (TextBox)((ASP.wui_slp_slp_slpquantity_ascx)slp_down_REQUEST_QTY).FindControl("TextBoxName");//訂貨量名稱 TextBox txt_down_RTN_DDL = (TextBox)((ASP.wui_slp_slp_slpdate_ascx)slp_down_RTN_DDL).FindControl("TextBoxCode");//退書截止日 CheckBox chk_down_IS_OVERDUE = (CheckBox)((ASP.wui_slp_slp_boolean_ascx)slp_down_IS_OVERDUE).FindControl("C1");//逾期客訂 #endregion System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Remove(0, sb.Length); CallBackValue = CallBackValue.Trim(); string[] s_Client_String = System.Text.RegularExpressions.Regex.Split(CallBackValue, "<partition>", System.Text.RegularExpressions.RegexOptions.IgnoreCase); ArrayList ParameterList = new ArrayList();//20091117 #region 新增模式下異動欄位[門市] if (s_Client_String[0] == "新增模式下異動欄位[門市]") { if (dtChainPOSetting != null) { dtChainPOSetting = null; } s_STORE = s_Client_String[1].ToString().Trim();//門市 s_CHAN_NO = s_Client_String[2].ToString().Trim();//通路 #region 從資料庫查詢資料 ParameterList.Clear(); ParameterList.Add(s_Client_String[1]);//門市 ParameterList.Add(s_Client_String[2]);//通路 ParameterList.Add(Session["UID"].ToString()); DataTable dt_Return = new DataTable(); BCO.MaintainStore bco = new BCO.MaintainStore(ConntionDB); dt_Return = bco.QUERY_STORE_BY_STOREANDCHAN(ParameterList); #endregion #region 設定回傳Client端資訊 if (dt_Return.Rows.Count == 0) { sb.Append("新增模式下異動欄位[門市]<partition>"); sb.Append("FALSE<partition>"); sb.Append("查無門市資料<partition>"); sb.Append(txt_up_STORE.ClientID + "<partition>");//設定焦點的欄位 sb.Append(txt_up_CHAN_NO.ClientID + "<partition>"); sb.Append(txt_up_Z_O.ClientID + "<partition>"); sb.Append(txt_up_SALE_ID.ClientID); } else { sb.Append("新增模式下異動欄位[門市]<partition>"); sb.Append("TRUE<partition>"); sb.Append(dt_Return.Rows[0]["CHAN_NO"].ToString() + "<partition_Detail>" + txt_up_CHAN_NO.ClientID + "<partition>"); sb.Append(dt_Return.Rows[0]["Z_O"].ToString() + "<partition_Detail>" + txt_up_Z_O.ClientID + "<partition>"); //sb.Append(dt_Return.Rows[0]["SAL_ID"].ToString() + "<partition_Detail>" + txt_up_SALE_ID.ClientID); sb.Append(dt_Return.Rows[0]["SAL_ID"].ToString() + "<partition_Detail>" + txt_up_SALE_ID.ClientID + "<partition>"); sb.Append("<partition_Detail>" + txt_up_CHAN_NAME.ClientID + "<partition>"); sb.Append("<partition_Detail>" + txt_up_Z_O_NAME.ClientID + "<partition>"); sb.Append("<partition_Detail>" + txt_up_SALE_NAME.ClientID); #region 取得通路PO控制設定 GetChainPOSetting(dt_Return.Rows[0]["CHAN_NO"].ToString(), dt_Return.Rows[0]["STORE"].ToString()); #endregion } #endregion } #endregion #region 新增或編輯模式下異動欄位[二段碼] else if (s_Client_String[0] == "新增或編輯模式下異動欄位[二段碼]") { #region 從資料庫查詢資料:群分類、品號、期別 ParameterList.Clear(); ParameterList.Add(s_Client_String[1]);//通路 ParameterList.Add(s_Client_String[2]);//一段碼 ParameterList.Add(s_Client_String[3]);//二段碼 ParameterList.Add(Session["UID"].ToString()); DataTable dt_Return = new DataTable(); BCO.QueryCRMCommon bco = new BCO.QueryCRMCommon(ConntionDB); dt_Return = bco.QueryItemPeriodInfoByBarcode(ParameterList); #endregion if (dt_Return.Rows.Count == 0) { sb.Append("新增或編輯模式下異動欄位[二段碼]<partition>"); sb.Append("FALSE<partition>"); sb.Append("此一段碼/二段碼不存在對應商品期別資訊,請重新輸入<partition>"); sb.Append(this.txt_down_BARCODE.ClientID + "<partition>");//設定焦點的欄位 sb.Append(this.txt_down_PERIOD_BARCODE.ClientID + "<partition>"); sb.Append(txt_down_ITEM.ClientID + "<partition>"); sb.Append(this.txt_down_PERIOD.ClientID + "<partition>"); sb.Append(txt_down_RTN_DDL.ClientID); } else { sb.Append("新增或編輯模式下異動欄位[二段碼]<partition>"); sb.Append("TRUE<partition>"); sb.Append(dt_Return.Rows[0]["ITEM"].ToString() + "<partition_Detail>" + txt_down_ITEM.ClientID + "<partition>"); sb.Append(dt_Return.Rows[0]["PERIOD"].ToString() + "<partition_Detail>" + this.txt_down_PERIOD.ClientID + "<partition>"); sb.Append(DateTime.Parse(dt_Return.Rows[0]["RTN_DDL"].ToString()).ToString("yyyy/MM/dd") + "<partition_Detail>" + txt_down_RTN_DDL.ClientID); //期別或品號有異動時,重取庫存 if (s_ITEM != dt_Return.Rows[0]["ITEM"].ToString() || s_PERIOD != dt_Return.Rows[0]["PERIOD"].ToString() ) { dtStock = null; } s_ROOT_NO = dt_Return.Rows[0]["ROOT_NO"].ToString(); s_ITEM = dt_Return.Rows[0]["ITEM"].ToString(); s_PERIOD = dt_Return.Rows[0]["PERIOD"].ToString(); GetStock(s_ROOT_NO, s_ITEM, s_PERIOD); } } #endregion #region 新增或編輯模式下異動欄位[一段碼]onchange else if (s_Client_String[0] == "新增或編輯模式下異動欄位[一段碼]onchange") { #region 根據一段碼帶出品號,最大發行期別,二段碼 ParameterList.Clear(); ParameterList.Add(s_Client_String[1]);//通路 ParameterList.Add(s_STORE);//通路 ParameterList.Add(s_Client_String[3]);//一段碼 ParameterList.Add(string.Empty);//二段碼 ParameterList.Add(Session["UID"].ToString()); DataTable dt_Return = new DataTable(); BCO.QueryCRMCommon bco = new BCO.QueryCRMCommon(ConntionDB); dt_Return = bco.QueryItemPeriodInfoByBarcode2(ParameterList); #endregion if (dt_Return.Rows.Count == 0) { sb.Append("新增或編輯模式下異動欄位[一段碼]onchange<partition>"); sb.Append("FALSE<partition>"); sb.Append("此一段碼不存在已發行對應商品期別資訊,請重新輸入<partition>"); sb.Append(this.txt_down_PERIOD_BARCODE.ClientID + "<partition>"); sb.Append(txt_down_ITEM.ClientID + "<partition>"); sb.Append(this.txt_down_PERIOD.ClientID + "<partition>"); sb.Append(txt_down_RTN_DDL.ClientID + "<partition>"); sb.Append(this.txt_down_RECOMMAND_LOCATION.ClientID + "<partition>");//建議儲區 sb.Append(this.txt_down_BARCODE.ClientID);//設定焦點的欄位 } else { if (dt_Return.Rows[0]["CAN_DELIVER"].ToString() == "1") { //期別或品號有異動時,重取庫存 dtStock = null; s_ROOT_NO = dt_Return.Rows[0]["ROOT_NO"].ToString(); s_ITEM = dt_Return.Rows[0]["ITEM"].ToString(); s_PERIOD = dt_Return.Rows[0]["PERIOD"].ToString(); GetStock(s_ROOT_NO, s_ITEM, s_PERIOD); sb.Append("新增或編輯模式下異動欄位[一段碼]onchange<partition>");//找到對應商品期別資訊,設定商品期別 sb.Append("TRUE<partition>"); sb.Append(s_ITEM + "<partition_Detail>" + txt_down_ITEM.ClientID + "<partition>"); sb.Append(dt_Return.Rows[0]["PERIOD_BARCODE"].ToString() + "<partition_Detail>" + this.txt_down_PERIOD_BARCODE.ClientID + "<partition>"); sb.Append(DateTime.Parse(dt_Return.Rows[0]["RTN_DDL"].ToString()).ToString("yyyy/MM/dd") + "<partition_Detail>" + txt_down_RTN_DDL.ClientID + "<partition>"); sb.Append(s_PERIOD + "<partition_Detail>" + this.txt_down_PERIOD.ClientID); } else { sb.Append("新增或編輯模式下異動欄位[一段碼]onchange<partition>"); sb.Append("FALSE<partition>"); sb.Append("此一段碼對應品號" + s_ITEM + "客服區域限制不可出貨,請重新輸入<partition>"); sb.Append(this.txt_down_PERIOD_BARCODE.ClientID + "<partition>"); sb.Append(txt_down_ITEM.ClientID + "<partition>"); sb.Append(this.txt_down_PERIOD.ClientID + "<partition>"); sb.Append(txt_down_RTN_DDL.ClientID + "<partition>"); sb.Append(this.txt_down_RECOMMAND_LOCATION.ClientID + "<partition>");//建議儲區 sb.Append(this.txt_down_BARCODE.ClientID);//設定焦點的欄位 } } //sb.Append("新增或編輯模式下異動欄位[一段碼]onchange<partition>"); //sb.Append("TRUE<partition>"); //sb.Append(txt_down_ITEM.ClientID + "<partition>"); //異動一段碼時,清空 Item、 Period 、退貨日、儲區、逾期客訂,設定焦點到ITEM //sb.Append(this.txt_down_PERIOD.ClientID + "<partition>"); //期別 //sb.Append(this.txt_down_PERIOD_BARCODE.ClientID + "<partition>"); //二段碼 //sb.Append(txt_down_RTN_DDL.ClientID + "<partition>"); //預定退貨日 //sb.Append(this.txt_down_RECOMMAND_LOCATION);//建議儲區 } #endregion #region 新增或編輯模式下異動欄位[品號/品名] else if (s_Client_String[0] == "新增或編輯模式下異動欄位[品號/品名]") { //s_PMA = string.Empty;//大分類 //s_ROOT_NO = string.Empty;//群分類 s_ITEM = s_Client_String[1].ToString().Trim();//品號 #region 從資料庫查詢資料 ParameterList.Clear(); ParameterList.Add(s_Client_String[1]);//品號 ParameterList.Add(s_CHAN_NO);//通路 ParameterList.Add(s_STORE);//門市 ParameterList.Add(Session["UID"].ToString()); DataTable dt_Return_1 = new DataTable(); BCO.QueryCRMCommon bco = new BCO.QueryCRMCommon(ConntionDB); dt_Return_1 = bco.GetMaxDeiveryPeriod2(ParameterList); #endregion if (dt_Return_1 == null || dt_Return_1.Rows.Count == 0 || dt_Return_1.Rows[0]["PERIOD"].ToString() == string.Empty) { sb.Length = 0; sb.Append("新增或編輯模式下異動欄位[品號/品名]<partition>"); sb.Append("FALSE<partition>"); sb.Append("查無資料<partition>"); sb.Append(txt_down_ITEM.ClientID);//設定焦點的欄位 } else { //設定品號、期別 s_ITEM = s_Client_String[1]; s_PERIOD = dt_Return_1.Rows[0]["PERIOD"].ToString(); //設定群分類、大分類 s_PMA = dt_Return_1.Rows[0]["PMA"].ToString();//大分類 s_ROOT_NO = dt_Return_1.Rows[0]["ROOT_NO"].ToString();//群分類 if (dt_Return_1.Rows[0]["CAN_DELIVER"].ToString() == "1") { sb.Length = 0; sb.Append("新增或編輯模式下異動欄位[品號/品名]<partition>"); sb.Append("TRUE<partition>"); sb.Append(dt_Return_1.Rows[0]["PERIOD"].ToString() + "<partition_Detail>" + this.txt_down_PERIOD.ClientID); } else { sb.Length = 0; sb.Append("新增或編輯模式下異動欄位[品號/品名]<partition>"); sb.Append("FALSE<partition>"); sb.Append("客服區域限制不可出貨<partition>"); sb.Append(txt_down_ITEM.ClientID);//設定焦點的欄位 } #region OLD 取得商品主檔資訊 //DataTable dt_Return_2 = new DataTable(); //ParameterList.Clear(); //BCO_ITM.SQLHelper.SQLWhere(ref ParameterList, DbType.String, "MA.ITEM", s_Client_String[1], "=", "and"); //BCO_ITM.MaintainSKU bco_itm = new BCO_ITM.MaintainSKU(ConntionDB); //dt_Return_2 = bco_itm.QuerySKUByFind_1(ParameterList); //if (dt_Return_2 != null && dt_Return_2.Rows.Count != 0) //{ // s_PMA = dt_Return_2.Rows[0]["PMA"].ToString();//大分類 // s_ROOT_NO = dt_Return_2.Rows[0]["ROOT_NO"].ToString();//群分類 //} //else //{ // sb = sb.Remove(0, sb.Length); // sb.Append("新增或編輯模式下異動欄位[品號/品名]<partition>"); // sb.Append("FALSE<partition>"); // sb.Append("商品主檔中無對應品號<partition>"); // sb.Append(txt_down_ITEM.ClientID);//設定焦點的欄位 //} #endregion } } #endregion #region 新增或編輯模式下異動欄位[期別] else if (s_Client_String[0] == "新增或編輯模式下異動欄位[期別]") { //期別或品號有異動時,重取庫存 if (s_ITEM != s_Client_String[3].ToString().Trim() || s_PERIOD != s_Client_String[4].ToString().Trim() ) { dtStock = null; } s_CHAN_NO = s_Client_String[1].ToString().Trim();//通路 s_STORE = s_Client_String[2].ToString().Trim();//門市 if (s_ITEM != s_Client_String[3].ToString().Trim()) { } s_ITEM = s_Client_String[3].ToString().Trim();//品號 s_PERIOD = s_Client_String[4].ToString().Trim();//期別 #region 檢查書店是否有未結案同品項訂單 if (s_Client_String[8] == string.Empty) { #region 從資料庫查詢資料 ParameterList.Clear(); ParameterList.Add(s_Client_String[1]);//通路 ParameterList.Add(s_Client_String[2]);//門市 ParameterList.Add(s_Client_String[3]);//品號 ParameterList.Add(s_Client_String[4]);//期別 ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(this.txt_up_CODE.Text);//訂單單號 DataTable dt_Return_1 = new DataTable(); BCO.RecordCRMOrder bco_Record = new BCO.RecordCRMOrder(ConntionDB); dt_Return_1 = bco_Record.CheckOrderItemExist(ParameterList); #endregion if (dt_Return_1.Rows.Count > 0) { sb.Append("新增或編輯模式下異動欄位[期別]<partition>"); sb.Append("檢查書店是否有未結案同品項訂單<partition>"); sb.Append("該門市已存在未結案之同品項訂單於訂單標號:[" + dt_Return_1.Rows[0]["CRM_REQUEST_NO"].ToString() + "],不可新增<partition>"); sb.Append(this.txt_down_PO_SOURCE_NO.ClientID + "<partition>");//設定焦點的欄位 sb.Append(chk_down_IS_OVERDUE.ClientID + "<partition>");//逾期客訂 sb.Append(this.txt_down_PO_SOURCE_NO.ClientID + "<partition>");//PO單號 sb.Append(this.txt_down_BARCODE.ClientID + "<partition>");//一段碼 sb.Append(this.txt_down_PERIOD_BARCODE.ClientID + "<partition>");//二段碼 sb.Append(txt_down_ITEM.ClientID + "<partition>");//品號 sb.Append(txt_down_ITEM_NAME.ClientID + "<partition>");//品名 sb.Append(this.txt_down_PERIOD.ClientID + "<partition>");//期別 sb.Append(txt_down_REQUEST_QTY.ClientID + "<partition>");//訂貨量 sb.Append(txt_down_REQUEST_QTY_NAME.ClientID + "<partition>");//訂貨量名稱 sb.Append(txt_down_RTN_DDL.ClientID + "<partition>");//退書截止日 sb.Append(this.txt_down_RECOMMAND_LOCATION.ClientID);//建議儲區 return sb.ToString(); } } #endregion #region 檢查牌價是否已經正確建立 ParameterList.Clear(); ParameterList.Add(s_Client_String[2]);//門市 ParameterList.Add(s_Client_String[3]);//品號 ParameterList.Add(s_Client_String[4]);//期別 ParameterList.Add(DateTime.Today.ToString("yyyy/MM/dd")); // 系統日 ParameterList.Add(Session["UID"].ToString()); PIC.VDS2G.BSM.ALO.ProcessALOCommon co_process = new PIC.VDS2G.BSM.ALO.ProcessALOCommon(ConntionDB); string sRes = co_process.CheckStAcceptDisPrice(ParameterList); //bool bRes = co_process.CheckStAcceptDisPrice(ParameterList, null); if (sRes != string.Empty) { sb.Append("新增或編輯模式下異動欄位[期別]<partition>"); sb.Append("檢查牌價是否已經正確建立<partition>"); sb.Append("期別" + s_PERIOD + "牌價未生效[" + sRes + "],不可新增<partition>"); sb.Append(this.txt_down_PERIOD.ClientID + "<partition>");//設定焦點的欄位 sb.Append(chk_down_IS_OVERDUE.ClientID + "<partition>");//逾期客訂 sb.Append(this.txt_down_PO_SOURCE_NO.ClientID + "<partition>");//PO單號 sb.Append(this.txt_down_BARCODE.ClientID + "<partition>");//一段碼 sb.Append(this.txt_down_PERIOD_BARCODE.ClientID + "<partition>");//二段碼 sb.Append(txt_down_ITEM.ClientID + "<partition>");//品號 sb.Append(txt_down_ITEM_NAME.ClientID + "<partition>");//品名 sb.Append(this.txt_down_PERIOD.ClientID + "<partition>");//期別 sb.Append(txt_down_REQUEST_QTY.ClientID + "<partition>");//訂貨量 sb.Append(txt_down_REQUEST_QTY_NAME.ClientID + "<partition>");//訂貨量名稱 sb.Append(txt_down_RTN_DDL.ClientID + "<partition>");//退書截止日 sb.Append(this.txt_down_RECOMMAND_LOCATION.ClientID);//建議儲區 return sb.ToString(); } #endregion #region 設定二段碼、退書截止日與逾期客訂 string s_down_BARCODE = string.Empty;//一段碼 string s_down_PERIOD_BARCODE = string.Empty;//二段碼 string s_down_RTN_DDL = string.Empty;//退書截止日 s_down_BARCODE = s_Client_String[5]; s_down_PERIOD_BARCODE = s_Client_String[6]; s_down_RTN_DDL = s_Client_String[7]; BCO.QueryCRMCommon bco_Common = new BCO.QueryCRMCommon(ConntionDB); // 不管原來有沒有值,只要品號改變,都重新查詢 //if (s_Client_String[5] == string.Empty ||//一段碼 // s_Client_String[6] == string.Empty ||//二段碼 // s_Client_String[7] == string.Empty)//退書截止日 //{ ParameterList.Clear(); ParameterList.Add(s_Client_String[1]);//通路 ParameterList.Add(s_Client_String[3]);//品號 ParameterList.Add(s_Client_String[4]);//期別 ParameterList.Add(Session["UID"].ToString()); DataTable dt_Return_2 = new DataTable(); dt_Return_2 = bco_Common.QueryItemPeriodInfo(ParameterList); if (dt_Return_2.Rows.Count > 0)//有找到資料 { s_down_BARCODE = dt_Return_2.Rows[0]["BARCODE"].ToString(); s_down_PERIOD_BARCODE = dt_Return_2.Rows[0]["PERIOD_BARCODE"].ToString(); s_down_RTN_DDL = DateTime.Parse(dt_Return_2.Rows[0]["RTN_DDL"].ToString()).ToString("yyyy/MM/dd"); } else//查無資料 { sb.Append("新增或編輯模式下異動欄位[期別]<partition>"); sb.Append("設定二段碼、退書截止日與逾期客訂<partition>"); sb.Append("查無[一段碼][二段碼][退書截止日],無法新增<partition>"); sb.Append(this.txt_down_PO_SOURCE_NO.ClientID + "<partition>");//設定焦點的欄位 sb.Append(chk_down_IS_OVERDUE.ClientID + "<partition>");//逾期客訂 sb.Append(this.txt_down_PO_SOURCE_NO.ClientID + "<partition>");//PO單號 sb.Append(this.txt_down_BARCODE.ClientID + "<partition>");//一段碼 sb.Append(this.txt_down_PERIOD_BARCODE.ClientID + "<partition>");//二段碼 sb.Append(txt_down_ITEM.ClientID + "<partition>");//品號 sb.Append(txt_down_ITEM_NAME.ClientID + "<partition>");//品名 sb.Append(this.txt_down_PERIOD.ClientID + "<partition>");//期別 sb.Append(txt_down_REQUEST_QTY.ClientID + "<partition>");//訂貨量 sb.Append(txt_down_REQUEST_QTY_NAME.ClientID + "<partition>");//訂貨量名稱 sb.Append(txt_down_RTN_DDL.ClientID + "<partition>");//退書截止日 sb.Append(this.txt_down_RECOMMAND_LOCATION.ClientID);//建議儲區 return sb.ToString(); } //} #endregion #region 逾期客訂確認 TimeSpan time = new TimeSpan(11, 00, 00); bool b_down_IS_OVERDUE = false; DateTime d_Now; DateTime d_RTN_DDL; d_Now = DateTime.Now; d_RTN_DDL = DateTime.Parse(s_down_RTN_DDL); if (d_Now.DayOfWeek == DayOfWeek.Saturday || d_Now.DayOfWeek == DayOfWeek.Sunday || (d_Now.DayOfWeek == DayOfWeek.Friday && d_Now.TimeOfDay.CompareTo(time) >= 0)) { //if (d_RTN_DDL.AddDays(-5).ToShortDateString().CompareTo(d_Now.ToShortDateString()) <= 0) if (d_RTN_DDL.AddDays(-5).ToString("yyyy/MM/dd").CompareTo(d_Now.ToString("yyyy/MM/dd")) <= 0) { b_down_IS_OVERDUE = true; b_IS_OVERDUE = true; } } else { //if (d_RTN_DDL.AddDays(-2).ToShortDateString().CompareTo(d_Now.ToShortDateString()) <= 0) if (d_RTN_DDL.AddDays(-2).ToString("yyyy/MM/dd").CompareTo(d_Now.ToString("yyyy/MM/dd")) <= 0) { b_down_IS_OVERDUE = true; b_IS_OVERDUE = true; } } //[@逾期客訂].檢查結果為True時,顯示Confirm訊息『商品已逾期,不可退貨,確定要新增?』 //使用者確認要新增時,可繼續編輯。 //使用者選擇不新增時,取消本筆明細新增。 if (b_down_IS_OVERDUE == true) { sb.Append("新增或編輯模式下異動欄位[期別]<partition>"); sb.Append("[逾期客訂]檢查結果為TRUE<partition>"); sb.Append(chk_down_IS_OVERDUE.ClientID + "<partition>");//逾期客訂 sb.Append(s_ROOT_NO + "<partition>");//群分類 sb.Append(s_Client_String[3] + "<partition>");//品號 sb.Append(s_Client_String[4] + "<partition>");//期別 sb.Append(s_down_BARCODE + "<partition_Detail>" + this.txt_down_BARCODE.ClientID + "<partition>");//一段碼 sb.Append(s_down_PERIOD_BARCODE + "<partition_Detail>" + this.txt_down_PERIOD_BARCODE.ClientID + "<partition>");//二段碼 sb.Append(s_down_RTN_DDL + "<partition_Detail>" + txt_down_RTN_DDL.ClientID);//退書截止日 return sb.ToString(); } else { sb.Append("新增或編輯模式下異動欄位[期別]<partition>"); sb.Append("[逾期客訂]檢查結果為FALSE<partition>"); sb.Append(chk_down_IS_OVERDUE.ClientID + "<partition>");//逾期客訂 sb.Append(s_down_BARCODE + "<partition_Detail>" + this.txt_down_BARCODE.ClientID + "<partition>");//一段碼 sb.Append(s_down_PERIOD_BARCODE + "<partition_Detail>" + this.txt_down_PERIOD_BARCODE.ClientID + "<partition>");//二段碼 sb.Append(s_down_RTN_DDL + "<partition_Detail>" + txt_down_RTN_DDL.ClientID);//退書截止日 } #endregion #region 取得庫存資訊 GetStock(s_ROOT_NO, s_Client_String[3], s_Client_String[4]); #endregion } #endregion #region 新增或編輯模式下異動欄位[期別]Confirm後 else if (s_Client_String[0] == "新增或編輯模式下異動欄位[期別]Confirm後") { if (dtStock != null) { dtStock = null; } if (s_Client_String[1] == "TRUE")//繼續編輯。 { #region 取得商品主檔資訊 if (s_PMA == String.Empty || s_ROOT_NO == String.Empty) { DataTable dt_Return_2 = new DataTable(); ParameterList.Clear(); BCO_ITM.SQLHelper.SQLWhere(ref ParameterList, DbType.String, "MA.ITEM", slp_down_ITEM.Text, "=", "and"); BCO_ITM.MaintainSKU bco_itm = new BCO_ITM.MaintainSKU(ConntionDB); dt_Return_2 = bco_itm.QuerySKUByFind_1(ParameterList); if (dt_Return_2 != null && dt_Return_2.Rows.Count != 0) { s_PMA = dt_Return_2.Rows[0]["PMA"].ToString();//大分類 s_ROOT_NO = dt_Return_2.Rows[0]["ROOT_NO"].ToString();//群分類 } else { sb = sb.Remove(0, sb.Length); sb.Append("新增或編輯模式下異動欄位[期別]Confirm後<partition>"); sb.Append("FALSE<partition>"); sb.Append("商品主檔中無對應品號<partition>"); sb.Append(txt_down_ITEM.ClientID);//設定焦點的欄位 } } #endregion #region 取得庫存資訊 GetStock(s_ROOT_NO, s_Client_String[3], s_Client_String[4]); #endregion } else if (s_Client_String[1] == "FALSE")//取消本筆明細新增。 { #region 清空靜態變數 dtStock = null;//異動欄位[期別] s_PMA = string.Empty;//大分類(異動欄位[品號/品名]) s_ROOT_NO = string.Empty;//群分類(異動欄位[品號/品名]) s_SRC_LOCATE_TYPE = string.Empty;//建議儲區類別(異動欄位[訂貨量]) #endregion #region 計算 dt_Detail 的筆數 int i_dt_Detail_Count = 0; if (dt_Detail != null) { if (dt_Detail.GetChanges(DataRowState.Deleted) == null) { i_dt_Detail_Count = dt_Detail.Rows.Count; } else { i_dt_Detail_Count = dt_Detail.Rows.Count - dt_Detail.GetChanges(DataRowState.Deleted).Rows.Count; } } #endregion sb.Append("新增或編輯模式下異動欄位[期別]Confirm後<partition>"); sb.Append(i_dt_Detail_Count.ToString() + "<partition>");//dt_Detail的筆數 sb.Append(this.hid_PageStatus.ClientID + "<partition>");//hid_PageStatus sb.Append(this.panel_Down_AddDetail.ClientID + "<partition>");//panel_Down_AddDetail sb.Append(this.panel_Down_Button.ClientID + "<partition>");//panel_Down_Button sb.Append(chk_down_IS_OVERDUE.ClientID + "<partition>");//逾期客訂 sb.Append(this.txt_down_PO_SOURCE_NO.ClientID + "<partition>");//PO單號 sb.Append(this.txt_down_BARCODE.ClientID + "<partition>");//一段碼 sb.Append(this.txt_down_PERIOD_BARCODE.ClientID + "<partition>");//二段碼 sb.Append(txt_down_ITEM.ClientID + "<partition>");//品號 sb.Append(txt_down_ITEM_NAME.ClientID + "<partition>");//品名 sb.Append(this.txt_down_PERIOD.ClientID + "<partition>");//期別 sb.Append(txt_down_REQUEST_QTY.ClientID + "<partition>");//訂貨量 sb.Append(txt_down_REQUEST_QTY_NAME.ClientID + "<partition>");//訂貨量名稱 sb.Append(txt_down_RTN_DDL.ClientID + "<partition>");//退書截止日 sb.Append(this.txt_down_RECOMMAND_LOCATION.ClientID + "<partition>");//建議儲區 sb.Append(txt_up_CHAN_NO.ClientID + "<partition>");//通路 sb.Append(txt_up_STORE.ClientID + "<partition>");//門市 sb.Append(txt_up_Z_O.ClientID + "<partition>");//營業所 sb.Append(txt_up_BUSDATE.ClientID + "<partition>");//訂單日期 sb.Append(txt_up_SALE_ID.ClientID + "<partition>");//營業人員 sb.Append(txt_up_BUSUID.ClientID + "<partition>");//訂單維護者 sb.Append(((DropDownList)((ASP.sys_slp_slp_enumbase_ascx)drop_up_ORDER_TYPE).FindControl("D1")).ClientID + "<partition>");//訂單來源 sb.Append(this.txt_up_PO_SOURCE_NO.ClientID + "<partition>");//PO單號預設 sb.Append(this.txt_up_CODE.ClientID + "<partition>");//訂單編號 sb.Append(this.txt_up_CRM_NO.ClientID + "<partition>");//流水編號 sb.Append(img_up_CHAN_NO.ClientID + "<partition>");//通路img sb.Append(img_up_STORE.ClientID + "<partition>");//門市img sb.Append(img_up_BUSDATE.ClientID + "<partition>");//訂單日期img sb.Append(img_up_SALE_ID.ClientID + "<partition>");//營業人員img sb.Append(img_up_BUSUID.ClientID);//訂單維護者img } } #endregion #region 新增或編輯模式下異動欄位[訂貨量] else if (s_Client_String[0] == "新增或編輯模式下異動欄位[訂貨量]") { #region 判斷庫存是否足夠 if ((dtStock == null) || (dtStock.Rows.Count < 1)) { GetStock(s_ROOT_NO, s_ITEM, s_PERIOD); } if (((dtStock == null) || (dtStock.Rows.Count < 1)) && (s_ROOT_NO != "2")) { sb.Append("新增或編輯模式下異動欄位[訂貨量]<partition>"); sb.Append("FALSE<partition>"); sb.Append("庫存量不足,請取消新增<partition>"); sb.Append(txt_down_REQUEST_QTY.ClientID + "<partition>");//設定焦點的欄位 sb.Append(this.txt_down_RECOMMAND_LOCATION.ClientID); return sb.ToString(); } #endregion DataView dvStock = new DataView(dtStock.Copy()); s_SRC_LOCATE_TYPE = string.Empty; int i_REQUEST_QTY = 0;//畫面上使用者輸入的"訂貨量" int i_ONHD_QTY = 0;//現有庫存量 int i_RESERVE_QTY = 0;//配本保留數 int i_Final_QTY = 0;//庫存儲區可配量 int i_DIS_ENABLE = 0;//可配量 string s_SRC_LOCATE_NO = string.Empty;//VDS_CRM_ORDER_DETL.SRC_LOCATE_NO欄位 i_REQUEST_QTY = int.Parse(s_Client_String[1]); // 2009-07-30 cyshu 修改,逾期客訂可取退貨儲區庫存 #region [@群分類]=1(雜誌) 時 //if (s_ROOT_NO == "1" && s_Client_String[2] == "false") if (s_ROOT_NO == "1") { #region 先檢查庫存儲區可用庫存 dvStock.RowFilter = "LOCATETYPE = '2'"; dvStock.Sort = "ONHD_QTY DESC"; #region Old Source //if (dvStock.Count > 0) //{ // i_ONHD_QTY = 0; // i_RESERVE_QTY = 0; // for (int i = 0; i < dvStock.Count; i++) // { // i_ONHD_QTY += int.Parse(dvStock[i]["ONHD_QTY"].ToString()); // i_RESERVE_QTY += int.Parse(dvStock[i]["RESERVE_QTY"].ToString()); // } //} #endregion #region new code i_ONHD_QTY = 0; i_RESERVE_QTY = 0; bool b_Locate_Stock = false; //庫存儲區 for (int i = 0; i < dvStock.Count; i++) { i_ONHD_QTY = int.Parse(dvStock[i]["ONHD_QTY"].ToString()); i_RESERVE_QTY = int.Parse(dvStock[i]["RESERVE_QTY"].ToString()); i_Final_QTY = i_ONHD_QTY - i_RESERVE_QTY;//庫存儲區可配量 if (i_Final_QTY >= i_REQUEST_QTY) { s_SRC_LOCATE_TYPE = "2"; s_SRC_LOCATE_NO = dvStock[i]["LOCATE_NO"].ToString();//現有庫存儲區 try { i_DIS_ENABLE = int.Parse(dvStock[0]["ONHD_QTY"].ToString()) - int.Parse(dvStock[0]["RESERVE_QTY"].ToString()); } catch { i_DIS_ENABLE = 0; } b_Locate_Stock = true; break; } } if (!b_Locate_Stock) //庫存儲區庫存不足 { if (s_PMA == "13" || s_PMA == "14" || s_PMA == "15" || s_PMA == "16") { #region 外雜 sb.Append("新增或編輯模式下異動欄位[訂貨量]<partition>"); sb.Append("FALSE<partition>"); sb.Append("外雜D儲區庫存量不足,無法新增訂單<partition>"); sb.Append(txt_down_REQUEST_QTY.ClientID + "<partition>");//設定焦點的欄位 sb.Append(this.txt_down_RECOMMAND_LOCATION.ClientID); return sb.ToString(); #endregion } else { #region 檢查退貨儲區可用庫存 i_ONHD_QTY = 0; i_RESERVE_QTY = 0; i_Final_QTY = 0; i_DIS_ENABLE = 0; s_SRC_LOCATE_NO = string.Empty; dvStock.RowFilter = "LOCATETYPE = '1'"; for (int i = 0; i < dvStock.Count; i++) { i_ONHD_QTY += int.Parse(dvStock[i]["ONHD_QTY"].ToString()); i_RESERVE_QTY += int.Parse(dvStock[i]["RESERVE_QTY"].ToString()); } i_Final_QTY = i_ONHD_QTY - i_RESERVE_QTY; if (i_Final_QTY >= i_REQUEST_QTY) { s_SRC_LOCATE_TYPE = "1";//退貨儲區 s_SRC_LOCATE_NO = dvStock[0]["LOCATE_NO"].ToString();//現有庫存量最大的儲區 i_DIS_ENABLE = int.Parse(dvStock[0]["ONHD_QTY"].ToString()) - int.Parse(dvStock[0]["RESERVE_QTY"].ToString()); } else { sb.Append("新增或編輯模式下異動欄位[訂貨量]<partition>"); sb.Append("FALSE<partition>"); sb.Append("庫存量不足,請取消新增<partition>"); sb.Append(txt_down_REQUEST_QTY.ClientID + "<partition>");//設定焦點的欄位 sb.Append(this.txt_down_RECOMMAND_LOCATION.ClientID); return sb.ToString(); } #endregion } } #endregion new code #region old code2 //i_Final_QTY = i_ONHD_QTY - i_RESERVE_QTY;//庫存儲區可配量 //// 庫存儲區可配量 >= 訂量時,設定建議儲區 = 庫存儲區 //if (i_Final_QTY >= i_REQUEST_QTY) //{ // s_SRC_LOCATE_TYPE = "2";//庫存儲區 // s_SRC_LOCATE_NO = dvStock[0]["LOCATE_NO"].ToString();//現有庫存量最大的儲區 // try // { // i_DIS_ENABLE = int.Parse(dvStock[0]["ONHD_QTY"].ToString()) - int.Parse(dvStock[0]["RESERVE_QTY"].ToString()); // } // catch { i_DIS_ENABLE = 0; } //} //else //{ // if (s_PMA == "13" || // s_PMA == "14" || // s_PMA == "15" || // s_PMA == "16") // { // sb.Append("新增或編輯模式下異動欄位[訂貨量]<partition>"); // sb.Append("FALSE<partition>"); // sb.Append("外雜D儲區庫存量不足,無法新增訂單<partition>"); // sb.Append(txt_down_REQUEST_QTY.ClientID + "<partition>");//設定焦點的欄位 // sb.Append(this.txt_down_RECOMMAND_LOCATION.ClientID); // return sb.ToString(); // } // else // { // #region 檢查退貨儲區可用庫存 // i_ONHD_QTY = 0; // i_RESERVE_QTY = 0; // i_Final_QTY = 0; // i_DIS_ENABLE = 0; // s_SRC_LOCATE_NO = string.Empty; // dvStock.RowFilter = "LOCATETYPE = '1'"; // for (int i = 0; i < dvStock.Count; i++) // { // i_ONHD_QTY += int.Parse(dvStock[i]["ONHD_QTY"].ToString()); // i_RESERVE_QTY += int.Parse(dvStock[i]["RESERVE_QTY"].ToString()); // } // i_Final_QTY = i_ONHD_QTY - i_RESERVE_QTY; // if (i_Final_QTY >= i_REQUEST_QTY) // { // s_SRC_LOCATE_TYPE = "1";//退貨儲區 // s_SRC_LOCATE_NO = dvStock[0]["LOCATE_NO"].ToString();//現有庫存量最大的儲區 // i_DIS_ENABLE = int.Parse(dvStock[0]["ONHD_QTY"].ToString()) - int.Parse(dvStock[0]["RESERVE_QTY"].ToString()); // } // else // { // sb.Append("新增或編輯模式下異動欄位[訂貨量]<partition>"); // sb.Append("FALSE<partition>"); // sb.Append("庫存量不足,請取消新增<partition>"); // sb.Append(txt_down_REQUEST_QTY.ClientID + "<partition>");//設定焦點的欄位 // sb.Append(this.txt_down_RECOMMAND_LOCATION.ClientID); // return sb.ToString(); // } // #endregion // } //} #endregion old code2 #endregion } #endregion #region [@群分類]=2(圖書) else { dvStock.RowFilter = "LOCATETYPE = '2'"; dvStock.Sort = "ONHD_QTY DESC"; if (dvStock.Count > 0) { // 先作預設值 s_SRC_LOCATE_TYPE = "2"; // 庫存儲區 s_SRC_LOCATE_NO = dvStock[0]["LOCATE_NO"].ToString();//現有庫存量最大的儲區 for (int i = 0; i < dvStock.Count; i++) { i_ONHD_QTY += int.Parse(dvStock[i]["ONHD_QTY"].ToString()); i_RESERVE_QTY += int.Parse(dvStock[i]["RESERVE_QTY"].ToString()); } i_Final_QTY = i_ONHD_QTY - i_RESERVE_QTY; if (i_Final_QTY >= i_REQUEST_QTY) { s_SRC_LOCATE_TYPE = "2";//庫存儲區 s_SRC_LOCATE_NO = dvStock[0]["LOCATE_NO"].ToString();//現有庫存量最大的儲區 i_DIS_ENABLE = int.Parse(dvStock[0]["ONHD_QTY"].ToString()) - int.Parse(dvStock[0]["RESERVE_QTY"].ToString()); } else //圖書庫存不足仍可新增 { s_SRC_LOCATE_TYPE = "2";//庫存儲區 s_SRC_LOCATE_NO = "D"; i_DIS_ENABLE = 0; sb.Append("新增或編輯模式下異動欄位[訂貨量]<partition>"); sb.Append("TRUE_ALERT<partition>"); sb.Append("圖書庫存不足,確認要新增?<partition>"); sb.Append(s_SRC_LOCATE_NO + "<partition_Detail>" + this.txt_down_RECOMMAND_LOCATION.ClientID + "<partition>"); sb.Append(i_DIS_ENABLE.ToString() + "<partition_Detail>" + this.hid_DIS_ENABLE.ClientID); return sb.ToString(); } } else //圖書庫存不足仍可新增 { #region 圖書庫存不足仍可新增 s_SRC_LOCATE_TYPE = "2";//庫存儲區 s_SRC_LOCATE_NO = "D"; i_DIS_ENABLE = 0; sb.Append("新增或編輯模式下異動欄位[訂貨量]<partition>"); sb.Append("TRUE_ALERT<partition>"); sb.Append("圖書庫存不足,確認要新增?<partition>"); sb.Append(s_SRC_LOCATE_NO + "<partition_Detail>" + this.txt_down_RECOMMAND_LOCATION.ClientID + "<partition>"); sb.Append(i_DIS_ENABLE.ToString() + "<partition_Detail>" + this.hid_DIS_ENABLE.ClientID); return sb.ToString(); #endregion } } #endregion if (sb.ToString() == string.Empty) { if (i_REQUEST_QTY > 100) { sb.Append("新增或編輯模式下異動欄位[訂貨量]<partition>"); sb.Append("TRUE_ALERT<partition>"); sb.Append("訂貨量大於100<partition>"); sb.Append(s_SRC_LOCATE_NO + "<partition_Detail>" + this.txt_down_RECOMMAND_LOCATION.ClientID + "<partition>"); sb.Append(i_DIS_ENABLE.ToString() + "<partition_Detail>" + this.hid_DIS_ENABLE.ClientID); return sb.ToString(); } else { sb.Append("新增或編輯模式下異動欄位[訂貨量]<partition>"); sb.Append("TRUE_NO_ALERT<partition>"); sb.Append(s_SRC_LOCATE_NO + "<partition_Detail>" + this.txt_down_RECOMMAND_LOCATION.ClientID + "<partition>"); sb.Append(i_DIS_ENABLE.ToString() + "<partition_Detail>" + this.hid_DIS_ENABLE.ClientID); return sb.ToString(); } } } #endregion #region 新增或編輯模式按下明細區[取消]鈕 else if (s_Client_String[0] == "新增或編輯模式按下明細區[取消]鈕") { #region 清空靜態變數 dtStock = null;//異動欄位[期別] s_PMA = string.Empty;//大分類(異動欄位[品號/品名]) s_ROOT_NO = string.Empty;//群分類(異動欄位[品號/品名]) s_SRC_LOCATE_TYPE = string.Empty;//建議儲區類別(異動欄位[訂貨量]) sb.Remove(0, sb.Length); #endregion #region 計算 dt_Detail 的筆數 int i_dt_Detail_Count = 0; if (dt_Detail != null) { if (dt_Detail.GetChanges(DataRowState.Deleted) == null) { i_dt_Detail_Count = dt_Detail.Rows.Count; } else { i_dt_Detail_Count = dt_Detail.Rows.Count - dt_Detail.GetChanges(DataRowState.Deleted).Rows.Count; } } #endregion sb.Append("新增或編輯模式按下明細區[取消]鈕<partition>"); sb.Append(i_dt_Detail_Count.ToString() + "<partition>");//dt_Detail的筆數 sb.Append(this.hid_PageStatus.ClientID + "<partition>");//hid_PageStatus sb.Append(this.panel_Down_AddDetail.ClientID + "<partition>");//panel_Down_AddDetail sb.Append(this.panel_Down_Button.ClientID + "<partition>");//panel_Down_Button sb.Append(chk_down_IS_OVERDUE.ClientID + "<partition>");//逾期客訂 sb.Append(this.txt_down_PO_SOURCE_NO.ClientID + "<partition>");//PO單號 sb.Append(this.txt_down_BARCODE.ClientID + "<partition>");//一段碼 sb.Append(this.txt_down_PERIOD_BARCODE.ClientID + "<partition>");//二段碼 sb.Append(txt_down_ITEM.ClientID + "<partition>");//品號 sb.Append(txt_down_ITEM_NAME.ClientID + "<partition>");//品名 sb.Append(this.txt_down_PERIOD.ClientID + "<partition>");//期別 sb.Append(txt_down_REQUEST_QTY.ClientID + "<partition>");//訂貨量 //sb.Append(txt_down_REQUEST_QTY_NAME.ClientID + "<partition>");//訂貨量名稱 sb.Append(txt_down_RTN_DDL.ClientID + "<partition>");//退書截止日 sb.Append(this.txt_down_RECOMMAND_LOCATION.ClientID + "<partition>");//建議儲區 sb.Append(txt_up_CHAN_NO.ClientID + "<partition>");//通路 sb.Append(txt_up_STORE.ClientID + "<partition>");//門市 sb.Append(txt_up_Z_O.ClientID + "<partition>");//營業所 sb.Append(txt_up_BUSDATE.ClientID + "<partition>");//訂單日期 sb.Append(txt_up_SALE_ID.ClientID + "<partition>");//營業人員 sb.Append(txt_up_BUSUID.ClientID + "<partition>");//訂單維護者 sb.Append(((DropDownList)((ASP.sys_slp_slp_enumbase_ascx)drop_up_ORDER_TYPE).FindControl("D1")).ClientID + "<partition>");//訂單來源 sb.Append(this.txt_up_PO_SOURCE_NO.ClientID + "<partition>");//PO單號預設 sb.Append(this.txt_up_CODE.ClientID + "<partition>");//訂單編號 sb.Append(this.txt_up_CRM_NO.ClientID + "<partition>");//流水編號 sb.Append(img_up_CHAN_NO.ClientID + "<partition>");//通路img sb.Append(img_up_STORE.ClientID + "<partition>");//門市img sb.Append(img_up_BUSDATE.ClientID + "<partition>");//訂單日期img sb.Append(img_up_SALE_ID.ClientID + "<partition>");//營業人員img sb.Append(img_up_BUSUID.ClientID);//訂單維護者img } #endregion #region 新增或編輯模式按下GridView[編輯]鈕 else if (s_Client_String[0] == "新增或編輯模式按下GridView[編輯]鈕") { DataRow dRow = dt_Detail.Select("ID = " + s_Client_String[1])[0]; string s_IS_OVERDUE; //改為已擷轉仍可修改 //if (dRow["TRANS_RESULT"].ToString() == "1")//已擷轉 //{ sb.Append("此筆訂單品項已擷轉,不可編輯或刪除\r\n"); } if (dRow["STATUS"].ToString() == "75")//已結案 { sb.Append("此筆訂單品項已結案,不可編輯或刪除\r\n"); } #region 編輯前檢查錯誤 if (sb.ToString() != string.Empty) { sb.Insert(0, "新增或編輯模式按下GridView[編輯]鈕_編輯前檢查FALSE<partition>"); return sb.ToString(); } #endregion #region 取得庫存 i_Curr_Order_Qty = 0; s_ROOT_NO = dRow["ROOT_NO"].ToString(); //群分類 s_ITEM = dRow["ITEM"].ToString(); //品號 s_PERIOD = dRow["PERIOD"].ToString(); //期別 i_Curr_Order_Qty = (dRow["REQUEST_QTY"].ToString().Trim() == string.Empty) ? 0 : int.Parse(dRow["REQUEST_QTY"].ToString().Trim()); s_SRC_LOCATE_NO = dRow["SRC_LOCATE_NO"].ToString();//原儲區 //取得目前庫存 dtStock = null; GetStock(s_ROOT_NO, s_ITEM, s_PERIOD); //編輯模式下,可用庫存應加上原訂單需求量 AddStockForEditMode(s_SRC_LOCATE_NO, i_Curr_Order_Qty); #endregion #region 編輯前檢查正確 s_IS_OVERDUE = (dRow["IS_OVERDUE"].ToString() == "0") ? "false" : "true"; sb.Append("新增或編輯模式按下GridView[編輯]鈕_編輯前檢查TRUE<partition>"); sb.Append(txt_up_CHAN_NO.ClientID + "<partition>");//通路 sb.Append(txt_up_STORE.ClientID + "<partition>");//門市 sb.Append(txt_down_ITEM.ClientID + "<partition>");//品號 sb.Append(this.txt_down_PERIOD.ClientID + "<partition>");//期別 sb.Append(this.txt_down_BARCODE.ClientID + "<partition>");//一段碼 sb.Append(this.txt_down_PERIOD_BARCODE.ClientID + "<partition>");//二段碼 sb.Append(txt_down_RTN_DDL.ClientID + "<partition>");//退書截止日 sb.Append(this.panel_Down_AddDetail.ClientID + "<partition>");//panel_Down_AddDetail sb.Append(this.panel_Down_Button.ClientID + "<partition>");//panel_Down_Button sb.Append(s_IS_OVERDUE + "<partition_Detail>" + chk_down_IS_OVERDUE.ClientID + "<partition>");//逾期客訂 sb.Append(dRow["PO_SOURCE_NO"].ToString() + "<partition_Detail>" + this.txt_down_PO_SOURCE_NO.ClientID + "<partition>");//PO單號 sb.Append(dRow["BARCODE"].ToString() + "<partition_Detail>" + this.txt_down_BARCODE.ClientID + "<partition>");//一段碼 sb.Append(dRow["PERIOD_BARCODE"].ToString() + "<partition_Detail>" + this.txt_down_PERIOD_BARCODE.ClientID + "<partition>");//二段碼 sb.Append(dRow["ITEM"].ToString() + "<partition_Detail>" + txt_down_ITEM.ClientID + "<partition>");//品號 sb.Append(dRow["ITEM_NAME"].ToString() + "<partition_Detail>" + txt_down_ITEM_NAME.ClientID + "<partition>");//品名 sb.Append(dRow["PERIOD"].ToString() + "<partition_Detail>" + this.txt_down_PERIOD.ClientID + "<partition>");//期別 sb.Append(dRow["REQUEST_QTY"].ToString() + "<partition_Detail>" + txt_down_REQUEST_QTY.ClientID + "<partition>");//訂貨量 //sb.Append(dRow["REQUEST_QTY"].ToString() + ".0000<partition_Detail>" + txt_down_REQUEST_QTY_NAME.ClientID + "<partition>");//訂貨量名稱 sb.Append(DateTime.Parse(dRow["RTN_DDL"].ToString()).ToString("yyyy/MM/dd") + "<partition_Detail>" + txt_down_RTN_DDL.ClientID + "<partition>");//退書截止日 sb.Append(dRow["SRC_LOCATE_NO"].ToString() + "<partition_Detail>" + this.txt_down_RECOMMAND_LOCATION.ClientID + "<partition>");//建議儲區 sb.Append(dRow["ID"].ToString() + "<partition_Detail>" + this.hid_ID.ClientID);//hid_ID #endregion } #endregion #region 新增或編輯模式按下明細區[新增明細]鈕 else if (s_Client_String[0] == "新增或編輯模式按下明細區[新增明細]鈕") { #region 清空靜態變數 dtStock = null;//異動欄位[期別] s_PMA = string.Empty;//大分類(異動欄位[品號/品名]) s_ROOT_NO = string.Empty;//群分類(異動欄位[品號/品名]) s_SRC_LOCATE_TYPE = string.Empty;//建議儲區類別(異動欄位[訂貨量]) #endregion } #endregion #region 新增模式異動欄位[流水編號] else if (s_Client_String[0] == "新增模式異動欄位[流水編號]") { #region 檢查是否為有效流水編號 DataTable dt_Return = new DataTable(); ParameterList.Clear(); ParameterList.Add(s_Client_String[1]);//流水編號 ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(DateTime.Now); BCO.RecordCRMRecord bco = new BCO.RecordCRMRecord(ConntionDB); dt_Return = bco.QueryCRMRecordByCode_CheckExist(ParameterList); if (dt_Return.Rows.Count == 0) { sb.Append("新增模式異動欄位[流水編號]<partition>"); sb.Append("FALSE<partition>"); sb.Append(this.txt_up_CRM_NO.ClientID + "<partition>"); sb.Append("[流水編號]不為存在的有效編號"); } #endregion } #endregion CallBackValue = sb.ToString(); } catch (Exception ex) { CallBackValue = "發生例外錯誤<partition>" + ex.Message; } } return CallBackValue; }
protected void Page_Load(object sender, EventArgs e) { try { this.ErrorMsgLabel.Text = string.Empty; this.RightMsgLabel.Text = string.Empty; if (!IsPostBack) { //寫入首次載入Page TimeStamp PageTimeStamp.Value = string.Format("{0}{1}{2}{3}{4}{5}", DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString().PadLeft(2, '0'), DateTime.Now.Day.ToString().PadLeft(2, '0'), DateTime.Now.Hour.ToString().PadLeft(2, '0'), DateTime.Now.Minute.ToString().PadLeft(2, '0'), DateTime.Now.Second.ToString().PadLeft(2, '0') ); Initialization_Component();//設定GridView預設的狀態 ToolBarInit(); // 移到最前面加 client event #region Attributes TextBox txt_Up_CHAN_NO = (TextBox)this.slp_Up_CHAN_NO.FindControl("TextBoxCode");//上方通路 TextBox txt_STORE = (TextBox)this.slp_STORE.FindControl("TextBoxCode");//上方門市 TextBox txt_up_BUSDATE = (TextBox)((ASP.wui_slp_slp_slpdate_ascx)slp_Up_BUSDATE).FindControl("TextBoxCode");//來電日期 //TextBox txt_up_ANSWER_TIME = (TextBox)((ASP.wui_slp_slp_time_ascx)txt_ANSWER_TIME).FindControl("TextBoxCode");//回答時間 TextBox txt_up_ANSWER_TIME = (TextBox)(FinfControlEx(this.txt_ANSWER_TIME, "TextBoxCode")); this.but_Up_Insert.Attributes.Add("onclick", "but_Click_Begin('" + this.but_Up_Insert.UniqueID + "');"); this.but_Up_Query.Attributes.Add("onclick", "but_Click_Begin('" + this.but_Up_Query.UniqueID + "');"); this.but_Up_Save.Attributes.Add("onclick", " ('" + this.but_Up_Save.UniqueID + "');"); this.but_Up_Delete.OnClientClick = "return but_Click_Begin_For_Delete('" + this.but_Up_Delete.UniqueID + "','確認要刪除?');"; this.but_Up_Edit.Attributes.Add("onclick", "but_Click_Begin('" + this.but_Up_Edit.UniqueID + "');"); //this.but_Up_Cancel.Attributes.Add("onclick", "but_Click_Begin('" + this.but_Up_Cancel.UniqueID + "');"); this.but_Down_Query.Attributes.Add("onclick", "but_Click_Begin('" + this.but_Down_Query.UniqueID + "');"); this.but_Down_Record_Three.Attributes.Add("onclick", "but_Click_Begin('" + this.but_Down_Record_Three.UniqueID + "');"); // 增加 電話/傳真不可輸入數字以外的字元 this.txt_STORE_TEL_AREA.Attributes["onkeypress"] += String.Format(@"return check_intkey({0});", this.txt_STORE_TEL_AREA.ClientID); this.txt_STORE_TEL_NO.Attributes["onkeypress"] += String.Format(@"return check_intkey({0});", this.txt_STORE_TEL_NO.ClientID); this.txt_STORE_FAX_AREA.Attributes["onkeypress"] += String.Format(@"return check_intkey({0});", this.txt_STORE_FAX_AREA.ClientID); this.txt_STORE_FAX_NO.Attributes["onkeypress"] += String.Format(@"return check_intkey({0});", this.txt_STORE_FAX_NO.ClientID); //this.txt_DEAL_CONTENT.Attributes["onkeypress"] += String.Format(@"return limit_length({0},{1});", this.txt_DEAL_CONTENT.ClientID, this.txt_DEAL_CONTENT.MaxLength); //this.txt_STORE_ADDRESS.Attributes["onkeypress"] += String.Format(@"return limit_length({0},{1});", this.txt_STORE_ADDRESS.ClientID, this.txt_STORE_ADDRESS.MaxLength); //this.txt_CODE.Attributes.Add("onblur", "Check_Code('輸入字串不符合流水編號格式!');"); this.txt_CODE.Attributes["onblur"] += "Check_Code('輸入字串不符合流水編號格式!');"; this.Form.Attributes.Add("onkeypress", "return WebForm_FireDefaultButton_Self();");//預設系統功能鍵 #region AJAX 設定通路 & 設定參考門市資料 string strJs; // 2009-07-21 cyhsu mark 改由JS呼叫隱藏button.click取代 //strJs = "if (document.getElementById('" + txt_Up_CHAN_NO.ClientID + "').value != '') " + // "{ __doPostBack(document.all['" + up_Master.ClientID + "'].id,'txt_Up_CHAN_NO_Onblur'); " + // "} if (" + this.slp_Z_O.TextBox_Code.ClientID + " != null) { " + // this.slp_Z_O.TextBox_Code.ClientID + ".select(); " + // this.slp_Z_O.TextBox_Code.ClientID + ".focus();} "; //txt_Up_CHAN_NO.Attributes["onblur"] += strJs; //strJs = "if (document.getElementById('" + txt_STORE.ClientID + "').value != '') " + // "{__doPostBack(document.all['" + up_Master.ClientID + "'].id,'txt_STORE_Onblur');" + // "} if (" + this.slp_Up_CHAN_NO.TextBox_Code.ClientID + " != null) { " + // this.slp_Up_CHAN_NO.TextBox_Code.ClientID + ".select(); " + // this.slp_Up_CHAN_NO.TextBox_Code.ClientID + ".focus();} "; //txt_STORE.Attributes["onblur"] += strJs; //txt_Up_CHAN_NO.Attributes["onblur"] += "__doPostBack(document.all['" + up_Master.ClientID + "'].id,'txt_Up_CHAN_NO_Onblur');"; //txt_STORE.Attributes["onblur"] += "__doPostBack(document.all['" + up_Master.ClientID + "'].id,'txt_STORE_Onblur');"; // 2009-07-21 cyhsu mark 改由JS呼叫隱藏button.click取代 //+"if (document.getElementById('" + txt_Up_CHAN_NO.ClientID + "')!= null) " + // "{ document.getElementById('" + txt_Up_CHAN_NO.ClientID + "').select();" + // " document.getElementById('" + txt_Up_CHAN_NO.ClientID + "').focus(); }"; // txt_STORE.Attributes.Add("onblur", @" //if(document.all['" + this.hid_Page_Status.ClientID + @"'].value == 'INSERT' || // document.all['" + this.hid_Page_Status.ClientID + @"'].value == 'QUERY') //{ // if(this.value != '') // {CallServer_Store('門市<partition>' + this.value + '<partition>' + document.all['" + txt_Up_CHAN_NO.ClientID + @"'].value);} //}"); // txt_Up_CHAN_NO.Attributes.Add("onblur", @" // if(document.all['" + this.hid_Page_Status.ClientID + @"'].value == 'INSERT' || // document.all['" + this.hid_Page_Status.ClientID + @"'].value == 'QUERY') // { // CallServer_Chan_No('通路<partition>' + this.value + '<partition>' + document.all['" + txt_STORE.ClientID + @"'].value); // }"); // RegClientScript(); #endregion #region 設定TabIndex this.slp_Up_CHAN_NO.TextBox_Code.TabIndex = 11; this.slp_Z_O.TextBox_Code.TabIndex = 12; this.txt_CODE.TabIndex = 13; this.slp_STORE.TextBox_Code.TabIndex = 14; txt_up_BUSDATE.TabIndex = 15; txt_up_ANSWER_TIME.TabIndex = 16; this.slp_SAL_ID.TextBox_Code.TabIndex = 17; this.slp_BUSUID.TextBox_Code.TabIndex = 18; this.txt_ROUTD_ID.TabIndex = 19; this.txt_ROUTD_STEP.TabIndex = 20; this.txt_STORE_TEL_AREA.TabIndex = 21; this.txt_STORE_TEL_NO.TabIndex = 22; this.txt_STORE_FAX_AREA.TabIndex = 23; this.txt_STORE_FAX_NO.TabIndex = 24; this.txt_STORE_ADDRESS.TabIndex = 25; this.chkbl_Detail.TabIndex = 26; this.txt_DEAL_CONTENT.TabIndex = 27; this.but_Up_Insert.TabIndex = 28; this.but_Up_Save.TabIndex = 29; this.but_Up_Query.TabIndex = 30; this.but_Up_Edit.TabIndex = 31; this.but_Up_Cancel.TabIndex = 32; this.but_Up_Delete.TabIndex = 33; #endregion #endregion #region 讀取客戶訊息資料 GetCustomerMessage(); #endregion #region 依照參數來設定哪一種模式的畫面 if (Request["CRM011_CODE"] == null) { #region 設定 Page_Status 狀態 //模式指定 string mode = "QUERY"; try { mode = Request["mode"].ToString(); } catch { mode = "INSERT"; } //權限控管 if (mode == "INSERT") if (!CanCreate) mode = "QUERY"; //該頁面共有4種狀態 //查詢 QUERY //檢視 VIEW //新增 INSERT //編輯 EDIT this.hid_Page_Status.Value = "QUERY"; this.txt_Page_Status.Text = "QUERY"; // todo : 為了在檢視模式下可以按新增按鈕,先用mode去判斷是否執行but_Up_Insert_Click // 待調整 by cyhsu 2009.03. if ((mode != "QUERY") && (mode != null)) { if (mode == "INSERT") { but_Up_Insert_Click(null, null); } } GetPageDefault();//設定各種模式預設值 #endregion } else {//代表是從查詢前三筆紀錄連過來的 #region 讀取 VDS_CRM_RECORD_MAIN 資料 DataSet ds_Return = new DataSet(); ArrayList ParameterList = new ArrayList();//20091117 ParameterList.Clear(); ParameterList.Add(Request["CRM011_CODE"].ToString()); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(DateTime.Now); BCO.RecordCRMRecord bco_Main = new BCO.RecordCRMRecord(ConntionDB); ds_Return = bco_Main.QueryCRMRecordByCode(ParameterList); #endregion #region 使用XML放置到前端資料 #region 將空白的資料做處理 GetDataSetBeforeSaveXML(ref ds_Return); #endregion xml_OLDData.InnerHtml = ds_Return.GetXml(); #endregion #region 設定各個欄位 this.slp_Up_CHAN_NO.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["CHAN_NO"].ToString();//通路 this.slp_Z_O.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["Z_O"].ToString();//營業所 this.txt_CODE.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["CODE"].ToString();//流水編號 this.slp_STORE.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["STORE"].ToString();//門市 this.slp_Up_BUSDATE.Text = ((DateTime)ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["BUSDATE"]).ToShortDateString();//處理日期 this.txt_ANSWER_TIME.Text = ((DateTime)ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["ANSWER_TIME"]).ToString("HH:mm");//接聽時間 yyyy/MM/dd HH:mm:ss this.slp_SAL_ID.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["SAL_ID"].ToString();//營業人員 this.slp_BUSUID.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["BUSUID"].ToString();//處理人員 this.txt_ROUTD_ID.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["ROUTE_ID"].ToString();//路線 this.txt_ROUTD_STEP.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["ROUTE_STEP"].ToString();//路順 this.txt_STORE_TEL_AREA.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["STORE_TEL_AREA"].ToString();//電話-區域號碼 this.txt_STORE_TEL_NO.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["STORE_TEL_NO"].ToString();//電話號碼 this.txt_STORE_FAX_AREA.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["FAX_AREA"].ToString();//傳真-區域號碼 this.txt_STORE_FAX_NO.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["FAX_NO"].ToString();//傳真號碼 this.txt_STORE_ADDRESS.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["STORE_ADDRESS"].ToString();//地址 this.txt_DEAL_CONTENT.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["DEAL_CONTENT"].ToString();//處理內容 foreach (DataRow dRow in ds_Return.Tables["VDS_CRM_RECORD_DETL"].Rows) { chkbl_Detail.Items.FindByValue(dRow["ONLINE_NO"].ToString()).Selected = true; } #endregion #region 設定 Page_Status 狀態 //該頁面共有4種狀態 //查詢 QUERY //檢視 VIEW //新增 INSERT //編輯 EDIT this.hid_Page_Status.Value = "VIEW"; this.txt_Page_Status.Text = "VIEW"; GetPageDefault();//設定各種模式預設值 #endregion } #endregion } else { //if (Request.Form["__EVENTARGUMENT"] == "txt_STORE_Onblur") // txt_STORE_Onblur(); //if (Request.Form["__EVENTARGUMENT"] == "txt_Up_CHAN_NO_Onblur") //{ // txt_Up_CHAN_NO_Onblur(); //} //else if (Request.Form["__EVENTARGUMENT"] == "txt_STORE_Onblur") // txt_STORE_Onblur(); } #region ToolBar 設定 //WUI_GMToolbarV uc = (WUI_GMToolbarV)this.GMToolbar1; //uc.Btn_Find += new WUI_GMToolbarV.UCDelegate(this.UC_Find); //uc.Btn_New += new WUI_GMToolbarV.UCDelegate(this.UC_New); //uc.Btn_Edit += new WUI_GMToolbarV.UCDelegate(this.UC_Edit); //uc.Btn_Save += new WUI_GMToolbarV.UCDelegate(this.UC_Save); //uc.Btn_Delete += new WUI_GMToolbarV.UCDelegate(this.UC_Delete); //uc.Btn_FindExport += new WUI_GMToolbarV.UCDelegate(UC_Export); //uc.Btn_Copy += new WUI_GMToolbarV.UCDelegate(UC_Copy); #endregion } catch (Exception ex) { WaringLogProcess(ex.Message); this.ErrorMsgLabel.Text = ex.Message; } finally { AuthorityControls(this); } }
/// <summary> /// 流水編號 /// </summary> /// <param name="strUserID"></param> /// <param name="strPageTimeStamp"></param> /// <param name="strOtherParam"></param> /// <returns></returns> private string GetValueByPageMethod_CHECKCRMNO(string strUserID, string strPageTimeStamp, string strOtherParam) { #region string strRtn = "", strTemp1 = ""; try { #region #region 檢查是否為有效流水編號 DataTable dt_Return = new DataTable(); ParameterList.Clear(); ParameterList.Add(strOtherParam);//流水編號 ParameterList.Add(strUserID); ParameterList.Add(DateTime.Now); BCO_CRM.RecordCRMRecord BCO = new BCO_CRM.RecordCRMRecord(ConntionDB); dt_Return = BCO.QueryCRMRecordByCode_CheckExist(ParameterList); BCO.CloseConnection(); if (dt_Return == null || dt_Return.Rows.Count == 0) { #region strTemp1 = string.Format("[流水編號]不為存在的有效編號"); #endregion } #endregion #endregion } catch (Exception ex) { throw ex; } return strRtn = string.Format("{0}", strTemp1); #endregion }
/// <summary> /// BUTTON 上面的編輯鈕 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void but_Up_Edit_Click(object sender, EventArgs e) { #region //System.Threading.Thread.Sleep(2000); try { if (this.hid_Page_Status.Value == "VIEW") { #region 檢查必填欄位 if (this.txt_CODE.Text.Trim() == string.Empty) { System.Web.UI.ScriptManager.RegisterStartupScript(this.up_Button, this.GetType(), "TO_CRM011.aspx", "alert('\"流水編號\"不可為空白')", true); return; } #endregion #region 查詢結果,根據畫面上"流水編號"這一個欄位 DataSet ds_Return = new DataSet(); ArrayList ParameterList = new ArrayList();//20091117 ParameterList.Clear(); ParameterList.Add(this.txt_CODE.Text.Trim()); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(DateTime.Now); BCO.RecordCRMRecord bco = new BCO.RecordCRMRecord(ConntionDB); ds_Return = bco.QueryCRMRecordByCode(ParameterList); #endregion #region 使用XML放置到前端資料 #region 將空白的資料做處理 GetDataSetBeforeSaveXML(ref ds_Return); #endregion xml_OLDData.InnerHtml = ds_Return.GetXml(); #endregion #region 設定各個欄位 this.slp_Up_CHAN_NO.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["CHAN_NO"].ToString();//通路 this.slp_Z_O.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["Z_O"].ToString();//營業所 this.txt_CODE.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["CODE"].ToString();//流水編號 this.slp_STORE.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["STORE"].ToString();//門市 this.slp_Up_BUSDATE.Text = ((DateTime)ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["BUSDATE"]).ToShortDateString();//處理日期 this.txt_ANSWER_TIME.Text = ((DateTime)ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["ANSWER_TIME"]).ToString("HH:mm");//接聽時間 yyyy/MM/dd HH:mm:ss this.slp_SAL_ID.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["SAL_ID"].ToString();//營業人員 this.slp_BUSUID.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["BUSUID"].ToString();//處理人員 this.txt_ROUTD_ID.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["ROUTE_ID"].ToString();//路線 this.txt_ROUTD_STEP.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["ROUTE_STEP"].ToString();//路順 this.txt_STORE_TEL_AREA.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["STORE_TEL_AREA"].ToString();//電話-區域號碼 this.txt_STORE_TEL_NO.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["STORE_TEL_NO"].ToString();//電話號碼 this.txt_STORE_FAX_AREA.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["FAX_AREA"].ToString();//傳真-區域號碼 this.txt_STORE_FAX_NO.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["FAX_NO"].ToString();//傳真號碼 this.txt_STORE_ADDRESS.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["STORE_ADDRESS"].ToString();//地址 this.txt_DEAL_CONTENT.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["DEAL_CONTENT"].ToString();//處理內容 foreach (ListItem li in this.chkbl_Detail.Items) { li.Selected = false; } foreach (DataRow dRow in ds_Return.Tables["VDS_CRM_RECORD_DETL"].Rows) { chkbl_Detail.Items.FindByValue(dRow["ONLINE_NO"].ToString()).Selected = true; } #endregion #region 設定頁面模式 this.hid_Page_Status.Value = "EDIT"; this.txt_Page_Status.Text = "EDIT"; #endregion #region 設定各欄位模式ReadOnly this.slp_Up_CHAN_NO.ReadOnly = true; this.slp_Z_O.ReadOnly = true; this.txt_CODE.ReadOnly = true; this.txt_CODE.CssClass = "readtxtbox"; this.slp_STORE.ReadOnly = true; this.slp_Up_BUSDATE.ReadOnly = true; this.txt_ANSWER_TIME.ReadOnly = true; this.slp_SAL_ID.ReadOnly = true; this.slp_BUSUID.ReadOnly = true; this.txt_ROUTD_ID.ReadOnly = true; this.txt_ROUTD_ID.CssClass = "readtxtbox"; this.txt_ROUTD_STEP.ReadOnly = true; this.txt_ROUTD_STEP.CssClass = "readtxtbox"; this.txt_STORE_TEL_AREA.ReadOnly = true; this.txt_STORE_TEL_AREA.CssClass = "readtxtbox"; this.txt_STORE_TEL_NO.ReadOnly = true; this.txt_STORE_TEL_NO.CssClass = "readtxtbox"; this.txt_STORE_FAX_AREA.ReadOnly = true; this.txt_STORE_FAX_AREA.CssClass = "readtxtbox"; this.txt_STORE_FAX_NO.ReadOnly = true; this.txt_STORE_FAX_NO.CssClass = "readtxtbox"; this.txt_STORE_ADDRESS.ReadOnly = true; this.txt_STORE_ADDRESS.CssClass = "readtxtbox"; this.txt_DEAL_CONTENT.ReadOnly = false; this.txt_DEAL_CONTENT.CssClass = ""; this.chkbl_Detail.Enabled = true; #endregion } } catch (Exception ex) { WaringLogProcess(ex.Message); this.ErrorMsgLabel.Text = ex.Message; } finally { GetPageDefault(); } #endregion }
private void QueryRecordMainFromToolbar(string s_Code, BrowseType bt) { #region try { BCO.RecordCRMRecord bco = new BCO.RecordCRMRecord(ConntionDB); ArrayList ParameterList = new ArrayList(); #region 查詢指定之CODE ParameterList.Clear(); ParameterList.Add(txt_CODE.Text); ParameterList.Add(slp_STORE.Text); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(bt.ToString()); string strCodeWanted = ""; strCodeWanted = bco.QueryRecordMainByTool(ParameterList); #endregion #region 查詢條件設定 ParameterList.Clear(); ParameterList.Add(null); ParameterList.Add(strCodeWanted); ParameterList.Add(null); ParameterList.Add(null); ParameterList.Add(null); ParameterList.Add(null); ParameterList.Add(null); ParameterList.Add(null); ParameterList.Add(null); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(DateTime.Now); #endregion #region 取得查詢資料 DataSet ds_Return = new DataSet(); ds_Return = bco.QueryCRMRecordByFind2(ParameterList); if (ds_Return.Tables.Count == 0) {//沒查到資料 System.Web.UI.ScriptManager.RegisterStartupScript(this.up_Button, this.GetType(), "TO_CRM011.aspx", "alert('查無資料')", true); #region 設定頁面模式 this.hid_Page_Status.Value = "QUERY"; this.txt_Page_Status.Text = "QUERY"; #endregion return; } else {//有查到資料 #region 使用XML放置到前端資料 #region 將空白的資料做處理 GetDataSetBeforeSaveXML(ref ds_Return); #endregion xml_OLDData.InnerHtml = ds_Return.GetXml(); #endregion #region 設定各個欄位 this.slp_Up_CHAN_NO.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["CHAN_NO"].ToString();//通路 this.slp_Z_O.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["Z_O"].ToString();//營業所 this.txt_CODE.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["CODE"].ToString();//流水編號 this.slp_STORE.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["STORE"].ToString();//門市 this.slp_Up_BUSDATE.Text = ((DateTime)ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["BUSDATE"]).ToShortDateString();//處理日期 this.txt_ANSWER_TIME.Text = ((DateTime)ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["ANSWER_TIME"]).ToString("HH:mm");//接聽時間 yyyy/MM/dd HH:mm:ss this.slp_SAL_ID.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["SAL_ID"].ToString();//營業人員 this.slp_BUSUID.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["BUSUID"].ToString();//處理人員 this.txt_ROUTD_ID.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["ROUTE_ID"].ToString();//路線 this.txt_ROUTD_STEP.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["ROUTE_STEP"].ToString();//路順 this.txt_STORE_TEL_AREA.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["STORE_TEL_AREA"].ToString();//電話-區域號碼 this.txt_STORE_TEL_NO.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["STORE_TEL_NO"].ToString();//電話號碼 this.txt_STORE_FAX_AREA.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["FAX_AREA"].ToString();//傳真-區域號碼 this.txt_STORE_FAX_NO.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["FAX_NO"].ToString();//傳真號碼 this.txt_STORE_ADDRESS.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["STORE_ADDRESS"].ToString();//地址 this.txt_DEAL_CONTENT.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["DEAL_CONTENT"].ToString();//處理內容 foreach (DataRow dRow in ds_Return.Tables["VDS_CRM_RECORD_DETL"].Rows) { chkbl_Detail.Items.FindByValue(dRow["ONLINE_NO"].ToString()).Selected = true; } #endregion #region 設定頁面模式 this.hid_Page_Status.Value = "VIEW"; this.txt_Page_Status.Text = "VIEW"; #endregion #region 設定各欄位模式ReadOnly this.slp_Up_CHAN_NO.ReadOnly = true; this.slp_Z_O.ReadOnly = true; this.txt_CODE.ReadOnly = true; this.txt_CODE.CssClass = "readtxtbox"; this.slp_STORE.ReadOnly = true; this.slp_Up_BUSDATE.ReadOnly = true; this.txt_ANSWER_TIME.ReadOnly = true; this.slp_SAL_ID.ReadOnly = true; this.slp_BUSUID.ReadOnly = true; this.txt_ROUTD_ID.ReadOnly = true; this.txt_ROUTD_ID.CssClass = "readtxtbox"; this.txt_ROUTD_STEP.ReadOnly = true; this.txt_ROUTD_STEP.CssClass = "readtxtbox"; this.txt_STORE_TEL_AREA.ReadOnly = true; this.txt_STORE_TEL_AREA.CssClass = "readtxtbox"; this.txt_STORE_TEL_NO.ReadOnly = true; this.txt_STORE_TEL_NO.CssClass = "readtxtbox"; this.txt_STORE_FAX_AREA.ReadOnly = true; this.txt_STORE_FAX_AREA.CssClass = "readtxtbox"; this.txt_STORE_FAX_NO.ReadOnly = true; this.txt_STORE_FAX_NO.CssClass = "readtxtbox"; this.txt_STORE_ADDRESS.ReadOnly = true; this.txt_STORE_ADDRESS.CssClass = "readtxtbox"; this.txt_DEAL_CONTENT.ReadOnly = true; this.txt_DEAL_CONTENT.CssClass = "readtxtbox"; this.chkbl_Detail.Enabled = false; #endregion } #endregion } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } finally { GetPageDefault(); } #endregion }
private void QueryDataAndSetControls() { #region BCO.RecordCRMRecord bco = new BCO.RecordCRMRecord(ConntionDB); ArrayList ParameterList = new ArrayList(); #region 根據回傳的 ID,將資料從 DATABASE 中取出 DataSet ds_Return = new DataSet(); Int32 i_ID; Int32.TryParse(s_ID, out i_ID); ParameterList.Clear(); ParameterList.Add(i_ID); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(DateTime.Now); ds_Return = bco.QueryCRMRecordByID(ParameterList); #endregion #region 使用XML放置到前端資料 #region 將空白的資料做處理 GetDataSetBeforeSaveXML(ref ds_Return); #endregion xml_OLDData.InnerHtml = ds_Return.GetXml(); #endregion #region 設定各個欄位的預設值 this.slp_Up_CHAN_NO.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["CHAN_NO"].ToString();//通路 this.slp_Z_O.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["Z_O"].ToString();//營業所 this.txt_CODE.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["CODE"].ToString();//流水編號 this.slp_STORE.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["STORE"].ToString();//門市 this.slp_Up_BUSDATE.Text = ((DateTime)ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["BUSDATE"]).ToShortDateString();//處理日期 this.txt_ANSWER_TIME.Text = ((DateTime)ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["ANSWER_TIME"]).ToString("HH:mm");//接聽時間 yyyy/MM/dd HH:mm:ss this.slp_SAL_ID.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["SAL_ID"].ToString();//營業人員 this.slp_BUSUID.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["BUSUID"].ToString();//處理人員 this.txt_ROUTD_ID.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["ROUTE_ID"].ToString();//路線 this.txt_ROUTD_STEP.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["ROUTE_STEP"].ToString();//路順 this.txt_STORE_TEL_AREA.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["STORE_TEL_AREA"].ToString();//電話-區域號碼 this.txt_STORE_TEL_NO.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["STORE_TEL_NO"].ToString();//電話號碼 this.txt_STORE_FAX_AREA.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["FAX_AREA"].ToString();//傳真-區域號碼 this.txt_STORE_FAX_NO.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["FAX_NO"].ToString();//傳真號碼 this.txt_STORE_ADDRESS.Text = ds_Return.Tables["VDS_STM_STORE"].Rows[0]["STORE_ADDRESS"].ToString();//地址 this.txt_DEAL_CONTENT.Text = ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["DEAL_CONTENT"].ToString();//處理內容 foreach (ListItem li in this.chkbl_Detail.Items) { li.Selected = false; } foreach (DataRow dRow in ds_Return.Tables["VDS_CRM_RECORD_DETL"].Rows) { chkbl_Detail.Items.FindByValue(dRow["ONLINE_NO"].ToString()).Selected = true; } #endregion #region 設定各欄位模式ReadOnly this.slp_Up_CHAN_NO.ReadOnly = true; this.slp_Z_O.ReadOnly = true; this.txt_CODE.ReadOnly = true; this.txt_CODE.CssClass = "readtxtbox"; this.slp_STORE.ReadOnly = true; this.slp_Up_BUSDATE.ReadOnly = true; this.txt_ANSWER_TIME.ReadOnly = true; this.slp_SAL_ID.ReadOnly = true; this.slp_BUSUID.ReadOnly = true; this.txt_ROUTD_ID.ReadOnly = true; this.txt_ROUTD_ID.CssClass = "readtxtbox"; this.txt_ROUTD_STEP.ReadOnly = true; this.txt_ROUTD_STEP.CssClass = "readtxtbox"; this.txt_STORE_TEL_AREA.ReadOnly = true; this.txt_STORE_TEL_AREA.CssClass = "readtxtbox"; this.txt_STORE_TEL_NO.ReadOnly = true; this.txt_STORE_TEL_NO.CssClass = "readtxtbox"; this.txt_STORE_FAX_AREA.ReadOnly = true; this.txt_STORE_FAX_AREA.CssClass = "readtxtbox"; this.txt_STORE_FAX_NO.ReadOnly = true; this.txt_STORE_FAX_NO.CssClass = "readtxtbox"; this.txt_STORE_ADDRESS.ReadOnly = true; this.txt_STORE_ADDRESS.CssClass = "readtxtbox"; this.txt_DEAL_CONTENT.ReadOnly = true; this.txt_DEAL_CONTENT.CssClass = "readtxtbox"; #endregion //old:toolbar //CheckCurrentIndexAndSwitchNavigator(s_ID); #endregion }
/// <summary> /// BUTTON 上面的刪除鈕 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void but_Up_Delete_Click(object sender, EventArgs e) { #region //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 刪除資料 ArrayList ParameterList = new ArrayList();//20091117 ParameterList.Clear(); ParameterList.Add(ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["ID"]); ParameterList.Add(ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["CODE"]); if (ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Columns.Contains("NAME") == true) { ParameterList.Add(ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["NAME"]); } else { ParameterList.Add(string.Empty); } if (ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Columns.Contains("BUSDATE") == true) { ParameterList.Add(ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["BUSDATE"]); } else { ParameterList.Add(string.Empty); } if (ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Columns.Contains("BUSUID") == true) { ParameterList.Add(ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["BUSUID"]); } else { ParameterList.Add(string.Empty); } if (ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Columns.Contains("CREATEDATE") == true) { ParameterList.Add(ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["CREATEDATE"]); } else { ParameterList.Add(string.Empty); } if (ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Columns.Contains("CREATEUID") == true) { ParameterList.Add(ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["CREATEUID"]); } else { ParameterList.Add(string.Empty); } if (ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Columns.Contains("UPDATEDATE") == true) { ParameterList.Add(ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["UPDATEDATE"]); } else { ParameterList.Add(string.Empty); } if (ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Columns.Contains("UPDATEUID") == true) { ParameterList.Add(ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["UPDATEUID"]); } else { ParameterList.Add(string.Empty); } if (ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Columns.Contains("STATUS") == true) { ParameterList.Add(ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["STATUS"]); } else { ParameterList.Add(string.Empty); } if (ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Columns.Contains("ENABLE") == true) { ParameterList.Add(ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["ENABLE"]); } else { ParameterList.Add(string.Empty); } ParameterList.Add(ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["CHAN_NO"]); ParameterList.Add(ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["STORE"]); if (ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Columns.Contains("ANSWER_TIME") == true) { ParameterList.Add(ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["ANSWER_TIME"]); } else { ParameterList.Add(string.Empty); } if (ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Columns.Contains("FAX_AREA") == true) { ParameterList.Add(ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["FAX_AREA"]); } else { ParameterList.Add(string.Empty); } if (ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Columns.Contains("FAX_NO") == true) { ParameterList.Add(ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["FAX_NO"]); } else { ParameterList.Add(string.Empty); } if (ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Columns.Contains("DEAL_CONTENT") == true) { ParameterList.Add(ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["DEAL_CONTENT"]); } else { ParameterList.Add(string.Empty); } if (ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Columns.Contains("REQUEST_MAN") == true) { ParameterList.Add(ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["REQUEST_MAN"]); } else { ParameterList.Add(string.Empty); } if (ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Columns.Contains("CRM_SOURCE") == true) { ParameterList.Add(ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["CRM_SOURCE"]); } else { ParameterList.Add(string.Empty); } if (ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Columns.Contains("STORE_GRADE") == true) { ParameterList.Add(ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["STORE_GRADE"]); } else { ParameterList.Add(string.Empty); } if (ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Columns.Contains("MAIL") == true) { ParameterList.Add(ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["MAIL"]); } else { ParameterList.Add(string.Empty); } ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(DateTime.Now); BCO.RecordCRMRecord bco = new BCO.RecordCRMRecord(ConntionDB); bco.DeletCRMRecord(ParameterList, null, ds_OldData.Tables["VDS_CRM_RECORD_DETL"]); #endregion #region 設定各個欄位的預設值 //Master this.slp_Up_CHAN_NO.Text = String.Empty;//通路 this.slp_Z_O.Text = String.Empty;//營業所 this.txt_CODE.Text = String.Empty;//流水編號 this.slp_STORE.Text = String.Empty;//門市 this.slp_Up_BUSDATE.Text = String.Empty;//處理日期 this.txt_ANSWER_TIME.Text = String.Empty;//接聽時間 this.slp_SAL_ID.Text = String.Empty;//營業人員 this.slp_BUSUID.Text = String.Empty;//處理人員 this.txt_ROUTD_ID.Text = String.Empty;//路線 this.txt_ROUTD_STEP.Text = String.Empty;//路順 this.txt_STORE_TEL_AREA.Text = String.Empty;//電話-區域號碼 this.txt_STORE_TEL_NO.Text = String.Empty;//電話號碼 this.txt_STORE_FAX_AREA.Text = String.Empty;//傳真-區域號碼 this.txt_STORE_FAX_NO.Text = String.Empty;//傳真號碼 this.txt_STORE_ADDRESS.Text = String.Empty;//地址 this.txt_DEAL_CONTENT.Text = String.Empty;//處理內容 //Detail foreach (ListItem li in this.chkbl_Detail.Items) { li.Selected = false; } #endregion #region 設定頁面模式 this.hid_Page_Status.Value = "QUERY"; this.txt_Page_Status.Text = "QUERY"; #endregion #region 設定各欄位模式ReadOnly this.slp_Up_CHAN_NO.ReadOnly = false; this.slp_Z_O.ReadOnly = false; this.txt_CODE.ReadOnly = false; this.txt_CODE.CssClass = ""; this.slp_STORE.ReadOnly = false; this.slp_Up_BUSDATE.ReadOnly = false; this.txt_ANSWER_TIME.ReadOnly = false; this.slp_SAL_ID.ReadOnly = false; this.slp_BUSUID.ReadOnly = false; this.txt_ROUTD_ID.ReadOnly = false; this.txt_ROUTD_ID.CssClass = ""; this.txt_ROUTD_STEP.ReadOnly = false; this.txt_ROUTD_STEP.CssClass = ""; this.txt_STORE_TEL_AREA.ReadOnly = false; this.txt_STORE_TEL_AREA.CssClass = ""; this.txt_STORE_TEL_NO.ReadOnly = false; this.txt_STORE_TEL_NO.CssClass = ""; this.txt_STORE_FAX_AREA.ReadOnly = false; this.txt_STORE_FAX_AREA.CssClass = ""; this.txt_STORE_FAX_NO.ReadOnly = false; this.txt_STORE_FAX_NO.CssClass = ""; this.txt_STORE_ADDRESS.ReadOnly = false; this.txt_STORE_ADDRESS.CssClass = ""; this.txt_DEAL_CONTENT.ReadOnly = false; this.txt_DEAL_CONTENT.CssClass = ""; #endregion System.Web.UI.ScriptManager.RegisterStartupScript(this.up_Button, this.GetType(), "TO_CRM011.aspx", "alert('刪除成功')", true); } } catch (Exception ex) { this.ErrorMsgLabel.Text = ex.Message; } finally { GetPageDefault(); } #endregion }
/// <summary> /// BUTTON 上面的存檔鈕 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void but_Up_Save_Click(object sender, EventArgs e) { #region //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_Z_O.Text.Trim() == string.Empty) { sb.Append("\"營業所\"欄位尚未設定\\r\\n"); } if (this.slp_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_ANSWER_TIME.Text.Trim() == string.Empty) { sb.Append("\"接聽時間\"欄位尚未設定\\r\\n"); } if (this.slp_SAL_ID.Text.Trim() == string.Empty) { sb.Append("\"營業人員\"欄位尚未設定\\r\\n"); } if (this.slp_BUSUID.Text.Trim() == string.Empty) { sb.Append("\"處理人員\"欄位尚未設定\\r\\n"); } // 2009-12-10 cyhsu :Insert 才檢查路線路順,因為歷史資料可能會沒有路線路順 if (this.hid_Page_Status.Value == "INSERT") { if (this.txt_ROUTD_ID.Text.Trim() == string.Empty) { sb.Append("\"路線\"欄位尚未設定\\r\\n"); } if (this.txt_ROUTD_STEP.Text.Trim() == string.Empty) { sb.Append("\"路順\"欄位尚未設定\\r\\n"); } } if (this.txt_DEAL_CONTENT.Text.Trim() == string.Empty) { sb.Append("\"處理內容\"欄位尚未設定\\r\\n"); } if (this.chkbl_Detail.SelectedIndex == -1) { sb.Append("\"服務項目\"[線上加量-D儲區]~[退返品查詢]至少必須勾選一個項目"); } if (GetStringLen(txt_DEAL_CONTENT.Text) > 600) { sb.Append("\"處理內容\"欄位資料長度太長\\r\\n"); } if (sb.ToString() != string.Empty) { ScriptManager.RegisterStartupScript(this.up_Button, this.GetType(), "TO_CRM011.aspx", "alert('" + sb.ToString() + "')", true); #region 設定頁面模式 this.hid_Page_Status.Value = "INSERT"; this.txt_Page_Status.Text = "INSERT"; #endregion return; } #endregion int i_Return_Id = 0; BCO.RecordCRMRecord bco = new BCO.RecordCRMRecord(ConntionDB); ArrayList ParameterList = new ArrayList();//20091117 if (this.hid_Page_Status.Value == "INSERT") { #region 整理明細服務項目資料 //取得 VDS_CRM_RECORD_DETL 的 SCHEMA //並將使用者選取資料放入 TEMP_TABLE ParameterList.Clear(); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(DateTime.Now); DataTable dt_Detail = bco.QuerySwitch(BCO.RecordCRMRecord.QueryType.CRM011_DETL_SCHEMA, ParameterList); DateTime d_Date_Now = DateTime.Now; foreach (ListItem li in this.chkbl_Detail.Items) { if (li.Selected == true) { DataRow dRow = dt_Detail.NewRow(); dRow["CREATEDATE"] = d_Date_Now; dRow["CREATEUID"] = Session["UID"].ToString(); dRow["UPDATEDATE"] = d_Date_Now; dRow["UPDATEUID"] = Session["UID"].ToString(); dRow["ONLINE_NO"] = li.Value; dRow["FLAG"] = 1; dt_Detail.Rows.Add(dRow); } } #endregion #region 處理新增資料 ParameterList.Clear(); ParameterList.Add(DateTime.ParseExact(this.slp_Up_BUSDATE.Text, "yyyy/MM/dd", null));//BUSDATE ParameterList.Add(this.slp_BUSUID.Text.Trim());//BUSUID ParameterList.Add(d_Date_Now);//CREATEDATE ParameterList.Add(Session["UID"].ToString());//CREATEUID ParameterList.Add(d_Date_Now);//UPDATEDATE ParameterList.Add(Session["UID"].ToString());//UPDATEUID ParameterList.Add(1);//STATUS ParameterList.Add(1);//ENABLE ParameterList.Add(this.slp_Up_CHAN_NO.Text.Trim());//CHAN_NO ParameterList.Add(this.slp_STORE.Text.Trim());//STORE ParameterList.Add(DateTime.ParseExact(this.txt_ANSWER_TIME.Text.Substring(0, 2) + ":" + txt_ANSWER_TIME.Text.Substring(2).Trim(), "HH:mm", null));//ANSWER_TIME ,yyyy/MM/dd HH:mm:ss ParameterList.Add(this.txt_STORE_FAX_AREA.Text.Trim());//FAX_AREA ParameterList.Add(this.txt_STORE_FAX_NO.Text.Trim());//FAX_NO ParameterList.Add(this.txt_DEAL_CONTENT.Text.Trim());//DEAL_CONTENT ParameterList.Add(Session["UID"].ToString());//V_LOG_UPDATEUID ParameterList.Add(DateTime.Now);//D_LOG_UPDATEDATE i_Return_Id = bco.CreateCRMRecord(ParameterList, null, dt_Detail); #endregion } else if (this.hid_Page_Status.Value == "EDIT") { #region 整理明細服務項目資料 DataSet ds_OldData = new DataSet(); DateTime d_Date_Now = DateTime.Now; #region 使用XML轉回DataSet System.IO.StringReader sr_OldData = new System.IO.StringReader(xml_OLDData.InnerHtml); ds_OldData.ReadXml(sr_OldData); #endregion #region 新增一個欄位,記錄狀態 DataColumn dColum = new DataColumn(); dColum.ColumnName = "STATUS"; dColum.DataType = System.Type.GetType("System.String"); ds_OldData.Tables["VDS_CRM_RECORD_DETL"].Columns.Add(dColum); #endregion #region 比對ds_OldData檔與CheckBox的資料,如果ds_OldData有CheckBox沒有,則註記該筆資料被使用者刪除 foreach (DataRow dRow in ds_OldData.Tables["VDS_CRM_RECORD_DETL"].Rows) { if (this.chkbl_Detail.Items.FindByValue(dRow["ONLINE_NO"].ToString()).Selected == false) { //如果使用者沒有勾選該筆資料,則將該筆資料從ds_OldData中移除 dRow["STATUS"] = "DELETE"; } } #endregion #region 比對CheckBox與ds_OldData檔的資料,如果CheckBox有ds_OldData沒有,則新增該筆資料進入ds_OldData,且註記該筆資料被使用者新增 foreach (ListItem li in this.chkbl_Detail.Items)//畫面上使用者選的通路 { if (li.Selected == true) { DataView dv_Detail = new DataView(); dv_Detail.Table = ds_OldData.Tables["VDS_CRM_RECORD_DETL"].Copy(); dv_Detail.RowFilter = "ONLINE_NO = '" + li.Value + "'"; if (dv_Detail.Count == 0) { DataRow dRow_New = (DataRow)ds_OldData.Tables["VDS_CRM_RECORD_DETL"].NewRow(); dRow_New["CREATEDATE"] = d_Date_Now; dRow_New["CREATEUID"] = Session["UID"].ToString(); dRow_New["UPDATEDATE"] = d_Date_Now; dRow_New["UPDATEUID"] = Session["UID"].ToString(); dRow_New["ONLINE_NO"] = li.Value; dRow_New["FLAG"] = 1; dRow_New["STATUS"] = "ADD"; ds_OldData.Tables["VDS_CRM_RECORD_DETL"].Rows.Add(dRow_New); } dv_Detail.Dispose(); }//if }//foreach #endregion #endregion #region 處理更新資料 ParameterList.Clear(); //新資料 ParameterList.Add(this.txt_DEAL_CONTENT.Text.Trim()); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(DateTime.Now); //舊資料 ParameterList.Add(ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["ID"]); ParameterList.Add(ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["CHAN_NO"]); ParameterList.Add(ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["CODE"]); ParameterList.Add(ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["STORE"]); ParameterList.Add(ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["BUSDATE"]); ParameterList.Add(ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["ANSWER_TIME"]); ParameterList.Add(ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["BUSUID"]); ParameterList.Add(ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["FAX_AREA"]); ParameterList.Add(ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["FAX_NO"]); ParameterList.Add(ds_OldData.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["DEAL_CONTENT"]); i_Return_Id = bco.UpdateCRMRecord(ParameterList, null, ds_OldData.Tables["VDS_CRM_RECORD_DETL"]); #endregion } #region 新增 & 更新後處理 if (i_Return_Id > 0)//代表新增或更新成功 { ParameterList.Clear(); ParameterList.Add(Session["UID"].ToString()); aryParamsPKey = bco.QueryIDForBROWSER(ParameterList); s_ID = i_Return_Id.ToString(); QueryDataAndSetControls(); #region 設定 PageStatus & Button 狀態 string s_Page_Status = string.Empty; s_Page_Status = this.hid_Page_Status.Value; this.hid_Page_Status.Value = "VIEW"; this.txt_Page_Status.Text = "VIEW"; #endregion if (s_Page_Status == "INSERT") {//在新增模式下按下"存檔"鈕 System.Web.UI.ScriptManager.RegisterStartupScript(this.up_Button, this.GetType(), "TO_CRM011.aspx", "alert('新增成功')", true); } else if (s_Page_Status == "EDIT") {//在編輯模式下按下"存檔"鈕 System.Web.UI.ScriptManager.RegisterStartupScript(this.up_Button, this.GetType(), "TO_CRM011.aspx", "alert('更新成功')", true); } } else { if (this.hid_Page_Status.Value == "INSERT") {//在新增模式下按下"存檔"鈕 System.Web.UI.ScriptManager.RegisterStartupScript(this.up_Button, this.GetType(), "TO_CRM011.aspx", "alert('新增失敗')", true); } else if (this.hid_Page_Status.Value == "EDIT") {//在編輯模式下按下"存檔"鈕 System.Web.UI.ScriptManager.RegisterStartupScript(this.up_Button, this.GetType(), "TO_CRM011.aspx", "alert('更新失敗')", true); } } #endregion } catch (Exception ex) { WaringLogProcess(ex.Message); this.ErrorMsgLabel.Text = ex.Message; } finally { GetPageDefault(); } #endregion }
/// <summary> /// BUTTON 查詢前三筆紀錄 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void but_Down_Record_Three_Click(object sender, EventArgs e) { try { #region 檢查條件 System.Text.StringBuilder sb = new System.Text.StringBuilder(); if (this.slp_Up_CHAN_NO.Text.Trim() == string.Empty) { sb.Append("欄位[通路]為必填欄位<br/>"); } if (this.slp_STORE.Text.Trim() == string.Empty) { sb.Append("欄位[門市]為必填欄位<br/>"); } if (sb.ToString() != string.Empty) { this.ErrorMsgLabel.Text = sb.ToString(); return; } #endregion #region 傳入參數 BCO.CRMCommon CRMComm = new BCO.CRMCommon(); ArrayList ParameterList = new ArrayList();//20091117 ParameterList.Clear(); ParameterList.Add(CRMComm.GetValueSetParameter(this.slp_Up_CHAN_NO.Text, "string", false)); ParameterList.Add(CRMComm.GetValueSetParameter(this.slp_STORE.Text, "string", false)); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(DateTime.Now); #endregion #region 連結資料庫 BCO.RecordCRMRecord bco = new BCO.RecordCRMRecord(ConntionDB); DataTable dt_Return = bco.QuerySwitch(BCO.RecordCRMRecord.QueryType.QueryLastThreeCRMRecord, ParameterList); #endregion #region 繫結GridView this.gv_Three.DataSource = dt_Return.DefaultView; this.gv_Three.DataBind(); #endregion #region 檢查回傳資料 if (dt_Return.Rows.Count == 0) { ScriptManager.RegisterStartupScript(this.up_Three, typeof(UpdatePanel), "隨便寫", "alert('查無資料!');", true); } #endregion } catch (Exception ex) { WaringLogProcess(ex.Message); this.ErrorMsgLabel.Text = ex.Message; } finally { GetPageDefault(); } }
/// <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 } }
//由流水號帶出來電資料 private bool Retrive_From_Code(string s_Code) { DataSet ds_Return = new DataSet(); ArrayList ParameterList = new ArrayList();//20091117 ParameterList.Clear(); ParameterList.Add(s_Code); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(DateTime.Now); BCO.RecordCRMRecord bco = new BCO.RecordCRMRecord(ConntionDB); ds_Return = bco.QueryCRMRecordByCode(ParameterList); if (ds_Return.Tables.Count != 0) { 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 = ((DateTime)ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["BUSDATE"]).ToString("yyyy/MM/dd");//處理日期 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();//地址 SetTabCrmRecordStatus(true); return true; } else { this.slp_up_CHAN_NO.Text = "";//通路 this.slp_up_Z_O.Text = "";//營業所 this.slp_up_STORE.Text = "";//門市 this.slp_up_BUSDATE.Text = "";//處理日期 this.txt_up_ANSWER_TIME.Text = "";//接聽時間 this.slp_up_SAL_ID.Text = "";//營業人員 this.slp_up_BUSUID.Text = "";//處理人員 this.txt_up_ROUTE_ID.Text = "";//路線 this.txt_up_ROUTE_STEP.Text = "";//路順 this.txt_up_STORE_TEL_AREA.Text = "";//電話-區域號碼 this.txt_up_STORE_TEL_NO.Text = "";//電話號碼 this.txt_up_FAX_AREA.Text = "";//傳真-區域號碼 this.txt_up_FAX_NO.Text = "";//傳真號碼 this.txt_up_STORE_ADDRESS.Text = "";//地址 return false; } }
/// <summary> /// 將變更後的內部變量this.CallBackValue返回給前台JavaScript方法ReceiveServerData(string Value)。 /// </summary> /// <returns></returns> string ICallbackEventHandler.GetCallbackResult() { try { System.Text.StringBuilder sb = new System.Text.StringBuilder(); DataSet ds_Return = new DataSet(); CallBackValue = CallBackValue.Trim(); string[] s_Client_String = System.Text.RegularExpressions.Regex.Split(CallBackValue, "<partition>", System.Text.RegularExpressions.RegexOptions.IgnoreCase); #region 離開欄位[流水編號] if (s_Client_String[0] == "離開欄位[流水編號]") { #region 傳入參數 ArrayList ParameterList = new ArrayList();//20091117 ParameterList.Clear(); ParameterList.Add(s_Client_String[1]); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(DateTime.Now); #endregion #region 取得資料 BCO.RecordCRMRecord bco = new BCO.RecordCRMRecord(ConntionDB); ds_Return = bco.QueryCRMRecordByCode(ParameterList); #endregion #region 檢查回傳資料,並將值傳至Client端 if (ds_Return.Tables.Count != 0) { sb.Remove(0, sb.Length); sb.Append("TRUE<partition>"); sb.Append(ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["CHAN_NO"] + "<partition>");//通路 sb.Append(ds_Return.Tables["VDS_STM_STORE"].Rows[0]["Z_O"] + "<partition>");//營業所 sb.Append(ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["STORE"] + "<partition>");//門市 sb.Append(((DateTime)ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["BUSDATE"]).ToString("yyyy/MM/dd") + "<partition>");//處理日期 sb.Append(((DateTime)ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["ANSWER_TIME"]).ToString("HH:mm") + "<partition>");//接聽時間 sb.Append(ds_Return.Tables["VDS_STM_STORE"].Rows[0]["SAL_ID"] + "<partition>");//營業人員 sb.Append(ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["BUSUID"] + "<partition>");//處理人員 sb.Append(ds_Return.Tables["VDS_STM_STORE"].Rows[0]["ROUTE_ID"] + "<partition>");//路線 sb.Append(ds_Return.Tables["VDS_STM_STORE"].Rows[0]["ROUTE_STEP"] + "<partition>");//路順 sb.Append(ds_Return.Tables["VDS_STM_STORE"].Rows[0]["STORE_TEL_AREA"] + "<partition>");//電話-區域號碼 sb.Append(ds_Return.Tables["VDS_STM_STORE"].Rows[0]["STORE_TEL_NO"] + "<partition>");//電話號碼 sb.Append(ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["FAX_AREA"] + "<partition>");//傳真-區域號碼 sb.Append(ds_Return.Tables["VDS_CRM_RECORD_MAIN"].Rows[0]["FAX_NO"] + "<partition>");//傳真號碼 sb.Append(ds_Return.Tables["VDS_STM_STORE"].Rows[0]["STORE_ADDRESS"] + "<partition>");//地址 CallBackValue = sb.ToString(); } else { sb.Append("FALSE<partition>"); sb.Append("無此流水編號[" + CallBackValue.Trim() + "]對應之來電記錄"); CallBackValue = sb.ToString(); } #endregion } #endregion #region [處理狀態]為[已處理]或[處理中] if (s_Client_String[0] == "[處理狀態]為[已處理]或[處理中]") { TextBox txt_down_CLOSE_DATE = (TextBox)this.slp_down_CLOSE_DATE.FindControl("TextBoxCode");//處理日期 TextBox CLOSE_TIME = (TextBox)(((ASP.wui_slp_slp_numberupdown_ascx)txt_down_CLOSE_TIME.FindControl("SLP_NumberUpDown1")).FindControl("TextBoxCode"));//處理時間 sb.Remove(0, sb.Length); sb.Append("TRUE<partition>"); sb.Append(DateTime.Now.ToString("yyyy/MM/dd") + "<partition_Detail>" + txt_down_CLOSE_DATE.ClientID + "<partition>"); sb.Append(DateTime.Now.ToString("HH:mm") + "<partition_Detail>" + CLOSE_TIME.ClientID); CallBackValue = sb.ToString(); } #endregion } catch (Exception ex) { CallBackValue = "FALSE<partition>" + ex.ToString(); } finally { } return CallBackValue; }