/// <summary> /// job列表 /// </summary> /// <returns></returns> public List <Job_Info> GetJobList() { List <Job_Info> list = null; try { string SqlStr = "select * from job_info"; var ds = MySqlHelper.GetDataSet(SqlStr); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { list = new List <Job_Info>(); Job_Info info = new Job_Info(); foreach (System.Data.DataRow row in ds.Tables[0].Rows) { info = Job_Info.ToEntity <Job_Info>(row, info); if (info != null) { list.Add(info); } } } } finally { } return(list); }
/// <summary> /// job列表 /// </summary> /// <returns></returns> public List <Job_Info> GetJobList(int pageIndex, int pageSize) { List <Job_Info> list = null; try { string SqlStr = "select * from job_info"; SqlStr += string.Format(" limit {0},{1};", (pageIndex - 1) * pageSize, pageSize); var ds = MySqlHelper.GetDataSet(SqlStr); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { list = new List <Job_Info>(); Job_Info info = new Job_Info(); foreach (System.Data.DataRow row in ds.Tables[0].Rows) { info = Job_Info.ToEntity <Job_Info>(row, info); if (info != null) { list.Add(info); } } } } finally { } return(list); }
/// <summary> /// 更新Job的状态 /// </summary> /// <param name="jobInfo"></param> /// <returns></returns> public int UpdateJobState(Job_Info jobInfo) { int result = 0; if (jobInfo == null) { return(result); } try { string SqlStr = string.Format("update job_info set job_state={0} where ", jobInfo.Job_state); if (jobInfo.Id > 0) { SqlStr += string.Format(" id={0};", jobInfo.Id); } else if (!string.IsNullOrEmpty(jobInfo.Job_name)) { SqlStr += string.Format(" job_name='{0}'", jobInfo.Job_name); } result = MySqlHelper.ExceuteSql(SqlStr); } finally { } return(result); }
public ActionResult Update(Job_Info job) { var bll = new JobInfoBLL(); if (bll.UpdateJobState(job) > 0) { return(Success()); } else { return(Error()); } }
public ActionResult Add(Job_Info job) { var bll = new JobInfoBLL(); if (bll.AddInfo(job) > 0) { return(Success()); } else { return(Error()); } }
/// <summary> /// 添加Job信息 /// </summary> /// <param name="jobInfo"></param> /// <returns></returns> public int AddInfo(Job_Info jobInfo) { int result = 0; if (jobInfo == null) { return(result); } try { string SqlStr = string.Format("insert into job_info(job_name,job_assembly,job_class,job_corn,job_type,job_execount,job_starttime,job_state) values('{0}','{1}','{7}','{2}',{3},{4},'{5}',{6})", jobInfo.Job_name, jobInfo.Job_assembly, jobInfo.Job_corn, jobInfo.Job_type, jobInfo.Job_execount, jobInfo.Job_starttime.ToString("yyyy-MM-dd HH:mm:ss"), 0, jobInfo.Job_class); result = MySqlHelper.ExceuteSql(SqlStr); } finally { } return(result); }
public Job_Info GetOne(int id) { Job_Info job = null; try { string SqlStr = "select * from job_info where id=" + id; var ds = MySqlHelper.GetDataSet(SqlStr); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { job = new Job_Info(); foreach (System.Data.DataRow row in ds.Tables[0].Rows) { job = Job_Info.ToEntity <Job_Info>(row, job); } } } catch (Exception ex) { } return(job); }
public void GetJob(int id) { job = jobbll.GetOne(id); }