/// <summary>
/// 获得数据列表
/// </summary>
/// <returns></returns>
public static List <MainBusinessExpInfo> GetList()
{
string cacheKey = GetCacheKey();
//本实体已经注册成缓存实体，并且缓存存在的时候，直接从缓存取
if (CachedEntityCommander.IsTypeRegistered(typeof(MainBusinessExpInfo)) && CachedEntityCommander.GetCache(cacheKey) != null)
{
return(CachedEntityCommander.GetCache(cacheKey) as List <MainBusinessExpInfo>);
}
else
{
List <MainBusinessExpInfo> list = new List <MainBusinessExpInfo>();
MainBusinessExpCollection collection = new MainBusinessExpCollection();
Query qry = new Query(MainBusinessExp.Schema);
collection.LoadAndCloseReader(qry.ExecuteReader());
foreach (MainBusinessExp mainBusinessExp in collection)
{
MainBusinessExpInfo mainBusinessExpInfo = new MainBusinessExpInfo();
LoadFromDAL(mainBusinessExpInfo, mainBusinessExp);
list.Add(mainBusinessExpInfo);
}
//生成缓存
if (CachedEntityCommander.IsTypeRegistered(typeof(MainBusinessExpInfo)))
{
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 <MainBusinessExpInfo> GetPagedList(int pPageIndex, int pPageSize, SortDirection pOrderBy, string pSortExpression, out int pRecordCount)
{
if (pPageIndex <= 1)
{
pPageIndex = 1;
}
List <MainBusinessExpInfo> list = new List <MainBusinessExpInfo>();
Query q = MainBusinessExp.CreateQuery();
q.PageIndex = pPageIndex;
q.PageSize = pPageSize;
q.ORDER_BY(pSortExpression, pOrderBy.ToString());
MainBusinessExpCollection collection = new MainBusinessExpCollection();
collection.LoadAndCloseReader(q.ExecuteReader());
foreach (MainBusinessExp mainBusinessExp in collection)
{
MainBusinessExpInfo mainBusinessExpInfo = new MainBusinessExpInfo();
LoadFromDAL(mainBusinessExpInfo, mainBusinessExp);
list.Add(mainBusinessExpInfo);
}
pRecordCount = q.GetRecordCount();
return(list);
}
//数据持久化
internal static void SaveToDb(MainBusinessExpInfo pMainBusinessExpInfo, MainBusinessExp pMainBusinessExp, bool pIsNew)
{
pMainBusinessExp.MainBusinessExpId = pMainBusinessExpInfo.mainBusinessExpId;
pMainBusinessExp.MainBusinessExpName = pMainBusinessExpInfo.mainBusinessExpName;
pMainBusinessExp.IsNew = pIsNew;
string UserName = SubsonicHelper.GetUserName();
try
{
pMainBusinessExp.Save(UserName);
}
catch (Exception ex)
{
LogManager.getInstance().getLogger(typeof(MainBusinessExpInfo)).Error(ex);
if (ex.Message.Contains("插入重复键")) //违反了唯一键
{
throw new AppException("此对象已经存在"); //此处等待优化可以从唯一约束中直接取出提示来，如果没有的话，默认为原始的出错提示
}
throw new AppException("保存失败");
}
pMainBusinessExpInfo.mainBusinessExpId = pMainBusinessExp.MainBusinessExpId;
//如果缓存存在，更新缓存
if (CachedEntityCommander.IsTypeRegistered(typeof(MainBusinessExpInfo)))
{
ResetCache();
}
}
/// <summary>
/// 批量装载
/// </summary>
internal static void LoadFromDALPatch(List <MainBusinessExpInfo> pList, MainBusinessExpCollection pCollection)
{
foreach (MainBusinessExp mainBusinessExp in pCollection)
{
MainBusinessExpInfo mainBusinessExpInfo = new MainBusinessExpInfo();
LoadFromDAL(mainBusinessExpInfo, mainBusinessExp);
pList.Add(mainBusinessExpInfo);
}
}
public MainBusinessExpInfo GetMainBusinessExpInfoById(int MainBusinessExpId)
{
MainBusinessExpInfo mainBusinessExpInfo = null;//
try
{
mainBusinessExpInfo = new MainBusinessExpInfo(MainBusinessExpId);
}
catch (AppException)
{
return null;
}
return mainBusinessExpInfo;
}
public MainBusinessExpInfo GetMainBusinessExpInfoById(int MainBusinessExpId)
{
MainBusinessExpInfo mainBusinessExpInfo = null; //
try
{
mainBusinessExpInfo = new MainBusinessExpInfo(MainBusinessExpId);
}
catch (AppException)
{
return(null);
}
return(mainBusinessExpInfo);
}
private void LoadFromId(int mainBusinessExpId)
{
if (CachedEntityCommander.IsTypeRegistered(typeof(MainBusinessExpInfo)))
{
MainBusinessExpInfo mainBusinessExpInfo = Find(GetList(), mainBusinessExpId);
if (mainBusinessExpInfo == null)
{
throw new AppException("未能在缓存中找到相应的键值对象");
}
Copy(mainBusinessExpInfo, this);
}
else
{
MainBusinessExp mainBusinessExp = new MainBusinessExp(mainBusinessExpId);
if (mainBusinessExp.IsNew)
{
throw new AppException("尚未初始化");
}
LoadFromDAL(this, mainBusinessExp);
}
}
public object SaveMainBusinessExpInfo(MainBusinessExpInfo mainBusinessExpInfo)
{
mainBusinessExpInfo.Save();
return mainBusinessExpInfo . MainBusinessExpId;
}
public void DeleteById(MainBusinessExpInfo pMainBusinessExpInfo)
{
MainBusinessExpInfo mainBusinessExpInfo = new MainBusinessExpInfo(pMainBusinessExpInfo.MainBusinessExpId);
mainBusinessExpInfo.Delete();
}
//数据持久化
internal static void SaveToDb(MainBusinessExpInfo pMainBusinessExpInfo, MainBusinessExp pMainBusinessExp,bool pIsNew)
{
pMainBusinessExp.MainBusinessExpId = pMainBusinessExpInfo.mainBusinessExpId;
pMainBusinessExp.MainBusinessExpName = pMainBusinessExpInfo.mainBusinessExpName;
pMainBusinessExp.IsNew=pIsNew;
string UserName = SubsonicHelper.GetUserName();
try
{
pMainBusinessExp.Save(UserName);
}
catch(Exception ex)
{
LogManager.getInstance().getLogger(typeof(MainBusinessExpInfo)).Error(ex);
if(ex.Message.Contains("插入重复键"))//违反了唯一键
{
throw new AppException("此对象已经存在");//此处等待优化可以从唯一约束中直接取出提示来，如果没有的话，默认为原始的出错提示
}
throw new AppException("保存失败");
}
pMainBusinessExpInfo.mainBusinessExpId = pMainBusinessExp.MainBusinessExpId;
//如果缓存存在，更新缓存
if (CachedEntityCommander.IsTypeRegistered(typeof(MainBusinessExpInfo)))
{
ResetCache();
}
}
//从后台获取数据
internal static void LoadFromDAL(MainBusinessExpInfo pMainBusinessExpInfo, MainBusinessExp pMainBusinessExp)
{
pMainBusinessExpInfo.mainBusinessExpId = pMainBusinessExp.MainBusinessExpId;
pMainBusinessExpInfo.mainBusinessExpName = pMainBusinessExp.MainBusinessExpName;
pMainBusinessExpInfo.Loaded=true;
}
/// <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<MainBusinessExpInfo> GetPagedList(int pPageIndex,int pPageSize,SortDirection pOrderBy,string pSortExpression,out int pRecordCount)
{
if(pPageIndex<=1)
pPageIndex=1;
List< MainBusinessExpInfo> list = new List< MainBusinessExpInfo>();
Query q = MainBusinessExp .CreateQuery();
q.PageIndex = pPageIndex;
q.PageSize = pPageSize;
q.ORDER_BY(pSortExpression,pOrderBy.ToString());
MainBusinessExpCollection collection=new MainBusinessExpCollection();
collection.LoadAndCloseReader(q.ExecuteReader());
foreach (MainBusinessExp mainBusinessExp in collection)
{
MainBusinessExpInfo mainBusinessExpInfo = new MainBusinessExpInfo();
LoadFromDAL(mainBusinessExpInfo, mainBusinessExp);
list.Add(mainBusinessExpInfo);
}
pRecordCount=q.GetRecordCount();
return list;
}
public void DeleteById(MainBusinessExpInfo pMainBusinessExpInfo)
{
MainBusinessExpInfo mainBusinessExpInfo = new MainBusinessExpInfo(pMainBusinessExpInfo.MainBusinessExpId);
mainBusinessExpInfo.Delete();
}
/// <summary>
/// 复制为另一个对象
/// </summary>
/// <param name="pIndustryTypeInfoTo"></param>
public void CopyTo(MainBusinessExpInfo pMainBusinessExpInfoTo)
{
Copy(this, pMainBusinessExpInfoTo);
}
//从后台获取数据
internal static void LoadFromDAL(MainBusinessExpInfo pMainBusinessExpInfo, MainBusinessExp pMainBusinessExp)
{
pMainBusinessExpInfo.mainBusinessExpId = pMainBusinessExp.MainBusinessExpId;
pMainBusinessExpInfo.mainBusinessExpName = pMainBusinessExp.MainBusinessExpName;
pMainBusinessExpInfo.Loaded = true;
}
/// <summary>
/// 复制一个对象，采用硬编码的方式，避免反射的低效
/// </summary>
/// <param name="pIndustryTypeInfoFrom"></param>
/// <param name="pIndustryTypeInfoTo"></param>
public static void Copy(MainBusinessExpInfo pMainBusinessExpInfoFrom, MainBusinessExpInfo pMainBusinessExpInfoTo)
{
pMainBusinessExpInfoTo.MainBusinessExpId = pMainBusinessExpInfoFrom.mainBusinessExpId;
pMainBusinessExpInfoTo.MainBusinessExpName = pMainBusinessExpInfoFrom.mainBusinessExpName;
pMainBusinessExpInfoTo.Loaded=pMainBusinessExpInfoFrom.Loaded;
}
/// <summary>
/// 获得数据列表
/// </summary>
/// <returns></returns>
public static List<MainBusinessExpInfo> GetList()
{
string cacheKey = GetCacheKey();
//本实体已经注册成缓存实体，并且缓存存在的时候，直接从缓存取
if (CachedEntityCommander.IsTypeRegistered(typeof(MainBusinessExpInfo)) && CachedEntityCommander.GetCache(cacheKey) != null)
{
return CachedEntityCommander.GetCache(cacheKey) as List< MainBusinessExpInfo>;
}
else
{
List< MainBusinessExpInfo> list =new List< MainBusinessExpInfo>();
MainBusinessExpCollection collection=new MainBusinessExpCollection();
Query qry = new Query(MainBusinessExp.Schema);
collection.LoadAndCloseReader(qry.ExecuteReader());
foreach(MainBusinessExp mainBusinessExp in collection)
{
MainBusinessExpInfo mainBusinessExpInfo= new MainBusinessExpInfo();
LoadFromDAL(mainBusinessExpInfo,mainBusinessExp);
list.Add(mainBusinessExpInfo);
}
//生成缓存
if (CachedEntityCommander.IsTypeRegistered(typeof(MainBusinessExpInfo)))
{
CachedEntityCommander.SetCache(cacheKey, list);
}
return list;
}
}
public List <MainBusinessExpInfo> GetMainBusinessExpInfoList()
{
return(MainBusinessExpInfo.GetList());
}
/// <summary>
/// 复制为另一个对象
/// </summary>
/// <param name="pIndustryTypeInfoTo"></param>
public void CopyTo(MainBusinessExpInfo pMainBusinessExpInfoTo)
{
Copy(this, pMainBusinessExpInfoTo);
}
public List <MainBusinessExpInfo> GetPagedList(int pPageIndex, int pPageSize, SortDirection pOrderBy, string pSortExpression, out int pRecordCount)
{
return(MainBusinessExpInfo.GetPagedList(pPageIndex, pPageSize, pOrderBy, pSortExpression, out pRecordCount));
}
/// <summary>
/// 批量装载
/// </summary>
internal static void LoadFromDALPatch(List< MainBusinessExpInfo> pList, MainBusinessExpCollection pCollection)
{
foreach (MainBusinessExp mainBusinessExp in pCollection)
{
MainBusinessExpInfo mainBusinessExpInfo = new MainBusinessExpInfo();
LoadFromDAL(mainBusinessExpInfo, mainBusinessExp );
pList.Add(mainBusinessExpInfo);
}
}
public object SaveMainBusinessExpInfo(MainBusinessExpInfo mainBusinessExpInfo)
{
mainBusinessExpInfo.Save();
return(mainBusinessExpInfo.MainBusinessExpId);
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (IsPageValid())
{
try
{
EmployeeInfo em = (EmployeeInfo)Session["Employee"];
int emid = Convert.ToInt32(Session["EmployeeId"]);
MainBusinessExpInfo main = new MainBusinessExpInfo();
main.Save();
int bExpId = Convert.ToInt32(Request["BusinessExpId"].ToString());
BusinessExpInfo be = new BusinessExpInfo(bExpId);
be.MainBusinessExpId = main.MainBusinessExpId;
DateTime date = DateTime.Now;
string strtoday = DateTime.Now.ToString("yyyyMMdd").Substring(2);
be.Today = strtoday;
be.SheetNum = txtSheetNum.Text.ToString();
be.ApplyDate=Convert.ToDateTime(txtApplyDate.Text.ToString()) ;
be.ApplyPeople=lblApplyPeople.Text.ToString();
be.Depart=lblDepart.Text.ToString();
be.Memo=txtMemo.Text.ToString();
be.ReasonExp=txtReason.Text.ToString();
be.Item1 = txtItem1.Text.ToString();
be.Item2 = txtItem2.Text.ToString();
be.Item3 = txtItem3.Text.ToString();
be.Item4 = txtItem4.Text.ToString();
be.Money1 = txtMoney1.Text.ToString();
be.Money2 = txtMoney2.Text.ToString();
be.Money3 = txtMoney3.Text.ToString();
be.Money4 = txtMoney4.Text.ToString();
be.MoneySum = txtMoneySum.Text.ToString();
string strRoleName = Session["RoleName"].ToString();
if (strRoleName == "���ž���")
{
be.SendEmployeeName = em.EmployeeName;
be.SendEmployeeId = emid;
be.PreIsApply = 1;
be.PreIsOver = 1;
be.SignName = 1;
}
else
{
be.PreEmployeeId = em.EmployeeId;
be.PreEmployeeName = em.EmployeeName;
be.PreIsApply = 0;
be.PreIsOver = 0;
be.SignName = 0;
}
be.IsApply = 0;
be.IsApprove = 0;
be.IsApply1 = 0;
be.IsApply2 = 0;
be.IsOver1 = 0;
be.IsOver2 = 0;
//GridViewǶ���ж�
be.IsMain = 1;
be.IsMain1 = 1;
be.IsMain2 = 1;
be.IsMain3 = 1;
be.IsNewCreate = 0;
be.Save();
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('��ӳɹ���');</script>");
//ClearForms();
ViewState["Isbtn"] = "1";
txtSheetNum.Text = SheetNums.SheetNumOfBE("ZDFY", strtoday);
}
catch (Exception Ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "alert('���ʧ�ܣ�" + Ex.Message + "');", true);
}
}
}
/// <summary>
/// 复制一个对象，采用硬编码的方式，避免反射的低效
/// </summary>
/// <param name="pIndustryTypeInfoFrom"></param>
/// <param name="pIndustryTypeInfoTo"></param>
public static void Copy(MainBusinessExpInfo pMainBusinessExpInfoFrom, MainBusinessExpInfo pMainBusinessExpInfoTo)
{
pMainBusinessExpInfoTo.MainBusinessExpId = pMainBusinessExpInfoFrom.mainBusinessExpId;
pMainBusinessExpInfoTo.MainBusinessExpName = pMainBusinessExpInfoFrom.mainBusinessExpName;
pMainBusinessExpInfoTo.Loaded = pMainBusinessExpInfoFrom.Loaded;
}
