/// <summary>
/// 填充数据到表单文本控件,下拉框控件
/// </summary>
/// <param name="IsFill"></param>
private void FillDataToCtrl(bool IsFill)
{
this.ddlEnbled.Items.Clear();
this.ddlEnbled.Items.Add("未激活");
this.ddlEnbled.Items.Add("激活");
this.ddlEnbled.SelectedIndex = 0;
MemCardLevelDB memlevelDB;
if (IsFill)
{
MemCardLevel level = new MemCardLevel();
memlevelDB = level.FindLevel(Request.QueryString["LevelId"]);
this.txtLevelName.Text = memlevelDB.LevelName;
if (memlevelDB.Enbled == 1)
{
ddlEnbled.SelectedIndex = 1;
}
else if (memlevelDB.Enbled == 0)
{
ddlEnbled.SelectedIndex = 0;
}
}
else
{
memlevelDB = new MemCardLevelDB();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
//创建用户数据表操作类对象
MemCardLevel level = new MemCardLevel();
if (ViewState["OperateStatus"].ToString() == "AddData")
{
string txtlevelname = this.txtLevelName.Text.Trim();
int Enbled = this.ddlEnbled.SelectedIndex;
//增加用户数据
if (level.AddLevel(txtlevelname, Enbled))
{
Common.ShowMsg("添加成功！");
//记录操作员操作
RecordOperate.SaveRecord(Session["UserID"].ToString(), "会员管理", "增加会员级别;级别名称：" + txtlevelname);
}
else
{
return;
}
}
if (ViewState["OperateStatus"].ToString() == "EditData")
{
int levelid = Convert.ToInt32(Request.QueryString["LevelId"]);
string txtlevelname = this.txtLevelName.Text.Trim();
int enbled = -1;
//MemCarsLevelDB leveldb;
//leveldb = level.FindUserByCardId(Request.QueryString["CardID"]);
if (this.ddlEnbled.SelectedIndex.ToString() == "0")
{
enbled = 0;
}
else if (this.ddlEnbled.SelectedIndex.ToString() == "1")
{
enbled = 1;
}
//更新用户数据
if (level.UpdateLevel(levelid, txtlevelname, enbled))
{
Common.ShowMsg("更新成功！");
//记录操作员操作
RecordOperate.SaveRecord(Session["UserID"].ToString(), "会员管理", "更新会员级别;级别名称：" + txtlevelname);
}
else
{
return;
}
}
}
Server.Transfer("MemManager_Level.aspx");
}
/// <summary>
/// 绑定数据到DataGrid控件MyDataGrid上
/// </summary>
private void BindDataGrid()
{
//创建操作员记录数据表类实例
MemCardLevel clsLevel = new MemCardLevel();
//获取记录数据
DataTable dt = clsLevel.Bind();
DataView dv = new DataView();
dt.TableName = "Level";
if (dt != null)
{
dv.Table = dt;
dv.Sort = " LevelId DESC";
if (ViewState["Condition"] != null && ViewState["Condition"].ToString() != "")
{
dv.RowFilter = ViewState["Condition"].ToString();
}
else
{
dv = dt.DefaultView;
}
//新增ID自增值列绑定
dt.Columns.Add(new DataColumn("idno", Type.GetType("System.Int32")));
int intCountRecNum = dv.Count; //获取数据表记录数
for (int i = 0; i < intCountRecNum; i++)
{
dv[i]["idno"] = i + 1;
}
MyDataGrid.DataSource = dv;
int PageCount = 0;
if (intCountRecNum % MyDataGrid.PageSize == 0)
{
PageCount = intCountRecNum / MyDataGrid.PageSize;
}
else
{
PageCount = intCountRecNum / MyDataGrid.PageSize + 1;
}
if (PageCount != 0 && MyDataGrid.CurrentPageIndex >= PageCount)
{
MyDataGrid.CurrentPageIndex = PageCount - 1;
}
MyDataGrid.DataBind();
lblRecNum.Text = intCountRecNum.ToString(); //显示总记录数
ShowStats(); //显示页数信息
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
//创建用户数据表操作类对象
MemCardLevel level = new MemCardLevel();
string levelid = Request.QueryString["LevelId"];
//删除用户数据
if (level.DelLevel(levelid))
{
Common.ShowMsg("删除成功！");
//记录操作员操作
RecordOperate.SaveRecord(Session["UserID"].ToString(), "会员管理", "删除会员级别信息");
}
else
{
return;
}
Server.Transfer("MemManager_Level.aspx");
}
protected void MyDataGrid_ItemCommand(object source, DataGridCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
//创建会员级别数据表操作类对象
MemCardLevel level = new MemCardLevel();
string LevelId = ((Label)e.Item.Cells[1].Controls[1]).Text;
//删除会员级别数据
if (level.DelLevel(LevelId))
{
Common.ShowMsg("删除成功！");
//记录操作员操作
RecordOperate.SaveRecord(Session["UserID"].ToString(), "会员管理", "删除会员级别信息,级别ID:" + LevelId);
}
Server.Transfer("MemManager_Level.aspx");
}
else
{
string Url = "MemManager_AddLev.aspx?LevelId=" + ((Label)e.Item.Cells[1].Controls[1]).Text;
Server.Transfer(Url);
}
}
