public List <ClassInfoEntity> GetSearch(string keyString, string sort, string order, int offset, int pageSize, out int total) { int pageCount = 0; string querySql = string.Format("select * from ClassInfo(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 <ClassInfoEntity> list = new List <ClassInfoEntity>(); foreach (DataRow dr in dt.Rows) { ClassInfoEntity entity = new ClassInfoEntity(); entity.ClassID = Ext.ToInt(dr["ClassID"]); entity.Code = Ext.ToString(dr["Code"]); entity.Name = Ext.ToString(dr["Name"]); entity.Type = Ext.ToString(dr["Type"]); entity.StartTime = Ext.ToDateOrNull(dr["StartTime"]); entity.EndTime = Ext.ToDateOrNull(dr["EndTime"]); entity.TeacherID = Ext.ToIntOrNull(dr["TeacherID"]); entity.Company = Ext.ToString(dr["Company"]); entity.Department = Ext.ToString(dr["Department"]); 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 SaveClass(string jsonString, string action) { try { ClassInfoEntity entity = JsonConvert.DeserializeObject <ClassInfoEntity>(jsonString); ClassInfoManager manager = new ClassInfoManager(); if (action == "add") { manager.Insert(entity); } else { ClassInfoEntity oldEntity = manager.GetClassInfoByCode(entity.Code); oldEntity.Name = entity.Name; oldEntity.Type = entity.Type; oldEntity.StartTime = entity.StartTime; oldEntity.EndTime = entity.EndTime; oldEntity.TeacherID = entity.TeacherID; oldEntity.UpdateBy = SessionHelper.CurrentUser.Code; manager.Update(oldEntity); } return("success"); } catch (Exception e) { return(e.ToString()); } }
public void Update(ClassInfoEntity entity) { entity.UpdateTime = DateTime.Now; IDbSession session = SessionFactory.CreateSession(); try { session.BeginTrans(); Repository.Update <ClassInfoEntity>(session.Connection, entity, session.Transaction); session.Commit(); } catch (System.Exception) { session.Rollback(); throw; } finally { session.Dispose(); } }
public string PutClassInfo(ClassInfoEntity entity) { try { if (entity == null) { return("error"); } ClassInfoManager manager = new ClassInfoManager(); entity.CreateTime = DateTime.Now; entity.CreateTime = DateTime.Now; manager.Update(entity); return("success"); } catch (Exception e) { return(e.ToString()); } }
public string DeleteClassInfo(int id) { try { ClassInfoManager manager = new ClassInfoManager(); ClassInfoEntity entity = manager.GetClassInfoByID(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()); } }