/// <summary> /// 扫描响应事件 /// </summary> /// <param name="DecodeText">扫描到的条码内容</param> private void scan_OnDecodeEvent(string DecodeText) { var cBarCode = DecodeText; if (!cBarCode.StartsWith("SF")) { MessageBox.Show("无效条码", "Error"); return; } //产品序列号 var cSerialNumber = cBarCode.Substring(0, 16); var cmd = new SqlCommand("select * from View_ProductLabel where cBarCode=@cBarCode"); cmd.Parameters.AddWithValue("@cBarCode", cSerialNumber); var con = new SqlConnection(frmLogin.WmsCon); var dtRaw = PDAFunction.GetSqlTable(con, cmd); if (dtRaw != null && dtRaw.Rows.Count > 0) { lblcSerialNumber.Text = dtRaw.Rows[0]["cSerialNumber"].ToString(); lbldDate.Text = dtRaw.Rows[0]["dDate"].ToString(); lblcInvCode.Text = dtRaw.Rows[0]["cInvCode"].ToString(); lblcInvName.Text = dtRaw.Rows[0]["cInvName"].ToString(); lblcLotNo.Text = dtRaw.Rows[0]["FBatchNo"].ToString(); lblcOrderNumber.Text = dtRaw.Rows[0]["cOrderNumber"].ToString(); lblcInvStd.Text = dtRaw.Rows[0]["cInvStd"].ToString(); } else { lblcSerialNumber.Text = ""; lbldDate.Text = ""; lblcInvCode.Text = ""; lblcInvName.Text = ""; lblcLotNo.Text = ""; lblcOrderNumber.Text = ""; lblcInvStd.Text = ""; } }
/// <summary> /// 处理条码扫描事件 /// </summary> /// <param name="DecodeText"></param> private void scan_OnDecodeEvent(String DecodeText) { if (!DecodeText.Contains(";")) { MessageBox.Show(@"无效条码", @"Warning"); return; } var cOrder = DecodeText.Split(';'); txtBarCode.Text = cOrder[0]; var cOrderNumber = cOrder[0]; if (BoolCanOkDownLoad()) { return; } //下载采购订单 var cmd = new SqlCommand(@"select POInstock.FBillNo,t_Supplier.FName cVendor,POInstockEntry.FItemID,POInstockEntry.FEntryID,t_ICItem.FShortNumber cInvCode, t_ICItem.FNumber,FModel,t_ICItem.FName cInvName,FQty from POInstock inner join POInstockEntry on POInstock.FInterID=POInstockEntry.FInterID inner join t_ICItem on POInstockEntry.FItemID=t_ICItem.FItemID inner join t_Supplier on POInstock.FSupplyID=t_Supplier.FItemID where POInstock.FInterID=@FinterID "); cmd.Parameters.AddWithValue("@FinterID", cOrder[1]); var con = new SqlConnection(frmLogin.KisCon); DataTable dtTemp = new DataTable("dtTemp"); try { dtTemp = PDAFunction.GetSqlTable(con, cmd); } catch (Exception ex) { MessageBox.Show(ex.Message + cOrderNumber, @"Warning"); return; } if (!PDAFunction.IsCanCon()) { MessageBox.Show(@"无法连接到服务器", @"Warning"); return; } if (dtTemp == null) { MessageBox.Show(@"下载出错,请联系管理员", @"Warning"); return; } if (dtTemp.Rows.Count < 1) { MessageBox.Show(@"无此采购单号!", @"Warning"); return; } lblSum.Text = dtTemp.Rows.Count.ToString(CultureInfo.CurrentCulture) + "行"; //进行循环判断是否属于当前库区 for (var i = 0; i < dtTemp.Rows.Count; i++) { var dr = rds.RmPo.NewRmPoRow(); dr.cOrderNumber = cOrderNumber; dr.FItemID = dtTemp.Rows[i]["FItemID"].ToString(); dr.FEntryID = dtTemp.Rows[i]["FEntryID"].ToString(); dr.cInvCode = dtTemp.Rows[i]["cInvCode"].ToString(); dr.cInvName = dtTemp.Rows[i]["cInvName"].ToString(); dr.iQuantity = dtTemp.Rows[i]["FQty"].ToString(); dr.cVendor = dtTemp.Rows[i]["cVendor"].ToString(); dr.cMemo = ""; rds.RmPo.Rows.Add(dr); } }
/// <summary> /// 扫描响应事件 /// </summary> /// <param name="DecodeText">扫描到的条码内容</param> private void scan_OnDecodeEvent(string DecodeText) { var cBarCode = DecodeText; if (string.IsNullOrEmpty(lblStockPlaceID.Text)) { var cmd = new SqlCommand("select * from t_StockPlace where FNumber=@FNumber"); cmd.Parameters.AddWithValue("@FNumber", cBarCode); if (PDAFunction.ExistSqlKis(cmd)) { lblStockPlaceID.Text = cBarCode; } else { MessageBox.Show("请先扫描库位", "Error"); } return; } if ((!cBarCode.StartsWith("P*") || !cBarCode.Contains("*L*") || !cBarCode.Contains("*S*"))) { MessageBox.Show("无效条码", "Error"); return; } cBarCode = cBarCode.Substring(cBarCode.IndexOf("*S*") + 3, 16); if (!JudgeBarCode(cBarCode)) { return; } //if (!cBarCode.StartsWith("R*") || !cBarCode.Contains("*L*") || !cBarCode.Contains("*S*")) //{ // MessageBox.Show("无效条码", "Error"); // return; //} ////物料编码 //var FitemID = cBarCode.Substring(2, cBarCode.IndexOf("*L*") - 2); ////产品序列号 //var cLotNo = cBarCode.Substring(cBarCode.IndexOf("*L*") + 3, cBarCode.IndexOf("*S*") - cBarCode.IndexOf("*L*") - 3); ////产品批号 //var cSerialNumber = cBarCode.Substring(cBarCode.IndexOf("*S*") + 3, cBarCode.Length - cBarCode.IndexOf("*S*") - 3); var cmdGetQuantity = new SqlCommand("select * from View_ProductLabel where cBarCode=@cBarCode"); cmdGetQuantity.Parameters.AddWithValue("@cBarCode", cBarCode); decimal iQuantity = 0; string cLotNo = ""; int FitemID = 1; var dtTemp = PDAFunction.GetSqlTable(cmdGetQuantity); if (dtTemp == null || dtTemp.Rows.Count < 1) { MessageBox.Show("无效条码,无打印记录", "Error"); return; } try { iQuantity = decimal.Parse(dtTemp.Rows[0]["iQuantity"].ToString()); cLotNo = dtTemp.Rows[0]["FBatchNo"].ToString(); FitemID = int.Parse(dtTemp.Rows[0]["cFitemID"].ToString()); _cInvCode = dtTemp.Rows[0]["cInvCode"].ToString(); cInvName = dtTemp.Rows[0]["cInvName"].ToString(); } catch (Exception ex) { MessageBox.Show("数据异常," + ex.Message, "Error"); return; } SaveOutWareHouse(cBarCode, _cInvCode, cInvName, iQuantity, cLotNo, FitemID); lblStockPlaceID.Text = ""; }
/// <summary> /// 扫描响应事件 /// </summary> /// <param name="DecodeText">扫描到的条码内容</param> private void scan_OnDecodeEvent(string DecodeText) { var cBarCode = DecodeText; if ((!cBarCode.StartsWith("R*") || !cBarCode.Contains("*L*") || !cBarCode.Contains("*S*"))) { if ((!cBarCode.StartsWith("P*") || !cBarCode.Contains("*L*") || !cBarCode.Contains("*S*"))) { MessageBox.Show("无效条码", "Error"); return; } //产品序列号 var cSerialNumber = cBarCode.Substring(cBarCode.IndexOf("*S*") + 3, 16); var cmd = new SqlCommand("select * from View_ProductLabel where cBarCode=@cBarCode"); cmd.Parameters.AddWithValue("@cBarCode", cSerialNumber); var con = new SqlConnection(frmLogin.WmsCon); var dtRaw = PDAFunction.GetSqlTable(con, cmd); if (dtRaw != null && dtRaw.Rows.Count > 0) { lblCompanyLot.Text = "制令单号"; lblcDefine1.Text = dtRaw.Rows[0]["cSerialNumber"].ToString(); lbldDate.Text = dtRaw.Rows[0]["dDate"].ToString(); lblcInvCode.Text = dtRaw.Rows[0]["cInvCode"].ToString(); lblcInvName.Text = dtRaw.Rows[0]["cInvName"].ToString(); lblcLotNo.Text = dtRaw.Rows[0]["FBatchNo"].ToString(); lblCompany.Text = "客户订单"; lblcVendor.Text = dtRaw.Rows[0]["cOrderNumber"].ToString(); lblDate.Text = "存货编码"; lbldDate.Text = dtRaw.Rows[0]["cInvStd"].ToString(); FitemID = dtRaw.Rows[0]["cFitemID"].ToString(); } else { lblcDefine1.Text = ""; lblcDefine2.Text = ""; lblcInvCode.Text = ""; lblcInvName.Text = ""; lblcLotNo.Text = ""; lblcVendor.Text = ""; lbldDate.Text = ""; lblQuantity.Text = ""; FitemID = ""; } } else { //产品序列号 var cSerialNumber = cBarCode.Substring(cBarCode.IndexOf("*S*") + 3, 12); var cmd = new SqlCommand("select * from RmLabel where cSerialNumber=@cSerialNumber"); cmd.Parameters.AddWithValue("@cSerialNumber", cSerialNumber); var con = new SqlConnection(frmLogin.WmsCon); var dtRaw = PDAFunction.GetSqlTable(con, cmd); if (dtRaw != null && dtRaw.Rows.Count > 0) { lblCompanyLot.Text = "供应商批号"; lblCompany.Text = "供应商"; lblDate.Text = "进货日期"; lblcDefine1.Text = dtRaw.Rows[0]["cDefine1"].ToString(); lblcDefine2.Text = dtRaw.Rows[0]["cDefine2"].ToString(); lblcInvCode.Text = dtRaw.Rows[0]["cInvCode"].ToString(); lblcInvName.Text = dtRaw.Rows[0]["cInvName"].ToString(); lblcLotNo.Text = dtRaw.Rows[0]["cLotNo"].ToString(); lblcVendor.Text = dtRaw.Rows[0]["cVendor"].ToString(); lbldDate.Text = dtRaw.Rows[0]["dDate"].ToString(); FitemID = dtRaw.Rows[0]["FitemID"].ToString(); } else { lblcDefine1.Text = ""; lblcDefine2.Text = ""; lblcInvCode.Text = ""; lblcInvName.Text = ""; lblcLotNo.Text = ""; lblcVendor.Text = ""; lbldDate.Text = ""; lblQuantity.Text = ""; FitemID = ""; } } if (string.IsNullOrEmpty(FitemID)) { return; } var cmdAll = new SqlCommand("select sum(FQty) from ICInventory where FitemID=@FitemID"); cmdAll.Parameters.AddWithValue("@FitemID", FitemID); var conAll = new SqlConnection(frmLogin.KisCon); lblQuantity.Text = PDAFunction.GetSqlSingle(conAll, cmdAll); }
/// <summary> /// 扫描响应事件 /// </summary> /// <param name="DecodeText">扫描到的条码内容</param> private void scan_OnDecodeEvent(string DecodeText) { var cBarCode = DecodeText; if ((!cBarCode.StartsWith("R*") || !cBarCode.Contains("*L*") || !cBarCode.Contains("*S*"))) { if ((!cBarCode.StartsWith("P*") || !cBarCode.Contains("*L*") || !cBarCode.Contains("*S*"))) { MessageBox.Show("无效条码", "Error"); return; } //产品序列号 var cSerialNumber = cBarCode.Substring(cBarCode.IndexOf("*S*") + 3, 16); var cmd = new SqlCommand("select * from View_ProductLabel where cBarCode=@cBarCode"); cmd.Parameters.AddWithValue("@cBarCode", cSerialNumber); var con = new SqlConnection(frmLogin.WmsCon); var dtRaw = PDAFunction.GetSqlTable(con, cmd); if (dtRaw != null && dtRaw.Rows.Count > 0) { lblcInvCode.Text = dtRaw.Rows[0]["cInvCode"].ToString(); lblcInvName.Text = dtRaw.Rows[0]["cInvName"].ToString(); FitemID = dtRaw.Rows[0]["cFitemID"].ToString(); } else { lblcInvCode.Text = ""; lblcInvName.Text = ""; lblQuantity.Text = ""; FitemID = ""; } } else { //产品序列号 var cSerialNumber = cBarCode.Substring(cBarCode.IndexOf("*S*") + 3, 12); var cmd = new SqlCommand("select * from RmLabel where cSerialNumber=@cSerialNumber"); cmd.Parameters.AddWithValue("@cSerialNumber", cSerialNumber); var con = new SqlConnection(frmLogin.WmsCon); var dtRaw = PDAFunction.GetSqlTable(con, cmd); if (dtRaw != null && dtRaw.Rows.Count > 0) { lblcInvCode.Text = dtRaw.Rows[0]["cInvCode"].ToString(); lblcInvName.Text = dtRaw.Rows[0]["cInvName"].ToString(); FitemID = dtRaw.Rows[0]["FitemID"].ToString(); } else { lblcInvCode.Text = ""; lblcInvName.Text = ""; lblQuantity.Text = ""; FitemID = ""; } } if (string.IsNullOrEmpty(FitemID)) { return; } var cmdAll = new SqlCommand("select sum(FQty) from ICInventory where FitemID=@FitemID"); cmdAll.Parameters.AddWithValue("@FitemID", FitemID); var conAll = new SqlConnection(frmLogin.KisCon); lblQuantity.Text = PDAFunction.GetSqlSingle(conAll, cmdAll); var cmdDetail = new SqlCommand(@"select a.FBatchNo,FQty,c.FName FStockName,d.FNumber FStockPlaceNumber,d.FName FStockPlaceName from ICInventory a inner join t_ICItem b on a.FItemID=b.FItemID inner join t_Stock c on a.FStockID=c.FItemID inner join t_StockPlace d on a.FStockPlaceID=d.FSPID where a.FQty>0 and a.FItemID =@FItemID order by a.FItemID,a.FBatchNo,a.FStockID,a.FStockPlaceID"); cmdDetail.Parameters.AddWithValue("@FitemID", FitemID); var conDetail = new SqlConnection(frmLogin.KisCon); var dtTemp = PDAFunction.GetSqlTable(conDetail, cmdDetail); if (dtTemp == null) { return; } prods.StockDetail.Rows.Clear(); for (var i = 0; i < dtTemp.Rows.Count; i++) { var dr = prods.StockDetail.NewStockDetailRow(); dr.FBatchNo = dtTemp.Rows[i]["FBatchNo"].ToString(); dr.FQty = dtTemp.Rows[i]["FQty"].ToString(); dr.FStockName = dtTemp.Rows[i]["FStockName"].ToString(); dr.FStockPlaceNumber = dtTemp.Rows[i]["FStockPlaceNumber"].ToString(); dr.FStockPlaceName = dtTemp.Rows[i]["FStockPlaceName"].ToString(); prods.StockDetail.Rows.Add(dr); } }
/// <summary> /// 处理条码扫描事件 /// </summary> /// <param name="DecodeText"></param> private void scan_OnDecodeEvent(String DecodeText) { txtBarCode.Text = DecodeText; if (BoolCanOkDownLoad()) { return; } var cmd = new SqlCommand(@"select * from View_ShiftBomDetail where cSerialNumber=@cSerialNumber"); cmd.Parameters.AddWithValue("@cSerialNumber", txtBarCode.Text); var con = new SqlConnection(frmLogin.WmsCon); DataTable dtTemp = new DataTable("dtTemp"); try { dtTemp = PDAFunction.GetSqlTable(con, cmd); } catch (Exception ex) { MessageBox.Show(ex.Message + DecodeText, @"Warning"); return; } if (!PDAFunction.IsCanCon()) { MessageBox.Show(@"无法连接到服务器", @"Warning"); return; } if (dtTemp == null) { MessageBox.Show(@"下载出错,请联系管理员", @"Warning"); return; } if (dtTemp.Rows.Count < 1) { MessageBox.Show(@"无此班次制令单!", @"Warning"); return; } lblSum.Text = dtTemp.Rows.Count.ToString(CultureInfo.CurrentCulture) + "行"; //进行循环判断是否属于当前库区 for (var i = 0; i < dtTemp.Rows.Count; i++) { var dr = rds.RmProduce.NewRmProduceRow(); dr.cCode = DecodeText; dr.cInvCode = dtTemp.Rows[i]["cInvCode"].ToString(); dr.cInvName = dtTemp.Rows[i]["cInvName"].ToString(); dr.iQuantity = dtTemp.Rows[i]["iQuantity"].ToString(); dr.cMemo = dtTemp.Rows[i]["cMemo"].ToString(); dr.FItemID = dtTemp.Rows[i]["cFItemID"].ToString(); dr.AutoID = dtTemp.Rows[i]["AutoID"].ToString(); rds.RmProduce.Rows.Add(dr); } }
/// <summary> /// 处理条码扫描事件 /// </summary> /// <param name="DecodeText"></param> private void scan_OnDecodeEvent(String DecodeText) { txtBarCode.Text = DecodeText; var cOrderNumber = DecodeText; if (BoolCanOkDownLoad()) { return; } //下载采购订单 var cmd = new SqlCommand(@"select * from ProDelivery where cCode=@cCode"); cmd.Parameters.AddWithValue("@cCode", cOrderNumber); var con = new SqlConnection(frmLogin.WmsCon); DataTable dtTemp = new DataTable("dtTemp"); try { dtTemp = PDAFunction.GetSqlTable(con, cmd); } catch (Exception ex) { MessageBox.Show(ex.Message + cOrderNumber, @"Warning"); return; } if (!PDAFunction.IsCanCon()) { MessageBox.Show(@"无法连接到服务器", @"Warning"); return; } if (dtTemp == null) { MessageBox.Show(@"下载出错,请联系管理员", @"Warning"); return; } if (dtTemp.Rows.Count < 1) { MessageBox.Show(@"无此采购单号!", @"Warning"); return; } lblSum.Text = dtTemp.Rows.Count.ToString(CultureInfo.CurrentCulture) + "行"; for (var i = 0; i < dtTemp.Rows.Count; i++) { var dr = prods.ProDelivery.NewProDeliveryRow(); dr.cCode = cOrderNumber; dr.AutoID = dtTemp.Rows[i]["AutoID"].ToString(); dr.cCusCode = dtTemp.Rows[i]["cCusCode"].ToString(); dr.cCusName = dtTemp.Rows[i]["cCusName"].ToString(); dr.cMaker = dtTemp.Rows[i]["cMaker"].ToString(); dr.dMaketime = dtTemp.Rows[i]["dMaketime"].ToString(); dr.cDepCode = dtTemp.Rows[i]["cDepCode"].ToString(); dr.cDepName = dtTemp.Rows[i]["cDepName"].ToString(); dr.cMemo = dtTemp.Rows[i]["cMemo"].ToString(); dr.cVerifyState = dtTemp.Rows[i]["cVerifyState"].ToString(); dr.cHandler = dtTemp.Rows[i]["cHandler"].ToString(); dr.dVeriDate = dtTemp.Rows[i]["dVeriDate"].ToString(); prods.ProDelivery.Rows.Add(dr); } }