/// <summary>
/// 查詢鈕
/// </summary>
protected void btnQuery_Click(object sender, EventArgs e)
{
if (VerifyFormData() == true)
{
try
{
ErrorMsgLabel.Text = "";
int intP_Qty_S = 0;
int intP_Qty_E = 0;
//如果刷讀數量起迄都沒輸入,預設為 0 ~ 9999
if (txt_P_Qty_S.Text.Length == 0 && txt_P_Qty_E.Text.Length == 0)
{
intP_Qty_S = 0;
intP_Qty_E = 9999;
}
//如果只輸入迄,未輸入起,則起設為和迄相等
if (txt_P_Qty_S.Text.Length == 0 && txt_P_Qty_E.Text.Length != 0)
{
intP_Qty_E = int.Parse(txt_P_Qty_E.Text);
intP_Qty_S = intP_Qty_E;
}
//如果只輸入起,未輸入迄,則迄設為和起相等
if (txt_P_Qty_S.Text.Length != 0 && txt_P_Qty_E.Text.Length == 0)
{
intP_Qty_S = int.Parse(txt_P_Qty_S.Text);
intP_Qty_E = intP_Qty_S;
}
if (txt_P_Qty_S.Text.Length != 0 && txt_P_Qty_E.Text.Length != 0)
{
intP_Qty_S = int.Parse(txt_P_Qty_S.Text);
intP_Qty_E = int.Parse(txt_P_Qty_E.Text);
}
//抓取本頁初次登記的時間
string SessionIDName = "CGR011_" + PageTimeStamp.Value;
CGRModel.MaintainSorterData BCO = new PIC.VDS2G.LGT.CGR.MaintainSorterData(ConntionDB);
DataTable Dt;
ParameterList.Clear();
ParameterList.Add(SLP_StoreChain.Text);//通路
ParameterList.Add(SLP_Store.Text);//門市
ParameterList.Add(SLP_P_Date.Text);//處理日
ParameterList.Add(txtChan_Source_No.Text);//通路單號
ParameterList.Add(SLP_T_Date.Text);//模板日
ParameterList.Add(SLP_Sign_Date.Text);//簽收日
ParameterList.Add(txtBatch_No.Text);//批次序號
ParameterList.Add(SLP_SKU1.Text);//品號/品名
ParameterList.Add(SLP_ItemPeriod.Text);//期別
ParameterList.Add(intP_Qty_S);//刷讀數量_起
ParameterList.Add(intP_Qty_E);//刷讀數量_迄
ParameterList.Add(Int16.Parse(TextBoxRowCountLimit.Text));
Dt = BCO.QueryDetlByFind(ParameterList);
if (Dt.Rows.Count == 0)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGR011.aspx", "alert(' 查無資料 ');", true);
}
Session[SessionIDName] = Dt;
GridView1.DataSource = Dt;
//設定分頁大小
GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
GridView1.PageIndex = 0;
GridView1.DataBind();
//為求總品項數的欄位
string[] fileds ={ "ITEM", "PERIOD" };
DataTable newdt = this.SelectDistinct(Dt, fileds);
lblDistinct.Text = newdt.Rows.Count.ToString();
Label1.Visible = true;
Label2.Visible = true;
lblSumPQty.Visible = true;
lblDistinct.Visible = true;
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}
}
private void BindGrid(ArrayList AL_Rule)
{
//抓取本頁初次登記的時間
string SessionIDName = "CGR011_" + PageTimeStamp.Value;
CGRModel.MaintainSorterData BCO = new PIC.VDS2G.LGT.CGR.MaintainSorterData(ConntionDB);
DataTable Dt;
Dt = BCO.QueryDetlByFind(AL_Rule);
Session[SessionIDName] = Dt;
GridView1.DataSource = Dt;
//設定分頁大小
GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
GridView1.PageIndex = 0;
GridView1.DataBind();
//為求總品項數的欄位
string[] fileds ={ "ITEM", "PERIOD" };
DataTable newdt = this.SelectDistinct(Dt, fileds);
lblDistinct.Text = newdt.Rows.Count.ToString();
Label1.Visible = true;
Label2.Visible = true;
lblSumPQty.Visible = true;
lblDistinct.Visible = true;
}
private void SaveData()
{
if (IsInt(PQty.Text))
{
string DtName = Request.QueryString["PageTimeStamp"];
DataTable Dt = (DataTable)Session["CGR011_" + DtName];
DataRow Dr = Dt.Select("ID=" + Request.QueryString["DID"])[0];
DateTime dtLastDate;
DateTime dtLastDateNew = DateTime.Now;
CGRModel.MaintainSorterData BCO = new PIC.VDS2G.LGT.CGR.MaintainSorterData(ConntionDB);
ParameterList.Clear();
ParameterList.Add(int.Parse(ID.Value.ToString()));
ParameterList.Add(Store.Text);
ParameterList.Add(int.Parse(PQty.Text));
if (DateTime.TryParse(Dr["LAST_DATE"].ToString(), out dtLastDate))
{
ParameterList.Add(dtLastDate.ToString("yyyy/MM/dd HH:mm:ss"));
}
else
{
ParameterList.Add("");
}
ParameterList.Add(dtLastDateNew.ToString("yyyy/MM/dd HH:mm:ss"));
ParameterList.Add(LastID.Text);
ParameterList.Add(Session["UID"].ToString());
BCO.UpdSorterData(ParameterList, DBT);
Dr["STORE"] = Store.Text;
Dr["P_QTY"] = int.Parse(PQty.Text);
Dr["LAST_DATE"] = dtLastDateNew;
Dr.AcceptChanges();
Dt.AcceptChanges();
Session["CGR011_" + DtName] = Dt;
ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "CloseWindow", "window.close();", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "NotPositive", "alert(' 請輸入 0 或正整數 ');", true);
}
}
private bool CheckSameChan()
{
DataRow Dr = (DataRow)Session["Dr_" + PageTimeStamp.Value];
if (Store.Text.Trim() != Dr["STORE"].ToString())
{
CGRModel.MaintainSorterData BCO = new PIC.VDS2G.LGT.CGR.MaintainSorterData(ConntionDB);
ParameterList.Clear();
ParameterList.Add(ChanNo.Text);
ParameterList.Add(Store.Text);
DataTable Dt = BCO.QueryChanStore(ParameterList);
if (Dt.Rows.Count == 0)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGR012.aspx", "alert(' 請選擇相同通路的門市 ');", true);
return false;
}
}
return true;
}
/// <summary>
/// 檢查是否曾出貨給該門市
/// </summary>
/// <returns></returns>
private bool CheckHisData()
{
DataRow Dr = (DataRow)Session["Dr_" + PageTimeStamp.Value];
if (Store.Text.Trim() != Dr["STORE"].ToString())
{
int intAccept_Qty = 0;
int intPatch_In_Qty_P = 0;
int intPatch_Out_Qty_P = 0;
int intAdj_In_Qty = 0;
DataTable Dt;
CGRModel.MaintainSorterData BCO = new PIC.VDS2G.LGT.CGR.MaintainSorterData(ConntionDB);
ParameterList.Clear();
ParameterList.Add(ChanNo.Text);
ParameterList.Add(Store.Text);
ParameterList.Add(Item.Text);
ParameterList.Add(Period.Text);
Dt = BCO.StoreAcceptHisData(ParameterList);
if (Dt.Rows.Count > 0)
{
intAccept_Qty = int.Parse(Dt.Rows[0]["Accept_Qty"].ToString());
intPatch_In_Qty_P = int.Parse(Dt.Rows[0]["Patch_In_Qty_P"].ToString());
intPatch_Out_Qty_P = int.Parse(Dt.Rows[0]["Patch_Out_Qty_P"].ToString());
intAdj_In_Qty = int.Parse(Dt.Rows[0]["Adj_In_Qty"].ToString());
if (intAccept_Qty + intPatch_In_Qty_P + intPatch_Out_Qty_P + intAdj_In_Qty <= 0)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGR012.aspx", "if (confirm('未發行此門市，確認修改?')){__doPostBack('SaveData','');}", true);
return false;
}
}
else
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGR012.aspx", "alert(' 未發行此門市 ');", true);
return false;
}
}
return true;
}
/// <summary>
/// 計算總刷讀數
/// </summary>
/// <param name="strBatchNo"></param>
/// <param name="strItem"></param>
/// <param name="strPeriod"></param>
/// <param name="strChanNo"></param>
/// <returns></returns>
private string GetSumPQty(string strBatchNo, string strItem, string strPeriod, string strChanNo)
{
string result = string.Empty;
CGRModel.MaintainSorterData BCO = new PIC.VDS2G.LGT.CGR.MaintainSorterData(ConntionDB);
ParameterList.Clear();
ParameterList.Add(strBatchNo);
ParameterList.Add(strItem);
ParameterList.Add(strPeriod);
ParameterList.Add(strChanNo);
result = BCO.CalSumPQty(ParameterList).ToString();
return result;
}
