/// <summary>
/// 获取波次单号
/// </summary>
private void LoaRmPo()
{
var sqLiteCmd = new SQLiteCommand("select cOrderNumber,max(dLoadDate) dLoadDate,sum(iQuantity) iQuantity,max(cVendor) cVendor,max(cMemo) cMemo from RmPo group by cOrderNumber");
rds.RmPo.Rows.Clear();
PDAFunction.GetSqLiteTable(sqLiteCmd, rds.RmPo);
}
/// <summary>
/// 获取波次单号
/// </summary>
private void LoaRmProduce()
{
var sqLiteCmd = new SQLiteCommand("select cCode,max(dLoadDate) dLoadDate,sum(iQuantity) iQuantity,max(cMemo) cMemo from RmProduce group by cCode");
rds.RmProduce.Rows.Clear();
PDAFunction.GetSqLiteTable(sqLiteCmd, rds.RmProduce);
}
/// <summary>
/// 获取波次单号
/// </summary>
private void LoaProDelivery()
{
var sqLiteCmd = new SQLiteCommand("select AutoID,cCode,cCusName,cMaker,cDepName,cMemo,cVerifyState from ProDelivery ");
prods.ProDelivery.Rows.Clear();
PDAFunction.GetSqLiteTable(sqLiteCmd, prods.ProDelivery);
}
private void ProDeliveryDetail_Load(object sender, EventArgs e)
{
InitGrid();
var cmd = new SQLiteCommand("select * from ProDeliveryDetail where cCode=@cCode");
cmd.Parameters.AddWithValue("@cCode", lblOrderNumber.Text);
PDAFunction.GetSqLiteTable(cmd, prods.ProDeliveryDetail);
}
private void RefreshGrid()
{
rds.RmPo.Clear();
var cmd = new SQLiteCommand("select * from RmPo where cOrderNumber=@cOrderNumber");
cmd.Parameters.AddWithValue("@cOrderNumber", lblOrderNumber.Text);
PDAFunction.GetSqLiteTable(cmd, rds.RmPo);
}
private void RefreshGrid()
{
rds.RmProduce.Clear();
var cmd = new SQLiteCommand("select id,cCode,cInvCode,cInvName,iQuantity,iScanQuantity,cMemo from RmProduce where cCode=@cCode");
cmd.Parameters.AddWithValue("@cCode", lblOrderNumber.Text);
PDAFunction.GetSqLiteTable(cmd, rds.RmProduce);
}
private void RefreshGrid()
{
//重新取出所有的数据
prods.ProStoreDetail.Rows.Clear();
prods.ProStoreDetail.Columns.Remove("RowNo");
DataColumn cAutoID = new DataColumn("RowNo", typeof(Int32));
cAutoID.AutoIncrement = true;
cAutoID.AutoIncrementSeed = 1;
cAutoID.AutoIncrementStep = 1;
prods.ProStoreDetail.Columns.Add(cAutoID);
var cmd = new SQLiteCommand("select id,cBarCode,cLotNo,FItemID,cInvCode,cInvName,iQuantity,cUser,FSPNumber,dScanTime from ProStoreDetail");
PDAFunction.GetSqLiteTable(cmd, prods.ProStoreDetail);
}
/// <summary>
/// 判断出库的产品是否包含在出库单中
/// </summary>
/// <param name="cInvCode"></param>
/// <returns></returns>
private bool JudgeInvCode(string FitemID)
{
var bOutAllCmd = new SQLiteCommand("select * from RmPo where FitemID=@FitemID and cOrderNumber=@cOrderNumber");
bOutAllCmd.Parameters.AddWithValue("@FitemID", FitemID);
bOutAllCmd.Parameters.AddWithValue("@cOrderNumber", lblOrderNumber.Text);
var dt = PDAFunction.GetSqLiteTable(bOutAllCmd);
if (dt == null || dt.Rows.Count < 1)
{
MessageBox.Show(@"该采购订单不包含此产品！");
return(false);
}
cInvName = dt.Rows[0]["cInvName"].ToString();
_cInvCode = dt.Rows[0]["cInvCode"].ToString();
return(true);
}
private void RefreshGrid()
{
//重新取出所有的数据
rds.RmProduceDetail.Rows.Clear();
rds.RmProduceDetail.Columns.Remove("RowNo");
DataColumn cAutoID = new DataColumn("RowNo", typeof(Int32));
cAutoID.AutoIncrement = true;
cAutoID.AutoIncrementSeed = 1;
cAutoID.AutoIncrementStep = 1;
rds.RmProduceDetail.Columns.Add(cAutoID);
var selectCmd = new SQLiteCommand("select * from RmProduceDetail where cCode=@cCode order by id desc");
selectCmd.Parameters.AddWithValue("@cCode", lblOrderNumber.Text);
PDAFunction.GetSqLiteTable(selectCmd, rds.RmProduceDetail);
if (rds.RmProduceDetail.Rows.Count >= 1)
{
dGridMain.CurrentRowIndex = 0;
}
var selectSumCmd = new SQLiteCommand("select sum(iQuantity) from RmProduceDetail where cCode=@cCode");
selectSumCmd.Parameters.AddWithValue("@cCode", lblOrderNumber.Text);
lblSum.Text = PDAFunction.GetScalreExecSqLite(selectSumCmd);
var bOutAllCmd = new SQLiteCommand("select * from RmProduce where cCode=@cCode and ifnull(iScanQuantity,0)<ifnull(iQuantity,0)");
bOutAllCmd.Parameters.AddWithValue("@cCode", lblOrderNumber.Text);
if (PDAFunction.ExistSqlite(frmLogin.SqliteCon, bOutAllCmd))
{
if (PDAFunction.ExistSqlite(frmLogin.SqliteCon, bOutAllCmd))
{
lblOutAll.Text = "未完成";
}
else
{
lblOutAll.Text = "完成";
}
}
}
///// <summary>
///// 判断出库产品的序列号是否已经出库
///// </summary>
///// <param name="cInvCode"></param>
///// <returns></returns>
//private bool JudgeBarCode(string cSerialNumber)
//{
// var bDeliveryCmd = new SQLiteCommand("select * from RmProduceDetail where cSerialNumber=@cSerialNumber");
// bDeliveryCmd.Parameters.AddWithValue("@cSerialNumber", cSerialNumber);
// if (PDAFunction.ExistSqlite(frmLogin.SqliteCon, bDeliveryCmd))
// if (PDAFunction.ExistSqlite(frmLogin.SqliteCon, bDeliveryCmd))
// {
// MessageBox.Show(@"该产品已经扫描！");
// return false;
// }
// return true;
//}
/// <summary>
/// 判断出库的产品是否包含在出库单中
/// </summary>
/// <param name="cInvCode"></param>
/// <returns></returns>
private bool JudgeInvCode(string FItemID)
{
var bOutAllCmd = new SQLiteCommand("select AutoID,cInvCode,cInvName from RmProduce where cCode=@cCode and FItemID=@FItemID");
bOutAllCmd.Parameters.AddWithValue("@cCode", lblOrderNumber.Text);
bOutAllCmd.Parameters.AddWithValue("@FItemID", FItemID);
var dt = PDAFunction.GetSqLiteTable(bOutAllCmd);
if (dt == null || dt.Rows.Count < 1)
{
MessageBox.Show(@"该生产订单不包含此产品！");
return(false);
}
cInvName = dt.Rows[0]["cInvName"].ToString();
_cInvCode = dt.Rows[0]["cInvCode"].ToString();
ShiftID = dt.Rows[0]["AutoID"].ToString();
return(true);
}
private void RefreshGrid()
{
//重新取出所有的数据
prods.ProDeliveryDetail.Rows.Clear();
prods.ProDeliveryDetail.Columns.Remove("RowNo");
DataColumn cAutoID = new DataColumn("RowNo", typeof(Int32));
cAutoID.AutoIncrement = true;
cAutoID.AutoIncrementSeed = 1;
cAutoID.AutoIncrementStep = 1;
prods.ProDeliveryDetail.Columns.Add(cAutoID);
var cmd = new SQLiteCommand("select * from ProDeliveryDetail where cCode=@cCode");
cmd.Parameters.AddWithValue("@cCode", lblOrderNumber.Text);
PDAFunction.GetSqLiteTable(cmd, prods.ProDeliveryDetail);
}
/// <summary>
/// 将拣货的主表也上传到服务器上
/// </summary>
/// <param name="cGuid"></param>
private void UpLoadMain(string cGuid)
{
rds.RmStoreDetail.Rows.Clear();
var Sqlitecmd = new SQLiteCommand("select * from RmPo where cOrderNumber=@cOrderNumber");
Sqlitecmd.Parameters.AddWithValue("@cOrderNumber", lblOrderNumber.Text);
PDAFunction.GetSqLiteTable(Sqlitecmd, rds.RmPo);
for (var i = 0; i <= rds.RmPo.Rows.Count - 1; i++)
{
ExecUpLoad(i, cGuid);
}
//using (var con = new SqlConnection(frmLogin.WmsCon))
//{
// using (var cmd = con.CreateCommand())
// {
// cmd.CommandText = "insert into ProDelivery(cCode,cGuid) values(@cCode,@cGuid)";
// cmd.Parameters.AddWithValue("@cCode", lblOwhNumber.Text);
// cmd.Parameters.AddWithValue("@cGuid", cGuid.ToString());
// con.Open();
// cmd.ExecuteNonQuery();
// }
//}
}
/// <summary>
/// 保存出库扫描,并重新进入出库单号的扫描获取
/// </summary>
private void SaveOutWareHouse(string cSerialNumber, string cInvCode, string cInvName, decimal iQuantity, string cLotNo, string FitemID)
{
var bInv = new SQLiteCommand("select iScanQuantity,iQuantity,FitemID,FEntryID from RmPo where cInvCode=@cInvCode and cOrderNumber=@cOrderNumber");
bInv.Parameters.AddWithValue("@cInvCode", cInvCode);
bInv.Parameters.AddWithValue("@cOrderNumber", lblOrderNumber.Text);
var dt = PDAFunction.GetSqLiteTable(bInv);
if (dt == null || dt.Rows.Count < 1)
{
MessageBox.Show(@"获取数据出错！");
return;
}
//var PlusCmd = new SQLiteCommand("update RmPo set iScanQuantity=ifnull(iScanQuantity,0)+@iQuantity where cOrderNumber=@cOrderNumber and cInvCode=@cInvCode ");
//PlusCmd.Parameters.AddWithValue("@cOrderNumber", lblOrderNumber.Text);
//PlusCmd.Parameters.AddWithValue("@iQuantity", iQuantity);
//PlusCmd.Parameters.AddWithValue("@cInvCode", cInvCode);
//PDAFunction.ExecSqLite(PlusCmd);
decimal iFSQty = 0, iFQty = 0;
for (var i = 0; i < dt.Rows.Count; i++)
{
try
{
iFSQty = decimal.Parse(dt.Rows[i]["iScanQuantity"].ToString());
iFQty = decimal.Parse(dt.Rows[i]["iQuantity"].ToString());
}
catch (Exception)
{
MessageBox.Show("无法取得通知单内原料批号的数量");
return;
}
if ((iFSQty + iQuantity) <= iFQty)
{
var sqLiteCmd = new SQLiteCommand("insert into RmStoreDetail(cSerialNumber,cOrderNumber,cLotNo,cInvCode,cInvName,iQuantity,cUser,FEntryID,FitemID,FSPNumber) " +
"values(@cSerialNumber,@cOrderNumber,@cLotNo,@cInvCode,@cInvName,@iQuantity,@cUser,@FEntryID,@FitemID,@FSPNumber)");
sqLiteCmd.Parameters.AddWithValue("@cSerialNumber", cSerialNumber);
sqLiteCmd.Parameters.AddWithValue("@cOrderNumber", lblOrderNumber.Text);
sqLiteCmd.Parameters.AddWithValue("@cLotNo", cLotNo);
sqLiteCmd.Parameters.AddWithValue("@cInvCode", cInvCode);
sqLiteCmd.Parameters.AddWithValue("@cInvName", cInvName);
sqLiteCmd.Parameters.AddWithValue("@iQuantity", iQuantity);
sqLiteCmd.Parameters.AddWithValue("@cUser", frmLogin.lUser);
sqLiteCmd.Parameters.AddWithValue("@FEntryID", dt.Rows[i]["FEntryID"].ToString());
sqLiteCmd.Parameters.AddWithValue("@FitemID", FitemID);
sqLiteCmd.Parameters.AddWithValue("@FSPNumber", lblStockPlaceID.Text);
PDAFunction.ExecSqLite(sqLiteCmd);
var PlusCmd = new SQLiteCommand("update RmPo set iScanQuantity=ifnull(iScanQuantity,0)+@iQuantity where cOrderNumber=@cOrderNumber and cInvCode=@cInvCode and FEntryID=@FEntryID");
PlusCmd.Parameters.AddWithValue("@cOrderNumber", lblOrderNumber.Text);
PlusCmd.Parameters.AddWithValue("@iQuantity", iQuantity);
PlusCmd.Parameters.AddWithValue("@cInvCode", cInvCode);
PlusCmd.Parameters.AddWithValue("@FEntryID", dt.Rows[i]["FEntryID"].ToString());
PDAFunction.ExecSqLite(PlusCmd);
txtBarCode.Text = "";
txtBarCode.Focus();
RefreshGrid();
return;
}
else
{
var sqLiteCmd = new SQLiteCommand("insert into RmStoreDetail(cSerialNumber,cOrderNumber,cLotNo,cInvCode,cInvName,iQuantity,cUser,FEntryID,FitemID,FSPNumber) " +
"values(@cSerialNumber,@cOrderNumber,@cLotNo,@cInvCode,@cInvName,@iQuantity,@cUser,@FEntryID,@FitemID,@FSPNumber)");
sqLiteCmd.Parameters.AddWithValue("@cSerialNumber", cSerialNumber);
sqLiteCmd.Parameters.AddWithValue("@cOrderNumber", lblOrderNumber.Text);
sqLiteCmd.Parameters.AddWithValue("@cLotNo", cLotNo);
sqLiteCmd.Parameters.AddWithValue("@cInvCode", cInvCode);
sqLiteCmd.Parameters.AddWithValue("@cInvName", cInvName);
sqLiteCmd.Parameters.AddWithValue("@iQuantity", iQuantity);
sqLiteCmd.Parameters.AddWithValue("@cUser", frmLogin.lUser);
sqLiteCmd.Parameters.AddWithValue("@FEntryID", dt.Rows[i]["FEntryID"].ToString());
sqLiteCmd.Parameters.AddWithValue("@FitemID", FitemID);
sqLiteCmd.Parameters.AddWithValue("@FSPNumber", lblStockPlaceID.Text);
PDAFunction.ExecSqLite(sqLiteCmd);
var PlusCmd = new SQLiteCommand("update RmPo set iScanQuantity=ifnull(iScanQuantity,0)+@iQuantity where cOrderNumber=@cOrderNumber and cInvCode=@cInvCode and FEntryID=@FEntryID");
PlusCmd.Parameters.AddWithValue("@cOrderNumber", lblOrderNumber.Text);
PlusCmd.Parameters.AddWithValue("@iQuantity", iQuantity);
PlusCmd.Parameters.AddWithValue("@cInvCode", cInvCode);
PlusCmd.Parameters.AddWithValue("@FEntryID", dt.Rows[i]["FEntryID"].ToString());
PDAFunction.ExecSqLite(PlusCmd);
iQuantity = iQuantity + iFSQty - iFQty;
}
}
txtBarCode.Text = "";
txtBarCode.Focus();
RefreshGrid();
}
