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
}
