private void btnDelete_Click(object sender, EventArgs e)
{
if (dGridMain.CurrentRowIndex < 0)
{
return;
}
if (MessageBox.Show(@"确定删除当前下载的生产订单?", @"确定删除?", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question,
MessageBoxDefaultButton.Button3) != DialogResult.Yes)
{
return;
}
var cmd = new SQLiteCommand("select * from RmProduceDetail where cCode=@cCode");
cmd.Parameters.AddWithValue("@cCode", rds.RmProduce.Rows[dGridMain.CurrentRowIndex]["cCode"]);
if (PDAFunction.ExistSqlite(frmLogin.SqliteCon, cmd))
{
MessageBox.Show(@"当前班次制令单已经进行过领料,不允许删除!", @"Warning");
return;
}
//if (!PDAFunction.IsCanCon())
//{
// MessageBox.Show(@"无法连接到服务器", @"Warning");
// return;
//}
var dCmd = new SQLiteCommand("Delete from RmProduce where cCode=@cCode");
dCmd.Parameters.AddWithValue("@cCode", rds.RmProduce.Rows[dGridMain.CurrentRowIndex]["cCode"]);
PDAFunction.ExecSqLite(dCmd);
MessageBox.Show(@"删除成功", @"Success");
LoaRmProduce();
}
/// <summary>
/// 判断出库的条码是否已经出库
/// </summary>
/// <param name="cInvCode"></param>
/// <returns></returns>
private bool JudgeBarCode(string cBarCode)
{
var bOutAllCmd = new SQLiteCommand("select * from ProStoreDetail where cBarCode=@cBarCode");
bOutAllCmd.Parameters.AddWithValue("@cBarCode", cBarCode);
if (PDAFunction.ExistSqlite(frmLogin.SqliteCon, bOutAllCmd))
{
MessageBox.Show(@"该包产品已经出库！");
return(false);
}
return(true);
}
/// <summary>
/// 判断该产品的批号是否全部出完
/// </summary>
/// <param name="cInvCode"></param>
/// <returns></returns>
private bool OutAll(string cInvCode)
{
var bOutAllCmd = new SQLiteCommand("select * from RmPo where cInvCode=@cInvCode and ifnull(iScanQuantity,0)<iQuantity and cOrderNumber=@cOrderNumber");
bOutAllCmd.Parameters.AddWithValue("@cInvCode", cInvCode);
bOutAllCmd.Parameters.AddWithValue("@cOrderNumber", lblOrderNumber.Text);
if (!PDAFunction.ExistSqlite(frmLogin.SqliteCon, bOutAllCmd))
{
MessageBox.Show(@"该产品已经全部扫描完成");
return(false);
}
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 OutAll(string FItemID)
{
var bOutAllCmd = new SQLiteCommand("select * from RmProduce where FItemID=@FItemID and iScanQuantity<iQuantity and cCode=@cCode");
bOutAllCmd.Parameters.AddWithValue("@FItemID", FItemID);
bOutAllCmd.Parameters.AddWithValue("@cCode", lblOrderNumber.Text);
if (!PDAFunction.ExistSqlite(frmLogin.SqliteCon, bOutAllCmd))
{
if (!PDAFunction.ExistSqlite(frmLogin.SqliteCon, bOutAllCmd))
{
MessageBox.Show(@"该产品已经领料完成");
return(false);
}
}
return(true);
}
/// <summary>
/// 是不可以满足下载出库通知单的条件
/// </summary>
/// <returns></returns>
private bool BoolCanOkDownLoad()
{
if (string.IsNullOrEmpty(txtBarCode.Text))
{
return(true);
}
if (rds.RmPo.Rows.Count > 0)
{
MessageBox.Show(@"请先保存上一个采购订单!", @"Warning");
return(true);
}
var bCmd = new SQLiteCommand("select * from RmPo where cOrderNumber=@cOrderNumber");
bCmd.Parameters.AddWithValue("@cOrderNumber", txtBarCode.Text.ToUpper());
if (PDAFunction.ExistSqlite(frmLogin.SqliteCon, bCmd))
{
MessageBox.Show(@"该采购订单已经下载过!", @"Warning");
txtBarCode.Text = "";
return(true);
}
return(false);
}
