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