/// <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"); string dateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); strSql = "insert into production (lineid,brakename,brakeid,brakecode,createtime,factory,remark)" + "values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')"; // strSql = string.Format(strSql, mdl.LineNum, mdl.ProductName, mdl.ProductID, mdl.ProductCode, dateTime, mdl.Factory, mdl.Remark); //ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null); ret = SQLiteDBHelper.ExecuteNonQuery(strSql); return(ret); } catch (Exception ex) { CLog.WriteErrLogInTrace(ex.Message); return(0); } }
/// <summary> /// 更新产品计划信息 /// </summary> /// <param name="info"></param> public int UpdateAcqCountItem(AcqCountMDL mdl) { int ret = 0; string strSql = string.Empty; try { string startTime = String.Format("{0:yyyy-MM-dd HH:mm:ss}", mdl.StartTime); //4-10-2010 17:16:50\ string endTime = String.Format("{0:yyyy-MM-dd HH:mm:ss}", mdl.EndTime); //(plan_id,pline_id,station_id,start_time,end_time,brakeid,plan_num,actual_num,shift,create_time,remark) strSql = "update acq_count_list set tagName='{0}',StartTime='{1}',EndTime='{2}',CurrentCount='{3}',Remark='{4}' " + " where tid='{5}'"; strSql = string.Format(strSql, mdl.TagName, startTime, endTime, mdl.StartTime, mdl.CurrentCount, mdl.Remark); // ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null); ret = SQLiteDBHelper.ExecuteNonQuery(strSql); return(ret); } catch (Exception ex) { CLog.WriteErrLogInTrace(ex.Message); return(0); } }
/// <summary> /// 插入单项产品计划 /// </summary> /// <param name="mdl"></param> /// <returns></returns> public int InsertAcqCountItem(AcqCountMDL mdl) { int ret = 0; string strSql = string.Empty; try { strSql = "insert into acq_count_list (tagName,StartTime,EndTime,CurrentCount,Remark)" + "values('{0}','{1}','{2}','{3}','{4}')"; //2015-05-11 08:30:00 string startTime = String.Format("{0:yyyy-MM-dd HH:mm:ss}", mdl.StartTime); //4-10-2010 17:16:50\ string endTime = String.Format("{0:yyyy-MM-dd HH:mm:ss}", mdl.EndTime); strSql = string.Format(strSql, mdl.TagName, startTime, endTime, mdl.CurrentCount, mdl.Remark); //ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null); ret = SQLiteDBHelper.ExecuteNonQuery(strSql); return(ret); } catch (Exception ex) { CLog.WriteErrLogInTrace(ex.Message); return(0); } }
/// <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); ret = SQLiteDBHelper.ExecuteNonQuery(strSql); return(ret); } catch (Exception ex) { CLog.WriteErrLogInTrace(ex.Message); return(0); } }
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); ret = SQLiteDBHelper.ExecuteNonQuery(strSql); return(ret); } catch (Exception ex) { CLog.WriteErrLogInTrace(ex.Message); } return(0); }
/// <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, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); //ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null); ret = SQLiteDBHelper.ExecuteNonQuery(strSql); return(ret); } catch (Exception ex) { CLog.WriteErrLogInTrace(ex.Message); return(0); } }
public int RemoveAllAcqCountItem() { try { int ret = 0; string strSql = "delete from acq_count_list;"; //ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null); ret = SQLiteDBHelper.ExecuteNonQuery(strSql); return(ret); } catch (Exception ex) { CLog.WriteErrLogInTrace(ex.Message); return(0); } }
/// <summary> /// 删除产品 /// </summary> /// <param name="id"></param> /// <returns></returns> public int DeleteProduction(int id) { int ret = 0; string strSql = string.Empty; try { strSql = "delete from production where tid=" + id.ToString(); //ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null); ret = SQLiteDBHelper.ExecuteNonQuery(strSql); return(ret); } catch (Exception ex) { CLog.WriteErrLogInTrace(ex.Message); return(0); } }
/// <summary> /// 更新插入单项的起始采集总数 /// </summary> /// <param name="mdl"></param> /// <returns></returns> public int UpdateItemStartCountValue(int startCount, string tagName) { int ret = 0; string strSql = string.Empty; try { strSql = "update acq_count_list set StartCount='{0}' " + " where tagName='{1}'"; strSql = string.Format(strSql, startCount, tagName); //ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null); ret = SQLiteDBHelper.ExecuteNonQuery(strSql); return(ret); } catch (Exception ex) { CLog.WriteErrLogInTrace(ex.Message); return(0); } }
public int UpdateAcqCountValue(AcqCountMDL mdl) { int ret = 0; string strSql = string.Empty; try { //(plan_id,pline_id,station_id,start_time,end_time,brakeid,plan_num,actual_num,shift,create_time,remark) strSql = "update acq_count_list set CurrentCount='{0}' " + " where tagName='{1}'"; strSql = string.Format(strSql, mdl.CurrentCount, mdl.TagName); //ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null); ret = SQLiteDBHelper.ExecuteNonQuery(strSql); return(ret); } catch (Exception ex) { CLog.WriteErrLogInTrace(ex.Message); return(0); } }
/// <summary> /// 更新产品信息 /// </summary> /// <param name="info"></param> public int UpdateProduction(ProductionMDL mdl) { int ret = 0; string strSql = string.Empty; try { //DateTime theDate = DateTime.Now; //theDate.ToString("yyyy-MM-dd HH:mm:ss"); string dateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); strSql = "update production set lineid='{0}',brakename='{1}',brakeid='{2}',brakecode='{3}',factory='{4}',remark='{5}' where tid='{6}'"; // strSql = string.Format(strSql, mdl.LineNum, mdl.ProductName, mdl.ProductID, mdl.ProductCode, mdl.Factory, mdl.Remark, mdl.TID); // ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql,null); ret = SQLiteDBHelper.ExecuteNonQuery(strSql); return(ret); } catch (Exception ex) { CLog.WriteErrLogInTrace(ex.Message); return(0); } }