protected void btnOk_ServerClick1(object sender, EventArgs e) { XYECOM.Model.UserGradeInfo eu = new XYECOM.Model.UserGradeInfo(); XYECOM.Business.UserGrade ug = new XYECOM.Business.UserGrade(); eu.GradeName = this.txtName.Text; eu.AnnualRent = Convert.ToDecimal(this.ymoney.Text); eu.MonthlyRent = Convert.ToDecimal(this.mmoney.Text); eu.SmallIconName = this.tbsmall.Text; eu.BigIconName = tbbig.Text; string url = "UserGrade.aspx"; int UG_ID = 0; int i = ug.Insert(eu, out UG_ID); if (i >= 0) { XYECOM.Model.UserGradePopedomInfo info = new XYECOM.Model.UserGradePopedomInfo(); info.UG_ID = UG_ID; new XYECOM.Business.UserGradePopedom().Insert(info); Response.Redirect(url); } else if (i == -1) { Alert("该用户等级名已经存在,请重新输入用户等级名!", url); } else { Alert("添加失败!", url); } }
/// <summary> /// ��ȡ���ݶ��� /// </summary> /// <param name="userGradeId">�ȼ�Id</param> /// <returns>���ݶ���</returns> public XYECOM.Model.UserGradeInfo GetItem(int userGradeId) { XYECOM.Model.UserGradeInfo info = null; Object obj = GetCache(); if (obj == null) return info; DataTable table = (DataTable)obj; DataRow[] rows = table.Select("UG_ID =" + userGradeId); if (rows != null && rows.Length > 0) { info = new XYECOM.Model.UserGradeInfo(); info.GradeId = userGradeId; info.MonthlyRent = Convert.ToDecimal(rows[0]["UG_Month"].ToString()); info.GradeName = rows[0]["UG_Name"].ToString(); info.AnnualRent = Convert.ToDecimal(rows[0]["UG_Year"].ToString()); info.SmallIconName = rows[0]["UG_SmallIconName"].ToString(); info.BigIconName = rows[0]["UG_BigIconName"].ToString(); info.OrderId = Convert.ToInt32(rows[0]["UG_Order"].ToString()); } return info; }
protected void Button1_Click(object sender, EventArgs e) { XYECOM.Business.Log l = new XYECOM.Business.Log(); XYECOM.Model.LogInfo el = new XYECOM.Model.LogInfo(); XYECOM.Model.UserGradeInfo eu = new XYECOM.Model.UserGradeInfo(); XYECOM.Business.UserGrade ug = new XYECOM.Business.UserGrade(); eu.GradeId = Convert.ToInt16(this.UG_ID.Value); eu.GradeName = this.txtname1.Text; eu.MonthlyRent = Convert.ToDecimal(this.mmoney1.Text); eu.AnnualRent = Convert.ToDecimal(this.ymoney1.Text); eu.SmallIconName = this.tbsmall.Text.Trim(); eu.BigIconName = this.tbbig.Text.Trim(); int i = 0; i = ug.Update(eu); string url = "UserGrade.aspx"; if (i >= 0) { el.L_Title = "用户等级管理"; el.L_Content = "修改用户等级成功"; el.L_MF = "财务管理"; el.UM_ID = AdminId; l.Insert(el); Response.Redirect(url); this.key.Value = "2"; } else { el.L_Title = "用户等级管理"; el.L_Content = "修改用户等级失败"; el.L_MF = "财务管理"; el.UM_ID = AdminId; l.Insert(el); Alert("修改失败!", url); } }
protected void gvlist_RowCommand(object sender, GridViewCommandEventArgs e) { XYECOM.Business.UserGrade ug = new XYECOM.Business.UserGrade(); if (e.CommandName == "up") { this.key.Value = "2"; XYECOM.Model.UserGradeInfo eu = new XYECOM.Model.UserGradeInfo(); this.UG_ID.Value = gvlist.DataKeys[Convert.ToInt16(e.CommandArgument)].Value.ToString(); eu = ug.GetItem(Convert.ToInt16(gvlist.DataKeys[Convert.ToInt16(e.CommandArgument)].Value.ToString())); this.txtname1.Text = eu.GradeName.ToString(); this.ymoney1.Text = XYECOM.Core.Utils.GetMoney(eu.AnnualRent.ToString()); this.mmoney1.Text = XYECOM.Core.Utils.GetMoney(eu.MonthlyRent.ToString()); this.tbsmall.Text = eu.SmallIconName; this.tbbig.Text = eu.BigIconName; } else if (e.CommandName == "del") { if (new XYECOM.Business.UserGrade().HasSubUser(gvlist.DataKeys[Convert.ToInt16(e.CommandArgument)].Value.ToString())) { Alert("该等级下已有用户信息,故不能删除!", "UserGrade.aspx"); } else { int i = 0; XYECOM.Business.Log l = new XYECOM.Business.Log(); XYECOM.Model.LogInfo el = new XYECOM.Model.LogInfo(); i = ug.Delete(Convert.ToInt16(gvlist.DataKeys[Convert.ToInt16(e.CommandArgument)].Value.ToString())); if (i >= 0) { el.L_Title = "用户等级管理"; el.L_Content = "删除用户等级成功"; el.L_MF = "用户等级"; { el.UM_ID = AdminId; } l.Insert(el); string url = "UserGrade.aspx"; this.key.Value = "3"; Response.Redirect(url); } else { el.L_Title = "用户等级管理"; el.L_Content = "删除用户等级失败"; el.L_MF = "用户等级"; { el.UM_ID = AdminId; } l.Insert(el); string url = "UserGrade.aspx"; Alert("删除失败!", url); } } } }
/// <summary> /// /// </summary> /// <param name="gradeIds"></param> /// <returns></returns> public List<Model.UserGradeInfo> GetItems(string gradeIds) { List<Model.UserGradeInfo> infos = new List<XYECOM.Model.UserGradeInfo>(); string sql = "select * from b_UserGrade"; if (!string.IsNullOrEmpty(gradeIds)) { string tmp = XYECOM.Core.Utils.RemoveComma(gradeIds); if (!string.IsNullOrEmpty(tmp)) { sql += " where UG_ID in (" + tmp + ")"; DataTable table = XYECOM.Core.Data.SqlHelper.ExecuteTable(sql); foreach (DataRow row in table.Rows) { Model.UserGradeInfo info = new XYECOM.Model.UserGradeInfo(); info.GradeId = Convert.ToInt32(row["UG_ID"].ToString()); info.MonthlyRent = Convert.ToDecimal(row["UG_Month"].ToString()); info.GradeName = row["UG_Name"].ToString(); info.AnnualRent = Convert.ToDecimal(row["UG_Year"].ToString()); info.SmallIconName = row["UG_SmallIconName"].ToString(); info.BigIconName = row["UG_BigIconName"].ToString(); info.OrderId = Convert.ToInt32(row["UG_Order"].ToString()); infos.Add(info); } } } return infos; }
/// <summary> /// ��ȡ�����û��ȼ����� /// </summary> /// <returns></returns> public List<XYECOM.Model.UserGradeInfo> GetItems() { List<Model.UserGradeInfo> Infos = new List<XYECOM.Model.UserGradeInfo>(); Object obj = GetCache(); if (obj == null) return Infos; DataTable table = (DataTable)obj; foreach (DataRow row in table.Rows) { Model.UserGradeInfo info = new XYECOM.Model.UserGradeInfo(); info.GradeId = Convert.ToInt32(row["UG_ID"].ToString()); info.MonthlyRent = Convert.ToDecimal(row["UG_Month"].ToString()); info.GradeName = row["UG_Name"].ToString(); info.AnnualRent = Convert.ToDecimal(row["UG_Year"].ToString()); info.SmallIconName = row["UG_SmallIconName"].ToString(); info.BigIconName = row["UG_BigIconName"].ToString(); info.OrderId = Convert.ToInt32(row["UG_Order"].ToString()); Infos.Add(info); } return Infos; }