/// <summary>
/// 初始化下拉列表的值
/// </summary>
protected void ShowDDLInfo()
{
try
{
//初始化下拉列表
//部门下拉列表
DataTable dt1 = new DataTable();
string sql1 = " SELECT ID,NAME FROM USER_Groups WHERE (TAGS = '部门') AND (DELFLAG = 0) GROUP BY ID,NAME ";
dt1 = pageControl.doSql(sql1).Tables[0];
CheckBox_DEPARTMENT.DataSource = dt1;
CheckBox_DEPARTMENT.DataTextField = "NAME";
CheckBox_DEPARTMENT.DataValueField = "ID";
CheckBox_DEPARTMENT.DataBind();
//for (int i = 0; i < dt1.Rows.Count; i++)
//{
// string DepartName = dt1.Rows[i]["NAME"].ToString();
// string ID = dt1.Rows[i]["ID"].ToString();
// ListItem li = new ListItem(DepartName, ID);
// DDL_DEPARTMENT.Items.Add(li);
//}
//岗位下拉列表
DataTable dt2 = new DataTable();
string sql2 = " SELECT ID,NAME FROM USER_Groups WHERE (TAGS = '岗位') AND (DELFLAG = 0) GROUP BY ID,NAME ";
dt2 = pageControl.doSql(sql2).Tables[0];
for (int k = 0; k < dt2.Rows.Count; k++)
{
string Station = dt2.Rows[k]["NAME"].ToString();
string ID = dt2.Rows[k]["ID"].ToString();
ListItem li = new ListItem(Station, ID);
DDL_Station.Items.Add(li);
}
//状态
DataTable dt3 = new DataTable();
string sql3 = " SELECT ID, WorkStataName FROM USER_WorkStats_Base WHERE (DELFLAG = '0') ";
dt3 = pageControl.doSql(sql3).Tables[0];
for (int j = 0; j < dt3.Rows.Count; j++)
{
string WorkStats = dt3.Rows[j]["WorkStataName"].ToString();
string ID = dt3.Rows[j]["ID"].ToString();
ListItem li = new ListItem(WorkStats, ID);
DDL_WorkStats.Items.Add(li);
}
//学历
DataTable dt4 = new DataTable();
string sql4 = " SELECT ID, EducationLevel FROM USER_EducationLevel_Base ";
dt4 = pageControl.doSql(sql4).Tables[0];
for (int t = 0; t < dt4.Rows.Count; t++)
{
string EducationLevel = dt4.Rows[t]["EducationLevel"].ToString();
string ID = dt4.Rows[t]["ID"].ToString();
ListItem li = new ListItem(EducationLevel, ID);
DDL_EducationLevel.Items.Add(li);
}
}
catch
{
}
}
protected void ShowUsersInfo(string id)
{
try
{
//获取到人员的详细信息
users_Model = users_Bll.GetModel(id);
//姓名
TB_Name.Text = check(users_Model.REALNAME);
//联系电话
TB_TEL.Text = check(users_Model.TEL);
//移动电话
TextBox_TEMP1.Text = check(users_Model.TEMP1);
//邮箱
TB_EMAIL.Text = check(users_Model.EMAIL);
//入职时间
TB_DatesEmployed.Value = check2(users_Model.DatesEmployed);
//离职时间
TB_LeaveDates.Value = check2(users_Model.LeaveDates);
//生日
TB_BIRTHDAY.Value = check2(users_Model.BIRTHDAY);
//籍贯
TB_NativePlace.Text = check(users_Model.NativePlace);
//住址
TB_ADDRESS.Text = check(users_Model.ADDRESS);
//毕业学校
TB_GraduateSchool.Text = check(users_Model.GraduateSchool);
//专业
TB_Major.Text = check(users_Model.Major);
//工作履历
TB_TrackRecord.Text = check(users_Model.TrackRecord);
//初始化下拉列表
//部门下拉列表
DataTable dt1 = new DataTable();
string sql1 = " SELECT ID,NAME FROM USER_Groups WHERE (TAGS = '部门') AND (DELFLAG = 0) GROUP BY ID,NAME ";
dt1 = pageControl.doSql(sql1).Tables[0];
CheckBox_DEPARTMENT.DataSource = dt1;
CheckBox_DEPARTMENT.DataTextField = "NAME";
CheckBox_DEPARTMENT.DataValueField = "ID";
CheckBox_DEPARTMENT.DataBind();
//获取部门信息
string[] Depart = users_Model.DepartMentID.Split(',');
//将部门信息导出部门选项中
foreach (ListItem item in CheckBox_DEPARTMENT.Items)
{
for (int i = 0; i < Depart.Length; i++)
{
if (Depart[i] == item.Value)
{
item.Selected = true;
}
}
}
//for (int i = 0; i < dt1.Rows.Count; i++)
//{
// string DepartName = dt1.Rows[i]["NAME"].ToString();
// string ID = dt1.Rows[i]["ID"].ToString();
// ListItem li = new ListItem(DepartName, ID);
// DDL_DEPARTMENT.Items.Add(li);
// if (ID.Equals(users_Model.DepartMentID))
// {
// li.Selected = true;
// }
//}
//岗位下拉列表
DataTable dt2 = new DataTable();
string sql2 = " SELECT ID,NAME FROM USER_Groups WHERE (TAGS = '岗位') AND (DELFLAG = 0) GROUP BY ID,NAME ";
dt2 = pageControl.doSql(sql2).Tables[0];
for (int k = 0; k < dt2.Rows.Count; k++)
{
string Station = dt2.Rows[k]["NAME"].ToString();
string ID = dt2.Rows[k]["ID"].ToString();
ListItem li = new ListItem(Station, ID);
DDL_Station.Items.Add(li);
if (ID.Equals(users_Model.StationID))
{
li.Selected = true;
}
}
//状态
DataTable dt3 = new DataTable();
string sql3 = " SELECT ID, WorkStataName FROM USER_WorkStats_Base WHERE (DELFLAG = '0') ";
dt3 = pageControl.doSql(sql3).Tables[0];
for (int j = 0; j < dt3.Rows.Count; j++)
{
string WorkStats = dt3.Rows[j]["WorkStataName"].ToString();
string ID = dt3.Rows[j]["ID"].ToString();
ListItem li = new ListItem(WorkStats, ID);
DDL_WorkStats.Items.Add(li);
if (ID.Equals(users_Model.WorkStats))
{
li.Selected = true;
}
}
//性别
for (int i = 0; i < RadioButtonList_SEX.Items.Count; i++)
{
if (RadioButtonList_SEX.Items[i].Value.Equals(users_Model.SEX))
{
RadioButtonList_SEX.Items[i].Selected = true;
}
}
//是否为项目经理
RadioButtonList_IsManager.SelectedValue = users_Model.IsManager.ToString();
//学历
DataTable dt4 = new DataTable();
string sql4 = " SELECT ID, EducationLevel FROM USER_EducationLevel_Base ";
dt4 = pageControl.doSql(sql4).Tables[0];
for (int t = 0; t < dt4.Rows.Count; t++)
{
string EducationLevel = dt4.Rows[t]["EducationLevel"].ToString();
string ID = dt4.Rows[t]["ID"].ToString();
ListItem li = new ListItem(EducationLevel, ID);
DDL_EducationLevel.Items.Add(li);
if (ID.Equals(users_Model.EducationLevel))
{
li.Selected = true;
}
}
}
catch
{
Response.Write("<script>alert('出错！')</script>");
}
}
