public static string ConfirmProcessOrderGR(string poId) { string result = ""; try { Utility utility = new Utility(); bool resultUps = false; BLProcessOrder blPrOrder = new BLProcessOrder(); DataTable dt = new DataTable(); dt.Columns.Add("result"); dt.Rows.Add("false"); resultUps = blPrOrder.UpdProcessOrderGR(poId); if (resultUps) { dt.Rows[0]["result"] = "true"; } result = utility.DataTableToJSONWithJavaScriptSerializer(dt); } catch (Exception ex) { throw ex; } return(result); }
public static string GetProcessOrderGR(string processOrder, string btfs, string status, string grStart, string grEnd) { BLProcessOrder blPrOrder = new BLProcessOrder(); DataSet ds = new DataSet(); Utility utility = new Utility(); string result = ""; try { ds = blPrOrder.GetProcessOrderGR(processOrder, btfs, status, grStart, grEnd); result = utility.DataTableToJSONWithJavaScriptSerializer(ds.Tables[0]); } catch (Exception ex) { } return(result); }
protected void txtProcessOrder_TextChanged(object sender, EventArgs e) { try { if (!String.IsNullOrEmpty(txtProcessOrder.Text)) { BLProcessOrder blOrder = new BLProcessOrder(); DataSet ds = blOrder.GetProcessOrder(txtProcessOrder.Text); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { txtBtfs.Text = dr["BTFS"].ToString(); txtMaterial.Text = dr["MAT_NO"].ToString(); txtMatDesc.Text = dr["MAT_DESC"].ToString(); txtOrderQty.Text = dr["ORDER_QTY"].ToString(); txtCoinType.Text = dr["COIN_DESC"].ToString(); lbMatchQty.InnerText = dr["MATCH_QTY"].ToString(); hdProcessOrderValid.Value = "Y"; } } else { msg = "ไม่พบ ProcessOrder ที่แสกน !"; actionResult = false; } } else { msg = "ไม่พบ ProcessOrder ที่แสกน !"; actionResult = false; } } } catch (Exception ex) { throw ex; } }
protected void txtBarcodeScan_OnTextChanged(object sender, EventArgs e) { int rowIndex = 0; try { if (!String.IsNullOrEmpty(txtBarcodeScan.Text) && txtBarcodeScan.Text.Length == 11 && IsDigitsOnly(txtBarcodeScan.Text)) { BLProcessOrder blPrOrder = new BLProcessOrder(); DataSet ds = blPrOrder.GetProcessOrderMatch(txtBarcodeScan.Text.Trim(), txtProcessOrder.Text.Trim()); if (ViewState["gridBarcodeScan"] != null) { DataTable dt = (DataTable)ViewState["gridBarcodeScan"]; DataRow dr = null; if (dt.Rows.Count > 0) { if (!IsDupplicateBarcode(dt, txtBarcodeScan.Text) && ds.Tables[0].Rows.Count == 0) { dr = dt.NewRow(); dr["No"] = dt.Rows.Count + 1; dr["Barcode"] = txtBarcodeScan.Text; dt.Rows.Add(dr); ViewState["gridBarcodeScan"] = dt; gridBarcodeScan.DataSource = dt; gridBarcodeScan.DataBind(); //var orderQty = Convert.ToInt32(txtOrderQty.Text); //var matchQty = dt.Rows.Count; //var remainQty = orderQty - matchQty; //lbMatchQty.InnerText = matchQty.ToString(); //lbRemainQty.InnerText = remainQty.ToString(); actionResult = true; } else { //Barcode Dupplicate actionResult = false; msg = "Barcode ถูกยิงไปแล้ว กรุณาลองใหม่!"; } } else { if (ds.Tables[0].Rows.Count == 0) { //after delete all SetInitialRow(txtBarcodeScan.Text); //var orderQty = Convert.ToInt32(txtOrderQty.Text); //var matchQty = 1; //var remainQty = orderQty - matchQty; //lbMatchQty.InnerText = matchQty.ToString(); //lbRemainQty.InnerText = remainQty.ToString(); actionResult = true; } else { //Barcode Dupplicate actionResult = false; msg = "Barcode ถูกยิงไปแล้ว กรุณาลองใหม่!"; } } } else { if (ds.Tables[0].Rows.Count == 0) { //First Record SetInitialRow(txtBarcodeScan.Text); //var orderQty = Convert.ToInt32(txtOrderQty.Text); //var matchQty = 1; //var remainQty = orderQty - matchQty; //lbMatchQty.InnerText = matchQty.ToString(); //lbRemainQty.InnerText = remainQty.ToString(); actionResult = true; } else { //Barcode Dupplicate actionResult = false; msg = "Barcode ถูกยิงไปแล้ว กรุณาลองใหม่!"; } } if (gridBarcodeScan.Rows.Count > 0 || actionResult) { btnSaveTemp.Visible = true; btnCancelScanBarcode.Visible = true; } else { btnSaveTemp.Visible = false; btnCancelScanBarcode.Visible = false; } } else { //Barcode invalid actionResult = false; msg = "รูปแบบ Barcode ไม่ถูกต้อง กรุณาลองใหม่!"; } //Set Focus txtBarcodeScan.Focus(); txtBarcodeScan.Text = ""; } catch (Exception ex) { throw ex; } }
protected void btnSave2_ServerClick(object sender, EventArgs e) { try { bool result = false; BLProcessOrder blPrOrder = new BLProcessOrder(); string barcode = ""; var users = (User)Session["User"]; var bcStart = txtBarcodeStart.Text; var bcEnd = txtBarcodeEnd.Text; var format = bcStart.Substring(0, 7); int stRunning = Convert.ToInt32(bcStart.Substring(bcStart.Length - 4)); int endRunning = Convert.ToInt32(bcEnd.Substring(bcStart.Length - 4)); for (int i = stRunning; i <= endRunning; i++) { var running = i.ToString().PadLeft(4, '0'); barcode = barcode + format + running + ","; } barcode = barcode.Substring(0, barcode.Length - 1); result = blPrOrder.InsertProcessOrderMatch(txtProcessOrder.Text, barcode, users.UserName, users.DeptName); if (result) { var spBarcode = barcode.Split(','); DataTable dt = new DataTable(); DataRow dr = null; dt.Columns.Add(new DataColumn("No", typeof(string))); dt.Columns.Add(new DataColumn("Barcode", typeof(string))); dt.Columns.Add(new DataColumn("Delete", typeof(string))); dt.Columns.Add(new DataColumn("Status", typeof(string))); var n = 1; foreach (var bc in spBarcode) { DataSet ds = blPrOrder.GetProcessOrderMatch(bc, txtProcessOrder.Text); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { dr = dt.NewRow(); dr["No"] = n; dr["Barcode"] = bc; dr["Delete"] = string.Empty; dr["Status"] = ds.Tables[0].Rows[0]["STATUS"]; dt.Rows.Add(dr); n++; } } } ViewState["gridBarcodeScan"] = dt; gridBarcodeScan.Columns[3].Visible = true; gridBarcodeScan.Columns[2].Visible = false; gridBarcodeScan.DataSource = dt; gridBarcodeScan.DataBind(); gridBarcodeScan.HeaderRow.Cells[0].CssClass = "visiblecol"; var countMatch = 0; foreach (GridViewRow item in gridBarcodeScan.Rows) { var status = item.Cells[3].Text; if (status.Equals("Matched")) { item.Cells[3].Style["background-color"] = "green"; countMatch++; } else { item.Cells[3].Style["background-color"] = "red"; } } btnSaveTemp.Visible = false; btnCancelScanBarcode.Visible = false; btnBack.Visible = true; txtBarcodeScan.Style["display"] = "none"; //Next Step dvProcessOrder.Style["display"] = "none"; dvScanBarcode.Style["display"] = "block"; dvRangesBarcode.Style["display"] = "none"; lbPrOrder.InnerText = txtProcessOrder.Text; lbBtfs.InnerText = txtBtfs.Text; lbOrderQty.InnerText = txtOrderQty.Text; var orderQty = Convert.ToInt32(txtOrderQty.Text); var matchQty = Convert.ToInt32(lbMatchQty.InnerText) + countMatch; var remainQty = orderQty - matchQty; lbMatchQty.InnerText = matchQty.ToString(); lbRemainQty.InnerText = remainQty.ToString(); btnBack.Visible = true; actionResult = true; msg = "บันทึกข้อมูลสำเร็จ"; } else { actionResult = false; msg = "เกิดข้อผิดพลาด กรุณาตรวจสอบ!"; } } catch (Exception ex) { throw ex; } }
protected void btnSave_ServerClick(object sender, EventArgs e) { try { bool result = false; BLProcessOrder blPrOrder = new BLProcessOrder(); string barcode = ""; var users = (User)Session["User"]; if (ViewState["gridBarcodeScan"] != null) { DataTable dt = (DataTable)ViewState["gridBarcodeScan"]; foreach (DataRow dr in dt.Rows) { barcode = barcode + dr["Barcode"].ToString() + ","; } barcode = barcode.Substring(0, barcode.Length - 1); } result = blPrOrder.InsertProcessOrderMatch(txtProcessOrder.Text, barcode, users.UserName, users.DeptName); if (result) { var spBarcode = barcode.Split(','); DataTable dt = (DataTable)ViewState["gridBarcodeScan"]; foreach (var bc in spBarcode) { DataSet ds = blPrOrder.GetProcessOrderMatch(bc, txtProcessOrder.Text); foreach (DataRow dr in dt.Rows) { if (dr["Barcode"].ToString().Equals(bc)) { dr["Status"] = ds.Tables[0].Rows[0]["STATUS"]; } } } ViewState["gridBarcodeScan"] = null; gridBarcodeScan.Columns[3].Visible = true; gridBarcodeScan.Columns[2].Visible = false; gridBarcodeScan.DataSource = dt; gridBarcodeScan.DataBind(); gridBarcodeScan.HeaderRow.Cells[0].CssClass = "visiblecol"; var countMatch = 0; foreach (GridViewRow item in gridBarcodeScan.Rows) { var status = item.Cells[3].Text; if (status.Equals("Matched")) { item.Cells[3].Style["background-color"] = "green"; countMatch++; } else { item.Cells[3].Style["background-color"] = "red"; } } btnSaveTemp.Visible = false; btnCancelScanBarcode.Visible = false; btnBack.Visible = true; txtBarcodeScan.Style["display"] = "none"; lbBarcodeScan.Style["display"] = "none"; var orderQty = Convert.ToInt32(txtOrderQty.Text); var matchQty = Convert.ToInt32(lbMatchQty.InnerText) + countMatch; var remainQty = orderQty - matchQty; lbMatchQty.InnerText = matchQty.ToString(); lbRemainQty.InnerText = remainQty.ToString(); actionResult = true; msg = "บันทึกข้อมูลสำเร็จ"; } else { actionResult = false; msg = "เกิดข้อผิดพลาด กรุณาตรวจสอบ!"; } } catch (Exception ex) { throw ex; } }