public ActionResult SemesterAdd(string Title,DateTime SignDate,DateTime StartDate,DateTime SignEndDate,DateTime EndDate) { Training_Plan model = new Training_Plan(); model.Title = Title; model.PartitionId = Code.SiteCache.Instance.LoginInfo.PartitionId; model.Sort = int.Parse(DateTime.Now.ToString("HHmmssfff")); model.IsOpen = false; model.Display = true; model.Delflag = false; model.CreateDate = DateTime.Now; model.SignUpStartTime = SignDate; model.SignUpEndTime = SignEndDate; model.OpenClassFrom = StartDate; model.OpenClassTo = EndDate; if (bll.YzPlanName(model.Title,0)) { return Content("no:学期名重复!!!"); } int i = bll.Add(model); if (i > 0) { return Content("yes:添加成功!!!"); } else { return Content("no:添加失败!!!"); } }
private void ConvertToModel(IDataReader reader, Training_Plan model) { if (reader["Id"] != DBNull.Value) model.Id = Convert.ToInt32(reader["Id"]); if (reader["Title"] != DBNull.Value) model.Title = reader["Title"].ToString(); if (reader["PartitionId"] != DBNull.Value) model.PartitionId = Convert.ToInt32(reader["PartitionId"]); if (reader["IsOpen"] != DBNull.Value) model.IsOpen = Convert.ToBoolean(reader["IsOpen"]); if (reader["Sort"] != DBNull.Value) model.Sort = Convert.ToInt32(reader["Sort"]); if (reader["Display"] != DBNull.Value) model.Display = Convert.ToBoolean(reader["Display"]); if (reader["Delflag"] != DBNull.Value) model.Delflag = Convert.ToBoolean(reader["Delflag"]); if (reader["CreateDate"] != DBNull.Value) model.CreateDate = Convert.ToDateTime(reader["CreateDate"]); if (reader["SignUpStartTime"] != DBNull.Value) model.SignUpStartTime = Convert.ToDateTime(reader["SignUpStartTime"]); if (reader["SignUpEndTime"] != DBNull.Value) model.SignUpEndTime = Convert.ToDateTime(reader["SignUpEndTime"]); if (reader["OpenClassFrom"] != DBNull.Value) model.OpenClassFrom = Convert.ToDateTime(reader["OpenClassFrom"]); if (reader["OpenClassTo"] != DBNull.Value) model.OpenClassTo = Convert.ToDateTime(reader["OpenClassTo"]); }
public bool SemesterUpd(Training_Plan model) { StringBuilder sql = new StringBuilder(); sql.Append(" update Training_Plan Set Title=@Title,Display=@Display, "); sql.Append(" SignUpStartTime=@SignUpStartTime,SignUpEndTime=@SignUpEndTime,OpenClassFrom=@OpenClassFrom,OpenClassTo=@OpenClassTo "); sql.Append(" where id=@id "); SqlParameter[] para ={ new SqlParameter("@Title",SqlDbType.VarChar), new SqlParameter("@Display",SqlDbType.Bit), new SqlParameter("@id",SqlDbType.Int), new SqlParameter("@SignUpStartTime",SqlDbType.DateTime), new SqlParameter("@SignUpEndTime",SqlDbType.DateTime), new SqlParameter("@OpenClassFrom",SqlDbType.DateTime), new SqlParameter("@OpenClassTo",SqlDbType.Date) }; para[0].Value = model.Title; para[1].Value = model.Display; para[2].Value = model.Id; para[3].Value = model.SignUpStartTime; para[4].Value = model.SignUpEndTime; para[5].Value = model.OpenClassFrom; para[6].Value = model.OpenClassTo; int i = MSEntLibSqlHelper.ExecuteNonQueryBySql(sql.ToString(), para); if (i > 0) { return true; } else { return false; } }
public List<Training_Plan> GetList(int pageSize, int pageIndex, string where, string orderBy, out int recordCount) { if (string.IsNullOrEmpty(orderBy)) throw new ArgumentNullException(); StringBuilder sb = new StringBuilder(); sb.Append("select count(1) from dbo.Training_Plan where Delflag = 0 and DisPlay = 1 "); if (!string.IsNullOrEmpty(where)) sb.Append(where); recordCount = Convert.ToInt32(MSEntLibSqlHelper.ExecuteScalarBySql(sb.ToString())); int start = (pageIndex - 1) * pageSize + 1; int end = pageIndex * pageSize; StringBuilder sql = new StringBuilder(); sql.Append("select * from (select *,ROW_NUMBER() over (order by " + orderBy + ") as RowNum from dbo.Training_Plan where Delflag = 0 and DisPlay = 1 "); if (!string.IsNullOrEmpty(where)) sql.Append(where); sql.Append(")as T where RowNum between @start and @end"); SqlParameter[] para ={ new SqlParameter("@start",start), new SqlParameter("@end",end) }; List<Training_Plan> list = new List<Training_Plan>(); using (IDataReader reader = MSEntLibSqlHelper.ExecuteDataReaderBySql(sql.ToString(),para)) { while (reader.Read()) { Training_Plan model = new Training_Plan(); ConvertToModel(reader, model); list.Add(model); } } return list; }
public bool SemesterUpd(Training_Plan model) { return dal.SemesterUpd(model); }
public ActionResult SemesterEdit(int id,string Title, DateTime SignDate, DateTime StartDate, DateTime SignEndDate, DateTime EndDate) { Training_Plan model = new Training_Plan(); model.Id = id; model.Title = Title; model.Display = true; model.SignUpStartTime = SignDate; model.SignUpEndTime = SignEndDate; model.OpenClassFrom = StartDate; model.OpenClassTo = EndDate; if (bll.YzPlanName(model.Title,model.Id)) { return Content("no:学期名重复!!!"); } if (bll.SemesterUpd(model)) { return Content("yes:修改成功!!!"); } else { return Content("no:修改失败!!!"); } }