/// <summary>
/// 將變更後的內部變量this.CallBackValue返回給前台JavaScript方法ReceiveServerData(string Value)。
/// </summary>
/// <returns></returns>
string ICallbackEventHandler.GetCallbackResult()
{
if (CallBackValue != string.Empty)
{
try
{
TextBox txt_CHAN_NO = (TextBox)((ASP.stm_slp_slp_storechain_ascx)slp_CHAN_NO).FindControl("TextBoxCode");//通路
TextBox txt_STORE = (TextBox)((ASP.stm_slp_slp_store_ascx)slp_STORE).FindControl("TextBoxCode");//門市
TextBox txt_ITEM = (TextBox)((ASP.itm_slp_slp_sku_ascx)slp_ITEM).FindControl("TextBoxCode");//品號
TextBox txt_PERIOD = (TextBox)((ASP.itm_slp_slp_itemperiod_ascx)slp_PERIOD).FindControl("TextBoxCode");//期別
System.Text.StringBuilder sb = new System.Text.StringBuilder();
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] == "離開欄位[@門市]")
{
#region 從資料庫查詢資料
ParameterList.Clear();
ParameterList.Add(s_Client_String[1]);//門市
ParameterList.Add(string.Empty);//通路
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
if (dt_Return.Rows.Count == 0)
{
sb.Append("離開欄位[@門市]<partition>");
sb.Append("FALSE<partition>");
sb.Append("查無資料<partition>");
sb.Append(txt_STORE.ClientID + "<partition>");//設定焦點的欄位
sb.Append(txt_CHAN_NO.ClientID);
}
else
{
sb.Append("離開欄位[@門市]<partition>");
sb.Append("TRUE<partition>");
sb.Append(dt_Return.Rows[0]["CHAN_NO"].ToString() + "<partition_Detail>" + txt_CHAN_NO.ClientID);
}
}
#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_BARCODE.ClientID + "<partition>");//設定焦點的欄位
sb.Append(this.txt_PERIOD_BARCODE.ClientID + "<partition>");
sb.Append(txt_ITEM.ClientID + "<partition>");
sb.Append(txt_PERIOD.ClientID);
}
else
{
sb.Append("異動欄位[@二段碼]設定值後<partition>");
sb.Append("TRUE<partition>");
sb.Append(dt_Return.Rows[0]["ITEM"].ToString() + "<partition_Detail>" + txt_ITEM.ClientID + "<partition>");
sb.Append(dt_Return.Rows[0]["PERIOD"].ToString() + "<partition_Detail>" + txt_PERIOD.ClientID);
}
}
#endregion
#region 異動欄位[@品號/品名]設定值後
else if (s_Client_String[0] == "異動欄位[@品號/品名]設定值後")
{
#region 從資料庫查詢資料
ParameterList.Clear();
ParameterList.Add(s_Client_String[1]);//品號
ParameterList.Add(Session["UID"].ToString());
DataTable dt_Return_1 = new DataTable();
BCO.QueryCRMCommon bco = new BCO.QueryCRMCommon(ConntionDB);
dt_Return_1 = bco.GetMaxDeiveryPeriod(ParameterList);
#endregion
if (dt_Return_1.Rows[0]["PERIOD"].ToString() == string.Empty)
{
sb.Append("異動欄位[@品號/品名]設定值後<partition>");
sb.Append("FALSE<partition>");
sb.Append("查無資料<partition>");
sb.Append(txt_ITEM.ClientID);//設定焦點的欄位
}
else
{
sb.Append("異動欄位[@品號/品名]設定值後<partition>");
sb.Append("TRUE<partition>");
sb.Append(dt_Return_1.Rows[0]["PERIOD"].ToString() + "<partition_Detail>" + txt_PERIOD.ClientID);
}
}
#endregion
CallBackValue = sb.ToString();
}
catch (Exception ex)
{ CallBackValue = "發生例外錯誤<partition>" + ex.Message; }
}
return CallBackValue;
}
/// <summary>
/// 異動欄位[@品號/品名]設定值後
/// </summary>
/// <param name="strItem"></param>
/// <param name="strUserID"></param>
/// <returns></returns>
private DataTable GetPeriodByItem(string strItem,string strUserID)
{
#region
try
{
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(strItem);//品號
ParameterList.Add(strUserID);
CRMModel.QueryCRMCommon BCO = new CRMModel.QueryCRMCommon(ConnectionDB);
return BCO.GetMaxDeiveryPeriod(ParameterList);
}
catch (Exception ex)
{
throw ex;
}
#endregion
}
