private string GetMemoByChanAndStore() { #region string strResult = ""; try { STM_SLP_StoreChain SLP_StoreChain1 = ((STM_SLP_StoreChain)FormView1.FindControl("SLP_StoreChain1")); PIC.VDS2G.WebUI.SLP.SLP_Store SLP_Store1 = (PIC.VDS2G.WebUI.SLP.SLP_Store)FormView1.FindControl("SLP_Store1"); ALOModel.MaintainDisStoreMemo BCO2 = new ALOModel.MaintainDisStoreMemo(ConnectionDB); ArrayList ParameterList = new ArrayList();//20091112 ParameterList.Clear(); ParameterList.Add(SLP_StoreChain1.Text.Trim()); ParameterList.Add(SLP_Store1.Text.Trim()); DataTable dt2 = BCO2.QueryMemoByChanAndStore(ParameterList); if (dt2 != null && dt2.Rows.Count > 0) { strResult = dt2.Rows[0][0].ToString().Trim(); if (strResult == "") strResult = "無設定備註"; } else { strResult = "無設定備註"; } } catch (Exception ex) { throw ex; } return strResult; #endregion }
/// <summary> /// 把值傳到Client端 /// </summary> /// <returns></returns> public string GetCallbackResult() { #region string rtn = "", strResult = ""; try { ALOModel.MaintinDisPattern BCO = new ALOModel.MaintinDisPattern(ConnectionDB); ALOModel.MaintainDisStoreMemo BCO2 = new ALOModel.MaintainDisStoreMemo(ConnectionDB); ALOModel.MaintainStoreOrderItem BCO3 = new ALOModel.MaintainStoreOrderItem(ConnectionDB); ALOModel.MaintainStoreAssignItem BCO4 = new ALOModel.MaintainStoreAssignItem(ConnectionDB); DataTable dt = null; DataTable dt2 = null; DataTable dt3 = null; string strChan_No = "", strChan_Name = "", strStore = "", strStore_Name = "", strCommemt = "", strConfirm = "", strStoreStateDesc = ""; Int32 iResult = 0; if (ObjectFrom == "PMA")//改由PageMethod執行 { dt = BCO.QueryRootByPMA(CallServerValue); } else if (ObjectFrom == "PATTERN")//改由PageMethod執行 { dt = BCO.QueryPMAByPattern(CallServerValue); } else if (ObjectFrom == "ITEM")//改由PageMethod執行 { dt = BCO.QueryPMA_PatternByItem(CallServerValue); } else if (ObjectFrom == "STORE") { #region string[] strAry = CallServerValue.Split("_".ToCharArray()); ArrayList ParameterList = new ArrayList();//20091112 ParameterList.Clear(); ParameterList.Add(strAry[0]);//Store dt = BCO2.QueryChanNoByStore(ParameterList); dt3 = BCO3.CheckSettingStateByStore(ParameterList); if (dt != null && dt.Rows.Count > 0) { strChan_No = dt.Rows[0][0].ToString().Trim(); strChan_Name = dt.Rows[0][1].ToString().Trim(); strStore_Name = dt.Rows[0][3].ToString().Trim(); #region ParameterList.Clear(); ParameterList.Add(strAry[1] != "" ? strAry[1] : strChan_No);//Chan_No ParameterList.Add(strAry[0]);//Store dt2 = BCO2.QueryMemoByChanAndStore(ParameterList);//get memo #endregion if (strChan_No != strAry[1] && strAry[1] != "") strStore_Name = "查無資料"; ParameterList.Clear(); ParameterList.Add(dt.Rows[0][0].ToString()); ParameterList.Add(strAry[0]); strStoreStateDesc = BCO4.CheckByChanAndStore(ParameterList); if (strChan_No != strAry[1] && strAry[1] != "") strStoreStateDesc = "輸入門市不屬於輸入通路"; } else { strStore_Name = "查無資料"; strStoreStateDesc = "輸入門市不屬於輸入通路"; if (strAry[0] == "" || strAry[1] == "") strStoreStateDesc = "通路、門市必填"; } if (dt2 != null && dt2.Rows.Count > 0) { strCommemt = dt2.Rows[0][0].ToString().Trim(); if (strChan_No != strAry[1] && strAry[1] != "") strCommemt = ""; if (strCommemt == "") strCommemt = "無設定備註"; } else { strCommemt = "無設定備註"; } if (dt3 != null && dt3.Rows.Count > 0) { Int32.TryParse(dt3.Rows[0][0].ToString().Trim(), out iResult); strConfirm = iResult.ToString(); if (strChan_No != strAry[1]) strConfirm = "0"; } else { strConfirm = "0"; } rtn = string.Format("{0}||{1}||{2}||{3}||{4}||{5}", strChan_No, strChan_Name, strStore_Name, strCommemt, strConfirm, strStoreStateDesc); #endregion } if (dt != null) { if (dt.Rows.Count > 0) { if (ObjectFrom == "PMA") { //ROOT rtn = string.Format("{0}", dt.Rows[0][0].ToString()); } else if (ObjectFrom == "PATTERN") { //ROOT-PMA rtn = string.Format("{0}-{1}", dt.Rows[0][1].ToString(), dt.Rows[0][0].ToString()); } else if (ObjectFrom == "ITEM") { //ROOT-PMA-PATTERN rtn = string.Format("{0}-{1}-{2}", dt.Rows[0][2].ToString(), dt.Rows[0][0].ToString(), dt.Rows[0][1].ToString()); } } } //附加相關控制項 if (ObjectFrom == "PMA") { strResult = string.Format("{0},{1}", SLP_ROOT.TextBox_Code.ClientID, rtn); } else if (ObjectFrom == "PATTERN") { strResult = string.Format("{0}-{1},{2}", SLP_ROOT.TextBox_Code.ClientID, SLP_PMA.TextBox_Code.ClientID, rtn); } else if (ObjectFrom == "ITEM") { strResult = string.Format("{0}-{1}-{2},{3}", SLP_ROOT.TextBox_Code.ClientID, SLP_PMA.TextBox_Code.ClientID, SLP_Pattern.TextBox_Code.ClientID, rtn); } else if (ObjectFrom == "STORE") { strResult = string.Format("{0}||{1}||{2}||{3}||{4};{5}", ((TextBox)((STM_SLP_StoreChain)FormView1.FindControl("SLP_StoreChain1")).FindControl("TextBoxCode")).ClientID, ((TextBox)FormView1.FindControl("txt_Comment")).ClientID, hiddenCounts.ClientID, hiddenStoreStateDesc.ClientID, ((Button)FormView1.FindControl("btn_EditComment")).ClientID, rtn); } } catch (Exception ex) { throw ex; } return strResult; #endregion }
/// <summary> /// 把值傳到Client端 /// </summary> /// <returns></returns> public string GetCallbackResult() { #region string rtn = "", strResult = ""; ALOModel.MaintinDisPattern BCO = new ALOModel.MaintinDisPattern(ConnectionDB); ALOModel.MaintainDisStoreMemo BCO2 = new ALOModel.MaintainDisStoreMemo(ConnectionDB); ALOModel.MaintainStoreOrderItem BCO3 = new ALOModel.MaintainStoreOrderItem(ConnectionDB); ALOModel.MaintainStoreAssignItem BCO4 = new ALOModel.MaintainStoreAssignItem(ConnectionDB); DataTable dt = null; DataTable dt2 = null; DataTable dt3 = null; string strChan_No = "", strChan_Name = "", strStore_Name = "", strCommemt = "", strConfirm = "", strStoreStateDesc = ""; Int32 iResult = 0; if (ObjectFrom.IndexOf("STORE") != -1) { #region string[] strAry = CallServerValue.Split("_".ToCharArray()); ArrayList ParameterList = new ArrayList();//20091112 ParameterList.Clear(); ParameterList.Add(strAry[0]);//Store dt = BCO2.QueryChanNoByStore(ParameterList); dt3 = BCO3.CheckSettingStateByStore(ParameterList); if (dt != null && dt.Rows.Count > 0) { strChan_No = dt.Rows[0][0].ToString().Trim(); strChan_Name = dt.Rows[0][1].ToString().Trim(); strStore_Name = dt.Rows[0][3].ToString().Trim(); #region ParameterList.Clear(); ParameterList.Add(strAry[1] != "" ? strAry[1] : strChan_No);//Chan_No ParameterList.Add(strAry[0]);//Store dt2 = BCO2.QueryMemoByChanAndStore(ParameterList);//get memo #endregion if (strChan_No != strAry[1] && strAry[1] != "") strStore_Name = "查無資料"; ParameterList.Clear(); ParameterList.Add(dt.Rows[0][0].ToString()); ParameterList.Add(strAry[0]); strStoreStateDesc = BCO4.CheckByChanAndStore(ParameterList); if (strChan_No != strAry[1] && strAry[1] != "") strStoreStateDesc = "輸入門市不屬於輸入通路"; } else { strStore_Name = "查無資料"; strStoreStateDesc = "輸入門市不屬於輸入通路"; if(strAry[0]=="" || strAry[1] =="") strStoreStateDesc = "通路、門市必填"; } if (dt2 != null && dt2.Rows.Count > 0) { strCommemt = dt2.Rows[0][0].ToString().Trim(); if (strChan_No != strAry[1] && strAry[1] != "") strCommemt = ""; if (strCommemt == "") strCommemt = "無設定備註"; } else { strCommemt = "無設定備註"; } if (dt3 != null && dt3.Rows.Count > 0) { Int32.TryParse(dt3.Rows[0][0].ToString().Trim(), out iResult); strConfirm = iResult.ToString(); } else { strConfirm = "0"; } rtn = string.Format("{0}||{1}||{2}||{3}||{4}||{5}", strChan_No, strChan_Name, strStore_Name, strCommemt, strConfirm, strStoreStateDesc); #endregion } //附加相關控制項 if (ObjectFrom.IndexOf("STORE") != -1) { TextBox txtStoreChain1 = (TextBox)SLP_StoreChain1.FindControl("TextBoxCode"); TextBox txtStoreChain2 = (TextBox)SLP_StoreChain2.FindControl("TextBoxCode"); if (ObjectFrom.IndexOf("1") != -1) { strResult = string.Format("{0}||{1}||{2}||{3}||{4};{5}", txtStoreChain1.UniqueID, txt_Comment.UniqueID, hiddenCounts.UniqueID, hiddenStoreStateDesc.UniqueID, btn_EditComment.ClientID, rtn); } else if (ObjectFrom.IndexOf("2") != -1) { strResult = string.Format("{0}||{1}||{2}||{3}||{4};{5}", txtStoreChain2.UniqueID, txt_Comment.UniqueID, hiddenCounts.UniqueID, hiddenStoreStateDesc.UniqueID, btn_EditComment.ClientID, rtn); } } return strResult; #endregion }
private string GetMemoByChanAndStore() { #region string strResult = ""; try { ALOModel.MaintainDisStoreMemo BCO2 = new ALOModel.MaintainDisStoreMemo(ConnectionDB); ArrayList ParameterList = new ArrayList(); ParameterList.Clear(); ParameterList.Add(SLP_StoreChain1.Text.Trim()); ParameterList.Add(SLP_Store1.Text.Trim()); DataTable dt2 = BCO2.QueryMemoByChanAndStore(ParameterList); if (dt2 != null && dt2.Rows.Count > 0) { strResult = dt2.Rows[0][0].ToString().Trim(); if (strResult == "") strResult = "無設定備註"; } else { strResult = "無設定備註"; } } catch (Exception ex) { throw ex; } return strResult; #endregion }
private string GetStoreValueByPageMethod(string CallServerValue) { #region ALOModel.MaintainDisStoreMemo BCO2 = new ALOModel.MaintainDisStoreMemo(ConnectionDB); ALOModel.MaintainStoreOrderItem BCO3 = new ALOModel.MaintainStoreOrderItem(ConnectionDB); ALOModel.MaintainStoreAssignItem BCO4 = new ALOModel.MaintainStoreAssignItem(ConnectionDB); string rtn = ""; string strChan_No = "", strChan_Name = "", strStore_Name = "", strCommemt = "", strConfirm = "", strStoreStateDesc = ""; Int32 iResult = 0; string[] strAry = CallServerValue.Split("_".ToCharArray()); try { DataTable dt = null; DataTable dt2 = null; DataTable dt3 = null; ArrayList ParameterList = new ArrayList(); ParameterList.Clear(); ParameterList.Add(strAry[0]);//Store dt = BCO2.QueryChanNoByStore(ParameterList); dt3 = BCO3.CheckSettingStateByStore(ParameterList); if (dt != null && dt.Rows.Count > 0) { strChan_No = dt.Rows[0][0].ToString().Trim(); strChan_Name = dt.Rows[0][1].ToString().Trim(); strStore_Name = dt.Rows[0][3].ToString().Trim(); #region ParameterList.Clear(); ParameterList.Add(strAry[1] != "" ? strAry[1] : strChan_No);//Chan_No ParameterList.Add(strAry[0]);//Store dt2 = BCO2.QueryMemoByChanAndStore(ParameterList);//get memo #endregion if (strChan_No != strAry[1] && strAry[1] != "") strStore_Name = "查無資料"; ParameterList.Clear(); ParameterList.Add(dt.Rows[0][0].ToString()); ParameterList.Add(strAry[0]); strStoreStateDesc = BCO4.CheckByChanAndStore(ParameterList); if (strChan_No != strAry[1] && strAry[1] != "") strStoreStateDesc = "輸入門市不屬於輸入通路"; } else { strStore_Name = "查無資料"; strStoreStateDesc = "輸入門市不屬於輸入通路"; if (strAry[0] == "" || strAry[1] == "") strStoreStateDesc = "通路、門市必填"; } if (dt2 != null && dt2.Rows.Count > 0) { strCommemt = dt2.Rows[0][0].ToString().Trim(); if (strChan_No != strAry[1] && strAry[1] != "") strCommemt = ""; if (strCommemt == "") strCommemt = "無設定備註"; } else { strCommemt = "無設定備註"; } if (dt3 != null && dt3.Rows.Count > 0) { Int32.TryParse(dt3.Rows[0][0].ToString().Trim(), out iResult); strConfirm = iResult.ToString(); } else { strConfirm = "0"; } rtn = string.Format("{0}||{1}||{2}||{3}||{4}||{5}", strChan_No, strChan_Name, strStore_Name, strCommemt, strConfirm, strStoreStateDesc); } catch (Exception ex) { throw ex; } finally { BCO2.CloseConnection(); BCO3.CloseConnection(); BCO4.CloseConnection(); } return rtn; #endregion }
/// <summary> /// 把值傳到Client端 /// </summary> /// <returns></returns> public string GetCallbackResult() { #region string rtn = "", strResult = ""; ALOModel.MaintinDisPattern BCO = new ALOModel.MaintinDisPattern(ConnectionDB); ALOModel.MaintainDisStoreMemo BCO2 = new ALOModel.MaintainDisStoreMemo(ConnectionDB); ALOModel.MaintainStoreOrderItem BCO3 = new ALOModel.MaintainStoreOrderItem(ConnectionDB); ALOModel.MaintainStoreAssignItem BCO4 = new ALOModel.MaintainStoreAssignItem(ConnectionDB); DataTable dt = null; DataTable dt2 = null; DataTable dt3 = null; string strChan_No = "", strChan_Name = "", strStore_Name = "", strCommemt = "", strConfirm = "", strStoreStateDesc = ""; Int32 iResult = 0; if (ObjectFrom.IndexOf("STORE") != -1) { #region string[] strAry = CallServerValue.Split("_".ToCharArray()); ArrayList ParameterList = new ArrayList();//20091112 ParameterList.Clear(); ParameterList.Add(strAry[0]);//Store dt = BCO2.QueryChanNoByStore(ParameterList); dt3 = BCO3.CheckSettingStateByStore(ParameterList); ParameterList.Clear(); ParameterList.Add(strAry[1]);//Chan_No ParameterList.Add(strAry[0]);//Store dt2 = BCO2.QueryMemoByChanAndStore(ParameterList); if (dt != null && dt.Rows.Count > 0) { strChan_No = dt.Rows[0][0].ToString().Trim(); strChan_Name = dt.Rows[0][1].ToString().Trim(); strStore_Name = dt.Rows[0][3].ToString().Trim(); if (strChan_No != strAry[1] && strAry[1] != "") strStore_Name = "查無資料"; } else { strStore_Name = "查無資料"; } rtn = string.Format("{0}-{1}-{2}", strChan_No, strChan_Name, strStore_Name); #endregion } //附加相關控制項 if (ObjectFrom.IndexOf("STORE") != -1) { strResult = string.Format("{0};{1}", SLP_StoreChain3.TextBox_Code.ClientID, rtn); } return strResult; #endregion }