/// <summary>
/// 绑定数据到DataGrid控件MyDataGrid上
/// </summary>
private void BindDataGrid()
{
GroupAuthorization clsRight = new GroupAuthorization(); //创建用户组权限数据表操作类实例
DataTable dt = clsRight.GetGroName(); //获取绑定数据的数据集对象
if (dt != null)
{
int intCountRecNum = dt.Rows.Count; //获取数据表记录数
MyDataGrid.DataSource = dt.DefaultView;
MyDataGrid.DataBind();
lblRecNum.Text = intCountRecNum.ToString(); //显示总记录数
ShowStats(); //显示页数信息
}
}
/// <summary>
/// 填充数据到表单文本控件,下拉框控件
/// </summary>
/// <param name="IsFill"></param>
private void FillDataToCtrl(bool IsFill)
{
UserAuthorizationDB clsUserDB; //创建用户权限表类对象
GroupAuthorization clsGroupUser = new GroupAuthorization(); //创建用户组权限表操作类对象
DataTable dt = clsGroupUser.GetGroName();
//DataRow dr = dt.NewRow();
//dr["GroupID"] = "";
//dr["GroupName"] = "--请选择--";
//dt.Rows.Add(dr);
this.ddlGroupID.DataTextField = "GroupName";
this.ddlGroupID.DataValueField = "GroupID";
this.ddlGroupID.DataSource = dt.DefaultView;
this.ddlGroupID.DataBind();
string strSql = "select userid,username from Sys_User";
DBManager db = DBManager.Instance();
DataTable dt1 = db.GetDataTable(strSql);
DataRow df = dt1.NewRow();
df["UserName"] = "******";
df["UserId"] = "0";
dt1.Rows.InsertAt(df, 0);
ddlFather.DataSource = dt1;
ddlFather.DataTextField = "UserName";
ddlFather.DataValueField = "UserId";
ddlFather.DataBind();
this.ddlSex.Items.Clear();
//this.ddlSex.Items.Add("---请选择---");
this.ddlSex.Items.Add("男");
this.ddlSex.Items.Add("女");
this.ddlSex.SelectedIndex = 0;
this.ddlStatus.Items.Clear();
this.ddlStatus.Items.Add("禁用");
this.ddlStatus.Items.Add("激活");
this.ddlStatus.SelectedIndex = 0;
if (IsFill)
{
OperatorAuthorization clsUser = new OperatorAuthorization();
clsUserDB = clsUser.FindUser((string)ViewState["UserID"]);
this.txtUserID.Text = ViewState["UserID"].ToString();
this.txtUserID.Enabled = false;
txtPassword.Text = Common.CCToEmpty(clsUserDB.Pwd);
txtUserName.Text = Common.CCToEmpty(clsUserDB.UserName);
txtAge.Text = Common.CCToEmpty(clsUserDB.Age);
txtBirthday.Text = Common.CCToEmpty(clsUserDB.Birthday);
txtJob.Text = Common.CCToEmpty(clsUserDB.Job);
txtMobile.Text = Common.CCToEmpty(clsUserDB.Mobile);
txtAddr.Text = Common.CCToEmpty(clsUserDB.Addr);
txtTel.Text = Common.CCToEmpty(clsUserDB.Tel);
if (clsUserDB.Sex.Trim() == "男")
{
ddlSex.SelectedIndex = 0;
}
else if (clsUserDB.Sex.Trim() == "女")
{
ddlSex.SelectedIndex = 1;
}
if (clsUserDB.Status.ToString() == "0")
{
ddlStatus.SelectedIndex = 0;
}
else if (clsUserDB.Status.ToString() == "1")
{
ddlStatus.SelectedIndex = 1;
}
for (int i = 0; i < ddlGroupID.Items.Count; i++)
{
if (this.ddlGroupID.Items[i].Value == clsUserDB.GroupID)
{
ddlGroupID.SelectedIndex = i;
break;
}
}
for (int i = 0; i < ddlFather.Items.Count; i++)
{
if (this.ddlFather.Items[i].Value == clsUserDB.Father)
{
ddlFather.SelectedIndex = i;
break;
}
}
}
else
{
clsUserDB = new UserAuthorizationDB();
this.txtUserID.Text = "";
this.txtUserID.Enabled = true;
}
}