/// <summary>
/// 根据用户的ID，显示用户的基本信息
/// </summary>
/// <param name="userid"></param>
private void showUserinfo(string userid)
{
try
{
users_model = users_bll.GetModel(userid);
if (users_model != null)
{
HiddenField_userid.Value = userid;
Label_userinfo.Text = users_model.REALNAME.ToString() + "(" + users_model.USERNAME.ToString() + ")";
showGroups(users_model.GROUPS.ToString());
}
}
catch
{
}
}
/// <summary>
/// 返回指定ID用户的在开始时间和结束时间范围内的项目任务
/// </summary>
/// <param name="userId"></param>
/// <param name="startDay"></param>
/// <param name="endData"></param>
/// <returns></returns>
private string getProject_Plan(string userId, DateTime startDay)
{
string couw = "";
try
{
userModel = usersBll.GetModel(userId);
if (userModel != null)
{
string sql = "select * from vProject_Task where Pro_DELFLAG='0' and Pro_Status=1 and '" + startDay.ToString("yyyy-MM-dd") + "' BETWEEN CAST(CONVERT(varchar(10), StartTime, 120) + ' 00:00:00' AS datetime) AND CAST(CONVERT(varchar(10), endTime, 120) + ' 23:59:59' AS datetime) and delflag = '0' and Status <> 2 and userInfo Like '%" + userModel.REALNAME.ToString() + "(" + userModel.USERNAME.ToString() + ")" + "%' order by StartTime asc";
DataTable dt = dosql.doSql(sql).Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
couw = "<task>";
for (int i = 0; i < dt.Rows.Count; i++)
{
couw = couw + "<info startTime=\"" + DateTime.Parse(dt.Rows[i]["StartTime"].ToString()).ToString("yyyy-MM-dd HH:mm:ss") + "\" endTime=\"" + DateTime.Parse(dt.Rows[i]["endTime"].ToString()).ToString("yyyy-MM-dd HH:mm:ss") + "\" url=\"/Admin/personalProjectManage/OAtask/manage.aspx?ID=" + dt.Rows[i]["ProjectID"].ToString() + "\" status=\"" + dt.Rows[i]["Status"].ToString() + "\">" + dt.Rows[i]["NAMES"].ToString() + "</info>";
}
couw = couw + "</task>";
}
}
}
catch
{
}
return(couw);
}
/// <summary>
/// 点击删除按钮触发的事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button_delete_onclick(object sender, EventArgs e)
{
int num = 0;
int rows = GridView1.Rows.Count;
if (rows > 0)
{
for (int i = 0; i < rows; i++)
{
CheckBox cb = (CheckBox)GridView1.Rows[i].Cells[0].FindControl("CheckBox_choose");
if (cb.Checked)
{
num = num + 1;
}
}
if (num == 0)
{
tag.Text = "删除时最少选择一条数据！";
}
else
{
tag.Text = "";
for (int j = 0; j < rows; j++)
{
CheckBox cb1 = (CheckBox)GridView1.Rows[j].Cells[0].FindControl("CheckBox_choose");
HiddenField hid = (HiddenField)GridView1.Rows[j].Cells[0].FindControl("Hid_ID");
if (cb1.Checked)
{
//获取到当前人员的基本信息
users_model = users_bll.GetModel(hid.Value.ToString());
//将删除标记设为1
users_model.DELFLAG = 1;
users_bll.Update(users_model);
//TODO: new ajax().UpdateUserRemoteInfoWithJAVAWebService(users_model, EnumRemoteOperation.Edit);
//添加操作日志
Dianda.BLL.SYS_LogsExt bsyslog = new Dianda.BLL.SYS_LogsExt();
Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"];
bsyslog.addlogs(user_model.REALNAME + "(" + user_model.USERNAME + ")", "删除人员信息", "删除" + users_model.REALNAME + "(" + user_model.USERNAME + ")" + "成功");
//添加操作日志
}
}
//tag.Text = "操作成功！";
// string coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"操作成功！现在进入列表页面\"); location.href = \"manage.aspx?pageindex=" + Request["pageindex"] + "&depart=" + DDL_Depart.SelectedValue.ToString() + "&workstatus=" + DDL_Status.SelectedValue.ToString() + "\";</script>";
// Response.Write(coutws);
ScriptManager.RegisterStartupScript(this, this.GetType(), "ok", "<script>alert('操作成功！现在进入我的列表页面');javascript:location='manage.aspx?pageindex=" + Request["pageindex"] + "&depart=" + DDL_Depart.SelectedValue.ToString() + "&workstatus=" + DDL_Status.SelectedValue.ToString() + "';</script>", false);
}
}
}
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>");
}
}