protected void btnUpdateData_Click(object sender, EventArgs e) { try { string ErrMsg; string Resault; int Qty; if (int.TryParse(this.txtRevQty.Text, out Qty) == false || int.TryParse(this.txtRtnQty.Text, out Qty)==false) { ShowErr("上架/廠退數量格式錯誤"); return; } //判斷數量是否正確 //判斷是否大於安全庫存數量及是否超過移出庫存量 int RevQty = Convert.ToInt32(txtRevQty.Text.Trim()); int RtnQty = Convert.ToInt32(txtRtnQty.Text.Trim()); int SafeQty = Convert.ToInt32(lblSafeQty.Text); int Onhd_OutQty = Convert.ToInt32(lblOnhdQtyOut.Text); int Onhd_InQty = Convert.ToInt32(lblOnhdQtyIn.Text); if (RevQty + RtnQty > Onhd_OutQty) { ShowErr("超過移出儲位庫存量"); return; } if (lblNonStock.Text == "1" && RtnQty==0) { ShowErr("廠退數量不可為0"); return; } else if (lblNonStock.Text == "0") { if (RevQty == 0) { ShowErr("上架數量不可為0"); return; } if (RevQty + Onhd_InQty > SafeQty && hidSafeFlg.Value == "1") { ShowErr("超過安全庫存量"); return; } //判斷儲位是否正確 if (slpInSection.Text1 != "D") { ShowErr("不可輸入D以外儲區"); return; } IVMModel.VDS_IVM39_BCO dbo = new IVMModel.VDS_IVM39_BCO(ConntionDB); ParameterList.Clear(); ParameterList.Add(slpITEM.Text); ParameterList.Add(txtPeriod.Text); ParameterList.Add(slpInSection.Text); dbo.CheckLocate(ParameterList, out Resault, out ErrMsg); if (Resault == "0") { ShowErr(ErrMsg); return; } } //更新 DataTable dt = new DataTable(); string SessionIDName = "IVM391_" + PageTimeStamp.Value; dt = (DataTable)Session[SessionIDName]; DataRow dr = dt.Select("BARCODE = '" + lblPreBarcode.Text.Trim() + "'")[0]; dr["INSECTION"] = slpInSection.Text; dr["REV_QTY"] = txtRevQty.Text; dr["RTN_QTY"] = txtRtnQty.Text; lblInSection.Text = slpInSection.Text; int Sort_ID = Convert.ToInt32(dt.Compute("max(Sort_ID)", "")) + 1; dr["Sort_ID"] = Sort_ID.ToString(); dr.AcceptChanges(); Session[SessionIDName] = dt; gv_Detail.DataSource = dt; gv_Detail.DataBind(); UpdatePanel1.Update(); //成功 txtRevQty.ReadOnly = true; txtRevQty.CssClass = "readtxtbox"; txtRtnQty.ReadOnly = true; txtRtnQty.CssClass = "readtxtbox"; slpInSection.Text = ""; slpInSection.Visible = false; lblInSection.Visible = true; txtBarCode.ReadOnly = false; txtBarCode.Text = ""; txtBarCode.CssClass = ""; Focus(txtBarCode.ClientID); btnUpdateData.Visible = false; btnCanCelUpdate.Visible = false; } catch { } }
protected void btnCheck_Click(object sender, EventArgs e) { ErrorMsgLabel.Text = ""; bool IsOk = false; int i = this.txtBarCode.Text.Trim().Length; if (i != 8 && i != 10 && i != 12 && i != 13 && i != 15 && i != 18) { ShowErr("條碼長度不正確"); return; } if (lblPreBarcode.Text.Trim() != "") { if (lblPreBarcode.Text == txtBarCode.Text.Trim()) { if (CheckQty()) { SetGV("InsertExistOnTop"); IsOk = true; } else return; } else { ClearData(); } } if (!IsOk) { DataTable dt_s = new DataTable(); dt_s = CheckInGV(); //如果條碼存在GridView中,則取出GridView的資料 if (dt_s != null) { SetTopData(dt_s); if (CheckQty()) { SetGV("InsertExistOnGV"); IsOk = true; } else return; } else { try { IVMModel.VDS_IVM39_BCO dbo = new IVMModel.VDS_IVM39_BCO(ConntionDB); DataTable dt_i = dbo.QueryITEM(txtBarCode.Text.Trim(),lblOutSection.Text); if (dt_i.Rows.Count == 1) { if (dt_i.Rows[0]["ERRMSG"].ToString() == "") { SetTopData(dt_i); SetGV("NEW"); } else { SetTopData(dt_i); lblPreBarcode.Text = ""; ShowErr(dt_i.Rows[0]["ERRMSG"].ToString()); return; } } else { ShowErr("條碼找不到資料或找到多筆資料"); return; } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } } } txtBarCode.Text = ""; Focus(txtBarCode.ClientID); }