public List <ArrangeClassEntity> GetSearch(string sort, string order, int offset, int pageSize, out int total) { int pageCount = 0; string querySql = string.Format("select * from ArrangeClass(nolock) where valid = 'T'"); DataTable dt = SplitPage.SqlSplitPage(querySql, string.Format("order by {0} {1}", sort, order), null, offset / pageSize, pageSize, out pageCount, out total); List <ArrangeClassEntity> list = new List <ArrangeClassEntity>(); foreach (DataRow dr in dt.Rows) { ArrangeClassEntity entity = new ArrangeClassEntity(); entity.ID = Ext.ToInt(dr["ID"]); entity.CurriculumID = Ext.ToInt(dr["CurriculumID"]); entity.ClassID = Ext.ToInt(dr["ClassID"]); entity.ClassRoomID = Ext.ToInt(dr["ClassRoomID"]); entity.TeacherID = Ext.ToInt(dr["TeacherID"]); entity.StartTime = Ext.ToDateOrNull(dr["StartTime"]); entity.EndTime = Ext.ToDateOrNull(dr["EndTime"]); entity.Remark = Ext.ToString(dr["Remark"]); entity.BespeakCount = Ext.ToIntOrNull(dr["BespeakCount"]); entity.AttendCount = Ext.ToIntOrNull(dr["AttendCount"]); entity.PassedCount = Ext.ToIntOrNull(dr["PassedCount"]); entity.Valid = Ext.ToString(dr["Valid"]); entity.CreateTime = Ext.ToDate(dr["CreateTime"]); entity.CreateBy = Ext.ToString(dr["CreateBy"]); entity.UpdateTime = Ext.ToDate(dr["UpdateTime"]); entity.UpdateBy = Ext.ToString(dr["UpdateBy"]); list.Add(entity); } return(list); }
public void Update(ArrangeClassEntity entity) { entity.UpdateTime = DateTime.Now; IDbSession session = SessionFactory.CreateSession(); try { session.BeginTrans(); Repository.Update <ArrangeClassEntity>(session.Connection, entity, session.Transaction); session.Commit(); } catch (System.Exception) { session.Rollback(); throw; } finally { session.Dispose(); } }
public string DeleteArrangeClass(int id) { try { ArrangeClassManager manager = new ArrangeClassManager(); ArrangeClassEntity entity = manager.GetArrangeClassByID(id); if (entity != null) { entity.Valid = "F"; entity.CreateTime = DateTime.Now; entity.CreateTime = DateTime.Now; manager.Update(entity); } return("success"); } catch (Exception e) { return(e.ToString()); } }
public string PostArrangeClass(ArrangeClassEntity entity) { try { if (entity == null || entity.ClassID <= 0 || entity.ClassRoomID <= 0 || entity.CurriculumID <= 0 || entity.TeacherID <= 0) { return("error"); } ArrangeClassManager manager = new ArrangeClassManager(); entity.CreateTime = DateTime.Now; entity.CreateTime = DateTime.Now; manager.Insert(entity); return("success"); } catch (Exception e) { return(e.ToString()); } }
public string PutArrangeClass(ArrangeClassEntity entity) { try { if (entity == null) { return("error"); } ArrangeClassManager manager = new ArrangeClassManager(); entity.CreateTime = DateTime.Now; entity.CreateTime = DateTime.Now; manager.Update(entity); return("success"); } catch (Exception e) { return(e.ToString()); } }