private void btn增加物资验收记录_Click(object sender, EventArgs e)
{
物资验收记录 form = new 物资验收记录(mainform);
form.Show();
if (dataGridView1.Rows.Count > 0)
{
dataGridView1.FirstDisplayedScrollingRowIndex = dataGridView1.Rows.Count - 1;
}
}
void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0 && e.ColumnIndex >= 0)
{
int id = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[0].Value);
物资验收记录 form = new 物资验收记录(mainform, id);
form.Owner = this;
form.ShowDialog();
}
}
private void btn提交审核_Click(object sender, EventArgs e)
{
String n;
if (!checkOuterData(out n))
{
MessageBox.Show("请填写完整的信息: " + n, "提示");
return;
}
SqlDataAdapter da;
SqlCommandBuilder cb;
DataTable dt;
da = new SqlDataAdapter("select * from 待审核 where 表名='不合格品处理记录' and 对应ID=" + dtOuter.Rows[0]["ID"], mySystem.Parameter.conn);
cb = new SqlCommandBuilder(da);
dt = new DataTable("temp");
da.Fill(dt);
DataRow dr = dt.NewRow();
dr["表名"] = "不合格品处理记录";
dr["对应ID"] = dtOuter.Rows[0]["ID"];
dt.Rows.Add(dr);
da.Update(dt);
dtOuter.Rows[0]["现场应急处理措施审核员"] = "__待审核";
_formState = Parameter.FormState.待审核;
btn提交审核.Enabled = false;
daOuter.Update((DataTable)bsOuter.DataSource);
btn保存.PerformClick();
setFormState();
setEnableReadOnly();
setControlFalse();
// 判断是否要生产请验单等
int tmpID = Convert.ToInt32(dtOuter.Rows[0]["物资验收记录ID"]);
da = new SqlDataAdapter("select * from 不合格品处理记录 where 物资验收记录ID=" + tmpID, mySystem.Parameter.conn);
dt = new DataTable("temp");
foreach (DataRow nndr in dt.Rows)
{
if (nndr["现场应急处理措施审核员"].ToString() == "")
{
return;
}
}
MessageBox.Show("本物资验收单下的所有物料均检验完毕，正在生成物资请验单、取样记录、检验台账！");
物资验收记录 form = new 物资验收记录(mainform, tmpID);
form.create请验单();
form.create取样记录();
form.insert检验台账();
form.insert库存台帐();
}
void tsi_Click(object sender, EventArgs e)
{
SqlDataAdapter da;
DataTable dt;
if (this.Name == sender.ToString())
{
return;
}
int id;
if (this.Name == "物资验收记录")
{
id = Convert.ToInt32(dtOuter.Rows[0]["ID"]);
}
else
{
id = Convert.ToInt32(dtOuter.Rows[0]["物资验收记录ID"]);
}
try
{
switch (sender.ToString())
{
case "物资验收记录":
物资验收记录 form1 = new 物资验收记录(mainform, id);
form1.Show();
break;
case "物资请验单":
da = new SqlDataAdapter("select * from 物资请验单 where 物资验收记录ID=" + id, mySystem.Parameter.conn);
dt = new DataTable();
da.Fill(dt);
物资请验单 form2 = new 物资请验单(mainform, Convert.ToInt32(dt.Rows[0]["ID"]));
form2.Show();
break;
case "检验记录":
da = new SqlDataAdapter("select * from 检验记录 where 物资验收记录ID=" + id, mySystem.Parameter.conn);
dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count == 0)
{
MessageBox.Show("没有关联的检验记录");
}
foreach (DataRow dr in dt.Rows)
{
(new 验记录(mainform, Convert.ToInt32(dr["ID"]))).Show(); //form3.Show();
}
break;
case "取样记录":
da = new SqlDataAdapter("select * from 取样记录 where 物资验收记录ID=" + id, mySystem.Parameter.conn);
dt = new DataTable();
da.Fill(dt);
取样记录 form4 = new 取样记录(mainform, Convert.ToInt32(dt.Rows[0]["ID"]));
form4.Show();
break;
}
}
catch
{
MessageBox.Show("关联失败，请检查是否有相应数据");
}
//MessageBox.Show(this.Name + "\n" + sender.ToString());
}