/// <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);
}
}
