protected void Page_Load(object sender, EventArgs e)
{
try
{
//如果不設定這個,畫面在第一次讀取關閉後,就不會再跑Page_Load了.
Response.Expires = 0;
//動態加入_self,不然會另開新視窗
Literal litCss = new Literal();
litCss.Text = @"<base target=""_self"">";
this.Header.Controls.Add(litCss);
ErrorMsgLabel.Text = "";
if (!IsPostBack)
{
IVMModel.VDS_IVM34_BCO bco = new IVMModel.VDS_IVM34_BCO(ConntionDB);
ArrayList ParameterList = new ArrayList();
ParameterList.Add(bco.GetValueSetParameter(Request.QueryString["StAcceptDate"],"date",false));
ParameterList.Add(bco.GetValueSetParameter(Request.QueryString["PMA22"], "int", false));
ParameterList.Add(bco.GetValueSetParameter(Request.QueryString["PickType"], "int", false));
ParameterList.Add(bco.GetValueSetParameter(Request.QueryString["ChanNo"], "string", false));
ParameterList.Add(bco.GetValueSetParameter(Request.QueryString["Store"], "string", false));
ParameterList.Add(bco.GetValueSetParameter(Request.QueryString["Route"], "string", false));
ParameterList.Add(bco.GetValueSetParameter(Request.QueryString["Item"], "string", false));
ParameterList.Add(bco.GetValueSetParameter(Request.QueryString["Period"], "string", false));
ParameterList.Add(bco.GetValueSetParameter(Session["UID"].ToString(), "string", false));
DataTable dtResult = bco.QueryQCDetl(ParameterList);
if (Request.QueryString["PickType"] == "0")
{
GridView1.DataSource = dtResult;
GridView1.DataBind();
GridView2.DataSource = null;
GridView2.DataBind();
}
else if (Request.QueryString["PickType"] == "1" || Request.QueryString["PickType"] == "2")
{
GridView1.DataSource = null;
GridView1.DataBind();
GridView2.DataSource = dtResult;
GridView2.DataBind();
}
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
finally { }
}
/// <summary>
/// BUTTON [查詢]鈕
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void but_Query_Click(object sender, EventArgs e)
{
try
{
if (slpRouteS.Text.Trim() != "" && slpRouteE.Text.Trim() == "")
{
ErrorMsgLabel.Text = "路線 起有輸入的話，訖也要輸入";
return;
}
if (slpRouteS.Text.Trim() == "" && slpRouteE.Text.Trim() != "")
{
ErrorMsgLabel.Text = "路線 訖有輸入的話，起也要輸入";
return;
}
if (slpRouteS.Text.Trim().CompareTo(slpRouteE.Text.Trim()) > 0)
{
ErrorMsgLabel.Text = "路線 起 不可大於 訖";
return;
}
IVMModel.VDS_IVM34_BCO BCO = new IVMModel.VDS_IVM34_BCO(ConntionDB);
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(BCO.GetValueSetParameter(this.slpStAcceptDate.Text, "date", false));
ParameterList.Add(BCO.GetValueSetParameter(this.rblPMA22.SelectedValue, "int", false));
ParameterList.Add(BCO.GetValueSetParameter(this.rblPickType.SelectedValue, "int", false));
ParameterList.Add(BCO.GetValueSetParameter(slpChanNo.Text, "string", false));
ParameterList.Add(BCO.GetValueSetParameter(slpStore.Text, "string", false));
ParameterList.Add(BCO.GetValueSetParameter(slpRouteS.Text, "string", false));
ParameterList.Add(BCO.GetValueSetParameter(slpRouteE.Text, "string", false));
ParameterList.Add(BCO.GetValueSetParameter(slpItem.Text, "string", false));
ParameterList.Add(BCO.GetValueSetParameter(slpPeriod.Text, "string", false));
ParameterList.Add(BCO.GetValueSetParameter(Session["UID"].ToString(), "string", false));
DataTable dt_Return = new DataTable();
dt_Return = BCO.QueryStAcceptGroupByItem(ParameterList);
string strStore = "";
if (dt_Return.Rows.Count == 0)
{
this.ErrorMsgLabel.Text = "查無【進貨數量與品保數量有差異】並且【差異原因已審核】的資料";
this.gv_QueryResult.DataSource = dt_Return;
this.gv_QueryResult.PageSize = (this.txt_Pagesize.Text == string.Empty) ? 20 : (int.Parse(this.txt_Pagesize.Text) < 0) ? 20 : int.Parse(this.txt_Pagesize.Text);
this.gv_QueryResult.PageIndex = 0;
this.gv_QueryResult.DataBind();
return;
}
else
{
for (int i = 0; i < dt_Return.Rows.Count; i++)
{
strStore += dt_Return.Rows[i]["STORE"].ToString() + ",";
}
}
ParameterList.Clear();
ParameterList.Add(BCO.GetValueSetParameter(this.slpStAcceptDate.Text, "date", false));
ParameterList.Add(BCO.GetValueSetParameter(this.rblPMA22.SelectedValue, "int", false));
ParameterList.Add(BCO.GetValueSetParameter(this.rblPickType.SelectedValue, "int", false));
ParameterList.Add(BCO.GetValueSetParameter(slpChanNo.Text, "string", false));
ParameterList.Add(BCO.GetValueSetParameter(strStore, "string", false));
ParameterList.Add(BCO.GetValueSetParameter(slpRouteS.Text, "string", false));
ParameterList.Add(BCO.GetValueSetParameter(slpRouteE.Text, "string", false));
ParameterList.Add(BCO.GetValueSetParameter(slpItem.Text, "string", false));
ParameterList.Add(BCO.GetValueSetParameter(slpPeriod.Text, "string", false));
ParameterList.Add(BCO.GetValueSetParameter((this.txt_RowCountLimit.Text == string.Empty) ? "100" : (int.Parse(this.txt_RowCountLimit.Text) < 0) ? "100" : this.txt_RowCountLimit.Text, "int", false));//[筆數]
ParameterList.Add(BCO.GetValueSetParameter(Session["UID"].ToString(), "string", false));
dt_Return = BCO.QueryStAcceptGroupByStore(ParameterList);
if (dt_Return.Rows.Count == 0)
{ this.ErrorMsgLabel.Text = "查無資料"; }
#region 使用XML放置到前端資料
MasterOLDData.InnerHtml = dt_Return.DataSet.GetXml();
#endregion
//抓取本頁初次登記的時間
string SessionIDName = "IVM341_" + PageTimeStamp.Value;
Session["SessionID"] = SessionIDName;
Session[SessionIDName] = dt_Return;
this.gv_QueryResult.DataSource = dt_Return;
this.gv_QueryResult.PageSize = (this.txt_Pagesize.Text == string.Empty) ? 20 : (int.Parse(this.txt_Pagesize.Text) < 0) ? 20 : int.Parse(this.txt_Pagesize.Text);
this.gv_QueryResult.PageIndex = 0;
this.gv_QueryResult.DataBind();
ArrayList arl_Key = new ArrayList();
foreach (DataRow drRow in dt_Return.Rows)
{ arl_Key.Add(drRow["STORE"].ToString()); }
Session["IVM341_SortKey" + this.PageTimeStamp.Value] = arl_Key;
}
catch (Exception ex)
{
WaringLogProcess(ex.Message);
this.ErrorMsgLabel.Text = ex.Message;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
int UpdateRecord = 0;
System.IO.TextReader tr;
try
{
//抓取本頁初次登記的時間
string SessionIDName = "IVM342_" + PageTimeStamp.Value;
IVMModel.VDS_IVM34_BCO BCO = new IVMModel.VDS_IVM34_BCO(ConntionDB);
#region 取得畫面元件的值
DateTime v_UPDATEDATE = System.DateTime.Now;
string v_UPDATEUID = Session["UID"].ToString();
#endregion
#region 使用XML轉回DataSet , 取得更新前舊值
DataSet Ds = null;
DataTable Dt = null;
if (MasterOLDData.InnerHtml.ToString().Trim() != "")
{
Ds = new DataSet();
System.IO.StringReader sr = new System.IO.StringReader(MasterOLDData.InnerHtml);
Ds.ReadXml(sr);
Dt = Ds.Tables[0];
}
#endregion
string OLD_ST_ACCEPT_QTY = "";
string NEW_ST_ACCEPT_QTY = "";
ArrayList ParameterList = new ArrayList();
for (int i = 0; i <= Repeater1.Items.Count -1; i++)
{
GridView gv1 = (GridView)Repeater1.Items[i].FindControl("GridView1");
for (int j = 0; j <= gv1.Rows.Count - 1; j++)
{
ParameterList.Clear();
ParameterList.Add(((Label)(gv1.Rows[j].FindControl("lblStAcceptNo"))).Text);
ParameterList.Add(((Label)(Repeater1.Items[i].FindControl("lblItem"))).Text);
ParameterList.Add(((Label)(Repeater1.Items[i].FindControl("lblPeriod"))).Text);
ParameterList.Add(((Label)(Repeater1.Items[i].FindControl("lblVirtualCode"))).Text);
ParameterList.Add(((Label)(gv1.Rows[j].FindControl("lblLocateNo"))).Text);
ParameterList.Add(((Label)(gv1.Rows[j].FindControl("lblLocateSection"))).Text);
OLD_ST_ACCEPT_QTY = ((Label)(gv1.Rows[j].FindControl("lblOldStAcceptQty"))).Text;//OLD_ST_ACCEPT_QTY
NEW_ST_ACCEPT_QTY = ((TextBox)(gv1.Rows[j].FindControl("txtStAcceptQty"))).Text;//NEW_ST_ACCEPT_QTY
if (((TextBox)(gv1.Rows[j].FindControl("txtStAcceptQty"))).Text != "")
{
ParameterList.Add(((Label)(gv1.Rows[j].FindControl("lblOldStAcceptQty"))).Text); //OLD_ST_ACCEPT_QTY
ParameterList.Add(((TextBox)(gv1.Rows[j].FindControl("txtStAcceptQty"))).Text);//NEW_ST_ACCEPT_QTY
((Label)(gv1.Rows[j].FindControl("lblOldStAcceptQty"))).Text = ((TextBox)(gv1.Rows[j].FindControl("txtStAcceptQty"))).Text;//把新值帶給舊值
}
else
{
ParameterList.Add(0);//OLD_ST_ACCEPT_QTY
ParameterList.Add(0);//NEW_ST_ACCEPT_QTY
((Label)(gv1.Rows[j].FindControl("lblOldStAcceptQty"))).Text = "0";
((TextBox)(gv1.Rows[j].FindControl("txtStAcceptQty"))).Text = "0";
}
ParameterList.Add(v_UPDATEDATE);
ParameterList.Add(v_UPDATEUID);
if (OLD_ST_ACCEPT_QTY != NEW_ST_ACCEPT_QTY)
BCO.UpdateStAcceptItem(ParameterList, null);
}
}
ErrorMsgLabel.Text = "儲存完畢";
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}
protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if ((e.Item.ItemType == ListItemType.Item) || (e.Item.ItemType == ListItemType.AlternatingItem))
{
GridView gv1 = (GridView)e.Item.FindControl("GridView1");
Label Item = (Label)e.Item.FindControl("lblItem");
Label Period = (Label)e.Item.FindControl("lblPeriod");
string strScript = "OpenDetail('" + txtStAcceptDate.Text + "','" + rblPMA22.SelectedValue + "','" + rblPickType.SelectedValue + "','" + slpChanNo.Text + "','" + slpStore.Text + "','" + slpRoute.Text + "','" + Item.Text + "','" + Period.Text + "');return false;";
((Button)e.Item.FindControl("btnView")).Attributes.Add("onclick", strScript);
IVMModel.VDS_IVM34_BCO BCO = new IVMModel.VDS_IVM34_BCO(ConntionDB);
ArrayList ParameterList = new ArrayList();
ParameterList.Add(BCO.GetValueSetParameter(txtStAcceptDate.Text,"date",false));
ParameterList.Add(BCO.GetValueSetParameter(rblPMA22.SelectedValue, "int", false));
ParameterList.Add(BCO.GetValueSetParameter(rblPickType.SelectedValue, "int", false));
ParameterList.Add(BCO.GetValueSetParameter(slpChanNo.Text, "string", false));
ParameterList.Add(BCO.GetValueSetParameter(slpStore.Text, "string", false));
ParameterList.Add(BCO.GetValueSetParameter(slpRoute.Text, "string", false));
ParameterList.Add(BCO.GetValueSetParameter(Item.Text, "string", false));
ParameterList.Add(BCO.GetValueSetParameter(Period.Text, "string", false));
ParameterList.Add(BCO.GetValueSetParameter(Session["UID"].ToString(), "string", false));
DataTable Dt = BCO.QueryStAcceptByItem(ParameterList);
gv1.DataSource = Dt;
gv1.DataBind();
}
}
/// <summary>
/// databind 繫結查詢資料到GridView1
/// </summary>
private void databind(string StAcceptDate, string PMA22, string PickType, string ChanNo, string Store, string RouteS, string RouteE)
{
//抓取本頁初次登記的時間
string SessionIDName = "IVM342_" + PageTimeStamp.Value;
IVMModel.VDS_IVM34_BCO BCO = new IVMModel.VDS_IVM34_BCO(ConntionDB);
DataTable Dt;
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(BCO.GetValueSetParameter(StAcceptDate,"date",false));
ParameterList.Add(BCO.GetValueSetParameter(PMA22, "int", false));
ParameterList.Add(BCO.GetValueSetParameter(PickType, "int", false));
ParameterList.Add(BCO.GetValueSetParameter(ChanNo, "string", false));
ParameterList.Add(BCO.GetValueSetParameter(Store, "string", false));
ParameterList.Add(BCO.GetValueSetParameter(RouteS, "string", false));
ParameterList.Add(BCO.GetValueSetParameter(RouteE, "string", false));
ParameterList.Add(BCO.GetValueSetParameter("", "string", false));
ParameterList.Add(BCO.GetValueSetParameter("", "string", false));
ParameterList.Add(BCO.GetValueSetParameter(Session["UID"].ToString(), "string", false));
Dt = BCO.QueryStAcceptGroupByItem(ParameterList);
if (Dt.Rows.Count == 0)
{
ErrorMsgLabel.Text = "無進貨數與品保數有差異的資料";
}
#region 使用XML放置到前端資料
MasterOLDData.InnerHtml = Dt.DataSet.GetXml();
#endregion
Session[SessionIDName] = Dt;
Repeater1.DataSource = Dt;
Repeater1.DataBind();
}
private void GetIVM341Data(string StAcceptDate, string PMA22, string PickType, string ChanNo, string Store, string RouteS, string RouteE, string Item, string Period,string RowCountLimit)
{
//抓取本頁初次登記的時間
string SessionIDName = "IVM342_01_" + Request.QueryString["SessionTimeStamp"];
IVMModel.VDS_IVM34_BCO BCO = new IVMModel.VDS_IVM34_BCO(ConntionDB);
DataTable Dt;
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(BCO.GetValueSetParameter(StAcceptDate, "date", false));
ParameterList.Add(BCO.GetValueSetParameter(PMA22, "int", false));
ParameterList.Add(BCO.GetValueSetParameter(PickType, "int", false));
ParameterList.Add(BCO.GetValueSetParameter(ChanNo, "string", false));
ParameterList.Add(BCO.GetValueSetParameter(Store, "string", false));
ParameterList.Add(BCO.GetValueSetParameter(RouteS, "string", false));
ParameterList.Add(BCO.GetValueSetParameter(RouteE, "string", false));
ParameterList.Add(BCO.GetValueSetParameter(Item, "string", false));
ParameterList.Add(BCO.GetValueSetParameter(Period, "string", false));
ParameterList.Add(BCO.GetValueSetParameter(RowCountLimit, "int", false));//[筆數]
ParameterList.Add(BCO.GetValueSetParameter(Session["UID"].ToString(), "string", false));
Dt = BCO.QueryStAcceptGroupByStore(ParameterList);
if (Dt.Rows.Count == 0)
{
ErrorMsgLabel.Text = "查無資料";
}
Session[SessionIDName] = Dt;
}
