/// <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 <ToolNumInfo> GetPagedList(int pPageIndex, int pPageSize, SortDirection pOrderBy, string pSortExpression, out int pRecordCount)
{
if (pPageIndex <= 1)
{
pPageIndex = 1;
}
List <ToolNumInfo> list = new List <ToolNumInfo>();
Query q = ToolNum.CreateQuery();
q.PageIndex = pPageIndex;
q.PageSize = pPageSize;
q.ORDER_BY(pSortExpression, pOrderBy.ToString());
ToolNumCollection collection = new ToolNumCollection();
collection.LoadAndCloseReader(q.ExecuteReader());
foreach (ToolNum toolNum in collection)
{
ToolNumInfo toolNumInfo = new ToolNumInfo();
LoadFromDAL(toolNumInfo, toolNum);
list.Add(toolNumInfo);
}
pRecordCount = q.GetRecordCount();
return(list);
}
/// <summary>
/// 保存
/// </summary>
public override void Save()
{
if (!m_Loaded) //新增
{
ToolNum toolNum = new ToolNum();
SaveToDb(this, toolNum, true);
}
else //修改
{
ToolNum toolNum = new ToolNum(toolNumId);
if (toolNum.IsNew)
{
throw new AppException("该数据已经不存在了");
}
SaveToDb(this, toolNum, false);
}
}
//从后台获取数据
internal static void LoadFromDAL(ToolNumInfo pToolNumInfo, ToolNum pToolNum)
{
pToolNumInfo.toolNumId = pToolNum.ToolNumId;
pToolNumInfo.num1 = pToolNum.Num1;
pToolNumInfo.num2 = pToolNum.Num2;
pToolNumInfo.num3 = pToolNum.Num3;
pToolNumInfo.num4 = pToolNum.Num4;
pToolNumInfo.num5 = pToolNum.Num5;
pToolNumInfo.num6 = pToolNum.Num6;
pToolNumInfo.num7 = pToolNum.Num7;
pToolNumInfo.num8 = pToolNum.Num8;
pToolNumInfo.num9 = pToolNum.Num9;
pToolNumInfo.num10 = pToolNum.Num10;
pToolNumInfo.num11 = pToolNum.Num11;
pToolNumInfo.num12 = pToolNum.Num12;
pToolNumInfo.num13 = pToolNum.Num13;
pToolNumInfo.num14 = pToolNum.Num14;
pToolNumInfo.num15 = pToolNum.Num15;
pToolNumInfo.num16 = pToolNum.Num16;
pToolNumInfo.num17 = pToolNum.Num17;
pToolNumInfo.num18 = pToolNum.Num18;
pToolNumInfo.num19 = pToolNum.Num19;
pToolNumInfo.num20 = pToolNum.Num20;
pToolNumInfo.num21 = pToolNum.Num21;
pToolNumInfo.num22 = pToolNum.Num22;
pToolNumInfo.num23 = pToolNum.Num23;
pToolNumInfo.num24 = pToolNum.Num24;
pToolNumInfo.num25 = pToolNum.Num25;
pToolNumInfo.num26 = pToolNum.Num26;
pToolNumInfo.num27 = pToolNum.Num27;
pToolNumInfo.num28 = pToolNum.Num28;
pToolNumInfo.num29 = pToolNum.Num29;
pToolNumInfo.num30 = pToolNum.Num30;
pToolNumInfo.num31 = pToolNum.Num31;
pToolNumInfo.num32 = pToolNum.Num32;
pToolNumInfo.num33 = pToolNum.Num33;
pToolNumInfo.num34 = pToolNum.Num34;
pToolNumInfo.num35 = pToolNum.Num35;
pToolNumInfo.num36 = pToolNum.Num36;
pToolNumInfo.num37 = pToolNum.Num37;
pToolNumInfo.num38 = pToolNum.Num38;
pToolNumInfo.num39 = pToolNum.Num39;
pToolNumInfo.num40 = pToolNum.Num40;
pToolNumInfo.Loaded = true;
}
/// <summary>
/// 删除
/// </summary>
/// <returns>是否成功</returns>
public override void Delete()
{
if (!m_Loaded)
{
throw new AppException("尚未初始化");
}
bool result = (ToolNum.Delete(ToolNumId) == 1);
//更新缓存
if (result && CachedEntityCommander.IsTypeRegistered(typeof(ToolNumInfo)))
{
ResetCache();
}
if (!result)
{
throw new AppException("删除失败，数据可能被删除");
}
}
private void LoadFromId(int toolNumId)
{
if (CachedEntityCommander.IsTypeRegistered(typeof(ToolNumInfo)))
{
ToolNumInfo toolNumInfo = Find(GetList(), toolNumId);
if (toolNumInfo == null)
{
throw new AppException("未能在缓存中找到相应的键值对象");
}
Copy(toolNumInfo, this);
}
else
{
ToolNum toolNum = new ToolNum(toolNumId);
if (toolNum.IsNew)
{
throw new AppException("尚未初始化");
}
LoadFromDAL(this, toolNum);
}
}
//数据持久化
internal static void SaveToDb(ToolNumInfo pToolNumInfo, ToolNum pToolNum, bool pIsNew)
{
pToolNum.ToolNumId = pToolNumInfo.toolNumId;
pToolNum.Num1 = pToolNumInfo.num1;
pToolNum.Num2 = pToolNumInfo.num2;
pToolNum.Num3 = pToolNumInfo.num3;
pToolNum.Num4 = pToolNumInfo.num4;
pToolNum.Num5 = pToolNumInfo.num5;
pToolNum.Num6 = pToolNumInfo.num6;
pToolNum.Num7 = pToolNumInfo.num7;
pToolNum.Num8 = pToolNumInfo.num8;
pToolNum.Num9 = pToolNumInfo.num9;
pToolNum.Num10 = pToolNumInfo.num10;
pToolNum.Num11 = pToolNumInfo.num11;
pToolNum.Num12 = pToolNumInfo.num12;
pToolNum.Num13 = pToolNumInfo.num13;
pToolNum.Num14 = pToolNumInfo.num14;
pToolNum.Num15 = pToolNumInfo.num15;
pToolNum.Num16 = pToolNumInfo.num16;
pToolNum.Num17 = pToolNumInfo.num17;
pToolNum.Num18 = pToolNumInfo.num18;
pToolNum.Num19 = pToolNumInfo.num19;
pToolNum.Num20 = pToolNumInfo.num20;
pToolNum.Num21 = pToolNumInfo.num21;
pToolNum.Num22 = pToolNumInfo.num22;
pToolNum.Num23 = pToolNumInfo.num23;
pToolNum.Num24 = pToolNumInfo.num24;
pToolNum.Num25 = pToolNumInfo.num25;
pToolNum.Num26 = pToolNumInfo.num26;
pToolNum.Num27 = pToolNumInfo.num27;
pToolNum.Num28 = pToolNumInfo.num28;
pToolNum.Num29 = pToolNumInfo.num29;
pToolNum.Num30 = pToolNumInfo.num30;
pToolNum.Num31 = pToolNumInfo.num31;
pToolNum.Num32 = pToolNumInfo.num32;
pToolNum.Num33 = pToolNumInfo.num33;
pToolNum.Num34 = pToolNumInfo.num34;
pToolNum.Num35 = pToolNumInfo.num35;
pToolNum.Num36 = pToolNumInfo.num36;
pToolNum.Num37 = pToolNumInfo.num37;
pToolNum.Num38 = pToolNumInfo.num38;
pToolNum.Num39 = pToolNumInfo.num39;
pToolNum.Num40 = pToolNumInfo.num40;
pToolNum.IsNew = pIsNew;
string UserName = SubsonicHelper.GetUserName();
try
{
pToolNum.Save(UserName);
}
catch (Exception ex)
{
LogManager.getInstance().getLogger(typeof(ToolNumInfo)).Error(ex);
if (ex.Message.Contains("插入重复键")) //违反了唯一键
{
throw new AppException("此对象已经存在"); //此处等待优化可以从唯一约束中直接取出提示来，如果没有的话，默认为原始的出错提示
}
throw new AppException("保存失败");
}
pToolNumInfo.toolNumId = pToolNum.ToolNumId;
//如果缓存存在，更新缓存
if (CachedEntityCommander.IsTypeRegistered(typeof(ToolNumInfo)))
{
ResetCache();
}
}
//数据持久化
internal static void SaveToDb(ToolNumInfo pToolNumInfo, ToolNum pToolNum,bool pIsNew)
{
pToolNum.ToolNumId = pToolNumInfo.toolNumId;
pToolNum.Num1 = pToolNumInfo.num1;
pToolNum.Num2 = pToolNumInfo.num2;
pToolNum.Num3 = pToolNumInfo.num3;
pToolNum.Num4 = pToolNumInfo.num4;
pToolNum.Num5 = pToolNumInfo.num5;
pToolNum.Num6 = pToolNumInfo.num6;
pToolNum.Num7 = pToolNumInfo.num7;
pToolNum.Num8 = pToolNumInfo.num8;
pToolNum.Num9 = pToolNumInfo.num9;
pToolNum.Num10 = pToolNumInfo.num10;
pToolNum.Num11 = pToolNumInfo.num11;
pToolNum.Num12 = pToolNumInfo.num12;
pToolNum.Num13 = pToolNumInfo.num13;
pToolNum.Num14 = pToolNumInfo.num14;
pToolNum.Num15 = pToolNumInfo.num15;
pToolNum.Num16 = pToolNumInfo.num16;
pToolNum.Num17 = pToolNumInfo.num17;
pToolNum.Num18 = pToolNumInfo.num18;
pToolNum.Num19 = pToolNumInfo.num19;
pToolNum.Num20 = pToolNumInfo.num20;
pToolNum.Num21 = pToolNumInfo.num21;
pToolNum.Num22 = pToolNumInfo.num22;
pToolNum.Num23 = pToolNumInfo.num23;
pToolNum.Num24 = pToolNumInfo.num24;
pToolNum.Num25 = pToolNumInfo.num25;
pToolNum.Num26 = pToolNumInfo.num26;
pToolNum.Num27 = pToolNumInfo.num27;
pToolNum.Num28 = pToolNumInfo.num28;
pToolNum.Num29 = pToolNumInfo.num29;
pToolNum.Num30 = pToolNumInfo.num30;
pToolNum.Num31 = pToolNumInfo.num31;
pToolNum.Num32 = pToolNumInfo.num32;
pToolNum.Num33 = pToolNumInfo.num33;
pToolNum.Num34 = pToolNumInfo.num34;
pToolNum.Num35 = pToolNumInfo.num35;
pToolNum.Num36 = pToolNumInfo.num36;
pToolNum.Num37 = pToolNumInfo.num37;
pToolNum.Num38 = pToolNumInfo.num38;
pToolNum.Num39 = pToolNumInfo.num39;
pToolNum.Num40 = pToolNumInfo.num40;
pToolNum.IsNew=pIsNew;
string UserName = SubsonicHelper.GetUserName();
try
{
pToolNum.Save(UserName);
}
catch(Exception ex)
{
LogManager.getInstance().getLogger(typeof(ToolNumInfo)).Error(ex);
if(ex.Message.Contains("插入重复键"))//违反了唯一键
{
throw new AppException("此对象已经存在");//此处等待优化可以从唯一约束中直接取出提示来，如果没有的话，默认为原始的出错提示
}
throw new AppException("保存失败");
}
pToolNumInfo.toolNumId = pToolNum.ToolNumId;
//如果缓存存在，更新缓存
if (CachedEntityCommander.IsTypeRegistered(typeof(ToolNumInfo)))
{
ResetCache();
}
}
//从后台获取数据
internal static void LoadFromDAL(ToolNumInfo pToolNumInfo, ToolNum pToolNum)
{
pToolNumInfo.toolNumId = pToolNum.ToolNumId;
pToolNumInfo.num1 = pToolNum.Num1;
pToolNumInfo.num2 = pToolNum.Num2;
pToolNumInfo.num3 = pToolNum.Num3;
pToolNumInfo.num4 = pToolNum.Num4;
pToolNumInfo.num5 = pToolNum.Num5;
pToolNumInfo.num6 = pToolNum.Num6;
pToolNumInfo.num7 = pToolNum.Num7;
pToolNumInfo.num8 = pToolNum.Num8;
pToolNumInfo.num9 = pToolNum.Num9;
pToolNumInfo.num10 = pToolNum.Num10;
pToolNumInfo.num11 = pToolNum.Num11;
pToolNumInfo.num12 = pToolNum.Num12;
pToolNumInfo.num13 = pToolNum.Num13;
pToolNumInfo.num14 = pToolNum.Num14;
pToolNumInfo.num15 = pToolNum.Num15;
pToolNumInfo.num16 = pToolNum.Num16;
pToolNumInfo.num17 = pToolNum.Num17;
pToolNumInfo.num18 = pToolNum.Num18;
pToolNumInfo.num19 = pToolNum.Num19;
pToolNumInfo.num20 = pToolNum.Num20;
pToolNumInfo.num21 = pToolNum.Num21;
pToolNumInfo.num22 = pToolNum.Num22;
pToolNumInfo.num23 = pToolNum.Num23;
pToolNumInfo.num24 = pToolNum.Num24;
pToolNumInfo.num25 = pToolNum.Num25;
pToolNumInfo.num26 = pToolNum.Num26;
pToolNumInfo.num27 = pToolNum.Num27;
pToolNumInfo.num28 = pToolNum.Num28;
pToolNumInfo.num29 = pToolNum.Num29;
pToolNumInfo.num30 = pToolNum.Num30;
pToolNumInfo.num31 = pToolNum.Num31;
pToolNumInfo.num32 = pToolNum.Num32;
pToolNumInfo.num33 = pToolNum.Num33;
pToolNumInfo.num34 = pToolNum.Num34;
pToolNumInfo.num35 = pToolNum.Num35;
pToolNumInfo.num36 = pToolNum.Num36;
pToolNumInfo.num37 = pToolNum.Num37;
pToolNumInfo.num38 = pToolNum.Num38;
pToolNumInfo.num39 = pToolNum.Num39;
pToolNumInfo.num40 = pToolNum.Num40;
pToolNumInfo.Loaded=true;
}
/// <summary>
/// 保存
/// </summary>
public override void Save()
{
if(!m_Loaded)//新增
{
ToolNum toolNum=new ToolNum();
SaveToDb(this, toolNum,true);
}
else//修改
{
ToolNum toolNum=new ToolNum(toolNumId);
if(toolNum.IsNew)
throw new AppException("该数据已经不存在了");
SaveToDb(this, toolNum,false);
}
}
private void LoadFromId(int toolNumId)
{
if (CachedEntityCommander.IsTypeRegistered(typeof(ToolNumInfo)))
{
ToolNumInfo toolNumInfo=Find(GetList(), toolNumId);
if(toolNumInfo==null)
throw new AppException("未能在缓存中找到相应的键值对象");
Copy(toolNumInfo, this);
}
else
{ ToolNum toolNum=new ToolNum( toolNumId);
if(toolNum.IsNew)
throw new AppException("尚未初始化");
LoadFromDAL(this, toolNum);
}
}
