/// <summary> /// 把值傳到Client端 /// </summary> /// <returns></returns> public string GetCallbackResult() { //判斷值是否有重覆 string rtn = "", strResult = ""; ALOModel.MaintainDisStoreMemo BCO2 = new ALOModel.MaintainDisStoreMemo(ConnectionDB); DataTable dt = null; if (ObjectFrom.IndexOf("STORE") != -1) { ArrayList ParameterList = new ArrayList();//20091112 ParameterList.Clear(); ParameterList.Add(CallServerValue); dt = BCO2.QueryChanNoByStore(ParameterList); if (dt != null) { if (dt.Rows.Count > 0) rtn = string.Format("{0},{1}", dt.Rows[0][0].ToString(), dt.Rows[0][1].ToString()); } } //附加相關控制項 if (ObjectFrom.IndexOf("STORE") != -1) { if (ObjectFrom.IndexOf("1") != -1) { strResult = string.Format("{0},{1};{2}", SLP_StoreChain1.TextBox_Code.UniqueID, SLP_StoreChain1.TextBox_Name.UniqueID, rtn); } else if (ObjectFrom.IndexOf("2") != -1) { strResult = string.Format("{0},{1};{2}", SLP_StoreChain2.TextBox_Code.UniqueID, SLP_StoreChain2.TextBox_Name.UniqueID, rtn); } } return strResult; }
public static string GetChanByStoreAtServer(string str_Store) { #region string strResult = ""; try { string strChan_No = "", strChan_Name = "", strStore_Name = ""; DataTable dt = null; ALOModel.MaintainDisStoreMemo BCO = new ALOModel.MaintainDisStoreMemo(ConnectionDB); ArrayList ParameterList = new ArrayList(); ParameterList.Clear(); ParameterList.Add(str_Store); dt = BCO.QueryChanNoByStore(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(); } else { strStore_Name = "查無資料"; } strResult = string.Format("{0}||{1}||{2}", strChan_No, strChan_Name, strStore_Name); } catch (Exception ex) { throw ex; } return strResult; #endregion }
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 ALOModel.MaintainDisStoreMemo BCO2 = new ALOModel.MaintainDisStoreMemo(ConnectionDB); DataTable dt = null; string rtn = "", strResult = ""; string strChan_No = "", strChan_Name = "", strStore_Name = ""; string[] strAryArg; ArrayList ParameterList = new ArrayList();//20091113 if (ObjectFrom.IndexOf("STORE") != -1) { #region strAryArg = CallServerValue.Split("_".ToCharArray()); ParameterList.Clear(); ParameterList.Add(strAryArg[0]);//Store dt = BCO2.QueryChanNoByStore(ParameterList); if (dt != null) { if (dt.Rows.Count > 0) rtn = string.Format("{0}", dt.Rows[0][0].ToString()); } 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 != strAryArg[1] && strAryArg[1] != "") strStore_Name = "查無資料"; } else { strStore_Name = "查無資料"; } bool bCheck = CheckCanAddMain(strChan_No); rtn = string.Format("{0}-{1}-{2}-{3}-{4}", strChan_No, strChan_Name, strStore_Name, bCheck.ToString(), CurrentPageMode.ToString()); #endregion } else if (ObjectFrom.IndexOf("PERIOD") != -1) { #region strAryArg = CallServerValue.Split(";".ToCharArray()); if (GetTaxType(strAryArg[0], strAryArg[1])) { rtn = "X"; } else { rtn = "無此期別 [" + strAryArg[1].ToString() + "] 設定,請輸入其他期別"; } #endregion } //附加相關控制項 if (ObjectFrom.IndexOf("STORE") != -1) { TextBox txtStoreChain1 = (TextBox)SLP_StoreChain1.FindControl("TextBoxCode"); strResult = string.Format("{0};{1}", txtStoreChain1.ClientID, rtn); } else if (ObjectFrom.IndexOf("PERIOD") != -1) { #region strAryArg = CallServerValue.Split(";".ToCharArray()); strResult = string.Format("{0}-{1};{2}", strAryArg[2], SLP_ItemPeriod1.TextBox_Code.ClientID, rtn); #endregion } return strResult; #endregion }
protected void btn_SaveComment_Click(object sender, EventArgs e) { #region Button btnSave = sender as Button; Button btnEdit = (Button)FormView1.FindControl("btn_EditComment"); TextBox txt_Comment = (TextBox)FormView1.FindControl("txt_Comment"); 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"); string strMemo = hiddenMemo.Value.Trim(); if (SLP_StoreChain1.Text.Trim() != "" && SLP_Store1.Text.Trim() != "") { if (GetStringLen(strMemo) > 400) { ResultMsgLabel.Text = "備註限制200中文字"; //ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "ClientScript", "alert('備註限制200中文字');", true); } else { #region bool bResult = false; try { #region Data ArrayList ParameterList = new ArrayList();//20091112 ParameterList.Clear(); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(SLP_StoreChain1.Text.Trim()); ParameterList.Add(SLP_Store1.Text.Trim()); ParameterList.Add(strMemo == "無設定備註" ? "" : strMemo); #endregion ALOModel.MaintainDisStoreMemo BCO = new ALOModel.MaintainDisStoreMemo(ConnectionDB); bResult = BCO.CreateStoreMemo(ParameterList, null); if (!bResult) { throw new Exception("更新0筆資料!"); } else { ResultMsgLabel.Text = "更改完成"; //ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "ClientScript", "alert('更改完成');", true); } txt_Comment.Text = GetMemoByChanAndStore(); } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } finally { btnEdit.Enabled = true; btnSave.Enabled = false; txt_Comment.ReadOnly = true; } #endregion } } else { if (SLP_StoreChain1.Text.Trim() == "") { ResultMsgLabel.Text = "通路不可空白"; //ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "ClientScript", "alert('通路不可空白');", true); } else if (SLP_Store1.Text.Trim() == "") { ResultMsgLabel.Text = "門市不可空白"; //ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "ClientScript", "alert('門市不可空白');", true); } } #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 }
protected void btn_SaveComment_Click(object sender, EventArgs e) { #region if (SLP_StoreChain1.Text.Trim() != "" && SLP_Store1.Text.Trim() != "") { if (GetStringLen(txt_Comment.Text.Trim()) > 400) { ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "ClientScript", "alert('備註限制200中文字');", true); } else { #region bool bResult = false; try { #region Data ArrayList ParameterList = new ArrayList();//20091112 ParameterList.Clear(); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(SLP_StoreChain1.Text.Trim()); ParameterList.Add(SLP_Store1.Text.Trim()); ParameterList.Add(strRemark.Trim() == "無設定備註" ? "" : strRemark.Trim()); #endregion ALOModel.MaintainDisStoreMemo BCO = new ALOModel.MaintainDisStoreMemo(ConnectionDB); bResult = BCO.CreateStoreMemo(ParameterList, null); if (!bResult) { throw new Exception("更新0筆資料!"); } else { CheckByChanAndStore(); //ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "ClientScript", "alert('更改完成');", true); ResultMsgLabel.Text = "更改完成"; } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } finally { btn_EditComment.Enabled = true; btn_SaveComment.Enabled = false; txt_Comment.ReadOnly = true; } #endregion } } else { if (SLP_StoreChain1.Text.Trim() == "") { ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "ClientScript", "alert('通路不可空白');", true); } else if (SLP_Store1.Text.Trim() == "") { ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "ClientScript", "alert('門市不可空白');", true); } } //20090716 added if (CurrentPageMode == PageCurrentMode.Query || CurrentPageMode == PageCurrentMode.Readonly) { ScriptManager.RegisterStartupScript(this, this.GetType(), "", string.Format("SwitchControlDisplay('{0}','',0);", PanelMasterAndDetail.ClientID), true); } #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() { string rtn = "", strResult = ""; ALOModel.QueryALOCommon BCO = new ALOModel.QueryALOCommon(ConnectionDB); ALOModel.MaintainDisStoreMemo BCO2 = new ALOModel.MaintainDisStoreMemo(ConnectionDB); DataTable dt = null; string strChan_No = "", strChan_Name = "", strStore_Name = "", strItemStateDesc = ""; Int32 iResult = 0; ArrayList ParameterList = new ArrayList();//20091113 if (ObjectFrom.IndexOf("ITEM") != -1) { #region if (CallServerValue != "") { ParameterList.Clear(); ParameterList.Add(CallServerValue); strItemStateDesc = BCO.CheckCurrentItemState(ParameterList); } else { strItemStateDesc = "品號必填"; } rtn = string.Format("{0}", strItemStateDesc); #endregion } else if (ObjectFrom.IndexOf("STORE") != -1) { #region string[] strAry = CallServerValue.Split("_".ToCharArray()); ParameterList.Clear(); ParameterList.Add(strAry[0]);//Store dt = BCO2.QueryChanNoByStore(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("ITEM") != -1) { strResult = string.Format("{0};{1}", hiddenItemStateDesc.ClientID, rtn); } else if (ObjectFrom.IndexOf("STORE") != -1) { TextBox txtStoreChain2 = (TextBox)SLP_StoreChain2.FindControl("TextBoxCode"); strResult = string.Format("{0};{1}", txtStoreChain2.ClientID, rtn); } return strResult; }
/// <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 }
/// <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); ALOModel.MaintinDisPattern BCO5 = new ALOModel.MaintinDisPattern(ConnectionDB); DataTable dt = null; DataTable dt2 = null; DataTable dt3 = null; ArrayList ParameterList = new ArrayList();//20091113 if (ObjectFrom.IndexOf("STORE") != -1) { #region ParameterList.Clear(); ParameterList.Add(CallServerValue); dt = BCO2.QueryChanNoByStore(ParameterList); if (dt != null) { if (dt.Rows.Count > 0) rtn = string.Format("{0}", dt.Rows[0][0].ToString()); } #endregion } else if (ObjectFrom.IndexOf("PMA") != -1)//改由PageMethod執行 { dt = BCO5.QueryRootByPMA(CallServerValue); //ROOT if (dt != null && dt.Rows.Count > 0) rtn = string.Format("{0}", dt.Rows[0][0].ToString()); } else if (ObjectFrom.IndexOf("PATTERN") != -1)//改由PageMethod執行 { dt = BCO5.QueryPMAByPattern(CallServerValue); //ROOT-PMA if (dt != null && dt.Rows.Count > 0) rtn = string.Format("{0}-{1}", dt.Rows[0][1].ToString(), dt.Rows[0][0].ToString()); } TextBox txtStoreChain1 = (TextBox)SLP_StoreChain1.FindControl("TextBoxCode"); TextBox txtStoreChain2 = (TextBox)SLP_StoreChain2.FindControl("TextBoxCode"); TextBox txtRootNo1 = (TextBox)SLP_RootNo1.FindControl("TextBoxCode"); TextBox txtPMA1 = (TextBox)SLP_PMA1.FindControl("TextBoxCode"); TextBox txtRootNo2 = (TextBox)SLP_RootNo2.FindControl("TextBoxCode"); TextBox txtPMA3 = (TextBox)SLP_PMA2.FindControl("TextBoxCode"); //附加相關控制項 if (ObjectFrom.IndexOf("STORE") != -1) { if (ObjectFrom.IndexOf("2") != -1) { strResult = string.Format("{0},{1}", txtStoreChain2.ClientID, rtn); } } else if (ObjectFrom.IndexOf("PMA") != -1) { if (ObjectFrom.IndexOf("1") != -1) { strResult = string.Format("{0},{1}", txtRootNo1.ClientID, rtn); } else if (ObjectFrom.IndexOf("2") != -1) { strResult = string.Format("{0},{1}", txtRootNo2.ClientID, rtn); } } else if (ObjectFrom.IndexOf("PATTERN") != -1) { if (ObjectFrom.IndexOf("1") != -1) { strResult = string.Format("{0}-{1},{2}", txtRootNo1.ClientID, txtPMA1.ClientID, rtn); } else if (ObjectFrom.IndexOf("2") != -1) { strResult = string.Format("{0}-{1},{2}", txtRootNo2.ClientID, txtPMA3.ClientID, rtn); } } return strResult; #endregion }