protected void Button1_Click(object sender, EventArgs e)
{
try
{
//if (lblErrQty.Text.Trim() != "0")
//{
// ScriptManager.RegisterStartupScript(Page, this.GetType(), "POP_VGR023_2.aspx", "alert(' 檔案有異常資料 ');", true);
// return;
//}
if (lblQty.Text.Trim() == "")
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "POP_VGR023_2.aspx", "alert(' 請先預覽欲轉入檔案 ');", true);
return;
}
if (lblQty.Text.Trim() == "0")//正常筆數等於0
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "POP_VGR023_2.aspx", "alert(' 無正常資料可轉入 ');", true);
return;
}
VGRModel.MaintainChanReturnData BCO = new PIC.VDS2G.LGT.VGR.MaintainChanReturnData(ConntionDB);
string strBatchNo = "";
int iPID = 0;
//================================================================================================
switch (Request["PageMode"])
{
case "2":
for (int i = 0; i < gv_Result.Rows.Count; i++)
{
ParameterList.Clear();
bool bl = true;
//string strPID = ((Label)this.GridView1.Rows[i].FindControl("Label1")).Text;
string strITEM = ((Label)this.gv_Result.Rows[i].FindControl("Label1")).Text;
string strPERIOD = ((Label)this.gv_Result.Rows[i].FindControl("Label3")).Text;
string strCREATEUID = Session["UID"].ToString();
string strUPDATEUID = Session["UID"].ToString();
//string strUPDATEDATE = ((Label)this.GridView1.Rows[i].FindControl("")).Text;
//string strCREATEDATE = ((Label)this.GridView1.Rows[i].FindControl("")).Text;
string strBACKWARD_QTY = ((Label)this.gv_Result.Rows[i].FindControl("Label6")).Text;
string strCHAN_PRICE = ((Label)this.gv_Result.Rows[i].FindControl("Label4")).Text;
string strChanEndDate = ((Label)this.gv_Result.Rows[i].FindControl("Label5")).Text;
ParameterList.Clear();
if (Request.QueryString["ID"] != null)
{
ParameterList.Add(int.Parse(Request.QueryString["ID"].ToString()));
}
else
{
ParameterList.Add(int.Parse("999999"));
}
DataTable OldDt = BCO.QueryByID(ParameterList);
foreach (DataRow dr in OldDt.Rows)
{
bl = true;
if (dr["ITEM"].ToString() == strITEM && dr["PERIOD"].ToString() == strPERIOD && dr["BACKWARD_QTY"].ToString() != strBACKWARD_QTY)
{
ParameterList.Clear();
ParameterList.Add(int.Parse(Request.QueryString["ID"].ToString()));
ParameterList.Add(strITEM);
ParameterList.Add(strPERIOD);
//ParameterList.Add(strCREATEUID);
//ParameterList.Add(strUPDATEUID);
//ParameterList.Add(DateTime.Parse(PageTimeStamp.Value));
//ParameterList.Add(DateTime.Parse(PageTimeStamp.Value));
ParameterList.Add(int.Parse(strBACKWARD_QTY));
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(DateTime.Parse(PageTimeStamp.Value));
BCO.UpdChanReturnData(ParameterList, DBT);
bl = false;
break;
}
else if (dr["ITEM"].ToString() == strITEM && dr["PERIOD"].ToString() == strPERIOD)
{
bl = false;
break;
}
}
if (bl)
{
//string strBatchNo = "";
//int iPID = 0;
ParameterList.Clear();
ParameterList.Add(int.Parse(Request.QueryString["ID"].ToString()));
ParameterList.Add(strITEM);
ParameterList.Add(strPERIOD);
ParameterList.Add(Decimal.Parse(strCHAN_PRICE));
ParameterList.Add(DateTime.Parse(strChanEndDate));
ParameterList.Add(int.Parse(strBACKWARD_QTY));
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(DateTime.Parse(PageTimeStamp.Value));
ParameterList.Add(DateTime.Parse(PageTimeStamp.Value));
BCO.DoInsertDetl(ParameterList, DBT);
}
}
Session["PageMode"] = "1";
break;
case "3":
//string strBatchNo = "";
//int iPID = 0;
ParameterList.Clear();
ParameterList.Add(DateTime.Parse(Request.QueryString["BackWardDate"].ToString()));
ParameterList.Add(DateTime.Parse(Request.QueryString["P_Date"].ToString()));
//ParameterList.Add(Request.QueryString["ChanNo"].ToString());
//ParameterList.Add(Request.QueryString["Store"].ToString());
//ParameterList.Add(Request.QueryString["ChanSourceNo"].ToString());
ParameterList.Add(Session["StoreChain"].ToString());
ParameterList.Add(Session["Store"].ToString());
ParameterList.Add(Session["ChanSourceNo"].ToString());
ParameterList.Add("25");
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(DateTime.Parse(PageTimeStamp.Value));
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(DateTime.Parse(PageTimeStamp.Value));
BCO.CreateChanReturnData(ParameterList, dtForBrowse, DBT, Session["UID"].ToString(), DateTime.Parse(PageTimeStamp.Value), out strBatchNo, out iPID);
//this.txtBatchNo.Text = strBatchNo;
Session["PID"] = iPID.ToString();
Session["BatchNo"] = strBatchNo;
Session["PageMode"] = "2";
Session["STATUS_EXPLAIN"] = "25";
#region
ArrayList IDList = new ArrayList();
ArrayList Batch_NoList = new ArrayList();
ArrayList Chan_NoList = new ArrayList();
ArrayList Sign_DateList = new ArrayList();
ArrayList P_DATEList = new ArrayList();
ArrayList StoreList = new ArrayList();
ArrayList Chan_Source_NoList = new ArrayList();
ArrayList STATUS_EXPLAINList = new ArrayList();
ArrayList UPDATEDATEList = new ArrayList();
ArrayList UPDATEUIDList = new ArrayList();
IDList.Add(iPID.ToString());
Batch_NoList.Add(strBatchNo);
Chan_NoList.Add(Session["StoreChain"].ToString());
Sign_DateList.Add(DateTime.Parse(Request.QueryString["BackWardDate"].ToString()));
P_DATEList.Add(Request.QueryString["P_Date"].ToString());
StoreList.Add(Session["Store"].ToString());
Chan_Source_NoList.Add(Session["ChanSourceNo"].ToString());
STATUS_EXPLAINList.Add("25");
UPDATEDATEList.Add(DateTime.Parse(PageTimeStamp.Value).ToString("yyyyMMddHHmmssfffff"));
UPDATEUIDList.Add(Session["UID"].ToString());
Session["VGR02QueryID"] = IDList;
Session["VGR02QueryBatch_No"] = Batch_NoList;
Session["VGR02QueryChan_No"] = Chan_NoList;
Session["VGR02QuerySign_Date"] = Sign_DateList;
Session["VGR02QueryP_DATE"] = P_DATEList;
Session["VGR02QueryStore"] = StoreList;
Session["VGR02QueryChan_Source_No"] = Chan_Source_NoList;
Session["VGR02QuerySTATUS_EXPLAIN"] = STATUS_EXPLAINList;
Session["VGR02QueryUPDATEDATE"] = UPDATEDATEList;
Session["VGR02QueryUPDATEUID"] = UPDATEUIDList;
#endregion
break;
default:
break;
}
//================================================================================================
Response.Write("<script>window.returnValue= 'test';window.close();</script>");
//Response.Redirect(string.Format("VGR022.aspx?ID=" + iPID.ToString() + "&PageMode=1&Batch_No=" + strBatchNo + "&Chan_No=" + Session["StoreChain"].ToString() + "&Sign_Date=" + Request.QueryString["BackWardDate"].ToString() + "&P_DATE=" + Request.QueryString["P_Date"].ToString() + "&Store=" + Session["Store"].ToString() + "&Chan_Source_No=" + Session["ChanSourceNo"].ToString() + "&STATUS_EXPLAIN=" + "25" + ""));
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}
public void doInsert()
{
VGRModel.MaintainChanReturnData BCO = new PIC.VDS2G.LGT.VGR.MaintainChanReturnData(ConntionDB);
string strBatchNo = "";
int iPID = 0;
ParameterList.Clear();
ParameterList.Add(DateTime.Parse(SLP_SLPDate1.Text));
ParameterList.Add(DateTime.Parse(SLP_SLPDate2.Text));
ParameterList.Add(SLP_StoreChain1.Text);
ParameterList.Add(SLP_Store1.Text);
ParameterList.Add(txtChanSourceNo.Text);
ParameterList.Add("25");
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(DateTime.Parse(PageTimeStamp.Value));
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(DateTime.Parse(PageTimeStamp.Value));
for (int i = 0; i < GridView1.Rows.Count; i++)
{
string strItem = ((Label)this.GridView1.Rows[i].FindControl("lblItem")).Text;
string strPeriod = ((Label)this.GridView1.Rows[i].FindControl("lblPeriod")).Text;
foreach (DataRow dr in dtForBrowse.Rows)
{
if (dr.RowState != DataRowState.Deleted)
{
if (dr["ITEM"].ToString() == strItem && dr["PERIOD"].ToString() == strPeriod)
{
if (((TextBox)this.GridView1.Rows[i].FindControl("txtBackWardQty")).Text.Trim() != "")
{
dr["BACKWARD_QTY"] = ((TextBox)this.GridView1.Rows[i].FindControl("txtBackWardQty")).Text;
}
else
{
dr["BACKWARD_QTY"] = 0;
((TextBox)this.GridView1.Rows[i].FindControl("txtBackWardQty")).Text = "0";
}
}
}
}
}
BCO.CreateChanReturnData(ParameterList, dtForBrowse, DBT, Session["UID"].ToString(), DateTime.Parse(PageTimeStamp.Value), out strBatchNo, out iPID);
this.txtBatchNo.Text = strBatchNo;
Session["BatchNo"] = strBatchNo;
Session["PageMode"] = "2";
#region 記錄Session
ArrayList IDList = new ArrayList();
ArrayList Batch_NoList = new ArrayList();
ArrayList Chan_NoList = new ArrayList();
ArrayList Sign_DateList = new ArrayList();
ArrayList P_DATEList = new ArrayList();
ArrayList StoreList = new ArrayList();
ArrayList Chan_Source_NoList = new ArrayList();
ArrayList STATUS_EXPLAINList = new ArrayList();
ArrayList UPDATEDATEList = new ArrayList();
ArrayList UPDATEUIDList = new ArrayList();
IDList.Add(iPID.ToString());
Batch_NoList.Add(strBatchNo);
Chan_NoList.Add(SLP_StoreChain1.Text);
Sign_DateList.Add(DateTime.Parse(SLP_SLPDate1.Text).ToString());
P_DATEList.Add(DateTime.Parse(SLP_SLPDate2.Text).ToString());
StoreList.Add(SLP_Store1.Text);
Chan_Source_NoList.Add(txtChanSourceNo.Text);
STATUS_EXPLAINList.Add("25");
UPDATEDATEList.Add(DateTime.Parse(PageTimeStamp.Value).ToString("yyyyMMddHHmmssfffff"));
UPDATEUIDList.Add(Session["UID"].ToString());
Session["VGR02QueryID"] = IDList;
Session["VGR02QueryBatch_No"] = Batch_NoList;
Session["VGR02QueryChan_No"] = Chan_NoList;
Session["VGR02QuerySign_Date"] = Sign_DateList;
Session["VGR02QueryP_DATE"] = P_DATEList;
Session["VGR02QueryStore"] = StoreList;
Session["VGR02QueryChan_Source_No"] = Chan_Source_NoList;
Session["VGR02QuerySTATUS_EXPLAIN"] = STATUS_EXPLAINList;
Session["VGR02QueryUPDATEDATE"] = UPDATEDATEList;
Session["VGR02QueryUPDATEUID"] = UPDATEUIDList;
#endregion
Response.Redirect(string.Format("VGR022.aspx?ID=" + iPID + "&PageMode=1&Batch_No=" + strBatchNo + "&Chan_No=" + SLP_StoreChain1.Text + "&Sign_Date=" + SLP_SLPDate1.Text + "&P_DATE=" + SLP_SLPDate2.Text + "&Store=" + SLP_Store1.Text + "&Chan_Source_No=" + txtChanSourceNo.Text + "&STATUS_EXPLAIN=" + "25&UPDATEUID=" + Session["UID"].ToString() + "&UPDATEDATE=" + DateTime.Parse(PageTimeStamp.Value).ToString("yyyyMMddHHmmssfffff")));
}
