protected bool UserInsert()
{
KPI_UserEntity usEntity = new KPI_UserEntity();
usEntity.UserID = Guid.NewGuid().ToString();
usEntity.UserCode = tbxUserCode.Text.Trim();
usEntity.UserName = tbxUserName.Text.Trim();
usEntity.UserPassword = KPI_UserDal.GetDESString("123456");
usEntity.UserEMail = tbxUserEMail.Text.Trim();
usEntity.UserPhone = tbxUserPhone.Text.Trim();
usEntity.UserTitle = tbxUserTitle.Text.Trim();
usEntity.UserGroups = lblUserGroups.Text.Trim();
usEntity.UserIsValid = int.Parse(rblUserIsValid.SelectedValue);
if (KPI_UserDal.Insert(usEntity))
{
MessageBox.popupClientMessage(this.Page, "添加成功！新用户的初始密码为:123456", "call();");
return(true);
}
else
{
MessageBox.popupClientMessage(this.Page, "添加失败！", "call();");
return(false);
}
}
void BindValues(bool bQuery)
{
string group = ddl_Groups.SelectedValue;
if (bQuery)
{
dtNotUsers = KPI_UserDal.GetNotUsersForGroup(group);
dtUsers = KPI_UserDal.GetUsersForGroup(group);
}
//左侧
cbxNotUsers.Items.Clear();
cbxNotUsers.DataSource = dtNotUsers;
cbxNotUsers.DataValueField = "UserID";
cbxNotUsers.DataTextField = "DisplayName";
cbxNotUsers.DataBind();
//右侧
cbxUsers.Items.Clear();
cbxUsers.DataSource = dtUsers;
cbxUsers.DataValueField = "UserID";
cbxUsers.DataTextField = "DisplayName";
cbxUsers.DataBind();
}
protected bool UserUpdate()
{
string userid = ViewState["userid"].ToString();
KPI_UserEntity usEntity = new KPI_UserEntity();
usEntity.UserID = userid;
usEntity.UserName = tbxUserCode.Text.Trim();
usEntity.UserEMail = tbxUserEMail.Text.Trim();
usEntity.UserPhone = tbxUserPhone.Text.Trim();
usEntity.UserTitle = tbxUserTitle.Text.Trim();
usEntity.UserGroups = lblUserGroups.Text.Trim();
usEntity.UserIsValid = int.Parse(rblUserIsValid.SelectedValue);
if (KPI_UserDal.Update(usEntity))
{
MessageBox.popupClientMessage(this.Page, "修改成功！", "call();");
return(true);
}
else
{
MessageBox.popupClientMessage(this.Page, "修改失败！", "call();");
return(false);
}
}
protected void gvUser_RowCommand(object sender, GridViewCommandEventArgs e)
{
string[] estr = e.CommandArgument.ToString().Split(new string[] { "$" }, StringSplitOptions.RemoveEmptyEntries);
if (estr.Length < 2)
{
MessageBox.popupClientMessage(this.Page, "参数无法获取正确,请联系开发人员。", "call();");
return;
}
string userid = Convert.ToString(estr[0]);
string nextparam = Convert.ToString(estr[1]);
if (e.CommandName == "passwordUpdate")
{
string newpassword = nextparam;
if (KPI_UserDal.SetInitPassword(newpassword, userid))
{
MessageBox.popupClientMessage(this.Page, "初始化成功,密码为:123456", "call();");
BindGrid();
}
else
{
MessageBox.popupClientMessage(this.Page, "初始化错误，请联系技术支持！", "call();");
}
}
else if (e.CommandName == "validUpdate")
{
string userisvalid = nextparam;
userisvalid = userisvalid == "1" ? "0" : "1";
if (KPI_UserDal.SetUserValid(userisvalid, userid))
{
MessageBox.popupClientMessage(this.Page, "设置成功！", "call();");
BindGrid();
}
else
{
MessageBox.popupClientMessage(this.Page, "设置错误，请联系技术支持！", "call();");
}
}
else if (e.CommandName == "dataDelete")
{
if (KPI_UserDal.DeleteUserID(userid))
{
MessageBox.popupClientMessage(this.Page, "删除成功！", "call();");
BindGrid();
}
else
{
MessageBox.popupClientMessage(this.Page, "删除错误！", "call();");
return;
}
}
}
protected void btnSave_Click(object sender, ImageClickEventArgs e)
{
if (bSaved)
{
MessageBox.popupClientMessage(this.Page, "没有任何操作!", "call();");
return;
}
string group = ddl_Groups.SelectedValue;
//删除权限
for (int i = 0; i < dtNotUsers.Rows.Count; i++)
{
string strSelected = dtNotUsers.Rows[i]["UserID"].ToString();
string strGroup = dtNotUsers.Rows[i]["UserGroups"].ToString();
if (strSelected != "")
{
strGroup = strGroup.Replace(group + ",", "");
if (strGroup.Trim() == "")
{
strGroup = "AB,";
}
KPI_UserDal.UpdateUserGroups(strSelected, strGroup);
}
bSaved = true;
}
//添加权限
for (int i = 0; i < dtUsers.Rows.Count; i++)
{
string strSelected = dtUsers.Rows[i]["UserID"].ToString();
string strGroup = dtUsers.Rows[i]["UserGroups"].ToString();
if (strSelected != "")
{
if (!strGroup.Contains(group))
{
strGroup += group + ",";
}
KPI_UserDal.UpdateUserGroups(strSelected, strGroup);
}
bSaved = true;
}
MessageBox.popupClientMessage(this.Page, "保存成功!", "call();");
//可以不用
//BindValues(true);
}
void BindGrid()
{
string username = tbx_UserName.Text.Trim();
DataTable dt = KPI_UserDal.GetUsers(username);
gvUser.DataSource = dt;
gvUser.DataBind();
}
protected void btnDel_Click(object sender, ImageClickEventArgs e)
{
for (int i = 0; i < cbxNotUsers.Items.Count; i++)
{
string strSelected = cbxNotUsers.Items[i].Selected ? cbxNotUsers.Items[i].Value : "";
if (strSelected != "")
{
KPI_UserDal.DeleteUserID(strSelected);
}
}
BindValues(true);
}
void BindValues(string usercode)
{
string userid = KPI_UserDal.GetUserID(usercode);
ViewState["userid"] = userid;
KPI_UserEntity usEntity = KPI_UserDal.GetEntity(userid);
tbxUserCode.Text = usEntity.UserCode;
tbxUserName.Text = usEntity.UserName;
//tbxUserPassword.Text = usEntity.UserPassword;
//tbxUserP1.Text = "";
//tbxUserP2.Text = "";
tbxUserEMail.Text = usEntity.UserEMail;
tbxUserPhone.Text = usEntity.UserPhone;
tbxUserTitle.Text = usEntity.UserTitle;
}
protected void btnLogin_Click(object sender, EventArgs e)
{
//判断用户名及密码
string strUserCode = usercode.Value.Trim();
string strUserPassword = userpassword.Value.Trim();
if (KPI_UserDal.CheckUserPassword(strUserCode, strUserPassword))
{
RedirectMain(true, strUserCode, strUserPassword);
}
else
{
userpassword.Value = "";
MessageBox.popupClientMessage(this.Page, "用户不存在或密码错误，请重新填写！", "call();");
}
}
void BindValues(string userid)
{
KPI_UserEntity usEntity = KPI_UserDal.GetEntity(userid);
tbxUserCode.Text = usEntity.UserCode;
tbxUserName.Text = usEntity.UserName;
//tbxUserPassword.Text = usEntity.UserPassword;
//tbxUserP1.Text = "";
//tbxUserP2.Text = "";
tbxUserEMail.Text = "";
tbxUserPhone.Text = "";
tbxUserTitle.Text = "";
lblUserGroups.Text = "";
//gvUser.DataSource = dt;
//gvUser.DataBind();
}
protected void btnExport_Click(object sender, EventArgs e)
{
string strExcelFile = "SISUser";
try
{
System.Data.DataTable dt = KPI_UserDal.GetUsersForExcel();
if (dt == null)
{
return;
}
ExportToSpreadsheet(dt, strExcelFile);
}
catch (Exception ee)
{
MessageBox.popupClientMessage(this.Page, "导出信息错误！" + ee.Message, "call();");
return;
}
return;
}
protected void ImportFromExcelToCreate(DataSet ds)
{
try
{
System.Data.DataTable dt = ds.Tables[0];
int nAll = dt.Rows.Count;
int nCreate = 0;
int nExist = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
if (dr["SelectX"].ToString().ToLower() == "x")
{
string userid = Guid.NewGuid().ToString();
string usercode = dr["UserCode"].ToString().Trim();
//判断是否存在
if (KPI_UserDal.UserCodeExist(usercode, userid))
{
nExist += 1;
continue;
}
string username = dr["UserName"].ToString().Trim();
string userdesc = dr["UserDesc"].ToString().Trim();
string userpassword = KPI_UserDal.GetDESString(dr["UserPassword"].ToString().Trim());
string useremail = dr["UserEmail"].ToString().Trim();
string userphone = dr["UserPhone"].ToString().Trim();
string usertitle = dr["UserTitle"].ToString().Trim();
string usergroups = "";
int userisvalid = int.Parse(dr["UserIsValid"].ToString().Trim());
string usernote = dr["UserNote"].ToString().Trim();
string usercreatetime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
//string usermodifytime = usercreatetime;
KPI_UserEntity usMenu = new KPI_UserEntity();
usMenu.UserID = userid;
usMenu.UserCode = usercode;
usMenu.UserName = username;
usMenu.UserDesc = userdesc;
usMenu.UserPassword = userpassword;
usMenu.UserEMail = useremail;
usMenu.UserPhone = userphone;
usMenu.UserTitle = usertitle;
usMenu.UserGroups = usergroups;
usMenu.UserIsValid = userisvalid;
usMenu.UserNote = usernote;
usMenu.UserCreateTime = usercreatetime;
usMenu.UserModifyTime = usercreatetime;
if (KPI_UserDal.Insert(usMenu))
{
nCreate += 1;
}
}
}
string strInfor = "用户总数：{0}个, 创建成功:{1}个，已存在用户: {2}个。";
strInfor = string.Format(strInfor, nAll, nCreate, nExist);
MessageBox.popupClientMessage(this.Page, strInfor, "call();");
BindGrid();
return;
}
catch (Exception)
{
//
//MessageBox.popupClientMessage(this.Page, ee.Message, "call();");
return;
}
}
protected void btnConfirm_Click(object sender, EventArgs e)
{
string userid = ViewState["userid"].ToString();
string usercode = tbxUserCode.Text.Trim();
//是否特殊用户sisdemo不能修改；sisadmin可以修改
if (usercode.ToUpper() == "SISDEMO")
{
MessageBox.popupClientMessage(this.Page, "无权修改sisdemo用户！", "call();");
return;
}
//不能为空
if (tbxUserP1.Text.Trim() == "")
{
tbxUserPassword.Text = "";
tbxUserP1.Text = "";
tbxUserP2.Text = "";
MessageBox.popupClientMessage(this.Page, "新密码不能为空！", "call();");
return;
}
string username = tbxUserName.Text.Trim();
string oldpassword = KPI_UserDal.GetUserPassword(userid);
string userpassword = KPI_UserDal.GetDESString(tbxUserPassword.Text.Trim());
string newpassword = KPI_UserDal.GetDESString(tbxUserP1.Text.Trim());
string userp1 = tbxUserP1.Text.Trim();
string userp2 = tbxUserP2.Text.Trim();
string useremail = tbxUserEMail.Text.Trim();
string userphone = tbxUserPhone.Text.Trim();
string usertitle = tbxUserTitle.Text.Trim();
//判断用户是否为空
if (username == "")
{
tbxUserPassword.Text = "";
tbxUserP1.Text = "";
tbxUserP2.Text = "";
MessageBox.popupClientMessage(this.Page, "用户姓名都不能空！", "call();");
return;
}
//判断旧密码是否正确
if (oldpassword != userpassword)
{
tbxUserPassword.Text = "";
tbxUserP1.Text = "";
tbxUserP2.Text = "";
MessageBox.popupClientMessage(this.Page, "旧密码不正确！", "call();");
return;
}
//判断新密码是否一致
if (userp1 != userp2)
{
tbxUserPassword.Text = "";
tbxUserP1.Text = "";
tbxUserP2.Text = "";
MessageBox.popupClientMessage(this.Page, "新密码不一致！", "call();");
return;
}
//判断新旧密码是否一致
if (oldpassword == newpassword)
{
tbxUserPassword.Text = "";
tbxUserP1.Text = "";
tbxUserP2.Text = "";
MessageBox.popupClientMessage(this.Page, "新密码不一致！", "call();");
return;
}
KPI_UserEntity usEntity = new KPI_UserEntity();
usEntity.UserID = userid;
usEntity.UserName = username;
usEntity.UserPassword = newpassword;
usEntity.UserEMail = useremail;
usEntity.UserPhone = userphone;
usEntity.UserTitle = usertitle;
if (KPI_UserDal.Update(usEntity))
{
MessageBox.popupClientMessage(this.Page, "修改成功！", "call();");
}
else
{
MessageBox.popupClientMessage(this.Page, "修改错误！", "call();");
}
return;
}
