/// <summary>
/// 添加采集数据单元
/// </summary>
/// <param name="mdl"></param>
/// <returns></returns>
public int AddPlinePlan(PlinePlanMDL mdl)
{
int ret = 0;
string strSql = string.Empty;
try
{
strSql = "INSERT INTO tlb_product_plan ( PLANID,PLINE,NAME,OP1,OP1_T,OP1_BEGIN,OP1_RANGE,OP1_ITEMS,OP2,OP2_T,OP2_BEGIN,OP2_RANGE,OP2_ITEMS,CREATE_TIME,REMARK)" +
" VALUES ('{0}','{1}','{2}',{3},{4},'{5}',{6},'{7}',{8},{9},'{10}',{11},'{12}','{13}','{14}')";
//"values('{0}','{1}','{2}',{3},{4},'{5}',{6},{7},{8},'{9}',{10},'{11}','{12}')";
strSql = string.Format(strSql, mdl.PLANID, mdl.PLINE, mdl.NAME, mdl.OP1, mdl.OP1_T, mdl.OP1_BEGIN.ToString("yyyy-MM-dd HH:mm:ss"),
mdl.OP1_RANGE, OPMDL.BuildOPString(mdl.OP1_ITEMS), mdl.OP2, mdl.OP2_T, mdl.OP2_BEGIN.ToString("yyyy-MM-dd HH:mm:ss"),
mdl.OP2_RANGE, OPMDL.BuildOPString(mdl.OP2_ITEMS), mdl.CREATE_TIME.ToString("yyyy-MM-dd HH:mm:ss"), mdl.REMARK);
ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
return(ret);
}
catch
{
throw;
}
}
/// <summary>
/// 更新产线计划
/// </summary>
/// <param name="mdl"></param>
/// <returns></returns>
public int UpdatePlinePlan(PlinePlanMDL mdl)
{
int ret = 0;
string strSql = string.Empty;
try
{
strSql = "UPDATE tlb_product_plan SET PLINE='{0}' ,NAME='{1}',OP1={2},OP1_T={3},OP1_BEGIN='{4}',OP1_RANGE={5},OP1_ITEMS='{6}',OP2={7},"
+ "OP2_T={8},OP2_BEGIN='{9}',OP2_RANGE={10},OP2_ITEMS='{11}',REMARK='{12}' WHERE PLANID='{13}'";
strSql = string.Format(strSql, mdl.PLINE, mdl.NAME, mdl.OP1, mdl.OP1_T, mdl.OP1_BEGIN.ToString("yyyy-MM-dd HH:mm:ss"),
mdl.OP1_RANGE, OPMDL.BuildOPString(mdl.OP1_ITEMS), mdl.OP2, mdl.OP2_T, mdl.OP2_BEGIN.ToString("yyyy-MM-dd HH:mm:ss"),
mdl.OP2_RANGE, OPMDL.BuildOPString(mdl.OP2_ITEMS), mdl.REMARK, mdl.PLANID);
ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
return(ret);
}
catch
{
throw;
}
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
this.dataGridView1.CellValueChanged -= new DataGridViewCellEventHandler(dataGridView1_CellContentClick);
switch (e.ColumnIndex)
{
case 4:
ModifyOPForm dlg = new ModifyOPForm();
OPMDL mdl = ops[e.RowIndex];
dlg.Info = " 工作时间范围 :" + mdl.IIME_RANGE.StartTime.ToShortTimeString() + "---" +
mdl.IIME_RANGE.EndTime.ToShortTimeString();
dlg.OP = mdl.OP;
if (dlg.ShowDialog() == DialogResult.OK)
{
ops[e.RowIndex].OP = dlg.OP;
ReloadDateGrid();
}
break;
default:
break;
}
this.dataGridView1.CellValueChanged += new DataGridViewCellEventHandler(dataGridView1_CellContentClick);
}