/// <summary> /// 获得数据列表 /// </summary> /// <returns></returns> public static List <OtGroupInfo> GetList() { string cacheKey = GetCacheKey(); //本实体已经注册成缓存实体,并且缓存存在的时候,直接从缓存取 if (CachedEntityCommander.IsTypeRegistered(typeof(OtGroupInfo)) && CachedEntityCommander.GetCache(cacheKey) != null) { return(CachedEntityCommander.GetCache(cacheKey) as List <OtGroupInfo>); } else { List <OtGroupInfo> list = new List <OtGroupInfo>(); OtGroupCollection collection = new OtGroupCollection(); Query qry = new Query(OtGroup.Schema); collection.LoadAndCloseReader(qry.ExecuteReader()); foreach (OtGroup otGroup in collection) { OtGroupInfo otGroupInfo = new OtGroupInfo(); LoadFromDAL(otGroupInfo, otGroup); list.Add(otGroupInfo); } //生成缓存 if (CachedEntityCommander.IsTypeRegistered(typeof(OtGroupInfo))) { CachedEntityCommander.SetCache(cacheKey, list); } return(list); } }
/// <summary> /// 获得分页列表,无论是否是缓存实体都从数据库直接拿取数据 /// </summary> /// <param name="pPageIndex">页数</param> /// <param name="pPageSize">每页列表</param> /// <param name="pOrderBy">排序</param> /// <param name="pSortExpression">排序字段</param> /// <param name="pRecordCount">列表行数</param> /// <returns>数据分页</returns> public static List <OtGroupInfo> GetPagedList(int pPageIndex, int pPageSize, SortDirection pOrderBy, string pSortExpression, out int pRecordCount) { if (pPageIndex <= 1) { pPageIndex = 1; } List <OtGroupInfo> list = new List <OtGroupInfo>(); Query q = OtGroup.CreateQuery(); q.PageIndex = pPageIndex; q.PageSize = pPageSize; q.ORDER_BY(pSortExpression, pOrderBy.ToString()); OtGroupCollection collection = new OtGroupCollection(); collection.LoadAndCloseReader(q.ExecuteReader()); foreach (OtGroup otGroup in collection) { OtGroupInfo otGroupInfo = new OtGroupInfo(); LoadFromDAL(otGroupInfo, otGroup); list.Add(otGroupInfo); } pRecordCount = q.GetRecordCount(); return(list); }
//数据持久化 internal static void SaveToDb(OtGroupInfo pOtGroupInfo, OtGroup pOtGroup, bool pIsNew) { pOtGroup.OtGroupId = pOtGroupInfo.otGroupId; pOtGroup.GroupName = pOtGroupInfo.groupName; pOtGroup.OverTimeId = pOtGroupInfo.overTimeId; pOtGroup.ApplyName = pOtGroupInfo.applyName; pOtGroup.IsNew = pIsNew; string UserName = SubsonicHelper.GetUserName(); try { pOtGroup.Save(UserName); } catch (Exception ex) { LogManager.getInstance().getLogger(typeof(OtGroupInfo)).Error(ex); if (ex.Message.Contains("插入重复键")) //违反了唯一键 { throw new AppException("此对象已经存在"); //此处等待优化可以从唯一约束中直接取出提示来,如果没有的话,默认为原始的出错提示 } throw new AppException("保存失败"); } pOtGroupInfo.otGroupId = pOtGroup.OtGroupId; //如果缓存存在,更新缓存 if (CachedEntityCommander.IsTypeRegistered(typeof(OtGroupInfo))) { ResetCache(); } }
protected void btnAdd_Click(object sender, EventArgs e) { OtGroupInfo group = new OtGroupInfo(); group.OverTimeId = Convert.ToInt32(ViewState["OverTimeId"]); group.Save(); gvDataBind(); }
//从后台获取数据 internal static void LoadFromDAL(OtGroupInfo pOtGroupInfo, OtGroup pOtGroup) { pOtGroupInfo.otGroupId = pOtGroup.OtGroupId; pOtGroupInfo.groupName = pOtGroup.GroupName; pOtGroupInfo.overTimeId = pOtGroup.OverTimeId; pOtGroupInfo.applyName = pOtGroup.ApplyName; pOtGroupInfo.Loaded = true; }
/// <summary> /// 复制一个对象,采用硬编码的方式,避免反射的低效 /// </summary> /// <param name="pIndustryTypeInfoFrom"></param> /// <param name="pIndustryTypeInfoTo"></param> public static void Copy(OtGroupInfo pOtGroupInfoFrom, OtGroupInfo pOtGroupInfoTo) { pOtGroupInfoTo.OtGroupId = pOtGroupInfoFrom.otGroupId; pOtGroupInfoTo.GroupName = pOtGroupInfoFrom.groupName; pOtGroupInfoTo.OverTimeId = pOtGroupInfoFrom.overTimeId; pOtGroupInfoTo.ApplyName = pOtGroupInfoFrom.applyName; pOtGroupInfoTo.Loaded = pOtGroupInfoFrom.Loaded; }
/// <summary> /// 批量装载 /// </summary> internal static void LoadFromDALPatch(List <OtGroupInfo> pList, OtGroupCollection pCollection) { foreach (OtGroup otGroup in pCollection) { OtGroupInfo otGroupInfo = new OtGroupInfo(); LoadFromDAL(otGroupInfo, otGroup); pList.Add(otGroupInfo); } }
public OtGroupInfo GetOtGroupInfoById(int OtGroupId) { OtGroupInfo otGroupInfo = null;// try { otGroupInfo = new OtGroupInfo(OtGroupId); } catch (AppException) { return null; } return otGroupInfo; }
public OtGroupInfo GetOtGroupInfoById(int OtGroupId) { OtGroupInfo otGroupInfo = null; // try { otGroupInfo = new OtGroupInfo(OtGroupId); } catch (AppException) { return(null); } return(otGroupInfo); }
private void LoadFromId(int otGroupId) { if (CachedEntityCommander.IsTypeRegistered(typeof(OtGroupInfo))) { OtGroupInfo otGroupInfo = Find(GetList(), otGroupId); if (otGroupInfo == null) { throw new AppException("未能在缓存中找到相应的键值对象"); } Copy(otGroupInfo, this); } else { OtGroup otGroup = new OtGroup(otGroupId); if (otGroup.IsNew) { throw new AppException("尚未初始化"); } LoadFromDAL(this, otGroup); } }
public List <OtGroupInfo> GetOtGroupInfoList() { return(OtGroupInfo.GetList()); }
public void DeleteById(OtGroupInfo pOtGroupInfo) { OtGroupInfo otGroupInfo = new OtGroupInfo(pOtGroupInfo.OtGroupId); otGroupInfo.Delete(); }
//数据持久化 internal static void SaveToDb(OtGroupInfo pOtGroupInfo, OtGroup pOtGroup,bool pIsNew) { pOtGroup.OtGroupId = pOtGroupInfo.otGroupId; pOtGroup.GroupName = pOtGroupInfo.groupName; pOtGroup.OverTimeId = pOtGroupInfo.overTimeId; pOtGroup.ApplyName = pOtGroupInfo.applyName; pOtGroup.IsNew=pIsNew; string UserName = SubsonicHelper.GetUserName(); try { pOtGroup.Save(UserName); } catch(Exception ex) { LogManager.getInstance().getLogger(typeof(OtGroupInfo)).Error(ex); if(ex.Message.Contains("插入重复键"))//违反了唯一键 { throw new AppException("此对象已经存在");//此处等待优化可以从唯一约束中直接取出提示来,如果没有的话,默认为原始的出错提示 } throw new AppException("保存失败"); } pOtGroupInfo.otGroupId = pOtGroup.OtGroupId; //如果缓存存在,更新缓存 if (CachedEntityCommander.IsTypeRegistered(typeof(OtGroupInfo))) { ResetCache(); } }
/// <summary> /// 批量装载 /// </summary> internal static void LoadFromDALPatch(List< OtGroupInfo> pList, OtGroupCollection pCollection) { foreach (OtGroup otGroup in pCollection) { OtGroupInfo otGroupInfo = new OtGroupInfo(); LoadFromDAL(otGroupInfo, otGroup ); pList.Add(otGroupInfo); } }
//从后台获取数据 internal static void LoadFromDAL(OtGroupInfo pOtGroupInfo, OtGroup pOtGroup) { pOtGroupInfo.otGroupId = pOtGroup.OtGroupId; pOtGroupInfo.groupName = pOtGroup.GroupName; pOtGroupInfo.overTimeId = pOtGroup.OverTimeId; pOtGroupInfo.applyName = pOtGroup.ApplyName; pOtGroupInfo.Loaded=true; }
/// <summary> /// 复制为另一个对象 /// </summary> /// <param name="pIndustryTypeInfoTo"></param> public void CopyTo(OtGroupInfo pOtGroupInfoTo) { Copy(this, pOtGroupInfoTo); }
/// <summary> /// 获得分页列表,无论是否是缓存实体都从数据库直接拿取数据 /// </summary> /// <param name="pPageIndex">页数</param> /// <param name="pPageSize">每页列表</param> /// <param name="pOrderBy">排序</param> /// <param name="pSortExpression">排序字段</param> /// <param name="pRecordCount">列表行数</param> /// <returns>数据分页</returns> public static List<OtGroupInfo> GetPagedList(int pPageIndex,int pPageSize,SortDirection pOrderBy,string pSortExpression,out int pRecordCount) { if(pPageIndex<=1) pPageIndex=1; List< OtGroupInfo> list = new List< OtGroupInfo>(); Query q = OtGroup .CreateQuery(); q.PageIndex = pPageIndex; q.PageSize = pPageSize; q.ORDER_BY(pSortExpression,pOrderBy.ToString()); OtGroupCollection collection=new OtGroupCollection(); collection.LoadAndCloseReader(q.ExecuteReader()); foreach (OtGroup otGroup in collection) { OtGroupInfo otGroupInfo = new OtGroupInfo(); LoadFromDAL(otGroupInfo, otGroup); list.Add(otGroupInfo); } pRecordCount=q.GetRecordCount(); return list; }
/// <summary> /// 获得数据列表 /// </summary> /// <returns></returns> public static List<OtGroupInfo> GetList() { string cacheKey = GetCacheKey(); //本实体已经注册成缓存实体,并且缓存存在的时候,直接从缓存取 if (CachedEntityCommander.IsTypeRegistered(typeof(OtGroupInfo)) && CachedEntityCommander.GetCache(cacheKey) != null) { return CachedEntityCommander.GetCache(cacheKey) as List< OtGroupInfo>; } else { List< OtGroupInfo> list =new List< OtGroupInfo>(); OtGroupCollection collection=new OtGroupCollection(); Query qry = new Query(OtGroup.Schema); collection.LoadAndCloseReader(qry.ExecuteReader()); foreach(OtGroup otGroup in collection) { OtGroupInfo otGroupInfo= new OtGroupInfo(); LoadFromDAL(otGroupInfo,otGroup); list.Add(otGroupInfo); } //生成缓存 if (CachedEntityCommander.IsTypeRegistered(typeof(OtGroupInfo))) { CachedEntityCommander.SetCache(cacheKey, list); } return list; } }
/// <summary> /// 复制一个对象,采用硬编码的方式,避免反射的低效 /// </summary> /// <param name="pIndustryTypeInfoFrom"></param> /// <param name="pIndustryTypeInfoTo"></param> public static void Copy(OtGroupInfo pOtGroupInfoFrom, OtGroupInfo pOtGroupInfoTo) { pOtGroupInfoTo.OtGroupId = pOtGroupInfoFrom.otGroupId; pOtGroupInfoTo.GroupName = pOtGroupInfoFrom.groupName; pOtGroupInfoTo.OverTimeId = pOtGroupInfoFrom.overTimeId; pOtGroupInfoTo.ApplyName = pOtGroupInfoFrom.applyName; pOtGroupInfoTo.Loaded=pOtGroupInfoFrom.Loaded; }
public List <OtGroupInfo> GetPagedList(int pPageIndex, int pPageSize, SortDirection pOrderBy, string pSortExpression, out int pRecordCount) { return(OtGroupInfo.GetPagedList(pPageIndex, pPageSize, pOrderBy, pSortExpression, out pRecordCount)); }
protected void gvOverTime_RowUpdating(object sender, GridViewUpdateEventArgs e) { int otid = Convert.ToInt32(gvOtGroup.DataKeys[e.RowIndex].Value); OtGroupInfo group = new OtGroupInfo(otid); TextBox txtGroupName = gvOtGroup.Rows[e.RowIndex].FindControl("txtGroupName") as TextBox; TextBox txtEmName = gvOtGroup.Rows[e.RowIndex].FindControl("txtApplyName") as TextBox; try { group.ApplyName = txtEmName.Text.ToString(); group.GroupName = txtGroupName.Text.ToString(); group.Save(); gvOtGroup.EditIndex = -1; gvDataBind(); } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "Save", "alert('����ʧ�ܣ�" + ex.Message + "');", true); } }
public object SaveOtGroupInfo(OtGroupInfo otGroupInfo) { otGroupInfo.Save(); return(otGroupInfo.OtGroupId); }
public object SaveOtGroupInfo(OtGroupInfo otGroupInfo) { otGroupInfo.Save(); return otGroupInfo . OtGroupId; }