/// <summary>
/// 根據勾選項目進行檢核
/// </summary>
/// <param name="sct"></param>
private void QueryData(StoreCheckType sct)
{
#region
try
{
ALOModel.ProcessMultiDisRecords BCO = new ALOModel.ProcessMultiDisRecords(ConnectionDB);
DataTable dt = null;
ArrayList ParameterList = new ArrayList();
string strPrefixed = "POP_StoreCheck";
if (sct == StoreCheckType.OpenAndClose)
{
#region 開關店
ParameterList.Clear();
ParameterList.Add(s_DIS_NO);
ParameterList.Add(SLP_SLPDate1.Text);
ParameterList.Add(i_DIS_NO_Count);
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(chk_OpenCloseStore.Checked ? "1" : "0");//2010/02/11
//gv_ResultOpenCloseStore.DataBind();
//gv_ResultVenderAssigendStore.DataBind();
#region old
//if (sct == StoreCheckType.OpenAndClose)
//{
// #region
// dt = BCO.QueryOpenAndCloseStore(ParameterList);
// dt_OpenCloseStore = dt;
// if (dt != null && dt.Rows.Count > 0)
// {
// if (dt.Rows.Count >= 100)
// {
// Session[string.Format("{0}_{1}", strPrefixed, PageTimeStamp.Value)] = dt;
// ScriptManager.RegisterStartupScript(this, this.GetType(), "storecheck", "POP_StoreCheck();", true);
// ResultMsgLabel.Text = string.Format("開關店檢核資料結果超過上限筆數:{0}，請先進行錯誤排除。", iErrorCountLimit);
// bErrorCountOverLimit = true;
// return;
// //Panel_OpenCloseStore.Height = 300;
// }
// else
// {
// gv_ResultOpenCloseStore.DataSource = dt;
// gv_ResultOpenCloseStore.DataBind();
// btn_SaveOpenCloseStore.Enabled = true;
// hidden_Executed_OpenCloseStore.Value = "0";
// }
// }
// else
// {
// gv_ResultOpenCloseStore.DataBind();
// //Panel_OpenCloseStore.Height = 0;
// ResultMsgLabel.Text += " 查無開關店檢核資料 ";
// btn_SaveOpenCloseStore.Enabled = false;
// hidden_Executed_OpenCloseStore.Value = "1";
// }
// Panel_OpenCloseStoreAll.Visible = true;
// #endregion
//}
#endregion
#region new
dt = BCO.QueryOpenAndCloseStore(ParameterList);
dt_OpenCloseStore = dt;
if (dt != null && dt.Rows.Count > 0)
{
if (dt.Rows.Count >= 100)
{
Session[string.Format("{0}_{1}", strPrefixed, PageTimeStamp.Value)] = dt;
ScriptManager.RegisterStartupScript(this, this.GetType(), "storecheck", "POP_StoreCheck();", true);
ResultMsgLabel.Text = string.Format("開關店檢核資料結果超過上限筆數:{0}，請先進行錯誤排除。", iErrorCountLimit);
bErrorCountOverLimit = true;
return;
//Panel_OpenCloseStore.Height = 300;
}
else
{
gv_ResultOpenCloseStore.DataSource = dt;
gv_ResultOpenCloseStore.DataBind();
btn_SaveOpenCloseStore.Enabled = true;
hidden_Executed_OpenCloseStore.Value = "0";
}
}
else
{
gv_ResultOpenCloseStore.DataBind();
//Panel_OpenCloseStore.Height = 0;
ResultMsgLabel.Text += " 查無開關店檢核資料 ";
btn_SaveOpenCloseStore.Enabled = false;
hidden_Executed_OpenCloseStore.Value = "1";
}
Panel_OpenCloseStoreAll.Visible = true;
#endregion
#endregion
}
else if (sct == StoreCheckType.VenderAssigend)
{
#region 指定店
ParameterList.Clear();
ParameterList.Add(s_DIS_NO);
ParameterList.Add(SLP_SLPDate1.Text);
ParameterList.Add(i_DIS_NO_Count);
ParameterList.Add(Session["UID"].ToString());
dt = BCO.QueryVenderAssigendStore(ParameterList);
dt_VenderAssignedStore = dt;
if (dt != null && dt.Rows.Count > 0)
{
if (dt.Rows.Count >= 100)
{
Session[string.Format("{0}_{1}", strPrefixed, PageTimeStamp.Value)] = dt;
//ScriptManager.RegisterStartupScript(this, this.GetType(), "storecheck", "POP_StoreCheck();", true);
ResultMsgLabel.Text = string.Format("指定店檢核資料結果超過上限筆數:{0}，請先減少配本序號檢核數量。", iErrorCountLimit);
bErrorCountOverLimit = true;
return;
//Panel_VenderAssignedStore.Height = 300;
}
else
{
gv_ResultVenderAssigendStore.DataSource = dt;
gv_ResultVenderAssigendStore.DataBind();
btn_SaveVenderAssigendStore.Enabled = true;
hidden_Executed_VenderAssignedStore.Value = "0";
}
}
else
{
gv_ResultVenderAssigendStore.DataBind();
//Panel_VenderAssignedStore.Height = 0;
ResultMsgLabel.Text += " 查無指定店檢核資料 ";
btn_SaveVenderAssigendStore.Enabled = false;
hidden_Executed_VenderAssignedStore.Value = "1";
}
Panel_VenderAssignedStoreAll.Visible = true;
#endregion
}
}
catch (Exception ex)
{
throw ex;
}
#endregion
}
