//数据持久化 internal static void SaveToDb(StampInfo pStampInfo, Stamp pStamp, bool pIsNew) { pStamp.StampId = pStampInfo.stampId; pStamp.UseDate = pStampInfo.useDate; pStamp.StampFileTypeId = pStampInfo.stampFileTypeId; pStamp.StampTypeId = pStampInfo.stampTypeId; pStamp.Stampuse = pStampInfo.stampuse; pStamp.Memo = pStampInfo.memo; pStamp.ApplyName = pStampInfo.applyName; pStamp.DepartName = pStampInfo.departName; pStamp.State = pStampInfo.state; pStamp.ApplyTime = pStampInfo.applyTime; pStamp.IsNew = pIsNew; string UserName = SubsonicHelper.GetUserName(); try { pStamp.Save(UserName); } catch (Exception ex) { LogManager.getInstance().getLogger(typeof(StampInfo)).Error(ex); if (ex.Message.Contains("插入重复键")) //违反了唯一键 { throw new AppException("此对象已经存在"); //此处等待优化可以从唯一约束中直接取出提示来,如果没有的话,默认为原始的出错提示 } throw new AppException("保存失败"); } pStampInfo.stampId = pStamp.StampId; //如果缓存存在,更新缓存 if (CachedEntityCommander.IsTypeRegistered(typeof(StampInfo))) { ResetCache(); } }
/// <summary> /// 获得数据列表 /// </summary> /// <returns></returns> public static List <StampInfo> GetList() { string cacheKey = GetCacheKey(); //本实体已经注册成缓存实体,并且缓存存在的时候,直接从缓存取 if (CachedEntityCommander.IsTypeRegistered(typeof(StampInfo)) && CachedEntityCommander.GetCache(cacheKey) != null) { return(CachedEntityCommander.GetCache(cacheKey) as List <StampInfo>); } else { List <StampInfo> list = new List <StampInfo>(); StampCollection collection = new StampCollection(); Query qry = new Query(Stamp.Schema); collection.LoadAndCloseReader(qry.ExecuteReader()); foreach (Stamp stamp in collection) { StampInfo stampInfo = new StampInfo(); LoadFromDAL(stampInfo, stamp); list.Add(stampInfo); } //生成缓存 if (CachedEntityCommander.IsTypeRegistered(typeof(StampInfo))) { 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 <StampInfo> GetPagedList(int pPageIndex, int pPageSize, SortDirection pOrderBy, string pSortExpression, out int pRecordCount) { if (pPageIndex <= 1) { pPageIndex = 1; } List <StampInfo> list = new List <StampInfo>(); Query q = Stamp.CreateQuery(); q.PageIndex = pPageIndex; q.PageSize = pPageSize; q.ORDER_BY(pSortExpression, pOrderBy.ToString()); StampCollection collection = new StampCollection(); collection.LoadAndCloseReader(q.ExecuteReader()); foreach (Stamp stamp in collection) { StampInfo stampInfo = new StampInfo(); LoadFromDAL(stampInfo, stamp); list.Add(stampInfo); } pRecordCount = q.GetRecordCount(); return(list); }
protected void btnNo_Click(object sender, EventArgs e) { int StampId = Convert.ToInt32(((Button)sender).CommandArgument.ToString()); StampInfo stamp = new StampInfo(StampId); stamp.State = 2; stamp.Save(); gvDataBind(); }
/// <summary> /// 批量装载 /// </summary> internal static void LoadFromDALPatch(List <StampInfo> pList, StampCollection pCollection) { foreach (Stamp stamp in pCollection) { StampInfo stampInfo = new StampInfo(); LoadFromDAL(stampInfo, stamp); pList.Add(stampInfo); } }
protected void btnSubmit_Click(object sender, EventArgs e) { int StampId = Convert.ToInt32(((Button)sender).CommandArgument.ToString()); StampInfo stamp = new StampInfo(StampId); stamp.State = 4;//通过 stamp.Save(); Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('通过!');</script>"); gvDataBind(); }
protected void gvStamp_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { Label lblState = e.Row.FindControl("lblState") as Label; Button btnSubmit = e.Row.FindControl("btnSubmit") as Button; Button btnNo = e.Row.FindControl("btnNo") as Button; if (!Convert.IsDBNull(gvStamp.DataKeys[e.Row.RowIndex].Value)) { StampInfo stamp = new StampInfo(Convert.ToInt32(gvStamp.DataKeys[e.Row.RowIndex].Value)); if (stamp.State != 3) { btnSubmit.Enabled = false; btnNo.Enabled = false; } switch (stamp.State) { case 0: lblState.Text = "未提交"; break; case 1: lblState.Text = "待部门领导审批"; break; case 2: lblState.Text = "部门:修正"; break; case 3: lblState.Text = "待总经理审批"; break; case 4: lblState.Text = "通过"; break; case 5: lblState.Text = "总经理:修正"; break; default: lblState.Text = "其他状态"; break; } } //鼠标移动到每项时颜色交替效果 e.Row.Attributes.Add("onmouseover", "e=this.style.backgroundColor; this.style.backgroundColor='#c1ebff'"); e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=e"); //设置悬浮鼠标指针形状为"小手" e.Row.Attributes["style"] = "Cursor:hand"; } }
protected void gvStamp_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { Label lblState = e.Row.FindControl("lblState") as Label; Button btnSubmit = e.Row.FindControl("btnSubmit") as Button; Button btnNo = e.Row.FindControl("btnNo") as Button; if (!Convert.IsDBNull(gvStamp.DataKeys[e.Row.RowIndex].Value)) { StampInfo stamp = new StampInfo(Convert.ToInt32(gvStamp.DataKeys[e.Row.RowIndex].Value)); if (stamp.State != 1 ) { btnSubmit.Enabled = false; btnNo.Enabled = false; } switch (stamp.State) { case 0: lblState.Text = "δ�ύ"; break; case 1: lblState.Text = "�������쵼����"; break; case 2: lblState.Text = "����:����"; break; case 3: lblState.Text = "���ܾ�������"; break; case 4: lblState.Text = "ͨ��"; break; case 5: lblState.Text = "�ܾ���:����"; break; default: lblState.Text = "����״̬"; break; } } //����ƶ���ÿ��ʱ��ɫ����Ч�� e.Row.Attributes.Add("onmouseover", "e=this.style.backgroundColor; this.style.backgroundColor='#c1ebff'"); e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=e"); //�����������ָ����״Ϊ"С��" e.Row.Attributes["style"] = "Cursor:hand"; } }
/// <summary> /// 复制一个对象,采用硬编码的方式,避免反射的低效 /// </summary> /// <param name="pIndustryTypeInfoFrom"></param> /// <param name="pIndustryTypeInfoTo"></param> public static void Copy(StampInfo pStampInfoFrom, StampInfo pStampInfoTo) { pStampInfoTo.StampId = pStampInfoFrom.stampId; pStampInfoTo.UseDate = pStampInfoFrom.useDate; pStampInfoTo.StampFileTypeId = pStampInfoFrom.stampFileTypeId; pStampInfoTo.StampTypeId = pStampInfoFrom.stampTypeId; pStampInfoTo.Stampuse = pStampInfoFrom.stampuse; pStampInfoTo.Memo = pStampInfoFrom.memo; pStampInfoTo.ApplyName = pStampInfoFrom.applyName; pStampInfoTo.DepartName = pStampInfoFrom.departName; pStampInfoTo.State = pStampInfoFrom.state; pStampInfoTo.ApplyTime = pStampInfoFrom.applyTime; pStampInfoTo.Loaded = pStampInfoFrom.Loaded; }
//从后台获取数据 internal static void LoadFromDAL(StampInfo pStampInfo, Stamp pStamp) { pStampInfo.stampId = pStamp.StampId; pStampInfo.useDate = pStamp.UseDate; pStampInfo.stampFileTypeId = pStamp.StampFileTypeId; pStampInfo.stampTypeId = pStamp.StampTypeId; pStampInfo.stampuse = pStamp.Stampuse; pStampInfo.memo = pStamp.Memo; pStampInfo.applyName = pStamp.ApplyName; pStampInfo.departName = pStamp.DepartName; pStampInfo.state = pStamp.State; pStampInfo.applyTime = pStamp.ApplyTime; pStampInfo.Loaded = true; }
public StampInfo GetStampInfoById(int StampId) { StampInfo stampInfo = null; // try { stampInfo = new StampInfo(StampId); } catch (AppException) { return(null); } return(stampInfo); }
protected void btnAdd_Click(object sender, EventArgs e) { StampInfo stamp = new StampInfo(); stamp.ApplyName = Session["EmployeeName"].ToString(); stamp.DepartName = Session["DepartName"].ToString(); stamp.UseDate = DateTime.Now.ToString("yyyy-MM-dd"); stamp.StampFileTypeId = 1; stamp.StampTypeId = 1; stamp.Stampuse = ""; stamp.Memo = ""; stamp.ApplyTime = ""; stamp.State = 0; stamp.Save(); gvDataBind(); }
public StampInfo GetStampInfoById(int StampId) { StampInfo stampInfo = null;// try { stampInfo = new StampInfo(StampId); } catch (AppException) { return null; } return stampInfo; }
protected void btnSubmit_Click(object sender, EventArgs e) { int StampId = Convert.ToInt32(((Button)sender).CommandArgument.ToString()); StampInfo stamp = new StampInfo(StampId); StampFileTypeInfo filetype = new StampFileTypeInfo(Convert.ToInt32(stamp.StampFileTypeId)); if (filetype.StampFileTypeName == "��˾�ļ�") { stamp.State = 3;//���ܾ������� } else if (filetype.StampFileTypeName == "�����ļ�") { stamp.State = 4;//ͨ�� } stamp.Save(); Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('ͨ����');</script>"); gvDataBind(); }
private void LoadFromId(int stampId) { if (CachedEntityCommander.IsTypeRegistered(typeof(StampInfo))) { StampInfo stampInfo = Find(GetList(), stampId); if (stampInfo == null) { throw new AppException("未能在缓存中找到相应的键值对象"); } Copy(stampInfo, this); } else { Stamp stamp = new Stamp(stampId); if (stamp.IsNew) { throw new AppException("尚未初始化"); } LoadFromDAL(this, stamp); } }
public void DeleteById(StampInfo pStampInfo) { StampInfo stampInfo = new StampInfo(pStampInfo.StampId); stampInfo.Delete(); }
/// <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<StampInfo> GetPagedList(int pPageIndex,int pPageSize,SortDirection pOrderBy,string pSortExpression,out int pRecordCount) { if(pPageIndex<=1) pPageIndex=1; List< StampInfo> list = new List< StampInfo>(); Query q = Stamp .CreateQuery(); q.PageIndex = pPageIndex; q.PageSize = pPageSize; q.ORDER_BY(pSortExpression,pOrderBy.ToString()); StampCollection collection=new StampCollection(); collection.LoadAndCloseReader(q.ExecuteReader()); foreach (Stamp stamp in collection) { StampInfo stampInfo = new StampInfo(); LoadFromDAL(stampInfo, stamp); list.Add(stampInfo); } pRecordCount=q.GetRecordCount(); return list; }
protected void gvStamp_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { Label lblState = e.Row.FindControl("lblState") as Label; Button btnSubmit = e.Row.FindControl("btnSubmit") as Button; Button btnDelete = e.Row.FindControl("btnDelete") as Button; Button btnEdit = e.Row.FindControl("btnEdit") as Button; if (!Convert.IsDBNull(gvStamp.DataKeys[e.Row.RowIndex].Value)) { StampInfo stamp = new StampInfo(Convert.ToInt32(gvStamp.DataKeys[e.Row.RowIndex].Value)); if (stamp.State != 0) { btnSubmit.Enabled = false; btnDelete.Enabled = false; btnEdit.Enabled = false; } switch (stamp.State) { case 0: lblState.Text = "未提交"; break; case 1: lblState.Text = "待部门领导审批"; break; case 2: lblState.Text = "部门:修正"; break; case 3: lblState.Text = "待总经理审批"; break; case 4: lblState.Text = "通过"; break; case 5: lblState.Text = "总经理:修正"; break; default: lblState.Text = "其他状态"; break; } } DropDownList ddlFileType = e.Row.FindControl("ddlFileType") as DropDownList; if (ddlFileType != null) { DataTable dt = StampInfo.getStampFileTypeList(); ddlFileType.DataSource = dt; ddlFileType.DataTextField = "StampFileTypeName"; ddlFileType.DataValueField = "StampFileTypeId"; ddlFileType.DataBind(); } DropDownList ddlStampType = e.Row.FindControl("ddlStampType") as DropDownList; if (ddlStampType != null) { DataTable dt1 = StampInfo.getStampType(); ddlStampType.DataSource = dt1; ddlStampType.DataTextField = "StampName"; ddlStampType.DataValueField = "StampTypeId"; ddlStampType.DataBind(); } //鼠标移动到每项时颜色交替效果 e.Row.Attributes.Add("onmouseover", "e=this.style.backgroundColor; this.style.backgroundColor='#c1ebff'"); e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=e"); //设置悬浮鼠标指针形状为"小手" e.Row.Attributes["style"] = "Cursor:hand"; } }
/// <summary> /// 复制为另一个对象 /// </summary> /// <param name="pIndustryTypeInfoTo"></param> public void CopyTo(StampInfo pStampInfoTo) { Copy(this, pStampInfoTo); }
protected void gvStamp_RowUpdating(object sender, GridViewUpdateEventArgs e) { int StampId = Convert.ToInt32(gvStamp.DataKeys[e.RowIndex].Value); TextBox txtApplyDate = gvStamp.Rows[e.RowIndex].FindControl("txtApplyDate") as TextBox; DropDownList ddlFileType = gvStamp.Rows[e.RowIndex].FindControl("ddlFileType") as DropDownList; DropDownList ddlStampType = gvStamp.Rows[e.RowIndex].FindControl("ddlStampType") as DropDownList; TextBox txtUse = gvStamp.Rows[e.RowIndex].FindControl("txtUse") as TextBox; TextBox txtMemo = gvStamp.Rows[e.RowIndex].FindControl("txtMemo") as TextBox; try { StampInfo stamp = new StampInfo(StampId); stamp.UseDate = txtApplyDate.Text.ToString(); stamp.StampFileTypeId = Convert.ToInt32(ddlFileType.SelectedValue); stamp.StampTypeId = Convert.ToInt32(ddlStampType.SelectedValue); stamp.Stampuse = txtUse.Text.ToString(); stamp.Memo = txtMemo.Text.ToString(); stamp.Save(); gvStamp.EditIndex = -1; gvDataBind(); } catch (Exception Ex) { ClientScript.RegisterStartupScript(this.GetType(), "Save", "alert('更新失败:" + Ex.Message + "');", true); } }
//从后台获取数据 internal static void LoadFromDAL(StampInfo pStampInfo, Stamp pStamp) { pStampInfo.stampId = pStamp.StampId; pStampInfo.useDate = pStamp.UseDate; pStampInfo.stampFileTypeId = pStamp.StampFileTypeId; pStampInfo.stampTypeId = pStamp.StampTypeId; pStampInfo.stampuse = pStamp.Stampuse; pStampInfo.memo = pStamp.Memo; pStampInfo.applyName = pStamp.ApplyName; pStampInfo.departName = pStamp.DepartName; pStampInfo.state = pStamp.State; pStampInfo.applyTime = pStamp.ApplyTime; pStampInfo.Loaded=true; }
//数据持久化 internal static void SaveToDb(StampInfo pStampInfo, Stamp pStamp,bool pIsNew) { pStamp.StampId = pStampInfo.stampId; pStamp.UseDate = pStampInfo.useDate; pStamp.StampFileTypeId = pStampInfo.stampFileTypeId; pStamp.StampTypeId = pStampInfo.stampTypeId; pStamp.Stampuse = pStampInfo.stampuse; pStamp.Memo = pStampInfo.memo; pStamp.ApplyName = pStampInfo.applyName; pStamp.DepartName = pStampInfo.departName; pStamp.State = pStampInfo.state; pStamp.ApplyTime = pStampInfo.applyTime; pStamp.IsNew=pIsNew; string UserName = SubsonicHelper.GetUserName(); try { pStamp.Save(UserName); } catch(Exception ex) { LogManager.getInstance().getLogger(typeof(StampInfo)).Error(ex); if(ex.Message.Contains("插入重复键"))//违反了唯一键 { throw new AppException("此对象已经存在");//此处等待优化可以从唯一约束中直接取出提示来,如果没有的话,默认为原始的出错提示 } throw new AppException("保存失败"); } pStampInfo.stampId = pStamp.StampId; //如果缓存存在,更新缓存 if (CachedEntityCommander.IsTypeRegistered(typeof(StampInfo))) { ResetCache(); } }
/// <summary> /// 批量装载 /// </summary> internal static void LoadFromDALPatch(List< StampInfo> pList, StampCollection pCollection) { foreach (Stamp stamp in pCollection) { StampInfo stampInfo = new StampInfo(); LoadFromDAL(stampInfo, stamp ); pList.Add(stampInfo); } }
public List <StampInfo> GetStampInfoList() { return(StampInfo.GetList()); }
public List <StampInfo> GetPagedList(int pPageIndex, int pPageSize, SortDirection pOrderBy, string pSortExpression, out int pRecordCount) { return(StampInfo.GetPagedList(pPageIndex, pPageSize, pOrderBy, pSortExpression, out pRecordCount)); }
public object SaveStampInfo(StampInfo stampInfo) { stampInfo.Save(); return(stampInfo.StampId); }
/// <summary> /// 获得数据列表 /// </summary> /// <returns></returns> public static List<StampInfo> GetList() { string cacheKey = GetCacheKey(); //本实体已经注册成缓存实体,并且缓存存在的时候,直接从缓存取 if (CachedEntityCommander.IsTypeRegistered(typeof(StampInfo)) && CachedEntityCommander.GetCache(cacheKey) != null) { return CachedEntityCommander.GetCache(cacheKey) as List< StampInfo>; } else { List< StampInfo> list =new List< StampInfo>(); StampCollection collection=new StampCollection(); Query qry = new Query(Stamp.Schema); collection.LoadAndCloseReader(qry.ExecuteReader()); foreach(Stamp stamp in collection) { StampInfo stampInfo= new StampInfo(); LoadFromDAL(stampInfo,stamp); list.Add(stampInfo); } //生成缓存 if (CachedEntityCommander.IsTypeRegistered(typeof(StampInfo))) { CachedEntityCommander.SetCache(cacheKey, list); } return list; } }
public object SaveStampInfo(StampInfo stampInfo) { stampInfo.Save(); return stampInfo . StampId; }
/// <summary> /// 复制一个对象,采用硬编码的方式,避免反射的低效 /// </summary> /// <param name="pIndustryTypeInfoFrom"></param> /// <param name="pIndustryTypeInfoTo"></param> public static void Copy(StampInfo pStampInfoFrom, StampInfo pStampInfoTo) { pStampInfoTo.StampId = pStampInfoFrom.stampId; pStampInfoTo.UseDate = pStampInfoFrom.useDate; pStampInfoTo.StampFileTypeId = pStampInfoFrom.stampFileTypeId; pStampInfoTo.StampTypeId = pStampInfoFrom.stampTypeId; pStampInfoTo.Stampuse = pStampInfoFrom.stampuse; pStampInfoTo.Memo = pStampInfoFrom.memo; pStampInfoTo.ApplyName = pStampInfoFrom.applyName; pStampInfoTo.DepartName = pStampInfoFrom.departName; pStampInfoTo.State = pStampInfoFrom.state; pStampInfoTo.ApplyTime = pStampInfoFrom.applyTime; pStampInfoTo.Loaded=pStampInfoFrom.Loaded; }