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.GetProcessOrderUnMatch(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 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.InsertProcessOrderUnMatch(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.GetProcessOrderUnMatch(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 countUnMatch = 0;
foreach (GridViewRow item in gridBarcodeScan.Rows)
{
var status = item.Cells[3].Text;
if (status.Equals("Unmatch"))
{
item.Cells[3].Style["background-color"] = "yellow";
countUnMatch++;
}
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 unMatchQty = countUnMatch;
lbUnMatchQty.InnerText = unMatchQty.ToString();
actionResult = true;
msg = "บันทึกข้อมูลสำเร็จ";
}
else
{
actionResult = false;
msg = "เกิดข้อผิดพลาด กรุณาตรวจสอบ!";
}
}
catch (Exception ex)
{
throw ex;
}
}