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;
}
