private void dataBind() { ErrorMsgLabel.Text = ""; string SessionIDName = "VGR061_" + PageTimeStamp.Value; VGRModel.VDS_VGR06_BCO BCOVGR = new VGRModel.VDS_VGR06_BCO(ConntionDB); ArrayList ParameterList = new ArrayList(); ParameterList.Add(txtBatchNo.Text); ParameterList.Add(SLP_Date.Text); ParameterList.Add(SLP_Vendor.Text); ParameterList.Add(SLP_Item.Text); ParameterList.Add(SLP_Period.Text); ParameterList.Add(int.Parse(TextBoxRowCountLimit.Text)); DataTable dt = BCOVGR.QueryMainByFind(ParameterList); if (dt.Rows.Count == 0) { ButtonNew.Enabled = false; SLP_LocateSection.ReadOnly = true; this.ErrorMsgLabel.Text = "查無資料"; } else { ButtonNew.Enabled = true; SLP_LocateSection.ReadOnly = false; } if (!dt.Columns.Contains("CHECKED"))//增加欄位以方便判別是否可 dt.Columns.Add("CHECKED"); if (!dt.Columns.Contains("ROWID"))//增加欄位以判別勾選與否 dt.Columns.Add("ROWID"); hidden_RowID_MaxID.Value = dt == null ? "-1" : (dt.Rows.Count - 1).ToString();//記錄最大ROWID hidden_RowID_Selected.Value = "";//清空已選 SetRowIDToDataTable(dt, false);//設定ROWID Session[SessionIDName] = dt; bAfterQueryDataBinding = true; GridView1.DataSource = dt; GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text); GridView1.PageIndex = 0; GridView1.DataBind(); bAfterQueryDataBinding = false; upMain.Update(); UpdatePanel1.Update(); }
private void LoadData() { ErrorMsgLabel.Text = ""; string SSID = Request["SSID"].ToString(); string strLocateSection = Request["LocateSection"].ToString(); DataTable dtBoxNo = (DataTable)Session[SSID]; DataTable dtResult = new DataTable(); VGRModel.VDS_VGR06_BCO BCOVGR = new VGRModel.VDS_VGR06_BCO(ConntionDB); for (int i = 0; i < dtBoxNo.Rows.Count; i++) { ParameterList.Clear(); ParameterList.Add(dtBoxNo.Rows[i]["box_no"].ToString()); ParameterList.Add(strLocateSection); DataTable dtTemp = BCOVGR.QueryItemByBoxNO(ParameterList); if (i == 0) dtResult = dtTemp.Clone(); dtResult.Merge(dtTemp); } DataView dv = dtResult.DefaultView; dv.Sort = "orderRemain asc,Remain_QTY asc,batch_no asc,box_no asc,item asc,period asc "; string SessionIDName = "VGR062_" + PageTimeStamp.Value; Session[SessionIDName] = dv.ToTable(); GridView1.DataSource = dv; GridView1.DataBind(); }//page_load
protected void btnSave_Click(object sender, EventArgs e) { #region try { ErrorMsgLabel.Text = ""; WriteToCache(); string strReturnNoS = string.Empty; string strReturnNoE = string.Empty; string strAdjustNoS = string.Empty; string strAdjustNoE = string.Empty; string strRemoveNoS = string.Empty; string strRemoveNoE = string.Empty; string strLocateSection = Request["LocateSection"].ToString(); DateTime dtNow = DateTime.Now; VGRModel.VDS_VGR06_BCO BCOVGR = new VGRModel.VDS_VGR06_BCO(ConntionDB); ParameterList.Clear(); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(strLocateSection); ParameterList.Add(dtNow); //0.UserID //1.LocateSection string SessionIDName = "VGR062_" + PageTimeStamp.Value; DataTable dtData = (DataTable)Session[SessionIDName]; if (dtData.Rows.Count == 0) { ErrorMsgLabel.Text = "沒有明細資料,請回查詢頁重新選取!"; return; } BCOVGR.SaveData(ParameterList, dtData, out strReturnNoS, out strReturnNoE, out strAdjustNoS, out strAdjustNoE, out strRemoveNoS, out strRemoveNoE); //儲存完後,載入資料 if (strReturnNoS != "") { txtReturn_No_S.Text = strReturnNoS; if (strReturnNoE != "") txtReturn_No_E.Text = strReturnNoE; else txtReturn_No_E.Text = strReturnNoS; txtAdjust_No_S.Text = strAdjustNoS; if (strAdjustNoE != "") txtAdjust_No_E.Text = strAdjustNoE; else txtAdjust_No_E.Text = strAdjustNoS; txtRemove_No_S.Text = strRemoveNoS; if (strRemoveNoE != "") txtRemove_No_E.Text = strRemoveNoE; else txtRemove_No_E.Text = strRemoveNoS; txtCreateDate.Text = dtNow.ToString("yyyy/MM/dd HH:mm:ss"); slpCreateID.Text = Session["UID"].ToString(); txtUpdateDate.Text = dtNow.ToString("yyyy/MM/dd HH:mm:ss"); slpUpdateID.Text = Session["UID"].ToString(); slpReturn_Date.Text = dtNow.ToString("yyyy/MM/dd"); //txtRemoveNo.Text = strRemoveNo; btnPrint1.Enabled = true; btnPrint2.Enabled = true; btnPrint1.OnClientClick = "AddIFrameTab('VGR04供應商退貨單明細表列印處理','../VGR/VGR041.aspx?Code=VGR04&Return_No_S=" + txtReturn_No_S.Text + "&Return_No_E=" + txtReturn_No_E.Text + "&eturn_Date=" + slpReturn_Date.Text + "');return false;"; } btnSave.Enabled = false; btnCancel.Enabled = false; ViewState["MODE"] = "VIEW"; GridView1.DataSource = dtData.DefaultView; GridView1.DataBind(); UpdatePanel1.Update(); ErrorMsgLabel.Text = "儲存成功"; } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } #endregion }
/// <summary> /// CGR05報表 /// </summary> /// <param name="ParameterList">變數清單</param> /// <returns>回傳查詢結果</returns> public DataTable VGR06_1(ArrayList ParameterList, string ReportOutputFormat, ref ReportList.ExcelOtherType EOT ) { VGRModel.VDS_VGR06_BCO bco = new VGRModel.VDS_VGR06_BCO(ConntionDB); DataTable dtData = bco.GetRptData(ParameterList); if (dtData.Rows.Count == 0) { throw new Exception("查無資料"); } else { DataTable dtResult = dtData.Copy(); DataView dv = dtData.DefaultView; dv.Sort = "Return_No asc,Item asc,Period asc"; dtData = dv.ToTable(); //取得筆數資料,筆數未滿10的倍數,塞假資料補成10的倍數(因為套表是10筆1張) int iSeqNo = 0; for (int j = 0; j < dtData.Rows.Count; j++) { if (j > 0) { if (dtData.Rows[j]["Return_No"].ToString().Trim() != dtData.Rows[j - 1]["Return_No"].ToString().Trim()) { if (iSeqNo < 10) { for (int i = 0; i < (10 - iSeqNo); i++) { DataRow drNew = dtResult.NewRow(); drNew["Return_Date"] = dtData.Rows[j - 1]["Return_Date"].ToString(); drNew["Vendor_Name"] = dtData.Rows[j - 1]["Vendor_Name"].ToString(); drNew["Vendor"] = dtData.Rows[j - 1]["Vendor"].ToString(); drNew["Business_Contact"] = dtData.Rows[j - 1]["Business_Contact"].ToString(); drNew["Business_Fax"] = dtData.Rows[j - 1]["Business_Fax"].ToString(); drNew["Return_No"] = dtData.Rows[j - 1]["Return_No"].ToString(); drNew["Tax_Total_Amt"] = decimal.Parse(dtData.Rows[j - 1]["Tax_Total_Amt"].ToString()); drNew["UnTax_Total_Amt"] = decimal.Parse(dtData.Rows[j - 1]["UnTax_Total_Amt"].ToString()); drNew["Tax_Amt"] = decimal.Parse(dtData.Rows[j - 1]["Tax_Amt"].ToString()); drNew["Item"] = "XXXXXXXXXX"; //只要ITEM是XXXXXXXXXX就抑制顯示 drNew["Item_Name"] = ""; drNew["Period"] = ""; drNew["Return_Qty"] = 0; drNew["Price"] = 0; drNew["Cost"] = 0; dtResult.Rows.Add(drNew); } } iSeqNo = 0; } } iSeqNo++; } if (iSeqNo < 10) //判斷最後一筆是否為第10筆 { for (int i = 0; i < (10 - iSeqNo); i++) { DataRow drNew = dtResult.NewRow(); drNew["Return_Date"] = dtData.Rows[dtData.Rows.Count - 1]["Return_Date"].ToString(); drNew["Vendor_Name"] = dtData.Rows[dtData.Rows.Count - 1]["Vendor_Name"].ToString(); drNew["Vendor"] = dtData.Rows[dtData.Rows.Count - 1]["Vendor"].ToString(); drNew["Business_Contact"] = dtData.Rows[dtData.Rows.Count - 1]["Business_Contact"].ToString(); drNew["Business_Fax"] = dtData.Rows[dtData.Rows.Count - 1]["Business_Fax"].ToString(); drNew["Return_No"] = dtData.Rows[dtData.Rows.Count - 1]["Return_No"].ToString(); drNew["Tax_Total_Amt"] = decimal.Parse(dtData.Rows[dtData.Rows.Count - 1]["Tax_Total_Amt"].ToString()); drNew["UnTax_Total_Amt"] = decimal.Parse(dtData.Rows[dtData.Rows.Count - 1]["UnTax_Total_Amt"].ToString()); drNew["Tax_Amt"] = decimal.Parse(dtData.Rows[dtData.Rows.Count - 1]["Tax_Amt"].ToString()); drNew["Item"] = "XXXXXXXXXX"; //只要ITEM是XXXXXXXXXX就抑制顯示 drNew["Item_Name"] = ""; drNew["Period"] = ""; drNew["Return_Qty"] = 0; drNew["Price"] = 0; drNew["Cost"] = 0; dtResult.Rows.Add(drNew); } } dv = dtResult.DefaultView; dv.Sort = "Return_No asc,Item asc,Period asc"; dtResult = dv.ToTable(); return dtResult; } }