/// <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 <HolidayApplyInfo> GetPagedList(int pPageIndex, int pPageSize, SortDirection pOrderBy, string pSortExpression, out int pRecordCount)
{
if (pPageIndex <= 1)
{
pPageIndex = 1;
}
List <HolidayApplyInfo> list = new List <HolidayApplyInfo>();
Query q = HolidayApply.CreateQuery();
q.PageIndex = pPageIndex;
q.PageSize = pPageSize;
q.ORDER_BY(pSortExpression, pOrderBy.ToString());
HolidayApplyCollection collection = new HolidayApplyCollection();
collection.LoadAndCloseReader(q.ExecuteReader());
foreach (HolidayApply holidayApply in collection)
{
HolidayApplyInfo holidayApplyInfo = new HolidayApplyInfo();
LoadFromDAL(holidayApplyInfo, holidayApply);
list.Add(holidayApplyInfo);
}
pRecordCount = q.GetRecordCount();
return(list);
}
/// <summary>
/// 保存
/// </summary>
public override void Save()
{
if (!m_Loaded) //新增
{
HolidayApply holidayApply = new HolidayApply();
SaveToDb(this, holidayApply, true);
}
else //修改
{
HolidayApply holidayApply = new HolidayApply(holidayApplyId);
if (holidayApply.IsNew)
{
throw new AppException("该数据已经不存在了");
}
SaveToDb(this, holidayApply, false);
}
}
/// <summary>
/// 删除
/// </summary>
/// <returns>是否成功</returns>
public override void Delete()
{
if (!m_Loaded)
{
throw new AppException("尚未初始化");
}
bool result = (HolidayApply.Delete(HolidayApplyId) == 1);
//更新缓存
if (result && CachedEntityCommander.IsTypeRegistered(typeof(HolidayApplyInfo)))
{
ResetCache();
}
if (!result)
{
throw new AppException("删除失败，数据可能被删除");
}
}
//数据持久化
internal static void SaveToDb(HolidayApplyInfo pHolidayApplyInfo, HolidayApply pHolidayApply, bool pIsNew)
{
pHolidayApply.HolidayApplyId = pHolidayApplyInfo.holidayApplyId;
pHolidayApply.Company1 = pHolidayApplyInfo.company1;
pHolidayApply.PositonName = pHolidayApplyInfo.positonName;
pHolidayApply.Company2 = pHolidayApplyInfo.company2;
pHolidayApply.Company2Name = pHolidayApplyInfo.company2Name;
pHolidayApply.HolidayTypeId = pHolidayApplyInfo.holidayTypeId;
pHolidayApply.BeginTime = pHolidayApplyInfo.beginTime;
pHolidayApply.EndTime = pHolidayApplyInfo.endTime;
pHolidayApply.TimeSum = pHolidayApplyInfo.timeSum;
pHolidayApply.Reason = pHolidayApplyInfo.reason;
pHolidayApply.SectionView = pHolidayApplyInfo.sectionView;
pHolidayApply.HrView = pHolidayApplyInfo.hrView;
pHolidayApply.ManagerView = pHolidayApplyInfo.managerView;
pHolidayApply.Memo = pHolidayApplyInfo.memo;
pHolidayApply.ApplyDate = pHolidayApplyInfo.applyDate;
pHolidayApply.ApplyTime = pHolidayApplyInfo.applyTime;
pHolidayApply.ApplyName = pHolidayApplyInfo.applyName;
pHolidayApply.DepartName = pHolidayApplyInfo.departName;
pHolidayApply.State = pHolidayApplyInfo.state;
pHolidayApply.IsNew = pIsNew;
string UserName = SubsonicHelper.GetUserName();
try
{
pHolidayApply.Save(UserName);
}
catch (Exception ex)
{
LogManager.getInstance().getLogger(typeof(HolidayApplyInfo)).Error(ex);
if (ex.Message.Contains("插入重复键")) //违反了唯一键
{
throw new AppException("此对象已经存在"); //此处等待优化可以从唯一约束中直接取出提示来，如果没有的话，默认为原始的出错提示
}
throw new AppException("保存失败");
}
pHolidayApplyInfo.holidayApplyId = pHolidayApply.HolidayApplyId;
//如果缓存存在，更新缓存
if (CachedEntityCommander.IsTypeRegistered(typeof(HolidayApplyInfo)))
{
ResetCache();
}
}
private void LoadFromId(int holidayApplyId)
{
if (CachedEntityCommander.IsTypeRegistered(typeof(HolidayApplyInfo)))
{
HolidayApplyInfo holidayApplyInfo = Find(GetList(), holidayApplyId);
if (holidayApplyInfo == null)
{
throw new AppException("未能在缓存中找到相应的键值对象");
}
Copy(holidayApplyInfo, this);
}
else
{
HolidayApply holidayApply = new HolidayApply(holidayApplyId);
if (holidayApply.IsNew)
{
throw new AppException("尚未初始化");
}
LoadFromDAL(this, holidayApply);
}
}
//从后台获取数据
internal static void LoadFromDAL(HolidayApplyInfo pHolidayApplyInfo, HolidayApply pHolidayApply)
{
pHolidayApplyInfo.holidayApplyId = pHolidayApply.HolidayApplyId;
pHolidayApplyInfo.company1 = pHolidayApply.Company1;
pHolidayApplyInfo.positonName = pHolidayApply.PositonName;
pHolidayApplyInfo.company2 = pHolidayApply.Company2;
pHolidayApplyInfo.company2Name = pHolidayApply.Company2Name;
pHolidayApplyInfo.holidayTypeId = pHolidayApply.HolidayTypeId;
pHolidayApplyInfo.beginTime = pHolidayApply.BeginTime;
pHolidayApplyInfo.endTime = pHolidayApply.EndTime;
pHolidayApplyInfo.timeSum = pHolidayApply.TimeSum;
pHolidayApplyInfo.reason = pHolidayApply.Reason;
pHolidayApplyInfo.sectionView = pHolidayApply.SectionView;
pHolidayApplyInfo.hrView = pHolidayApply.HrView;
pHolidayApplyInfo.managerView = pHolidayApply.ManagerView;
pHolidayApplyInfo.memo = pHolidayApply.Memo;
pHolidayApplyInfo.applyDate = pHolidayApply.ApplyDate;
pHolidayApplyInfo.applyTime = pHolidayApply.ApplyTime;
pHolidayApplyInfo.applyName = pHolidayApply.ApplyName;
pHolidayApplyInfo.departName = pHolidayApply.DepartName;
pHolidayApplyInfo.state = pHolidayApply.State;
pHolidayApplyInfo.Loaded = true;
}
private void LoadFromId(int holidayApplyId)
{
if (CachedEntityCommander.IsTypeRegistered(typeof(HolidayApplyInfo)))
{
HolidayApplyInfo holidayApplyInfo=Find(GetList(), holidayApplyId);
if(holidayApplyInfo==null)
throw new AppException("未能在缓存中找到相应的键值对象");
Copy(holidayApplyInfo, this);
}
else
{ HolidayApply holidayApply=new HolidayApply( holidayApplyId);
if(holidayApply.IsNew)
throw new AppException("尚未初始化");
LoadFromDAL(this, holidayApply);
}
}
//数据持久化
internal static void SaveToDb(HolidayApplyInfo pHolidayApplyInfo, HolidayApply pHolidayApply,bool pIsNew)
{
pHolidayApply.HolidayApplyId = pHolidayApplyInfo.holidayApplyId;
pHolidayApply.Company1 = pHolidayApplyInfo.company1;
pHolidayApply.PositonName = pHolidayApplyInfo.positonName;
pHolidayApply.Company2 = pHolidayApplyInfo.company2;
pHolidayApply.Company2Name = pHolidayApplyInfo.company2Name;
pHolidayApply.HolidayTypeId = pHolidayApplyInfo.holidayTypeId;
pHolidayApply.BeginTime = pHolidayApplyInfo.beginTime;
pHolidayApply.EndTime = pHolidayApplyInfo.endTime;
pHolidayApply.TimeSum = pHolidayApplyInfo.timeSum;
pHolidayApply.Reason = pHolidayApplyInfo.reason;
pHolidayApply.SectionView = pHolidayApplyInfo.sectionView;
pHolidayApply.HrView = pHolidayApplyInfo.hrView;
pHolidayApply.ManagerView = pHolidayApplyInfo.managerView;
pHolidayApply.Memo = pHolidayApplyInfo.memo;
pHolidayApply.ApplyDate = pHolidayApplyInfo.applyDate;
pHolidayApply.ApplyTime = pHolidayApplyInfo.applyTime;
pHolidayApply.ApplyName = pHolidayApplyInfo.applyName;
pHolidayApply.DepartName = pHolidayApplyInfo.departName;
pHolidayApply.State = pHolidayApplyInfo.state;
pHolidayApply.IsNew=pIsNew;
string UserName = SubsonicHelper.GetUserName();
try
{
pHolidayApply.Save(UserName);
}
catch(Exception ex)
{
LogManager.getInstance().getLogger(typeof(HolidayApplyInfo)).Error(ex);
if(ex.Message.Contains("插入重复键"))//违反了唯一键
{
throw new AppException("此对象已经存在");//此处等待优化可以从唯一约束中直接取出提示来，如果没有的话，默认为原始的出错提示
}
throw new AppException("保存失败");
}
pHolidayApplyInfo.holidayApplyId = pHolidayApply.HolidayApplyId;
//如果缓存存在，更新缓存
if (CachedEntityCommander.IsTypeRegistered(typeof(HolidayApplyInfo)))
{
ResetCache();
}
}
//从后台获取数据
internal static void LoadFromDAL(HolidayApplyInfo pHolidayApplyInfo, HolidayApply pHolidayApply)
{
pHolidayApplyInfo.holidayApplyId = pHolidayApply.HolidayApplyId;
pHolidayApplyInfo.company1 = pHolidayApply.Company1;
pHolidayApplyInfo.positonName = pHolidayApply.PositonName;
pHolidayApplyInfo.company2 = pHolidayApply.Company2;
pHolidayApplyInfo.company2Name = pHolidayApply.Company2Name;
pHolidayApplyInfo.holidayTypeId = pHolidayApply.HolidayTypeId;
pHolidayApplyInfo.beginTime = pHolidayApply.BeginTime;
pHolidayApplyInfo.endTime = pHolidayApply.EndTime;
pHolidayApplyInfo.timeSum = pHolidayApply.TimeSum;
pHolidayApplyInfo.reason = pHolidayApply.Reason;
pHolidayApplyInfo.sectionView = pHolidayApply.SectionView;
pHolidayApplyInfo.hrView = pHolidayApply.HrView;
pHolidayApplyInfo.managerView = pHolidayApply.ManagerView;
pHolidayApplyInfo.memo = pHolidayApply.Memo;
pHolidayApplyInfo.applyDate = pHolidayApply.ApplyDate;
pHolidayApplyInfo.applyTime = pHolidayApply.ApplyTime;
pHolidayApplyInfo.applyName = pHolidayApply.ApplyName;
pHolidayApplyInfo.departName = pHolidayApply.DepartName;
pHolidayApplyInfo.state = pHolidayApply.State;
pHolidayApplyInfo.Loaded=true;
}
/// <summary>
/// 保存
/// </summary>
public override void Save()
{
if(!m_Loaded)//新增
{
HolidayApply holidayApply=new HolidayApply();
SaveToDb(this, holidayApply,true);
}
else//修改
{
HolidayApply holidayApply=new HolidayApply(holidayApplyId);
if(holidayApply.IsNew)
throw new AppException("该数据已经不存在了");
SaveToDb(this, holidayApply,false);
}
}
public static void DelHoliday(int hid)
{
HolidayApply.Delete(hid);
}