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 = "完成";
}
}
}
