public List <ClassRoomInfoEntity> GetSearch(string keyString, string sort, string order, int offset, int pageSize, out int total) { int pageCount = 0; string querySql = string.Format("select * from ClassRoomInfo(nolock) where valid = 'T' and (code like '%{0}%' or name like '%{0}%')", keyString); DataTable dt = SplitPage.SqlSplitPage(querySql, string.Format("order by {0} {1}", sort, order), null, offset / pageSize, pageSize, out pageCount, out total); List <ClassRoomInfoEntity> list = new List <ClassRoomInfoEntity>(); foreach (DataRow dr in dt.Rows) { ClassRoomInfoEntity entity = new ClassRoomInfoEntity(); entity.ClassRoomID = Ext.ToInt(dr["ClassRoomID"]); entity.Code = Ext.ToString(dr["Code"]); entity.Name = Ext.ToString(dr["Name"]); entity.Address = Ext.ToString(dr["Address"]); entity.Type = Ext.ToString(dr["Type"]); entity.SeatNum = Ext.ToIntOrNull(dr["SeatNum"]); entity.Remark = Ext.ToString(dr["Remark"]); 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 string SaveClassRoom(string jsonString, string action) { try { ClassRoomInfoEntity entity = JsonConvert.DeserializeObject <ClassRoomInfoEntity>(jsonString); ClassRoomInfoManager manager = new ClassRoomInfoManager(); if (action == "add") { manager.Insert(entity); } else { ClassRoomInfoEntity oldEntity = manager.GetClassRoomInfoByCode(entity.Code); oldEntity.Name = entity.Name; oldEntity.Address = entity.Address; oldEntity.Type = entity.Type; oldEntity.SeatNum = entity.SeatNum; oldEntity.UpdateBy = SessionHelper.CurrentUser.Code; manager.Update(oldEntity); } return("success"); } catch (Exception e) { return(e.ToString()); } }
public void Update(ClassRoomInfoEntity entity) { entity.UpdateTime = DateTime.Now; IDbSession session = SessionFactory.CreateSession(); try { session.BeginTrans(); Repository.Update <ClassRoomInfoEntity>(session.Connection, entity, session.Transaction); session.Commit(); } catch (System.Exception) { session.Rollback(); throw; } finally { session.Dispose(); } }
public string PutClassRoomInfo(ClassRoomInfoEntity entity) { try { if (entity == null) { return("error"); } ClassRoomInfoManager manager = new ClassRoomInfoManager(); entity.CreateTime = DateTime.Now; entity.CreateTime = DateTime.Now; manager.Update(entity); return("success"); } catch (Exception e) { return(e.ToString()); } }
public string DeleteClassRoomInfo(int id) { try { ClassRoomInfoManager manager = new ClassRoomInfoManager(); ClassRoomInfoEntity entity = manager.GetClassRoomInfoByID(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()); } }