/// <summary> /// 增加一条数据 /// </summary> public void Add(Common.Model.MouldingMachineEvent_Model model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into MouldingMachineEvent("); strSql.Append("MachineID,PQMmachineID,Event_Type,error_code,error_name,event_time,remarks)"); strSql.Append(" values ("); strSql.Append("@MachineID,@PQMmachineID,@Event_Type,@error_code,@error_name,@event_time,@remarks)"); SqlParameter[] parameters = { new SqlParameter("@MachineID", SqlDbType.VarChar, 50), new SqlParameter("@PQMmachineID", SqlDbType.VarChar, 50), new SqlParameter("@Event_Type", SqlDbType.VarChar, 50), new SqlParameter("@error_code", SqlDbType.VarChar, 50), new SqlParameter("@error_name", SqlDbType.VarChar, 50), new SqlParameter("@event_time", SqlDbType.DateTime2, 8), new SqlParameter("@remarks", SqlDbType.VarChar, 50) }; DBHelp.Reports.LogFile.DebugLog("AUTOCODE", "NameSpace:Common.DAL", "Class:MouldingMachineEvent_DAL", "Function: public void Add(Common.Model.MouldingMachineEvent_Model model)"+ "TableName:MouldingMachineEvent", ";MachineID = " + model.MachineID.ToString() + ";PQMmachineID = " + model.PQMmachineID.ToString() + ";Event_Type = " + model.Event_Type.ToString() + ";error_code = " + model.error_code.ToString() + ";error_name = " + model.error_name.ToString() + ";event_time = " + model.event_time.ToString() + ";remarks = " + model.remarks.ToString() + ""); parameters[0].Value = model.MachineID; parameters[1].Value = model.PQMmachineID; parameters[2].Value = model.Event_Type; parameters[3].Value = model.error_code; parameters[4].Value = model.error_name; parameters[5].Value = model.event_time; parameters[6].Value = model.remarks; DBHelp.SqlDB.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public Common.Model.MouldingMachineEvent_Model GetModel(string MachineID, string PQMmachineID, string Event_Type, string error_code, string error_name, DateTime?event_time, string remarks) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 MachineID,PQMmachineID,Event_Type,error_code,error_name,event_time,remarks from MouldingMachineEvent "); strSql.Append(" where "); SqlParameter[] parameters = { }; DBHelp.Reports.LogFile.DebugLog("AUTOCODE", "NameSpace:Common.DAL", "Class:MouldingMachineEvent_DAL", "Function: public Common.Model.MouldingMachineEvent_Model GetModel(string MachineID,string PQMmachineID,string Event_Type,string error_code,string error_name,DateTime? event_time,string remarks)"+ "TableName:MouldingMachineEvent", ""); Common.Model.MouldingMachineEvent_Model model = new Common.Model.MouldingMachineEvent_Model(); DataSet ds = DBHelp.SqlDB.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { model.MachineID = ds.Tables[0].Rows[0]["MachineID"].ToString(); model.PQMmachineID = ds.Tables[0].Rows[0]["PQMmachineID"].ToString(); model.Event_Type = ds.Tables[0].Rows[0]["Event_Type"].ToString(); model.error_code = ds.Tables[0].Rows[0]["error_code"].ToString(); model.error_name = ds.Tables[0].Rows[0]["error_name"].ToString(); if (ds.Tables[0].Rows[0]["event_time"].ToString() != "") { model.event_time = DateTime.Parse(ds.Tables[0].Rows[0]["event_time"].ToString()); } model.remarks = ds.Tables[0].Rows[0]["remarks"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Common.Model.MouldingMachineEvent_Model model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update MouldingMachineEvent set "); strSql.Append("MachineID=@MachineID,"); strSql.Append("PQMmachineID=@PQMmachineID,"); strSql.Append("Event_Type=@Event_Type,"); strSql.Append("error_code=@error_code,"); strSql.Append("error_name=@error_name,"); strSql.Append("event_time=@event_time,"); strSql.Append("remarks=@remarks"); strSql.Append(" where "); SqlParameter[] parameters = { new SqlParameter("@MachineID", SqlDbType.VarChar, 50), new SqlParameter("@PQMmachineID", SqlDbType.VarChar, 50), new SqlParameter("@Event_Type", SqlDbType.VarChar, 50), new SqlParameter("@error_code", SqlDbType.VarChar, 50), new SqlParameter("@error_name", SqlDbType.VarChar, 50), new SqlParameter("@event_time", SqlDbType.DateTime2, 8), new SqlParameter("@remarks", SqlDbType.VarChar, 50) }; parameters[0].Value = model.MachineID; parameters[1].Value = model.PQMmachineID; parameters[2].Value = model.Event_Type; parameters[3].Value = model.error_code; parameters[4].Value = model.error_name; parameters[5].Value = model.event_time; parameters[6].Value = model.remarks; DBHelp.Reports.LogFile.DebugLog("AUTOCODE", "NameSpace:Common.DAL", "Class:MouldingMachineEvent_DAL", "Function: public bool Update(Common.Model.MouldingMachineEvent_Model model)"+ "TableName:MouldingMachineEvent", ";MachineID = " + model.MachineID.ToString() + ";PQMmachineID = " + model.PQMmachineID.ToString() + ";Event_Type = " + model.Event_Type.ToString() + ";error_code = " + model.error_code.ToString() + ";error_name = " + model.error_name.ToString() + ";event_time = " + model.event_time.ToString() + ";remarks = " + model.remarks.ToString() + ""); int rows = DBHelp.SqlDB.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }