public int ScheduleConfigInfoUpdate(ScheduleConfigQuery query) //更新schedule_config信息 { StringBuilder sql = new StringBuilder(); query.Replace4MySQL(); try { sql.AppendFormat("update schedule_config set schedule_code = '{0}', parameterCode = '{1}', value = '{2}',parameterName='{3}',create_user='******',change_user='******',change_time='{6}' where rowid='{7}' ", query.schedule_code, query.parameterCode, query.value, query.parameterName, query.create_user, query.change_user, CommonFunction.GetPHPTime(DateTime.Now.ToString()), query.rowid); return _access.execCommand(sql.ToString()); } catch (Exception ex) { throw new Exception("ScheduleServiceDao-->ScheduleMasterInfoUpdate-->" + sql.ToString() + ex.Message); } }
public int ScheduleConfigInfoInsert(ScheduleConfigQuery query) //插入schedule_config信息 { StringBuilder sql = new StringBuilder(); query.Replace4MySQL(); try { sql.Append("insert into schedule_config ( schedule_code, parameterCode, value,parameterName,create_user,change_user, create_time, change_time) values "); sql.AppendFormat("('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", query.schedule_code, query.parameterCode, query.value, query.parameterName, query.create_user, query.change_user, CommonFunction.GetPHPTime(DateTime.Now.ToString()), CommonFunction.GetPHPTime(DateTime.Now.ToString())); return _access.execCommand(sql.ToString()); } catch (Exception ex) { throw new Exception("ScheduleServiceDao-->ScheduleMasterInfoInsert-->" + sql.ToString() + ex.Message); } }