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