//发送审核按钮
private void btn审核_Click(object sender, EventArgs e)
{
//保存
bool isSaved = Save();
if (isSaved == false)
{
return;
}
//写待审核表
DataTable dt_temp = new DataTable("待审核");
//BindingSource bs_temp = new BindingSource();
if (!mySystem.Parameter.isSqlOk)
{
OleDbDataAdapter da_temp = new OleDbDataAdapter("select * from 待审核 where 表名='清洁分切运行记录' and 对应ID=" + dt记录.Rows[0]["ID"], mySystem.Parameter.connOle);
OleDbCommandBuilder cb_temp = new OleDbCommandBuilder(da_temp);
da_temp.Fill(dt_temp);
if (dt_temp.Rows.Count == 0)
{
DataRow dr = dt_temp.NewRow();
dr["表名"] = "清洁分切运行记录";
dr["对应ID"] = (int)dt记录.Rows[0]["ID"];
dt_temp.Rows.Add(dr);
}
da_temp.Update(dt_temp);
}
else
{
SqlDataAdapter da_temp = new SqlDataAdapter("select * from 待审核 where 表名='清洁分切运行记录' and 对应ID=" + dt记录.Rows[0]["ID"], mySystem.Parameter.conn);
SqlCommandBuilder cb_temp = new SqlCommandBuilder(da_temp);
da_temp.Fill(dt_temp);
if (dt_temp.Rows.Count == 0)
{
DataRow dr = dt_temp.NewRow();
dr["表名"] = "清洁分切运行记录";
dr["对应ID"] = (int)dt记录.Rows[0]["ID"];
dt_temp.Rows.Add(dr);
}
da_temp.Update(dt_temp);
}
//写日志
//格式：
// =================================================
// yyyy年MM月dd日，操作员：XXX 提交审核
string log = "=====================================\n";
log += DateTime.Now.ToString("yyyy年MM月dd日 hh时mm分ss秒") + "\n" + label角色.Text + "：" + mySystem.Parameter.userName + " 提交审核\n";
dt记录.Rows[0]["日志"] = dt记录.Rows[0]["日志"].ToString() + log;
dt记录.Rows[0]["审核人"] = "__待审核";
Save();
_formState = Parameter.FormState.待审核;
setEnableReadOnly();
setDataGridViewFormat();
}
// 获取当前窗体状态：窗口状态 0：未保存；1：待审核；2：审核通过；3：审核未通过
private void setFormState(bool newForm = false)
{
if (newForm)
{
_formState = Parameter.FormState.无数据;
return;
}
string s = dt记录.Rows[0]["审核员"].ToString();
bool b = Convert.ToBoolean(dt记录.Rows[0]["审核是否通过"]);
if (s == "")
{
_formState = Parameter.FormState.未保存;
}
else if (s == "__待审核")
{
_formState = Parameter.FormState.待审核;
}
else
{
if (b)
{
_formState = Parameter.FormState.审核通过;
}
else
{
_formState = Parameter.FormState.审核未通过;
}
}
}
void setFormState()
{
//string s = dtOuter.Rows[0]["审核员"].ToString();
//bool b = Convert.ToBoolean(dtOuter.Rows[0]["审核是否通过"]);
//if (s == "") _formState = 0;
//else if (s == "__待审核") _formState = 1;
//else
//{
// if (b) _formState = 2;
// else _formState = 3;
//}
string s = dtOuter.Rows[0]["审核员"].ToString();
bool b = Convert.ToBoolean(dtOuter.Rows[0]["审核是否通过"]);
if (s == "")
{
_formState = 0;
}
else if (s == "__待审核")
{
_formState = Parameter.FormState.待审核;
}
else
{
if (b)
{
_formState = Parameter.FormState.审核通过;
}
else
{
_formState = Parameter.FormState.审核未通过;
}
}
}
// 获取当前窗体状态：窗口状态 0：未保存；1：待审核；2：审核通过；3：审核未通过
// 如果『审核人』为空，则为未保存
// 否则，如果『审核人』为『__待审核』，则为『待审核』
// 否则
// 如果审核结果为『通过』，则为『审核通过』
// 如果审核结果为『不通过』，则为『审核未通过』
void setFormState()
{
//if (dt_prodinstr.Rows[0]["审核人"].ToString() == "")
// stat_form = 0;
//else if(dt_prodinstr.Rows[0]["审核人"].ToString() =="__待审核")
// stat_form = 1;
//else if((bool)dt_prodinstr.Rows[0]["审核是否通过"])
// stat_form = 2;
//else
// stat_form = 3;
string s = dt_prodinstr.Rows[0]["审核人"].ToString();
bool b = Convert.ToBoolean(dt_prodinstr.Rows[0]["审核是否通过"]);
if (s == "")
{
_formState = 0;
}
else if (s == "__待审核")
{
_formState = Parameter.FormState.待审核;
}
else
{
if (b)
{
_formState = Parameter.FormState.审核通过;
}
else
{
_formState = Parameter.FormState.审核未通过;
}
}
}
void setFormState()
{
string s = dtOuter.Rows[0]["审核员"].ToString();
bool b = Convert.ToBoolean(dtOuter.Rows[0]["审核是否通过"]);
if (s == "")
{
_formState = Parameter.FormState.未保存;
}
else if (s == "__待审核")
{
_formState = Parameter.FormState.待审核;
}
else
{
if (b)
{
_formState = Parameter.FormState.审核通过;
}
else
{
_formState = Parameter.FormState.审核未通过;
}
}
}
void setFormState(bool newForm = false)
{
if (newForm)
{
_formState = Parameter.FormState.无数据;
return;
}
string s = dtOuter.Rows[0]["审核人"].ToString();
string b = dtOuter.Rows[0]["评审结果"].ToString();
if (s == "")
{
_formState = 0;
}
else if (s == "__待审核")
{
_formState = Parameter.FormState.待审核;
}
else
{
if (b == "同意")
{
_formState = Parameter.FormState.审核通过;
}
else
{
_formState = Parameter.FormState.审核未通过;
}
}
}
private void btn提交审核_Click(object sender, EventArgs e)
{
//read from database table and find current record
string checkName = "待审核";
DataTable dtCheck = new DataTable(checkName);
SqlDataAdapter daCheck = new SqlDataAdapter("SELECT * FROM " + checkName + " WHERE 表名='" + tablename1 + "' AND 对应ID = " + searchId + ";", conn);
BindingSource bsCheck = new BindingSource();
SqlCommandBuilder cbCheck = new SqlCommandBuilder(daCheck);
daCheck.Fill(dtCheck);
//if current hasn't been stored, insert a record in table
if (0 == dtCheck.Rows.Count)
{
DataRow newrow = dtCheck.NewRow();
newrow["表名"] = tablename1;
newrow["对应ID"] = dtOuter.Rows[0]["ID"];
dtCheck.Rows.Add(newrow);
}
bsCheck.DataSource = dtCheck;
daCheck.Update((DataTable)bsCheck.DataSource);
//this part to add log
//格式：
// =================================================
// yyyy年MM月dd日，操作员：XXX 提交审核
string log = "=====================================\n";
log += DateTime.Now.ToString("yyyy年MM月dd日 hh时mm分ss秒") + "\n操作员：" + mySystem.Parameter.userName + " 提交审核\n";
dtOuter.Rows[0]["日志"] = dtOuter.Rows[0]["日志"].ToString() + log;
//fill reviwer information
if ((Convert.ToString(Parameter.userflight) == "白班") && (dtOuter.Rows[0]["夜班接班员"].ToString() == ""))
{
dtOuter.Rows[0]["夜班接班员"] = __待审核;
dtOuter.Rows[0]["白班交接班时间"] = Convert.ToDateTime(DateTime.Now.ToShortTimeString());
}
if ((Convert.ToString(Parameter.userflight) == "夜班") && (dtOuter.Rows[0]["白班接班员"].ToString() == ""))
{
dtOuter.Rows[0]["白班接班员"] = __待审核;
dtOuter.Rows[0]["夜班交接班时间"] = Convert.ToDateTime(DateTime.Now.ToShortTimeString());
}
//update log into table
bsOuter.EndEdit();
daOuter.Update((DataTable)bsOuter.DataSource);
readOuterData(__生产指令编号, __生产日期);
removeOuterBind();
outerBind();
_formState = Parameter.FormState.待审核;
setEnableReadOnly(true);
btn提交审核.Enabled = false;
btn保存.Enabled = false;
}
void setFormState(bool newForm = false)
{
string s = dtOuter.Rows[0]["审核人"].ToString();
bool b = Convert.ToBoolean(dtOuter.Rows[0]["审核结果"]);
if (s == "")
{
_formState = 0;
}
else if (s == "__待审核")
{
_formState = Parameter.FormState.待审核;
}
else
{
if (b)
{
_formState = Parameter.FormState.审核通过;
}
else
{
_formState = Parameter.FormState.审核未通过;
}
}
}
//审核功能
public override void CheckResult()
{
//保存
bool isSaved = Save();
if (isSaved == false)
{
return;
}
base.CheckResult();
dt记录.Rows[0]["审核人"] = mySystem.Parameter.userName;
dt记录.Rows[0]["审核意见"] = checkform.opinion;
dt记录.Rows[0]["审核是否通过"] = checkform.ischeckOk;
//写待审核表
DataTable dt_temp = new DataTable("待审核");
//BindingSource bs_temp = new BindingSource();
if (!mySystem.Parameter.isSqlOk)
{
OleDbDataAdapter da_temp = new OleDbDataAdapter("select * from 待审核 where 表名='清洁分切开机确认' and 对应ID=" + dt记录.Rows[0]["ID"], mySystem.Parameter.connOle);
OleDbCommandBuilder cb_temp = new OleDbCommandBuilder(da_temp);
da_temp.Fill(dt_temp);
dt_temp.Rows[0].Delete();
da_temp.Update(dt_temp);
}
else
{
SqlDataAdapter da_temp = new SqlDataAdapter("select * from 待审核 where 表名='清洁分切开机确认' and 对应ID=" + dt记录.Rows[0]["ID"], mySystem.Parameter.conn);
SqlCommandBuilder cb_temp = new SqlCommandBuilder(da_temp);
da_temp.Fill(dt_temp);
dt_temp.Rows[0].Delete();
da_temp.Update(dt_temp);
}
//写日志
string log = "=====================================\n";
log += DateTime.Now.ToString("yyyy年MM月dd日 hh时mm分ss秒") + "\n" + label角色.Text + "：" + mySystem.Parameter.userName + " 完成审核\n";
log += "审核结果：" + (checkform.ischeckOk == true ? "通过\n" : "不通过\n");
log += "审核意见：" + checkform.opinion + "\n";
dt记录.Rows[0]["日志"] = dt记录.Rows[0]["日志"].ToString() + log;
Save();
//修改状态，设置可控性
if (checkform.ischeckOk)
{
_formState = Parameter.FormState.审核通过;
} //审核通过
else
{
_formState = Parameter.FormState.审核未通过;
} //审核未通过
setEnableReadOnly();
}
void setFormState(bool newForm = false)
{
string s = dtOuter.Rows[0]["批准人"].ToString();
if (s == "")
{
_formState = Parameter.FormState.未保存;
}
else
{
_formState = Parameter.FormState.审核通过;
}
}
//提交审核按钮
private void btn提交审核_Click(object sender, EventArgs e)
{
//判断内表是否完全提交审核
for (int i = 0; i < dt记录详情.Rows.Count; i++)
{
if (dt记录详情.Rows[i]["审核员"].ToString() == "")
{
MessageBox.Show("第" + (i + 1) + "行未提交数据审核");
return;
}
}
//保存
bool isSaved = Save();
if (isSaved == false)
{
return;
}
//写待审核表
DataTable dt_temp = new DataTable("待审核");
//BindingSource bs_temp = new BindingSource();
SqlDataAdapter da_temp = new SqlDataAdapter("select * from 待审核 where 表名='生产退料记录表' and 对应ID=" + dt记录.Rows[0]["ID"], mySystem.Parameter.conn);
SqlCommandBuilder cb_temp = new SqlCommandBuilder(da_temp);
da_temp.Fill(dt_temp);
if (dt_temp.Rows.Count == 0)
{
DataRow dr = dt_temp.NewRow();
dr["表名"] = "生产退料记录表";
dr["对应ID"] = (int)dt记录.Rows[0]["ID"];
dt_temp.Rows.Add(dr);
}
da_temp.Update(dt_temp);
//写日志
//格式：
// =================================================
// yyyy年MM月dd日，操作员：XXX 提交审核
string log = "=====================================\n";
log += DateTime.Now.ToString("yyyy年MM月dd日 hh时mm分ss秒") + "\n" + label角色.Text + "：" + mySystem.Parameter.userName + " 提交审核\n";
dt记录.Rows[0]["日志"] = dt记录.Rows[0]["日志"].ToString() + log;
dt记录.Rows[0]["审核员"] = "__待审核";
Save();
_formState = Parameter.FormState.待审核;
setEnableReadOnly();
}
//提交审核按钮
private void btn提交审核_Click_1(object sender, EventArgs e)
{
foreach (DataGridViewRow gdvr in dataGridView1.Rows)
{
if (gdvr.DefaultCellStyle.BackColor == Color.Red)
{
MessageBox.Show("有条目待确认");
return;
}
}
//保存
bool isSaved = Save();
if (isSaved == false)
{
return;
}
//写待审核表
DataTable dt_temp = new DataTable("待审核");
//BindingSource bs_temp = new BindingSource();
SqlDataAdapter da_temp = new SqlDataAdapter("select * from 待审核 where 表名='制袋机开机前确认表' and 对应ID=" + dt记录.Rows[0]["ID"], mySystem.Parameter.conn);
SqlCommandBuilder cb_temp = new SqlCommandBuilder(da_temp);
da_temp.Fill(dt_temp);
if (dt_temp.Rows.Count == 0)
{
DataRow dr = dt_temp.NewRow();
dr["表名"] = "制袋机开机前确认表";
dr["对应ID"] = Convert.ToInt32(dt记录.Rows[0]["ID"]);
dt_temp.Rows.Add(dr);
}
da_temp.Update(dt_temp);
//写日志
//格式：
// =================================================
// yyyy年MM月dd日，操作员：XXX 提交审核
string log = "=====================================\n";
log += DateTime.Now.ToString("yyyy年MM月dd日 hh时mm分ss秒") + "\n" + label角色.Text + "：" + mySystem.Parameter.userName + " 提交审核\n";
dt记录.Rows[0]["日志"] = dt记录.Rows[0]["日志"].ToString() + log;
dt记录.Rows[0]["审核员"] = "__待审核";
Save();
_formState = Parameter.FormState.待审核;
setEnableReadOnly();
}
// 获取当前窗体状态：窗口状态 0：未保存；1：待审核；2：审核通过；3：审核未通过
private void setFormState(bool newForm = false)
{
#region //旧版
//if (dt记录.Rows[0]["审核人"].ToString() == "")
// stat_form = 0;
//else if (dt记录.Rows[0]["审核人"].ToString() == "__待审核")
// stat_form = 1;
//else if ((bool)dt记录.Rows[0]["审核是否通过"])
// stat_form = 2;
//else
// stat_form = 3;
#endregion
if (newForm)
{
_formState = Parameter.FormState.无数据;
return;
}
string s = dt记录.Rows[0]["审核人"].ToString();
bool b = Convert.ToBoolean(dt记录.Rows[0]["审核是否通过"]);
if (s == "")
{
_formState = Parameter.FormState.未保存;
}
else if (s == "__待审核")
{
_formState = Parameter.FormState.待审核;
}
else
{
if (b)
{
_formState = Parameter.FormState.审核通过;
}
else
{
_formState = Parameter.FormState.审核未通过;
}
}
}
void setFormState(bool newForm = false)
{
_formState = Parameter.FormState.未保存;
}
//审核功能
public override void CheckResult()
{
//保存
bool isSaved = Save();
if (isSaved == false)
{
return;
}
base.CheckResult();
dt记录.Rows[0]["审核员"] = mySystem.Parameter.userName;
dt记录.Rows[0]["审核意见"] = checkform.opinion;
dt记录.Rows[0]["审核是否通过"] = checkform.ischeckOk;
//写待审核表
DataTable dt_temp = new DataTable("待审核");
//BindingSource bs_temp = new BindingSource();
SqlDataAdapter da_temp = new SqlDataAdapter("select * from 待审核 where 表名='产品外包装记录表' and 对应ID=" + dt记录.Rows[0]["ID"], mySystem.Parameter.conn);
SqlCommandBuilder cb_temp = new SqlCommandBuilder(da_temp);
da_temp.Fill(dt_temp);
dt_temp.Rows[0].Delete();
da_temp.Update(dt_temp);
//写日志
string log = "=====================================\n";
log += DateTime.Now.ToString("yyyy年MM月dd日 hh时mm分ss秒") + "\n" + label角色.Text + "：" + mySystem.Parameter.userName + " 完成审核\n";
log += "审核结果：" + (checkform.ischeckOk == true ? "通过\n" : "不通过\n");
log += "审核意见：" + checkform.opinion + "\n";
dt记录.Rows[0]["日志"] = dt记录.Rows[0]["日志"].ToString() + log;
Save();
if (checkform.ischeckOk)
{
// 产品入库
SqlDataAdapter da = new SqlDataAdapter("select * from 生产指令详细信息 where T生产指令ID=" + Convert.ToInt32(dt记录.Rows[0]["生产指令ID"]), mySystem.Parameter.conn);
DataTable dt = new DataTable();
SqlCommandBuilder cb;
da.Fill(dt);
string 订单号 = dt.Rows[0]["客户或订单号"].ToString();
string strConnect = "server=" + Parameter.IP_port + ";database=dingdan_kucun;MultipleActiveResultSets=true;Uid=" + Parameter.sql_user + ";Pwd=" + Parameter.sql_pwd;
SqlConnection Tconn;
Tconn = new SqlConnection(strConnect);
Tconn.Open();
string sql = "select * from 设置存货档案 where 存货代码='{0}'";
da = new SqlDataAdapter(string.Format(sql, dt记录.Rows[0]["产品代码"].ToString()), Tconn);
dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count == 0)
{
MessageBox.Show("在存货档案中没有找到代码为:" + dt记录.Rows[0]["产品代码"].ToString() + " 的产品");
return;
}
string 称 = dt.Rows[0]["存货名称"].ToString();
string 产品规格 = dt.Rows[0]["规格型号"].ToString();
string 主计量单位 = dt.Rows[0]["主计量单位名称"].ToString();
sql = "select * from 库存台帐 where 产品代码='{0}' and 用途='{1}' and 状态='合格'";
da = new SqlDataAdapter(string.Format(sql, dt记录.Rows[0]["产品代码"].ToString(), 订单号), Tconn);
cb = new SqlCommandBuilder(da);
dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count == 0)
{
DataRow dr = dt.NewRow();
dr["产品代码"] = dt记录.Rows[0]["产品代码"].ToString();
dr["产品名称"] = 称;
dr["产品规格"] = 产品规格;
dr["产品批号"] = dt记录.Rows[0]["产品批号"];
dr["现存数量"] = Convert.ToDouble(dt记录.Rows[0]["产品数量只数合计"]);
dr["主计量单位"] = 主计量单位;
dr["状态"] = "合格";
dr["用途"] = 订单号;
dt.Rows.Add(dr);
}
else
{
dt.Rows[0]["现存数量"] = Convert.ToDouble(dt记录.Rows[0]["产品数量只数合计"]) + Convert.ToDouble(dt.Rows[0]["现存数量"]);
}
da.Update(dt);
}
//修改状态，设置可控性
if (checkform.ischeckOk)
{
_formState = Parameter.FormState.审核通过;
} //审核通过
else
{
_formState = Parameter.FormState.审核未通过;
} //审核未通过
setEnableReadOnly();
}
//提交审核按钮
private void btn提交审核_Click(object sender, EventArgs e)
{
String n;
if (!checkOuterData(out n))
{
MessageBox.Show("请填写完整的信息: " + n, "提示");
return;
}
if (!checkInnerData(dataGridView1))
{
MessageBox.Show("请填写完整的表单信息", "提示");
return;
}
btn提交数据审核.PerformClick();
//foreach (DataRow dr in dt记录详情.Rows)
//{
// if (dr["审核员"] == DBNull.Value || dr["审核员"].ToString() == "")
// {
// MessageBox.Show("请先提交数据审核");
// return;
// }
//}
//保存
bool isSaved = Save();
if (isSaved == false)
{
return;
}
//写待审核表
DataTable dt_temp = new DataTable("待审核");
//BindingSource bs_temp = new BindingSource();
SqlDataAdapter da_temp = new SqlDataAdapter("select * from 待审核 where 表名='生产领料申请单表' and 对应ID=" + dt记录.Rows[0]["ID"], Parameter.conn);
SqlCommandBuilder cb_temp = new SqlCommandBuilder(da_temp);
da_temp.Fill(dt_temp);
if (dt_temp.Rows.Count == 0)
{
DataRow dr = dt_temp.NewRow();
dr["表名"] = "生产领料申请单表";
dr["对应ID"] = (int)dt记录.Rows[0]["ID"];
dt_temp.Rows.Add(dr);
}
da_temp.Update(dt_temp);
//写日志
//格式：
// =================================================
// yyyy年MM月dd日，操作员：XXX 提交审核
string log = "=====================================\n";
log += DateTime.Now.ToString("yyyy年MM月dd日 HH时mm分ss秒") + "\n" + label角色.Text + "：" + mySystem.Parameter.userName + " 提交审核\n";
dt记录.Rows[0]["日志"] = dt记录.Rows[0]["日志"].ToString() + log;
dt记录.Rows[0]["审核员"] = "__待审核";
Save();
_formState = Parameter.FormState.待审核;
setEnableReadOnly();
}
//审核功能
public override void CheckResult()
{
//保存
bool isSaved = Save();
if (isSaved == false)
{
return;
}
base.CheckResult();
//日志准备阶段
string log = "=====================================\n";
log += DateTime.Now.ToString("yyyy年MM月dd日 hh时mm分ss秒") + "\n" + label角色.Text + "：" + mySystem.Parameter.userName + " 完成审核\n";
log += "审核结果：" + (checkform.ischeckOk == true ? "通过\n" : "不通过\n");
log += "审核意见：" + checkform.opinion + "\n";
// 写数据
if (checkform.ischeckOk)
{
DataTable dt出库Out = new DataTable("出库Outer");
dt出库Out.Columns.Add("生产指令ID", Type.GetType("System.Int32"));
dt出库Out.Columns.Add("生产指令编号", Type.GetType("System.String"));
dt出库Out.Columns.Add("产品代码", Type.GetType("System.String"));
dt出库Out.Columns.Add("产品批号", Type.GetType("System.String"));
dt出库Out.Columns.Add("审核员", Type.GetType("System.String"));
dt出库Out.Columns.Add("审核日期", Type.GetType("System.DateTime"));
dt出库Out.Columns.Add("审核是否通过", Type.GetType("System.Boolean"));
dt出库Out.Columns.Add("属于工序", Type.GetType("System.String"));
dt出库Out.Columns.Add("日志", Type.GetType("System.String"));
dt出库Out.Columns.Add("审核意见", Type.GetType("System.String"));
dt出库Out.Rows.Add(new object[] { _生产指令ID, _生产指令编号, _产品代码, _产品批号, mySystem.Parameter.userName, DateTime.Now, true, _属于工序, (dt记录.Rows[0]["日志"].ToString() + log), checkform.opinion });
DataTable dt出库Inner = new DataTable("出库Inner");
dt出库Inner.Columns.Add("出库日期时间", Type.GetType("System.DateTime"));
dt出库Inner.Columns.Add("物料代码", Type.GetType("System.String"));
dt出库Inner.Columns.Add("物料批号", Type.GetType("System.String"));
dt出库Inner.Columns.Add("发料数量", Type.GetType("System.Int32"));
foreach (DataRow dr in dt记录详情.Rows)
{
dt出库Inner.Rows.Add(new object[] { DateTime.Now, dr["物料代码"], dr["物料批号"], dr["申请数量主计量"] });
}
if (mySystem.Process.Stock.材料退库出库单.生成表单(2, dt出库Out, dt出库Inner, _属于工序) == false)
{
MessageBox.Show("出库失败，请重新审核！");
return;
}
}
dt记录.Rows[0]["审核员"] = mySystem.Parameter.userName;
dt记录.Rows[0]["审核意见"] = checkform.opinion;
dt记录.Rows[0]["审核是否通过"] = checkform.ischeckOk;
//写待审核表
DataTable dt_temp = new DataTable("待审核");
//BindingSource bs_temp = new BindingSource();
SqlDataAdapter da_temp = new SqlDataAdapter("select * from 待审核 where 表名='生产领料申请单表' and 对应ID=" + dt记录.Rows[0]["ID"], mySystem.Parameter.conn);
SqlCommandBuilder cb_temp = new SqlCommandBuilder(da_temp);
da_temp.Fill(dt_temp);
dt_temp.Rows[0].Delete();
da_temp.Update(dt_temp);
//写日志
dt记录.Rows[0]["日志"] = dt记录.Rows[0]["日志"].ToString() + log;
Save();
//修改状态，设置可控性
if (checkform.ischeckOk)
{
_formState = Parameter.FormState.审核通过;
} //审核通过
else
{
_formState = Parameter.FormState.审核未通过;
} //审核未通过
setEnableReadOnly();
try
{
(this.Owner as mySystem.Query.QueryExtruForm).search();
}
catch (NullReferenceException exp) { }
}
//审核功能
public override void CheckResult()
{
//保存
bool isSaved = Save();
if (isSaved == false)
{
return;
}
base.CheckResult();
if (checkform.ischeckOk)
{
// 退料入库
// SqlDataAdapter da = new SqlDataAdapter("select * from 生产指令详细信息 where T生产指令ID=" + Convert.ToInt32(dt记录.Rows[0]["生产指令ID"]), mySystem.Parameter.conn);
// DataTable dt = new DataTable();
// SqlCommandBuilder cb;
// da.Fill(dt);
// string 订单号 = dt.Rows[0]["客户或订单号"].ToString();
// string strConnect = @"Provider=Microsoft.Jet.OLEDB.4.0;
// Data Source=../../database/dingdan_kucun.mdb;Persist Security Info=False";
// OleDbConnection Tconn;
// Tconn = new OleDbConnection(strConnect);
// Tconn.Open();
// foreach (DataRow dr in dt记录详情.Rows)
// {
// string 代码 = dr["物料代码"].ToString();
// string 批号 = dr["物料批号"].ToString();
// double 退库数量 = Convert.ToDouble(dr["退库数量"]);
// string sql = "select * from 库存台帐 where 产品代码='{0}' and 产品批号='{1}' and 用途='{2}' and 状态='合格'";
// da = new SqlDataAdapter(string.Format(sql, 代码, 批号, 订单号), Tconn);
// cb = new SqlCommandBuilder(da);
// dt = new DataTable();
// da.Fill(dt);
// if (dt.Rows.Count == 0)
// {
// MessageBox.Show("原料:" + 代码 + ",批号：" + 批号 + "退库失败");
// return;
// }
// else
// {
// dt.Rows[0]["现存数量"] = 退库数量 + Convert.ToDouble(dt.Rows[0]["现存数量"]);
// da.Update(dt);
// }
// }
gene出库单();
}
dt记录.Rows[0]["审核员"] = mySystem.Parameter.userName;
dt记录.Rows[0]["审核意见"] = checkform.opinion;
dt记录.Rows[0]["审核是否通过"] = checkform.ischeckOk;
//写待审核表
DataTable dt_temp = new DataTable("待审核");
//BindingSource bs_temp = new BindingSource();
SqlDataAdapter da_temp = new SqlDataAdapter("select * from 待审核 where 表名='生产退料记录表' and 对应ID=" + dt记录.Rows[0]["ID"], mySystem.Parameter.conn);
SqlCommandBuilder cb_temp = new SqlCommandBuilder(da_temp);
da_temp.Fill(dt_temp);
dt_temp.Rows[0].Delete();
da_temp.Update(dt_temp);
//写日志
string log = "=====================================\n";
log += DateTime.Now.ToString("yyyy年MM月dd日 hh时mm分ss秒") + "\n" + label角色.Text + "：" + mySystem.Parameter.userName + " 完成审核\n";
log += "审核结果：" + (checkform.ischeckOk == true ? "通过\n" : "不通过\n");
log += "审核意见：" + checkform.opinion + "\n";
dt记录.Rows[0]["日志"] = dt记录.Rows[0]["日志"].ToString() + log;
Save();
//修改状态，设置可控性
if (checkform.ischeckOk)
{
_formState = Parameter.FormState.审核通过;
} //审核通过
else
{
_formState = Parameter.FormState.审核未通过;
} //审核未通过
setEnableReadOnly();
}
//提交审核按钮
private void btn提交审核_Click(object sender, EventArgs e)
{
String n;
if (!checkOuterData(out n))
{
MessageBox.Show("请填写完整的信息: " + n, "提示");
return;
}
//保存
bool isSaved = Save();
if (isSaved == false)
{
return;
}
//写待审核表
if (!mySystem.Parameter.isSqlOk)
{
DataTable dt_temp = new DataTable("待审核");
//BindingSource bs_temp = new BindingSource();
OleDbDataAdapter da_temp = new OleDbDataAdapter("select * from 待审核 where 表名='吹膜预热参数记录表' and 对应ID=" + dt记录.Rows[0]["ID"], mySystem.Parameter.connOle);
OleDbCommandBuilder cb_temp = new OleDbCommandBuilder(da_temp);
da_temp.Fill(dt_temp);
if (dt_temp.Rows.Count == 0)
{
DataRow dr = dt_temp.NewRow();
dr["表名"] = "吹膜预热参数记录表";
dr["对应ID"] = Convert.ToInt32(dt记录.Rows[0]["ID"]);
dt_temp.Rows.Add(dr);
}
da_temp.Update(dt_temp);
}
else
{
DataTable dt_temp = new DataTable("待审核");
//BindingSource bs_temp = new BindingSource();
SqlDataAdapter da_temp = new SqlDataAdapter("select * from 待审核 where 表名='吹膜预热参数记录表' and 对应ID=" + dt记录.Rows[0]["ID"], mySystem.Parameter.conn);
SqlCommandBuilder cb_temp = new SqlCommandBuilder(da_temp);
da_temp.Fill(dt_temp);
if (dt_temp.Rows.Count == 0)
{
DataRow dr = dt_temp.NewRow();
dr["表名"] = "吹膜预热参数记录表";
dr["对应ID"] = Convert.ToInt32(dt记录.Rows[0]["ID"]);
dt_temp.Rows.Add(dr);
}
da_temp.Update(dt_temp);
}
//写日志
//格式：
// =================================================
// yyyy年MM月dd日，操作员：XXX 提交审核
string log = "=====================================\n";
log += DateTime.Now.ToString("yyyy年MM月dd日 hh时mm分ss秒") + "\n" + label角色.Text + "：" + mySystem.Parameter.userName + " 提交审核\n";
dt记录.Rows[0]["日志"] = dt记录.Rows[0]["日志"].ToString() + log;
dt记录.Rows[0]["审核人"] = "__待审核";
Save();
_formState = Parameter.FormState.待审核;
setEnableReadOnly();
}
