/// <summary>
/// 获得数据列表
/// </summary>
/// <returns></returns>
public static List <DayInfo> GetList()
{
string cacheKey = GetCacheKey();
//本实体已经注册成缓存实体，并且缓存存在的时候，直接从缓存取
if (CachedEntityCommander.IsTypeRegistered(typeof(DayInfo)) && CachedEntityCommander.GetCache(cacheKey) != null)
{
return(CachedEntityCommander.GetCache(cacheKey) as List <DayInfo>);
}
else
{
List <DayInfo> list = new List <DayInfo>();
DayCollection collection = new DayCollection();
Query qry = new Query(Day.Schema);
collection.LoadAndCloseReader(qry.ExecuteReader());
foreach (Day day in collection)
{
DayInfo dayInfo = new DayInfo();
LoadFromDAL(dayInfo, day);
list.Add(dayInfo);
}
//生成缓存
if (CachedEntityCommander.IsTypeRegistered(typeof(DayInfo)))
{
CachedEntityCommander.SetCache(cacheKey, list);
}
return(list);
}
}
//数据持久化
internal static void SaveToDb(DayInfo pDayInfo, Day pDay, bool pIsNew)
{
pDay.DayId = pDayInfo.dayId;
pDay.WeekId = pDayInfo.weekId;
pDay.WorkContent = pDayInfo.workContent;
pDay.WorkDate = pDayInfo.workDate;
pDay.Result = pDayInfo.result;
pDay.WeekSumId = pDayInfo.weekSumId;
pDay.IsNew = pIsNew;
string UserName = SubsonicHelper.GetUserName();
try
{
pDay.Save(UserName);
}
catch (Exception ex)
{
LogManager.getInstance().getLogger(typeof(DayInfo)).Error(ex);
if (ex.Message.Contains("插入重复键")) //违反了唯一键
{
throw new AppException("此对象已经存在"); //此处等待优化可以从唯一约束中直接取出提示来，如果没有的话，默认为原始的出错提示
}
throw new AppException("保存失败");
}
pDayInfo.dayId = pDay.DayId;
//如果缓存存在，更新缓存
if (CachedEntityCommander.IsTypeRegistered(typeof(DayInfo)))
{
ResetCache();
}
}
/// <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 <DayInfo> GetPagedList(int pPageIndex, int pPageSize, SortDirection pOrderBy, string pSortExpression, out int pRecordCount)
{
if (pPageIndex <= 1)
{
pPageIndex = 1;
}
List <DayInfo> list = new List <DayInfo>();
Query q = Day.CreateQuery();
q.PageIndex = pPageIndex;
q.PageSize = pPageSize;
q.ORDER_BY(pSortExpression, pOrderBy.ToString());
DayCollection collection = new DayCollection();
collection.LoadAndCloseReader(q.ExecuteReader());
foreach (Day day in collection)
{
DayInfo dayInfo = new DayInfo();
LoadFromDAL(dayInfo, day);
list.Add(dayInfo);
}
pRecordCount = q.GetRecordCount();
return(list);
}
/// <summary>
/// 批量装载
/// </summary>
internal static void LoadFromDALPatch(List <DayInfo> pList, DayCollection pCollection)
{
foreach (Day day in pCollection)
{
DayInfo dayInfo = new DayInfo();
LoadFromDAL(dayInfo, day);
pList.Add(dayInfo);
}
}
//从后台获取数据
internal static void LoadFromDAL(DayInfo pDayInfo, Day pDay)
{
pDayInfo.dayId = pDay.DayId;
pDayInfo.weekId = pDay.WeekId;
pDayInfo.workContent = pDay.WorkContent;
pDayInfo.workDate = pDay.WorkDate;
pDayInfo.result = pDay.Result;
pDayInfo.weekSumId = pDay.WeekSumId;
pDayInfo.Loaded = true;
}
/// <summary>
/// 复制一个对象，采用硬编码的方式，避免反射的低效
/// </summary>
/// <param name="pIndustryTypeInfoFrom"></param>
/// <param name="pIndustryTypeInfoTo"></param>
public static void Copy(DayInfo pDayInfoFrom, DayInfo pDayInfoTo)
{
pDayInfoTo.DayId = pDayInfoFrom.dayId;
pDayInfoTo.WeekId = pDayInfoFrom.weekId;
pDayInfoTo.WorkContent = pDayInfoFrom.workContent;
pDayInfoTo.WorkDate = pDayInfoFrom.workDate;
pDayInfoTo.Result = pDayInfoFrom.result;
pDayInfoTo.WeekSumId = pDayInfoFrom.weekSumId;
pDayInfoTo.Loaded = pDayInfoFrom.Loaded;
}
public DayInfo GetDayInfoById(int DayId)
{
DayInfo dayInfo = null; //
try
{
dayInfo = new DayInfo(DayId);
}
catch (AppException)
{
return(null);
}
return(dayInfo);
}
public DayInfo GetDayInfoById(int DayId)
{
DayInfo dayInfo = null;//
try
{
dayInfo = new DayInfo(DayId);
}
catch (AppException)
{
return null;
}
return dayInfo;
}
private void LoadFromId(int dayId)
{
if (CachedEntityCommander.IsTypeRegistered(typeof(DayInfo)))
{
DayInfo dayInfo = Find(GetList(), dayId);
if (dayInfo == null)
{
throw new AppException("未能在缓存中找到相应的键值对象");
}
Copy(dayInfo, this);
}
else
{
Day day = new Day(dayId);
if (day.IsNew)
{
throw new AppException("尚未初始化");
}
LoadFromDAL(this, day);
}
}
protected void btnAddDay_Click(object sender, EventArgs e)
{
int wksumid = Convert.ToInt32(Request["sumId"].ToString());
DayInfo day = new DayInfo();
day.WeekSumId = wksumid;
day.WorkDate = Convert.ToDateTime(txtDate.Text.ToString());
day.WorkContent = txtWorkContent.Text.ToString();
day.Result = txtResult.Text.ToString();
if (ddlWeek.SelectedValue == "")
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('��ѡ������');</script>");
}
else
{
day.WeekId = Convert.ToInt32(ddlWeek.SelectedValue);
day.Save();
gvwBind();
}
}
/// <summary>
/// 批量装载
/// </summary>
internal static void LoadFromDALPatch(List< DayInfo> pList, DayCollection pCollection)
{
foreach (Day day in pCollection)
{
DayInfo dayInfo = new DayInfo();
LoadFromDAL(dayInfo, day );
pList.Add(dayInfo);
}
}
public List <DayInfo> GetDayInfoList()
{
return(DayInfo.GetList());
}
protected void gvwDay_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
if (Page.IsValid)
{
int dayid = Convert.ToInt32(gvwDay.DataKeys[e.RowIndex].Value);
DropDownList ddlwk = gvwDay.Rows[e.RowIndex].FindControl("ddlWeek") as DropDownList;
TextBox txtwd = gvwDay.Rows[e.RowIndex].FindControl("txtDate") as TextBox;
TextBox txtwc = gvwDay.Rows[e.RowIndex].FindControl("txtWorkContent") as TextBox;
TextBox txtrs = gvwDay.Rows[e.RowIndex].FindControl("txtResult") as TextBox;
try
{
DayInfo day = new DayInfo(dayid);
day.WeekId = Convert.ToInt32(ddlwk.SelectedValue.ToString());
day.WorkDate = DateTime.Parse(txtwd.Text.Trim());
day.WorkContent = txtwc.Text.ToString();
day.Result = txtrs.Text.ToString();
day.Save();
gvwDay.EditIndex = -1;
gvwBind();
}
catch (Exception Ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "alert('����ʧ�ܣ�" + Ex.Message + "');", true);
}
}
}
public object SaveDayInfo(DayInfo dayInfo)
{
dayInfo.Save();
return dayInfo . DayId;
}
public object SaveDayInfo(DayInfo dayInfo)
{
dayInfo.Save();
return(dayInfo.DayId);
}
public List <DayInfo> GetPagedList(int pPageIndex, int pPageSize, SortDirection pOrderBy, string pSortExpression, out int pRecordCount)
{
return(DayInfo.GetPagedList(pPageIndex, pPageSize, pOrderBy, pSortExpression, out pRecordCount));
}
//从后台获取数据
internal static void LoadFromDAL(DayInfo pDayInfo, Day pDay)
{
pDayInfo.dayId = pDay.DayId;
pDayInfo.weekId = pDay.WeekId;
pDayInfo.workContent = pDay.WorkContent;
pDayInfo.workDate = pDay.WorkDate;
pDayInfo.result = pDay.Result;
pDayInfo.weekSumId = pDay.WeekSumId;
pDayInfo.Loaded=true;
}
/// <summary>
/// 复制为另一个对象
/// </summary>
/// <param name="pIndustryTypeInfoTo"></param>
public void CopyTo(DayInfo pDayInfoTo)
{
Copy(this, pDayInfoTo);
}
/// <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<DayInfo> GetPagedList(int pPageIndex,int pPageSize,SortDirection pOrderBy,string pSortExpression,out int pRecordCount)
{
if(pPageIndex<=1)
pPageIndex=1;
List< DayInfo> list = new List< DayInfo>();
Query q = Day .CreateQuery();
q.PageIndex = pPageIndex;
q.PageSize = pPageSize;
q.ORDER_BY(pSortExpression,pOrderBy.ToString());
DayCollection collection=new DayCollection();
collection.LoadAndCloseReader(q.ExecuteReader());
foreach (Day day in collection)
{
DayInfo dayInfo = new DayInfo();
LoadFromDAL(dayInfo, day);
list.Add(dayInfo);
}
pRecordCount=q.GetRecordCount();
return list;
}
/// <summary>
/// 获得数据列表
/// </summary>
/// <returns></returns>
public static List<DayInfo> GetList()
{
string cacheKey = GetCacheKey();
//本实体已经注册成缓存实体，并且缓存存在的时候，直接从缓存取
if (CachedEntityCommander.IsTypeRegistered(typeof(DayInfo)) && CachedEntityCommander.GetCache(cacheKey) != null)
{
return CachedEntityCommander.GetCache(cacheKey) as List< DayInfo>;
}
else
{
List< DayInfo> list =new List< DayInfo>();
DayCollection collection=new DayCollection();
Query qry = new Query(Day.Schema);
collection.LoadAndCloseReader(qry.ExecuteReader());
foreach(Day day in collection)
{
DayInfo dayInfo= new DayInfo();
LoadFromDAL(dayInfo,day);
list.Add(dayInfo);
}
//生成缓存
if (CachedEntityCommander.IsTypeRegistered(typeof(DayInfo)))
{
CachedEntityCommander.SetCache(cacheKey, list);
}
return list;
}
}
/// <summary>
/// 复制一个对象，采用硬编码的方式，避免反射的低效
/// </summary>
/// <param name="pIndustryTypeInfoFrom"></param>
/// <param name="pIndustryTypeInfoTo"></param>
public static void Copy(DayInfo pDayInfoFrom, DayInfo pDayInfoTo)
{
pDayInfoTo.DayId = pDayInfoFrom.dayId;
pDayInfoTo.WeekId = pDayInfoFrom.weekId;
pDayInfoTo.WorkContent = pDayInfoFrom.workContent;
pDayInfoTo.WorkDate = pDayInfoFrom.workDate;
pDayInfoTo.Result = pDayInfoFrom.result;
pDayInfoTo.WeekSumId = pDayInfoFrom.weekSumId;
pDayInfoTo.Loaded=pDayInfoFrom.Loaded;
}
//数据持久化
internal static void SaveToDb(DayInfo pDayInfo, Day pDay,bool pIsNew)
{
pDay.DayId = pDayInfo.dayId;
pDay.WeekId = pDayInfo.weekId;
pDay.WorkContent = pDayInfo.workContent;
pDay.WorkDate = pDayInfo.workDate;
pDay.Result = pDayInfo.result;
pDay.WeekSumId = pDayInfo.weekSumId;
pDay.IsNew=pIsNew;
string UserName = SubsonicHelper.GetUserName();
try
{
pDay.Save(UserName);
}
catch(Exception ex)
{
LogManager.getInstance().getLogger(typeof(DayInfo)).Error(ex);
if(ex.Message.Contains("插入重复键"))//违反了唯一键
{
throw new AppException("此对象已经存在");//此处等待优化可以从唯一约束中直接取出提示来，如果没有的话，默认为原始的出错提示
}
throw new AppException("保存失败");
}
pDayInfo.dayId = pDay.DayId;
//如果缓存存在，更新缓存
if (CachedEntityCommander.IsTypeRegistered(typeof(DayInfo)))
{
ResetCache();
}
}
public void DeleteById(DayInfo pDayInfo)
{
DayInfo dayInfo = new DayInfo(pDayInfo.DayId);
dayInfo.Delete();
}
/// <summary>
/// 复制为另一个对象
/// </summary>
/// <param name="pIndustryTypeInfoTo"></param>
public void CopyTo(DayInfo pDayInfoTo)
{
Copy(this, pDayInfoTo);
}
public void DeleteById(DayInfo pDayInfo)
{
DayInfo dayInfo = new DayInfo(pDayInfo.DayId);
dayInfo.Delete();
}
