/// <summary>
/// 插入单项产品计划
/// </summary>
/// <param name="mdl"></param>
/// <returns></returns>
public int InsertProductionPlanItem(ProductionPlanMDL mdl)
{
int ret = 0;
string strSql = string.Empty;
try
{
strSql = "insert into production_plan (plan_id,pline_id,station_id,start_time,end_time,brakeid,plan_num,actual_num,shift,create_time,remark)" +
"values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}')";
strSql = string.Format(strSql, mdl.PlanID, mdl.Pline_ID, mdl.Station_ID, mdl.StartTime.ToString("yyyy-MM-dd HH:mm:ss"),
mdl.EndTime.ToString("yyyy-MM-dd HH:mm:ss"), mdl.BreakeID, mdl.PlanNum,
mdl.Actual_num, mdl.Shift, mdl.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"), mdl.Remark);
ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
return(ret);
}
catch (Exception ex)
{
CLog.WriteErrLogInTrace(ex.Message);
return(0);
}
}
/// <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;
}
}
public int UpdateByField(string fieldName, object fieldValue, string keyName, string keyValue)
{
string format = string.Empty;
try
{
Type type = fieldValue.GetType();
if (type == typeof(string))
{
format = "update result_line2 set {0}='{1}',updatetime = now() where {2}='{3}'";
}
else
{
if ((((type != typeof(int)) && (type != typeof(double))) && (type != typeof(float))) && (type != typeof(bool)))
{
throw new Exception("fieldValue的值只能为string、bool、int、double或float类型");
}
format = "update result_line2 set {0}={1},updatetime = now() where {2}='{3}'";
}
format = string.Format(format, new object[] { fieldName, fieldValue, keyName, keyValue });
return(MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, format, null));
}
catch (Exception exception)
{
CLog.WriteErrLogInTrace(exception.Message);
return(0);
}
}
/// <summary>
/// 插入产品信息
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int InsertProduction(ProductionMDL mdl)
{
int ret = 0;
string strSql = string.Empty;
try
{
//DateTime theDate = DateTime.Now;
//theDate.ToString("yyyy-MM-dd HH:mm:ss");
strSql = "insert into tlb_product (PN,PLID,NAME ,EMS,CREATE_TIME,CODE,TYPE,FACTORY,CT,OP,REMARK)" +
"values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}')";
strSql = string.Format(strSql, mdl.PN, mdl.PLID, mdl.Name, mdl.EMS, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
, mdl.Code, mdl.CodeType, mdl.Factory, mdl.CT, mdl.OP, mdl.Remark);
ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
return(ret);
}
catch (Exception ex)
{
CLog.WriteErrLogInTrace(ex.Message);
return(0);
}
}
public int UpdateByField(string fieldName, string fieldValue, int valueType, string keyName, string keyValue)
{
int num = 0;
string format = string.Empty;
try
{
if (valueType == 2)
{
format = "update device_list set {0}='{1}' where {2}='{3}'";
}
else if (valueType == 1)
{
format = "update device_list set {0}={1} where {2}='{3}'";
}
format = string.Format(format, new object[] { fieldName, fieldValue, keyName, keyValue });
num = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, format, null);
if (num <= 0)
{
CLog.WriteErrLog(format);
}
return(num);
}
catch (Exception exception)
{
CLog.WriteErrLogInTrace(exception.Message);
CLog.WriteErrLog(format);
return(0);
}
}
public bool UpdateProductNameByKeyCode(string keyFieldName, string barCode, string productType)
{
object obj2 = null;
string format = string.Empty;
string str2 = string.Empty;
bool flag = false;
try
{
format = "select productname from process_parameter where productid='{0}' limit 1";
format = string.Format(format, productType);
obj2 = MySqlDBHelper.ExecuteScalar(MySqlDBHelper.Conn, CommandType.Text, format, null);
if (obj2 != null)
{
str2 = obj2.ToString();
}
format = "update result_line2 set productname='{0}' where {1}='{2}'";
format = string.Format(format, str2, keyFieldName, barCode);
if (MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, format, null) > 0)
{
flag = true;
}
}
catch (Exception exception)
{
CLog.WriteErrLogInTrace(exception.Message);
flag = false;
}
return(flag);
}
/// <summary>
/// 插入文本文本内容
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
private int InsertNoticeInfo(string info)
{
int ret = 0;
string strSql = string.Empty;
try
{
DateTime theDate = DateTime.Now;
theDate.ToString("yyyy-MM-dd HH:mm:ss");
strSql = "insert into notice (tid,content,update_time) values(1,'{0}','{1}')";
strSql = string.Format(strSql, info, theDate);
ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
return(ret);
}
catch (Exception ex)
{
CLog.WriteErrLogInTrace(ex.Message);
return(0);
}
}
/// <summary>
/// 添加采集数据单元
/// </summary>
/// <param name="mdl"></param>
/// <returns></returns>
public int AddExTimeItem(ExtTimeMDL mdl)
{
int ret = 0;
string strSql = string.Empty;
try
{
strSql = "insert into tlb_ext_time ( PLINEID,NAME,LUNCH,L_TIME,DINNER,D_TIME,REMARK)" +
"values('{0}','{1}','{2}',{3},'{4}',{5},'{6}')";
strSql = string.Format(strSql, mdl.PLINEID, mdl.NAME, mdl.LUNCH.ToString("yyyy-MM-dd HH:mm:ss"),
mdl.L_TIME, mdl.DINNER.ToString("yyyy-MM-dd HH:mm:ss"),
mdl.D_TIME, 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;
}
}
public int MoveBrakeDataToCaliper(string brakeCode, string caliperCode)
{
int num11;
int num = 0;
int num9 = 0;
int num10 = 0;
string format = string.Empty;
DataSet set = new DataSet();
MySqlParameter[] commandParameters = null;
try
{
format = "select tid,st300,st320,st332,st350,st360,st361,st290,trialproduce from result_line2 where (length(calipercode)<=0 or calipercode is null) and brakecode='{0}' order by updatetime desc limit 1";
format = string.Format(format, brakeCode);
set = MySqlDBHelper.ExecuteDataSet(MySqlDBHelper.Conn, CommandType.Text, format, null);
if (set.Tables[0].Rows.Count <= 0)
{
return(0);
}
num = Convert.ToInt32(set.Tables[0].Rows[0]["tid"]);
if (set.Tables[0].Rows[0]["trialproduce"].ToString() != string.Empty)
{
num9 = Convert.ToInt32(set.Tables[0].Rows[0]["trialproduce"]);
}
commandParameters = new MySqlParameter[] { new MySqlParameter("@brakecode", brakeCode), new MySqlParameter("@st300", set.Tables[0].Rows[0]["st300"]), new MySqlParameter("@st320", set.Tables[0].Rows[0]["st320"]), new MySqlParameter("@st332", set.Tables[0].Rows[0]["st332"]), new MySqlParameter("@st350", set.Tables[0].Rows[0]["st350"]), new MySqlParameter("@st360", set.Tables[0].Rows[0]["st360"]), new MySqlParameter("@st361", set.Tables[0].Rows[0]["st361"]), new MySqlParameter("@st290", set.Tables[0].Rows[0]["st290"]), new MySqlParameter("@calipercode", caliperCode) };
if (num9 == 1)
{
format = "update result_line2 set brakecode=@brakecode,st300=@st300,st320=@st320,st332=@st332,st350=@st350,st360=@st360,st361=@st361,st290=@st290,trialproduce=1,updatetime = now() where calipercode=@calipercode";
}
else
{
format = "update result_line2 set brakecode=@brakecode,st300=@st300,st320=@st320,st332=@st332,st350=@st350,st360=@st360,st361=@st361,st290=@st290,updatetime = now() where calipercode=@calipercode";
}
num10 = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, format, commandParameters);
if (num10 > 0)
{
format = "delete from result_line2 where tid={0}";
format = string.Format(format, num);
}
num11 = num10;
}
catch (Exception exception)
{
CLog.WriteErrLogInTrace(exception.Message);
num11 = 0;
}
finally
{
set.Dispose();
}
return(num11);
}
public int UpdateResultByKeyCode(string keyFieldName, string barCode, int integrity, int valid, int result, string resultDesc)
{
string format = string.Empty;
try
{
format = "update result_line2 set integrity={0},valid={1},result={2},resultdesc='{3}' where {4}='{5}'";
format = string.Format(format, new object[] { integrity, valid, result, resultDesc, keyFieldName, barCode });
return(MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, format, null));
}
catch (Exception exception)
{
CLog.WriteErrLogInTrace(exception.Message);
return(0);
}
}
public int InsertCode(string codeName, string codeValue)
{
string format = string.Empty;
try
{
format = "insert into result_line2({0},createtime) values ('{1}',now())";
format = string.Format(format, codeName, codeValue);
return(MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, format, null));
}
catch (Exception exception)
{
CLog.WriteErrLogInTrace(exception.Message);
return(0);
}
}
public int UpdateDigiForceByKeyCode(string keyFieldName, string barCode, DigiForceMDL mdl)
{
string format = string.Empty;
try
{
format = "update result_line2 set st360_xminx1={0},st360_xminy1={1},st360_xmaxx1={2},st360_xmaxy1={3},st360_yminx1={4},st360_yminy1={5},st360_ymaxx1={6},st360_ymaxy1={7} where {8}='{9}'";
format = string.Format(format, new object[] { mdl.Xminx, mdl.Xminy, mdl.Xmaxx, mdl.Xmaxy, mdl.Yminx, mdl.Yminy, mdl.Ymaxx, mdl.Ymaxy, keyFieldName, barCode });
CLog.WriteStationLog("ST360", format);
return(MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, format, null));
}
catch (Exception exception)
{
CLog.WriteErrLogInTrace(exception.Message);
return(0);
}
}
public int UpdateByKeyName(PrintCountMDL mdl)
{
int num = 0;
string format = string.Empty;
try
{
format = "update print_count set keycount={0},updatetime=now() where keyname='{1}'";
format = string.Format(format, mdl.KeyCount, mdl.KeyName);
num = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, format, null);
}
catch (Exception exception)
{
CLog.WriteErrLogInTrace(exception.Message);
}
return(num);
}
public int InsertData(PrintCountMDL mdl)
{
int num = 0;
string cmdText = string.Empty;
try
{
cmdText = "insert into print_count (";
cmdText = string.Format(cmdText + "keyname, keycount, updatetime, remark) values (" + "'{0}', 1, now(), '')", mdl.KeyName);
num = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, cmdText, null);
}
catch (Exception exception)
{
CLog.WriteErrLogInTrace(exception.Message);
}
return(num);
}
/// <summary>
/// 删除数据
/// </summary>
/// <param name="plineID"></param>
/// <returns></returns>
public int DeleteLineDT(string dtid)
{
int ret = 0;
try
{
string strSql = "DELETE * FROM tlb_line_dt WHERE DTID='{0}'";
strSql = string.Format(strSql, dtid);
ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
return(ret);
}
catch
{
throw;
}
}
/// <summary>
/// 删除产线计划
/// </summary>
/// <param name="tid"></param>
/// <returns></returns>
public int DeleteProudctionPlanItem(int tid)
{
int ret = 0;
string strSql = string.Empty;
try
{
strSql = "delete from production_plan where tid=" + tid.ToString();
ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
return(ret);
}
catch (Exception ex)
{
CLog.WriteErrLogInTrace(ex.Message);
return(0);
}
}
/// <summary>
/// 删除产品
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
//public int DeleteProduction(int pn)
//{
// int ret = 0;
// string strSql = string.Empty;
// try
// {
// strSql = "DELETE FROM tlb_product WHERE PN=" + pn.ToString();
// ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
// return ret;
// }
// catch (Exception ex)
// {
// CLog.WriteErrLogInTrace(ex.Message);
// return 0;
// }
//}
public int DeleteProduction(int ems)
{
int ret = 0;
string strSql = string.Empty;
try
{
strSql = "DELETE FROM tlb_product WHERE EMS=" + ems.ToString();
ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
return(ret);
}
catch (Exception ex)
{
CLog.WriteErrLogInTrace(ex.Message);
return(0);
}
}
/// <summary>
/// 删除改变计数值
/// </summary>
/// <param name="tid"></param>
/// <returns></returns>
public int DeleteChangeTimeItem(string tid)
{
int ret = 0;
string strSql = string.Empty;
try
{
strSql = "DELETE FROM tlb_line_change WHERE TID='{0}'";
strSql = string.Format(strSql, tid);
ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
return(ret);
}
catch
{
throw;
}
}
/// <summary>
/// 更新记录数据
/// </summary>
/// <param name="mdl"></param>
/// <returns></returns>
public int UpdateAcqTrace(AcqLineTraceMDL mdl)
{
int ret = 0;
string strSql = string.Empty;
try
{
strSql = "UPDATE tlb_acq_trace SET SEQID='{0}',PLID='{1}',EMS = {2},STATIONID='{3}' WHERE ACQID='{4}'";
strSql = string.Format(strSql, mdl.SEQID, mdl.PLID, mdl.EMS, mdl.STATIONID, mdl.ACQID);
ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
return(ret);
}
catch
{
throw;
}
}
public int UpdateActualPlan(string tid, int actualNum)
{
try
{
int ret = 0;
string strSql = "update production_plan set actual_num='{0}' where tid='{1}'";
strSql = string.Format(strSql, actualNum, tid);
ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
return(ret);
}
catch (Exception ex)
{
CLog.WriteErrLogInTrace(ex.Message);
}
return(0);
}
/// <summary>
/// 删除产线记录
/// </summary>
/// <param name="tid"></param>
/// <returns></returns>
public int DeletePlinePlanm(string planID)
{
int ret = 0;
string strSql = string.Empty;
try
{
strSql = "DELETE FROM tlb_product_plan WHERE PLANID='{0}'";
strSql = string.Format(strSql, planID);
ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
return(ret);
}
catch
{
throw;
}
}
/// <summary>
/// 更新停机区间
/// </summary>
/// <param name="mdl"></param>
/// <returns></returns>
public int UpdateLineDT(PlineDTMDL mdl)
{
int ret = 0;
string strSql = string.Empty;
try
{
strSql = "UPDATE tlb_line_dt SET START_TIME='{0}',END_TIME='{1}',RANGEID='{2}',CLA_ORDER={3}, WHERE DTID='{3}";
strSql = string.Format(strSql, mdl.START_TIME.ToString("yyyy-MM-dd HH:mm:ss"), mdl.END_TIME.ToString("yyyy-MM-dd HH:mm:ss"), mdl.RANGEID, mdl.CLA_ORDER, mdl.DTID);
ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
return(ret);
}
catch
{
throw;
}
}
public int UpdateDateExTime(ExtTimeMDL mdl)
{
int ret = 0;
string strSql = string.Empty;
try
{
strSql = "UPDATE tlb_ext_time SET NAME='{0}',LUNCH='{1}',L_TIME={2},DINNER='{3}',D_TIME={4} WHERE PLINEID='{5}'";
strSql = string.Format(strSql, mdl.NAME, mdl.LUNCH.ToString("yyyy-MM-dd HH:mm:ss"),
mdl.L_TIME, mdl.DINNER.ToString("yyyy-MM-dd HH:mm:ss"), mdl.D_TIME, mdl.PLINEID);
ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
return(ret);
}
catch
{
throw;
}
}
/// <summary>
/// 更新产品信息
/// </summary>
/// <param name="info"></param>
public int UpdateProduction(ProductionMDL mdl)
{
int ret = 0;
string strSql = string.Empty;
try
{
strSql = "UPDATE tlb_product SET NAME='{0}',PN='{1}',CODE='{2}',TYPE={3},FACTORY='{4}',CT={5},OP={6},REMARK='{7}' WHERE EMS={8} AND PLID={9}";
strSql = string.Format(strSql, mdl.Name, mdl.PN, mdl.Code, mdl.CodeType, mdl.Factory, mdl.CT, mdl.OP, mdl.Remark, mdl.EMS, mdl.PLID);
ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
return(ret);
}
catch (Exception ex)
{
CLog.WriteErrLogInTrace(ex.Message);
return(0);
}
}
public void CheckResultState()
{
string str = string.Empty;
string str2 = string.Empty;
string str3 = string.Empty;
string cmdText = string.Empty;
int num = 0;
DataSet set = new DataSet();
try
{
cmdText = "select calipercode,brakecode,bracketcode from result_line2 where calipercode is not null and brakecode is not null and bracketcode is not null and result is null and (resultdesc is null or resultdesc='')";
set = MySqlDBHelper.ExecuteDataSet(MySqlDBHelper.Conn, CommandType.Text, cmdText, null);
if (set.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < set.Tables[0].Columns.Count; i++)
{
str = set.Tables[0].Rows[i]["calipercode"].ToString();
str2 = set.Tables[0].Rows[i]["brakecode"].ToString();
str3 = set.Tables[0].Rows[i]["bracketcode"].ToString();
cmdText = "update result_line2 set integrity=1,valid=1,result=1 where calipercode='{0}' and brakecode='{1}' and bracketcode='{2}'";
cmdText = string.Format(cmdText, str, str2, str3);
num = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, cmdText, null);
}
}
}
catch (Exception exception)
{
CLog.WriteErrLogInTrace(exception.Message);
}
finally
{
if (set != null)
{
set.Dispose();
}
}
}
public int UpdateChangeUnitItem(ChangeTimeMDL mdl)
{
int ret = 0;
string strSql = string.Empty;
try
{
strSql = "UPDATE tlb_line_change SET PLID='{0}' ,UNITID='{1}',PER_PN='{2}',CUR_PN='{3}',CUR_TIME='{4}',TIME_MIG={5},PER_TIME='{6}' WHERE SEQID='{7}'";
strSql = string.Format(strSql, mdl.PLID, mdl.UNITID, mdl.PER_PN, mdl.CUR_PN, mdl.CUR_TIME.ToString("yyyy-MM-dd HH:mm:ss"),
mdl.TIME_MIG, mdl.PER_TIME.ToString("yyyy-MM-dd HH:mm:ss"), mdl.SEQID);
ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
return(ret);
}
catch
{
throw;
}
}
/// <summary>
/// 添加采集数据单元
/// </summary>
/// <param name="mdl"></param>
/// <returns></returns>
public int AddChangeUnitItem(ChangeTimeMDL mdl)
{
int ret = 0;
string strSql = string.Empty;
try
{
strSql = "insert into tlb_line_change ( SEQID,PLID,UNITID,PER_PN,CUR_PN,CUR_TIME,TIME_MIG,PER_TIME)" +
"values('{0}','{1}','{2}','{3}','{4}','{5}',{6},'{7}')";
strSql = string.Format(strSql, mdl.SEQID, mdl.PLID, mdl.UNITID, mdl.PER_PN, mdl.CUR_PN, mdl.CUR_TIME.ToString("yyyy-MM-dd HH:mm:ss"),
mdl.TIME_MIG, mdl.PER_TIME.ToString("yyyy-MM-dd HH:mm:ss"));
ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
return(ret);
}
catch
{
throw;
}
}
/// <summary>
/// 插入停机区间
/// </summary>
/// <param name="mdl"></param>
/// <returns></returns>
public int AddLineDT(PlineDTMDL mdl)
{
int ret = 0;
string strSql = string.Empty;
try
{
strSql = "insert into tlb_line_dt (DTID,PLINEID,CLA_ORDER,START_TIME,END_TIME,DOWNTIME,RANGEID)" +
"values('{0}','{1}',{2},'{3}','{4}',{5},'{6}')";
strSql = string.Format(strSql, mdl.DTID, mdl.PLINEID, mdl.CLA_ORDER, mdl.START_TIME.ToString("yyyy-MM-dd HH:mm:ss"),
mdl.END_TIME.ToString("yyyy-MM-dd HH:mm:ss"), mdl.DOWNTIME, mdl.RANGEID);
ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
return(ret);
}
catch
{
throw;
}
}
/// <summary>
/// 添加采集数据
/// </summary>
/// <param name="mdl"></param>
/// <returns></returns>
public int AddAcqTrace(AcqLineTraceMDL mdl)
{
int ret = 0;
string strSql = string.Empty;
try
{
strSql = "insert into tlb_acq_trace (ACQID,ACQ_DATE,SEQID,PLID,EMS,STATIONID,BEG_COUNT,ERROR)" +
"values('{0}','{1}','{2}','{3}',{4},'{5}',{6},'{7}')";
strSql = string.Format(strSql, mdl.ACQID, mdl.ACQ_DATE.ToString("yyyy-MM-dd HH:mm:ss"), mdl.SEQID, mdl.PLID, mdl.EMS, mdl.STATIONID, mdl.BEG_COUNT, mdl.ERROR);
ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
return(ret);
}
catch
{
throw;
}
}
