}//Page_Load
private void QueryData()
{
#region
string SessionIDName = string.Format("{0}_{1}", strPrefixed, PageTimeStamp.Value);
DataTable dt = new DataTable();
ALOModel.MaintainStoreOrderItem BCO = new ALOModel.MaintainStoreOrderItem(ConnectionDB);
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(this.SLP_StoreChain1.Text);
ParameterList.Add(this.SLP_StoreChain2.Text);
ParameterList.Add(this.SLP_Z_O1.Text);
ParameterList.Add(this.SLP_Z_O2.Text);
ParameterList.Add(this.SLP_Store1.Text);
ParameterList.Add(this.SLP_Store2.Text);
Int32 iTopRowNum;
Int32.TryParse(TextBoxRowCountLimit.Text.Trim(), out iTopRowNum);
ParameterList.Add(iTopRowNum);
dt = BCO.QueryStore(ParameterList);
bAfterQueryDataBinding = true;
if (!dt.Columns.Contains("CHECKED"))
dt.Columns.Add("CHECKED");
if (!dt.Columns.Contains("ROWID"))//判別勾選與否
dt.Columns.Add("ROWID");
hidden_RowID_MaxID.Value = dt == null ? "-1" : (dt.Rows.Count - 1).ToString();//記錄最大ROWID
hidden_RowID_Selected.Value = "";//清空已選ROWID
Session[SessionIDName] = dt;
SetRowIDToDataTable(true);//設定ROWID
GridView1.DataSource = dt;
GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) <= 0) ? 10 : int.Parse(TextBoxPagesize.Text);
GridView1.PageIndex = 0;
GridView1.DataBind();
GridView1.SelectedIndex = -1;
GridView2.DataSource = null;
GridView2.DataBind();
bAfterQueryDataBinding = false;
LabelQueryRecordCount.Text = string.Format(" {0} Rows ", dt.Rows.Count.ToString());
if (dt == null || (dt != null && dt.Rows.Count <= 0))
{
ResultMsgLabel.Text = "查無資料";
}
#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_Exec_Click(object sender, EventArgs e)
{
try
{
if (CheckInputValuesNotNull())
{
if (SLP_SKU1.Text.Trim() == SLP_SKU2.Text.Trim())
{
ResultMsgLabel.Text = "品號不可相同";
return;
}
ALOModel.MaintainStoreOrderItem BCO = new PIC.VDS2G.BSM.ALO.MaintainStoreOrderItem(ConnectionDB);
bool bResult = BCO.CopyToNewItem(GetInputValues(), null);
if (bResult)
{
ResultMsgLabel.Text = "複製成功";
}
else
{
ResultMsgLabel.Text = "複製失敗";
}
}
else
{
ResultMsgLabel.Text = "欄位不可空白";
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
finally
{
fmStatus = FormStatus.fmBrowse;
}
}
private bool CheckStoreOrderItemCanAdd(ArrayList ParameterList)
{
#region
bool bResult = false;
try
{
ALOModel.MaintainStoreOrderItem BCO = new ALOModel.MaintainStoreOrderItem(ConnectionDB);
string strErrMsg = "";
bResult = BCO.CheckStoreOrderItemCanAdd(ParameterList, ref strErrMsg);
if (!bResult && strErrMsg != "")
{
ErrorMsgLabel.Text = strErrMsg;
//ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "ClientScript", string.Format("alert('{0}');", strErrMsg), true);
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
return bResult;
#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
}
protected void SmartGridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
#region
try
{
bool bResult = false;
#region 取得畫面元件的值
DateTime processtime = DateTime.Now;
#endregion
#region 取得刪除前舊值
Label lbl_ID = (Label)SmartGridView1.Rows[e.RowIndex].FindControl("lbl_ID");
SetTmpDataForMaster(lbl_ID.Text.Trim());//將CurrentRow的值塞入暫存master
DataTable dtTemp = dtForMaster;
if (dtTemp == null || dtTemp.Rows.Count == 0)
{
throw new Exception("抓取不到舊值,更新失敗!");
}
#endregion
#region 加入更新條件
//master
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
//舊值
ParameterList.Add(dtTemp.Rows[0]["ID"]);
ParameterList.Add(dtTemp.Rows[0]["CODE"]);
ParameterList.Add(dtTemp.Rows[0]["ENABLE"]);
ParameterList.Add(dtTemp.Rows[0]["CREATEDATE"]);
ParameterList.Add(dtTemp.Rows[0]["CREATEUID"]);
ParameterList.Add(dtTemp.Rows[0]["UPDATEDATE"]);
ParameterList.Add(dtTemp.Rows[0]["UPDATEUID"]);
ParameterList.Add(dtTemp.Rows[0]["CHAN_NO"]);
ParameterList.Add(dtTemp.Rows[0]["STORE"]);
ParameterList.Add(dtTemp.Rows[0]["ITEM"]);
ParameterList.Add(dtTemp.Rows[0]["PERIOD_ST"]);
ParameterList.Add(dtTemp.Rows[0]["PERIOD_END"]);
ParameterList.Add(dtTemp.Rows[0]["ORDER_QTY"]);
ParameterList.Add(dtTemp.Rows[0]["BUY_FLAG"]);
ParameterList.Add(dtTemp.Rows[0]["REASON"]);
//需要更新值
ParameterList.Add(processtime);
ParameterList.Add(Session["UID"].ToString());
#endregion
ALOModel.MaintainStoreOrderItem BCO = new ALOModel.MaintainStoreOrderItem(ConnectionDB);
bResult = BCO.DeleteMaster(ParameterList, null);
//ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "ClientScript", "alert('刪除完成');", true);
ResultMsgLabel.Text = "刪除完成";
QueryData();
CurrentPageMode = PageCurrentMode.Readonly;
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
#endregion
}
/// <summary>
/// 繫結資料到控制項
/// </summary>
/// <param name="vdb"></param>
private void QueryData()
{
#region
if (rBtn_STORE.Checked)
{
if (SLP_StoreChain1.Text.Trim() == "" || SLP_Store1.Text.Trim() == "")
{
ErrorMsgLabel.Text = "通路門市資料為必填";
CurrentPageMode = PageCurrentMode.Query;
return;
}
}
else if (rBtn_ITEM.Checked)
{
if (SLP_SKU1.Text == "")
{
ErrorMsgLabel.Text = "品號為必填";
CurrentPageMode = PageCurrentMode.Query;
return;
}
}
else
{
ErrorMsgLabel.Text = "請選擇查詢方式";
CurrentPageMode = PageCurrentMode.Query;
return;
}
LabelQueryRecordCount.Text = "";
string SessionIDName = string.Format("{0}_{1}", PAGE_DT_01, PageTimeStamp.Value);
ALOModel.MaintainStoreOrderItem BCO = new ALOModel.MaintainStoreOrderItem(ConnectionDB);
//2010/04/13 modified:for performance DataTable Dt = BCO.QueryStoreOrderItemByFind(GetInputValues());
DataTable Dt = BCO.QueryStoreOrderItemByFind2(GetInputValues());
Session[SessionIDName] = Dt;
SmartGridView1.DataSource = Dt;
SmartGridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) <= 0) ? 10 : int.Parse(TextBoxPagesize.Text);
if (!(CurrentPageMode == PageCurrentMode.Query || CurrentPageMode == PageCurrentMode.Readonly))
{
SmartGridView1.PageIndex = GetPageIndexByParam(SLP_SKU3.Text.Trim());
}
else
{
SmartGridView1.PageIndex = 0;
}
SmartGridView1.DataBind();
LabelQueryRecordCount.Text = string.Format(" {0} Rows ", Dt.Rows.Count.ToString());
if (Dt == null || (Dt != null && Dt.Rows.Count <= 0))
{
if (btn_Export.Visible == true)
{
btn_Export.Enabled = false;
}
//ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "ClientScript", "alert('查無資料');", true);
ResultMsgLabel.Text = "查無資料";
CurrentPageMode = PageCurrentMode.Query;
}
else
{
if (btn_Export.Visible == true)
{
btn_Export.Enabled = true;
}
LastPageMode = PageCurrentMode.Query;
CurrentPageMode = PageCurrentMode.Readonly;
}
if (rBtn_STORE.Checked)
{
btn_EditComment.Enabled = true;
}
else
{
btn_EditComment.Enabled = false;
}
#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
}
protected void btn_Save_Click(object sender, EventArgs e)
{
#region
if (CurrentPageMode == PageCurrentMode.Edit)
{
#region
bool bResult = false;
try
{
#region Master
#region New
ArrayList ParameterListNew = new ArrayList();
ParameterListNew.Clear();
string strCode = string.Format("{0}_{1}_{2}_{3}_{4}",
SLP_StoreChain2.Text.Trim(), SLP_Store2.Text.Trim(), SLP_SKU3.Text.Trim(), SLP_ItemPeriod5.Text.Trim(), SLP_ItemPeriod6.Text.Trim());
ParameterListNew.Add(strCode);
ParameterListNew.Add(Session["UID"].ToString());
ParameterListNew.Add(SLP_StoreChain2.Text.Trim());
ParameterListNew.Add(SLP_Store2.Text.Trim());
ParameterListNew.Add(SLP_SKU3.Text.Trim());
ParameterListNew.Add(SLP_ItemPeriod5.Text.Trim());
ParameterListNew.Add(SLP_ItemPeriod6.Text.Trim());
ParameterListNew.Add(SLP_Number1.Text.Trim());
ParameterListNew.Add(((CheckBox)this.SLP_Boolean1.FindControl("C1")).Checked ? "1" : "0");
ParameterListNew.Add(strReason.Trim());
#endregion
#region Original
DataTable dtTemp = dtForMaster;
if (dtTemp == null || dtTemp.Rows.Count == 0)
{
throw new Exception("抓取不到舊值,更新失敗!");
}
DateTime processtime = DateTime.Now;
ArrayList ParameterListOriginal = new ArrayList();
ParameterListOriginal.Clear();
//舊值
ParameterListOriginal.Add(dtTemp.Rows[0]["ID"]);
ParameterListOriginal.Add(dtTemp.Rows[0]["CODE"]);
ParameterListOriginal.Add(dtTemp.Rows[0]["ENABLE"]);
ParameterListOriginal.Add(dtTemp.Rows[0]["CREATEDATE"]);
ParameterListOriginal.Add(dtTemp.Rows[0]["CREATEUID"]);
ParameterListOriginal.Add(dtTemp.Rows[0]["UPDATEDATE"]);
ParameterListOriginal.Add(dtTemp.Rows[0]["UPDATEUID"]);
ParameterListOriginal.Add(dtTemp.Rows[0]["CHAN_NO"]);
ParameterListOriginal.Add(dtTemp.Rows[0]["STORE"]);
ParameterListOriginal.Add(dtTemp.Rows[0]["ITEM"]);
ParameterListOriginal.Add(dtTemp.Rows[0]["PERIOD_ST"]);
ParameterListOriginal.Add(dtTemp.Rows[0]["PERIOD_END"]);
ParameterListOriginal.Add(dtTemp.Rows[0]["ORDER_QTY"]);
ParameterListOriginal.Add(dtTemp.Rows[0]["BUY_FLAG"]);
ParameterListOriginal.Add(dtTemp.Rows[0]["REASON"]);
//需要更新值
ParameterListOriginal.Add(processtime);
ParameterListOriginal.Add(Session["UID"].ToString());
#endregion
ALOModel.MaintainStoreOrderItem BCO = new ALOModel.MaintainStoreOrderItem(ConnectionDB);
if (s_PERIOD_ST == SLP_ItemPeriod5.Text.Trim() && s_PERIOD_END == SLP_ItemPeriod6.Text.Trim())
{
bResult = BCO.UpdateMaster(ParameterListNew, null);
}
else
{
bResult = BCO.UpdateMaster_PKEditable(ParameterListOriginal, ParameterListNew, null);
}
if (!bResult)
{
throw new Exception("更新0筆資料!");
}
else
{
//ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "ClientScript", "alert('更改完成');", true);
ResultMsgLabel.Text = "更改完成";
QueryData();
CurrentPageMode = PageCurrentMode.Readonly;
//PanelMasterAndDetail.Visible = false;
}
#endregion
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
#endregion
}
else if (CurrentPageMode == PageCurrentMode.Insert)
{
#region
Int32 iResult = 0;
try
{
ArrayList ParameterList1 = new ArrayList();
ParameterList1.Clear();
ParameterList1.Add(SLP_StoreChain2.Text.Trim());
ParameterList1.Add(SLP_Store2.Text.Trim());
ParameterList1.Add(SLP_SKU3.Text.Trim());
ParameterList1.Add(SLP_ItemPeriod5.Text.Trim());
ParameterList1.Add(SLP_ItemPeriod6.Text.Trim());
if (CheckStoreOrderItemCanAdd(ParameterList1))
{
#region
#region Master
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
string strCode = string.Format("{0}_{1}_{2}_{3}_{4}",
SLP_StoreChain2.Text.Trim(), SLP_Store2.Text.Trim(), SLP_SKU3.Text.Trim(), SLP_ItemPeriod5.Text.Trim(), SLP_ItemPeriod6.Text.Trim());
ParameterList.Add(strCode);
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(SLP_StoreChain2.Text.Trim());
ParameterList.Add(SLP_Store2.Text.Trim());
ParameterList.Add(SLP_SKU3.Text.Trim());
ParameterList.Add(SLP_ItemPeriod5.Text.Trim());
ParameterList.Add(SLP_ItemPeriod6.Text.Trim());
ParameterList.Add(SLP_Number1.Text.Trim());
ParameterList.Add(((CheckBox)this.SLP_Boolean1.FindControl("C1")).Checked ? "1" : "0");
ParameterList.Add(strReason.Trim());
#endregion
ALOModel.MaintainStoreOrderItem BCO = new ALOModel.MaintainStoreOrderItem(ConnectionDB);
iResult = BCO.CreateStoreOrderItem(ParameterList, null);
if (iResult == 0)
{
throw new Exception("新增0筆資料!");
}
else
{
//ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "ClientScript", "alert('新增完成');", true);
ResultMsgLabel.Text = "新增完成";
QueryData();
CurrentPageMode = PageCurrentMode.Readonly;
}
#endregion
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
#endregion
}
#endregion
}
protected void btn_PatternSelect_Click(object sender, EventArgs e)
{
#region
try
{
dtMultiSaveClassAndItem = dtClassAndItemSelected;// (DataTable)Session["dtClassAndItemSelected"];
if (dtMultiSaveClassAndItem.Rows.Count > 0)
{
#region
if (!dtMultiSaveClassAndItem.Columns.Contains("chan_no"))
dtMultiSaveClassAndItem.Columns.Add("chan_no");
if (!dtMultiSaveClassAndItem.Columns.Contains("store"))
dtMultiSaveClassAndItem.Columns.Add("store");
if (!dtMultiSaveClassAndItem.Columns.Contains("period_st"))
dtMultiSaveClassAndItem.Columns.Add("period_st");
if (!dtMultiSaveClassAndItem.Columns.Contains("period_end"))
dtMultiSaveClassAndItem.Columns.Add("period_end");
if (!dtMultiSaveClassAndItem.Columns.Contains("order_qty"))
dtMultiSaveClassAndItem.Columns.Add("order_qty");
if (!dtMultiSaveClassAndItem.Columns.Contains("buy_flag"))
dtMultiSaveClassAndItem.Columns.Add("buy_flag");
if (!dtMultiSaveClassAndItem.Columns.Contains("buy_flag_show"))
dtMultiSaveClassAndItem.Columns.Add("buy_flag_show");
if (!dtMultiSaveClassAndItem.Columns.Contains("reason"))
dtMultiSaveClassAndItem.Columns.Add("reason");
if (!dtMultiSaveClassAndItem.Columns.Contains("explain"))
dtMultiSaveClassAndItem.Columns.Add("explain");
#endregion
ALOModel.MaintainStoreOrderItem BCO = new ALOModel.MaintainStoreOrderItem(ConnectionDB);
string strPeriodSt, strPeriodEnd;
Int32 iPeriodSt, iPeriodEnd;
string strErrMsg = "", strErrMsgFinal = "";
ArrayList ParameterList = new ArrayList();//20091112
//取得其他預設值
for (Int32 i = dtMultiSaveClassAndItem.Rows.Count - 1; i >= 0; i--)
{
#region
strPeriodSt = "";
strPeriodEnd = "";
strErrMsg = "";
iPeriodSt = 0;
ParameterList.Clear();
ParameterList.Add(dtMultiSaveClassAndItem.Rows[i]["ITEM"]);
strPeriodSt = BCO.GetNextPeriodStByItem(ParameterList);
Int32.TryParse(strPeriodSt, out iPeriodSt);
strPeriodSt = (iPeriodSt + 1000000).ToString().Substring(1, 6);
if (rbtn_PeriodNext3.Checked)
{
strPeriodEnd = (iPeriodSt + 3 + 1000000).ToString().Substring(1, 6);
}
else if (rbtn_PeriodUnlimited.Checked)
{
strPeriodEnd = "999999";
}
dtMultiSaveClassAndItem.Rows[i]["period_st"] = strPeriodSt;
dtMultiSaveClassAndItem.Rows[i]["period_end"] = strPeriodEnd;
dtMultiSaveClassAndItem.Rows[i]["chan_no"] = SLP_StoreChain1.Text.Trim();
dtMultiSaveClassAndItem.Rows[i]["store"] = SLP_Store1.Text.Trim();
dtMultiSaveClassAndItem.Rows[i]["order_qty"] = SLP_SLPNumber1.Text;
dtMultiSaveClassAndItem.Rows[i]["buy_flag"] = ((CheckBox)this.SLP_Boolean1.FindControl("C1")).Checked ? "1" : "0";
dtMultiSaveClassAndItem.Rows[i]["buy_flag_show"] = ((CheckBox)this.SLP_Boolean1.FindControl("C1")).Checked ? "是" : "否";
dtMultiSaveClassAndItem.Rows[i]["reason"] = SLP_CodeFile1.Text;
dtMultiSaveClassAndItem.Rows[i]["explain"] = ((DropDownList)SLP_CodeFile1.FindControl("D1")).SelectedItem.Text;
ParamTemp.Clear();
ParamTemp.Add(dtMultiSaveClassAndItem.Rows[i]["chan_no"].ToString().Trim());
ParamTemp.Add(dtMultiSaveClassAndItem.Rows[i]["store"].ToString().Trim());
ParamTemp.Add(dtMultiSaveClassAndItem.Rows[i]["item"].ToString().Trim());
ParamTemp.Add(dtMultiSaveClassAndItem.Rows[i]["period_st"].ToString().Trim());
ParamTemp.Add(dtMultiSaveClassAndItem.Rows[i]["period_end"].ToString().Trim());
if (!BCO.CheckStoreOrderItemCanAdd(ParamTemp, ref strErrMsg))
{
//strErrMsgFinal += string.Format("{0}_{1}_{2}_{3}_{4}:{5},",
// dtMultiSaveClassAndItem.Rows[i]["chan_no"].ToString().Trim(),
// dtMultiSaveClassAndItem.Rows[i]["store"].ToString().Trim(),
// dtMultiSaveClassAndItem.Rows[i]["item"].ToString().Trim(),
// dtMultiSaveClassAndItem.Rows[i]["period_st"].ToString().Trim(),
// dtMultiSaveClassAndItem.Rows[i]["period_end"].ToString().Trim(),
// strErrMsg);
strErrMsgFinal += string.Format("{0}:{1};\\n", dtMultiSaveClassAndItem.Rows[i]["item"].ToString().Trim(), strErrMsg);
//所選擇之商品為 [逾期]或[未生效]資料，不可設定
dtMultiSaveClassAndItem.Rows.RemoveAt(i);
}
#endregion
}
if (strErrMsgFinal != "")
{
if (strErrMsgFinal.Substring(strErrMsgFinal.Length - 3, 3) == ";\\n")
{
strErrMsgFinal = strErrMsgFinal.Substring(0, strErrMsgFinal.Length - 3);
}
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "strErrMsgFinal", string.Format("alert('{0}。');", strErrMsgFinal), true);
}
}
GridView1.DataSource = dtMultiSaveClassAndItem;
GridView1.DataBind();
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
#endregion
}
protected void btn_Save_Click(object sender, EventArgs e)
{
#region
try
{
if (dtMultiSaveClassAndItem.Rows.Count > 0)
{
ALOModel.MaintainStoreOrderItem BCO = new ALOModel.MaintainStoreOrderItem(ConnectionDB);
bool bResult = false;
bResult = BCO.CreateMultiStoreOrderItems(dtMultiSaveClassAndItem, null);
if (!bResult)
{
throw new Exception("新增0筆資料!");
}
else
{
ScriptManager.RegisterStartupScript(UpdatePanel2, this.GetType(), "ClientScript", string.Format("alert('新增完成');location.replace('ALO051.aspx?Code=ALO05&ChanNo={0}&Store={1}');", SLP_StoreChain1.Text, SLP_Store1.Text), true);
}
}
else
{
ScriptManager.RegisterStartupScript(UpdatePanel2, this.GetType(), "ClientScript", "alert('請先加入商品');", true);
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
#endregion
}
protected void Page_Load(object sender, EventArgs e)
{
#region
ErrorMsgLabel.Text = "";
strReason = SLP_CodeFile1.Text;
if (!IsPostBack)
{
if (Request.QueryString["PageTimeStamp"] != null)
PageTimeStamp.Value = Request.QueryString["PageTimeStamp"];
else
PageTimeStamp.Value = string.Format("{0}{1}{2}{3}{4}{5}",
DateTime.Now.Year.ToString(),
DateTime.Now.Month.ToString().PadLeft(2, '0'),
DateTime.Now.Day.ToString().PadLeft(2, '0'),
DateTime.Now.Hour.ToString().PadLeft(2, '0'),
DateTime.Now.Minute.ToString().PadLeft(2, '0'),
DateTime.Now.Second.ToString().PadLeft(2, '0')
);
if (Request.QueryString["Item"] != null)
{
SLP_SKU1.Text = Request.QueryString["Item"].Trim();
}
SLP_SKU1.ReadOnly = true;
ParameterList.Clear();
ParameterList.Add(Request.QueryString["Item"].Trim());
ALOModel.MaintainStoreOrderItem BCO = new ALOModel.MaintainStoreOrderItem(ConnectionDB);
string strPeriodSt = BCO.GetNextPeriodStByItem(ParameterList);
if (strPeriodSt == string.Empty)
{
ErrorMsgLabel.Text = "找不到最新期別";
btn_StoreSelect.Enabled = false;
btn_Save.Enabled = false;
return;
}
else
{
lbl_Period.Text = strPeriodSt;
}
//查詢商品最新期別狀態
ParameterList.Clear();
ParameterList.Add(Request.QueryString["Item"].Trim());
ParameterList.Add(strPeriodSt);
ALOModel.QueryALOCommon ALO1 = new ALOModel.QueryALOCommon(ConnectionDB);
string strStstusDesc = ALO1.CheckCurrentItemPeriodState(ParameterList);
if (strStstusDesc != string.Empty)
{
lbl_Status.Text = "(" + strStstusDesc + ")";
}
//for POP_StoreSelector
dtStoreSelected = null;
btn_StoreSelect.OnClientClick = "checkMultiAddInput_Item();if(Page_IsValid==false){return false;}POP_StoreSelector();";
ToolBarInit();
AuthorityControls(this);
}
#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
}
/// <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
}
