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; }