private string ProcessQueryItemClassInfo(string strParamValue, string strCtrlCallingFrom, string strRootNoClientID, string strPMAClientID, string strPatternClientID,string strItemClientID) { #region string strCallbackResult = ""; try { ALOModel.QueryALOCommon BCO = new ALOModel.QueryALOCommon(ConnectionDB); DataTable dt = null; ArrayList ParameterList = new ArrayList();//20091111 ParameterList.Clear(); if (strCtrlCallingFrom == "PMA") { ParameterList.Add(strParamValue); ParameterList.Add(null); ParameterList.Add(null); dt = BCO.QueryItemClassInfo(ParameterList); } else if (strCtrlCallingFrom == "PATTERN") { ParameterList.Add(null); ParameterList.Add(strParamValue); ParameterList.Add(null); dt = BCO.QueryItemClassInfo(ParameterList); } else if (strCtrlCallingFrom == "ITEM") { ParameterList.Add(null); ParameterList.Add(null); ParameterList.Add(strParamValue); dt = BCO.QueryItemClassInfo(ParameterList); } if (dt != null) { if (dt.Rows.Count > 0) { string strCtrlPending = "";//附加相關控制項 string strItemClassInfo = ""; strItemClassInfo = string.Format("{0},{1},{2},{3},{4},{5},{6},{7}", dt.Rows[0][0].ToString(), dt.Rows[0][1].ToString(), dt.Rows[0][2].ToString(), dt.Rows[0][3].ToString(), dt.Rows[0][4].ToString(), dt.Rows[0][5].ToString(), dt.Rows[0][6].ToString(), dt.Rows[0][7].ToString()); if (strCtrlCallingFrom == "PMA") { //ROOT strCtrlPending = string.Format("{0},{1},{2},{3}", strRootNoClientID, strPMAClientID, "null", "null"); } else if (strCtrlCallingFrom == "PATTERN") { //ROOT-PMA strCtrlPending = string.Format("{0},{1},{2},{3}", strRootNoClientID, strPMAClientID, strPatternClientID, "null"); } else if (strCtrlCallingFrom == "ITEM") { //ROOT-PMA-PATTERN strCtrlPending = string.Format("{0},{1},{2},{3}", strRootNoClientID, strPMAClientID, strPatternClientID, strItemClientID); } strCallbackResult = string.Format("{0};{1}", strCtrlPending, strItemClassInfo); } } } catch (Exception ex) { throw ex; } return strCallbackResult; #endregion }
/// <summary> /// 把值傳到Client端 /// </summary> /// <returns></returns> public string GetCallbackResult() { #region string rtn = "", strResult = ""; try { #region OLD //ALOModel.MaintinDisPattern BCO = new ALOModel.MaintinDisPattern(ConnectionDB); //DataTable dt = null; //if (ObjectFrom == "PMA") //{ // dt = BCO.QueryRootByPMA(CallServerValue); //} //else if (ObjectFrom == "PATTERN") //{ // dt = BCO.QueryPMAByPattern(CallServerValue); //} //else if (ObjectFrom == "ITEM") //{ // dt = BCO.QueryPMA_PatternByItem(CallServerValue); //} //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}", ((TextBox)SLP_ROOT1.FindControl("TextBoxCode")).ClientID, rtn); //} //else if (ObjectFrom == "PATTERN") //{ // strResult = string.Format("{0}-{1},{2}", ((TextBox)SLP_ROOT1.FindControl("TextBoxCode")).ClientID, ((TextBox)SLP_PMA1.FindControl("TextBoxCode")).ClientID, rtn); //} //else if (ObjectFrom == "ITEM") //{ // strResult = string.Format("{0}-{1}-{2},{3}", ((TextBox)SLP_ROOT1.FindControl("TextBoxCode")).ClientID, ((TextBox)SLP_PMA1.FindControl("TextBoxCode")).ClientID, ((TextBox)SLP_Pattern1.FindControl("TextBoxCode")).ClientID, rtn); //} #endregion #region NEW if (CallServerValue.Trim() == "") return strResult; ALOModel.QueryALOCommon BCO = new ALOModel.QueryALOCommon(ConnectionDB); DataTable dt = null; ArrayList ParameterList = new ArrayList();//20091111 ParameterList.Clear(); if (ObjectFrom == "PMA")//改由PageMethod執行 { ParameterList.Add(CallServerValue); ParameterList.Add(null); ParameterList.Add(null); dt = BCO.QueryItemClassInfo(ParameterList); } else if (ObjectFrom == "PATTERN")//改由PageMethod執行 { ParameterList.Add(null); ParameterList.Add(CallServerValue); ParameterList.Add(null); dt = BCO.QueryItemClassInfo(ParameterList); } else if (ObjectFrom == "ITEM")//改由PageMethod執行 { ParameterList.Add(null); ParameterList.Add(null); ParameterList.Add(CallServerValue); dt = BCO.QueryItemClassInfo(ParameterList); } if (dt != null) { if (dt.Rows.Count > 0) { string strCtrlPending = "";//附加相關控制項 string strItemClassInfo = ""; strItemClassInfo = string.Format("{0},{1},{2},{3},{4},{5},{6},{7}", dt.Rows[0][0].ToString(), dt.Rows[0][1].ToString(), dt.Rows[0][2].ToString(), dt.Rows[0][3].ToString(), dt.Rows[0][4].ToString(), dt.Rows[0][5].ToString(), dt.Rows[0][6].ToString(), dt.Rows[0][7].ToString()); if (ObjectFrom == "PMA") { //ROOT strCtrlPending = string.Format("{0},{1},{2},{3}", SLP_ROOT1.TextBox_Code.ClientID, SLP_PMA1.TextBox_Code.ClientID, "null", "null"); } else if (ObjectFrom == "PATTERN") { //ROOT-PMA strCtrlPending = string.Format("{0},{1},{2},{3}", SLP_ROOT1.TextBox_Code.ClientID, SLP_PMA1.TextBox_Code.ClientID, SLP_Pattern1.TextBox_Code.ClientID, "null"); } else if (ObjectFrom == "ITEM") { //ROOT-PMA-PATTERN strCtrlPending = string.Format("{0},{1},{2},{3}", SLP_ROOT1.TextBox_Code.ClientID, SLP_PMA1.TextBox_Code.ClientID, SLP_Pattern1.TextBox_Code.ClientID, SLP_SKU1.TextBox_Code.ClientID); } strResult = string.Format("{0};{1}", strCtrlPending, strItemClassInfo); } } #endregion } catch (Exception ex) { throw ex; } return strResult; #endregion }
public static string GetRootNoByPMAAtServer(string str_PMA) { #region string strResult = ""; try { string strRoot_No = "", strRoot_Name = "", strPMA_Name = ""; ALOModel.QueryALOCommon BCO = new ALOModel.QueryALOCommon(ConnectionDB); DataTable dt = null; ArrayList ParameterList = new ArrayList(); ParameterList.Clear(); ParameterList.Add(str_PMA); ParameterList.Add(null); ParameterList.Add(null); dt = BCO.QueryItemClassInfo(ParameterList); //回傳完整商品ID、NAME資訊(群分類、大分類、Pattern、Item) //0,1:ROOT //2,3:PMA //4,5:PATTERN //6,7:ITEM if (dt != null) { if (dt.Rows.Count > 0) { strRoot_No = dt.Rows[0][0].ToString(); strRoot_Name = dt.Rows[0][1].ToString(); strPMA_Name = dt.Rows[0][3].ToString(); } } strResult = string.Format("{0}||{1}||{2}", strRoot_No, strRoot_Name, strPMA_Name); } catch (Exception ex) { throw ex; } return strResult; #endregion }