protected void Btn_Save_Click(object sender, EventArgs e)
{
try
{
ErrorMsgLabel.Text = "";
String slp_dateHidden = SLP_DateHidden.Value;
String slp_date = SLP_SLPDate1.Text;
TRNModel.MaintainRestrainedQty BCO = new TRNModel.MaintainRestrainedQty(ConntionDB);
int rowCounts = GridView1.Rows.Count;
bool checkPkFlag = false;
//檢查PK是否已存在
for (int i = 0; i < rowCounts; i++)
{
String v_ID = ((HtmlInputHidden)GridView1.Rows[i].Cells[6].FindControl("Id")).Value;
// String vProcStatus = ((HtmlInputHidden)GridView1.Rows[i].Cells[6].FindControl("ProcStatus")).Value;
int vBindsPerDrayOld = Convert.ToInt32(((HtmlInputHidden)GridView1.Rows[i].Cells[6].FindControl("binds_per_dray_old")).Value);
int vBindsPerDray = Convert.ToInt32(((WUI.SLP.SLPNumber)GridView1.Rows[i].Cells[6].FindControl("binds_per_dray")).Text);
int vPcsPerBindOld = Convert.ToInt32(((HtmlInputHidden)GridView1.Rows[i].Cells[5].FindControl("pcs_per_bind_old")).Value);
int vPcsPerBind = Convert.ToInt32(((WUI.SLP.SLPNumber)GridView1.Rows[i].Cells[5].FindControl("pcs_per_bind")).Text);
String vItem = GridView1.Rows[i].Cells[0].Text;
String vPeriod = GridView1.Rows[i].Cells[1].Text;
String vVirtualCode = ((HtmlInputHidden)GridView1.Rows[i].Cells[6].FindControl("virtual_code")).Value;
if (v_ID.Equals("0"))
{
if (vBindsPerDray > 0 || vPcsPerBind > 0)
{
ParameterList.Clear();
ParameterList.Add(slp_dateHidden);
ParameterList.Add(vItem);
ParameterList.Add(vPeriod);
ParameterList.Add(vVirtualCode);
DataTable newDt = BCO.QueryExistPk(ParameterList);
if (newDt.Rows.Count > 0 && newDt != null)
{
checkPkFlag = true;
break;
}
}
}
}
if (checkPkFlag)
{
// ErrorMsgLabel.Text ="資料已被其他使用者異動,處理失敗,請確認";
ShowErrorMessage("資料已被其他使用者異動,處理失敗,請確認"); return;
}
else
{
for (int i = 0; i < rowCounts; i++)
{
String v_ID = ((HtmlInputHidden)GridView1.Rows[i].Cells[6].FindControl("Id")).Value;
// String vProcStatus = ((HtmlInputHidden)GridView1.Rows[i].Cells[6].FindControl("ProcStatus")).Value;
int vBindsPerDrayOld = Convert.ToInt32(((HtmlInputHidden)GridView1.Rows[i].Cells[6].FindControl("binds_per_dray_old")).Value);
int vBindsPerDray = Convert.ToInt32(((WUI.SLP.SLPNumber)GridView1.Rows[i].Cells[6].FindControl("binds_per_dray")).Text);
int vPcsPerBindOld = Convert.ToInt32(((HtmlInputHidden)GridView1.Rows[i].Cells[5].FindControl("pcs_per_bind_old")).Value);
int vPcsPerBind = Convert.ToInt32(((WUI.SLP.SLPNumber)GridView1.Rows[i].Cells[5].FindControl("pcs_per_bind")).Text);
String vItem = GridView1.Rows[i].Cells[0].Text;
String vPeriod = GridView1.Rows[i].Cells[1].Text;
String vVirtualCode = ((HtmlInputHidden)GridView1.Rows[i].Cells[6].FindControl("virtual_code")).Value;
if (v_ID.Equals("0"))
{
//當 雜誌手開紙箱PCS數/捆(箱)> 0 或 捆(箱)數/板>0 才需新增資料
if (vBindsPerDray > 0 || vPcsPerBind > 0)
{
ParameterList.Clear();
ParameterList.Add(vItem);
ParameterList.Add(DateTime.Now);
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(DateTime.Now);
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(Convert.ToDateTime(slp_dateHidden));
ParameterList.Add(vItem);
ParameterList.Add(vPeriod);
ParameterList.Add(vVirtualCode);
ParameterList.Add(vPcsPerBind);
ParameterList.Add(vBindsPerDray);
int newID = BCO.CreatePickBind(ParameterList, null);
}
}
else
{
//當 有修改 雜誌手開紙箱PCS數/捆(箱) 或 捆(箱)數/板 時，才需修改資料
if ((vBindsPerDrayOld != vBindsPerDray) || (vPcsPerBind != vPcsPerBindOld))
{
DataTable dt = BCO.ConvertXMLToDataTable(VDS_TRN_PICK_BIND.InnerHtml);
DataRow[] drs = dt.Select(string.Format("ID='{0}'", v_ID));
DataRow drOLD = drs[0];
ParameterList.Clear();
ParameterList.Add(Convert.ToInt32(drOLD["ID"]));
ParameterList.Add(drOLD["CODE"].ToString()); //OLD_CODE
ParameterList.Add(Convert.ToDateTime(drOLD["CREATEDATE"])); //OLD_CREATEDATE
ParameterList.Add(drOLD["CREATEUID"].ToString()); //OLD_CREATEUID
ParameterList.Add(Convert.ToDateTime(drOLD["UPDATEDATE"])); //OLD_UPDATEDATE
ParameterList.Add(drOLD["UPDATEUID"].ToString()); //OLD_UPDATEUID
ParameterList.Add(Convert.ToDateTime(drOLD["ST_ACCEPT_DATE"]));
ParameterList.Add(drOLD["ITEM"].ToString());
ParameterList.Add(drOLD["PERIOD"].ToString());
ParameterList.Add(drOLD["VIRTUAL_CODE"].ToString());
ParameterList.Add(Convert.ToInt32(drOLD["PCS_PER_BIND"].ToString()));
ParameterList.Add(Convert.ToInt32(drOLD["BINDS_PER_DRAY"]));
ParameterList.Add(drOLD["ENABLE"].ToString()); //OLD_ENABLE
ParameterList.Add(vItem);
ParameterList.Add(Convert.ToDateTime(slp_dateHidden));
ParameterList.Add(vItem);
ParameterList.Add(vPeriod);
ParameterList.Add(vVirtualCode);
ParameterList.Add(vPcsPerBind);
ParameterList.Add(vBindsPerDray);
ParameterList.Add(DateTime.Now);
ParameterList.Add(Session["UID"].ToString());
int id = BCO.UpdatePickBind(ParameterList, null);
}
}
}
}
databind();
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}
protected void Btn_Delete_Click(object sender, EventArgs e)
{
ErrorMsgLabel.Text = "";
try
{
String slp_dateHidden = SLP_DateHidden.Value;
String slp_date = SLP_SLPDate1.Text;
if (slp_date == "")
{
ShowErrorMessage("請輸入[門市進貨日]"); return;
}
else
{
if (DateTime.Parse(slp_dateHidden) <= DateTime.Now)
{
ShowErrorMessage("門市進貨日已過，不可刪除資料"); return;
}
else
{
TRNModel.MaintainRestrainedQty BCO = new TRNModel.MaintainRestrainedQty(ConntionDB);
ParameterList.Clear();
ParameterList.Add(slp_dateHidden.Trim());
int k = BCO.DeletePickBind(ParameterList, null);
if (k>0)
ShowErrorMessage("刪除成功");
databind();
}
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}
///// <summary>
///// 查詢資料庫取得資料
///// </summary>
private void databind()
{
//抓取本頁初次登記的時間
string SessionIDName = "TRN021_" + PageTimeStamp.Value;
Session["Toolbar"] = SessionIDName; //給Toolbar換頁用
TRNModel.MaintainRestrainedQty BCO = new TRNModel.MaintainRestrainedQty(ConntionDB);
ParameterList.Clear();
ParameterList.Add(SLP_SLPDate1.Text.Trim());
//讀取VDS_TRN_PICK_BIND，等於進貨日當日的資料，並置放於xml中。
DataTable StAcceptDateDt = BCO.QueryByStAcceptDate(ParameterList);
VDS_TRN_PICK_BIND.InnerHtml = BCO.ConvertBetweenDataTableToXML(StAcceptDateDt);
//讀取來自不同table 資料
DataTable Dt = BCO.QueryUnionDataByStAcceptDate(ParameterList);
Session[SessionIDName] = Dt;
GridView1.DataSource = Dt;
if (Dt.Rows.Count > 0)
{
Btn_Delete.Visible = true;
Btn_Save.Visible = true;
this.hid_PageStatus.Value = "EDIT";
this.txt_PageStatus.Text = "EDIT";
}
else
{
Btn_Delete.Visible = false;
Btn_Save.Visible = false;
this.hid_PageStatus.Value = "QUERY";
this.txt_PageStatus.Text = "QUERY";
}
//設定分頁大小
//GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
GridView1.PageIndex = 0;
GridView1.DataBind();
if (Dt == null || (Dt != null && Dt.Rows.Count <= 0))
{
ResultMsgLabel.Text = "查無資料";
}
//LabelQueryRecordCount.Text = string.Format(" {0} Rows ", Dt.Rows.Count.ToString());
ToolBarInit(hid_PageStatus.Value);
AuthorityControls(this);
}
