123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437 |
- using DevComponents.DotNetBar.Layout;
- using DevComponents.DotNetBar.SuperGrid;
- using System;
- using System.Collections.Generic;
- using System.ComponentModel;
- using System.Data;
- using System.Drawing;
- using System.Linq;
- using System.Text;
- using System.Windows.Forms;
- using WCS_Client.UC;
- using WCS_Client.Utility;
- namespace WCS_Client.Frm
- {
- public partial class FrmUser : Form
- {
- public FrmUser()
- {
- InitializeComponent();
- InitFrm();
- }
- DataTable _dt;
- #region 分页查询
- private void InitFrm()
- {
- List<GridColumn> GCList = new List<GridColumn>()
- {
- SuperGridUtil.Get_GridColumn("USER_NO", "登录名", 100),
- SuperGridUtil.Get_GridColumn("Use_Name", "用户名", 100),
- SuperGridUtil.Get_GridColumn("Use_RoleId", "用户角色id", 20,false),
- SuperGridUtil.Get_GridColumn("Use_RoleName", "用户角色", 100),
- SuperGridUtil.Get_GridColumn("Use_Sex", "性别", 20,false),
- SuperGridUtil.Get_GridColumn("Use_SexCh", "性别", 60),
- SuperGridUtil.Get_CheckBoxX_GridColumn("Use_IsStop", "是否停用", 80),
- SuperGridUtil.Get_GridColumn("Use_ContactText", "联系方式", 100),
- SuperGridUtil.Get_GridColumn("Use_Email", "邮箱", 100),
- SuperGridUtil.Get_GridColumn("Use_Address", "地址", 100),
- //SuperGridUtil.Get_GridColumn("Use_AddUserNo", "创建用户", 100),
- //SuperGridUtil.Get_GridColumn("Use_AddDateTime", "创建时间", 100),
- SuperGridUtil.Get_GridColumn("Use_EditUserNo", "编辑用户", 100),
- SuperGridUtil.Get_GridColumn("Use_EditDateTime", "编辑时间", 120),
- SuperGridUtil.Get_GridColumn("Use_LoginTime", "登录时间", 120),
- SuperGridUtil.Get_GridColumn("Use_Notes", "备注", 120),
- };
- List<LayoutControlItem> LCIList = new List<LayoutControlItem>();
- //LCIList.Add(LCItemUtil.Add_TextboxX("User_No", "登录名:", 49, SubmitMethods, null));
- //LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "User_No like '%{0}%'" };
- //LCIList.Add(LCItemUtil.Add_TextboxX("Use_Name", "显示名:", 49, SubmitMethods, null));
- //LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "Use_Name like '%{0}%'" };
- //LCIList.Add(LCItemUtil.Add_CheckBoxX("Use_IsStop", "是否停用", true, 100, SubmitMethods, null));
- //LCIList[LCIList.Count - 1].WidthType = eLayoutSizeType.Absolute;
- //LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "User_IsStop={0}" };
- LCIList.Add(LCItemUtil.Add_ButtonX("btn_QDB", "刷新", 80, 30, SubmitMethods));
- //LCIList.Add(LCItemUtil.Add_ButtonX("btn_QClear", "重置", 80, 30, SubmitMethods));
- LCIList.Add(LCItemUtil.Add_ButtonX("btn_NewUser", "新建用户", 80, 30, SubmitMethods));
- LCIList.Add(LCItemUtil.Add_ButtonX("btn_EditUser", "修改用户", 80, 30, SubmitMethods));
- LCIList.Add(LCItemUtil.Add_ButtonX("btn_ModifyPwd", "修改密码", 80, 30, SubmitMethods));
- LCIList.Add(LCItemUtil.Add_ButtonX("btn_DeleteUser", "删除用户", 80, 30, SubmitMethods));
- this.UC_Qq.Init_QueryPage(30, true, true, "", GCList, LCIList, QueryPageDataMethods, null, GridDoubleClickMethods, null, ClikMethod, 1);
- CommonShow.ShowProcessing("正在处理中,请稍候...", this, (obj) =>
- {
- UC_Qq.RefreshData(1, 0);
- }, null);
- }
- //获取数据集
- private PageData QueryPageDataMethods(int PageIndex, int PageSize)
- {
- string _SQLText = "SELECT * FROM WCS_Users";
- string _Orderby = " User_No asc";
- PageData pd =BaseWorkflow.QueryPageData2(_SQLText, _Orderby, UC_Qq.GetQueryWhere(), PageIndex, PageSize);
- _dt = pd.Dt;
- return pd;
- }
- /// <summary>
- /// 按钮绑定事件
- /// </summary>
- /// <param name="LCName"></param>
- private void SubmitMethods(string LCName)
- {
- if (LCName == "btn_QClear")
- {
- this.UC_Qq.ShowOpaqueLayer();
- this.UC_Qq.ClearLCItemValue();
- this.UC_Qq.RefreshData(1, 0);
- this.UC_Qq.HideOpaqueLayer();
- return;
- }
- else if (LCName == "btn_NewUser")
- {
- Init_frmLAddEdit();
- frmLAddEdit.FrmNewShowDialog();
- }
- else if (LCName == "btn_EditUser")
- {
- DataTable dt = this.UC_Qq.SCGrid_GetChkRows();
- if (dt == null || dt.Rows.Count == 0)
- {
- UC.MessageUtil.ShowTips("请选择编辑项!!!");
- return;
- }
- Init_frmLAddEdit();
- frmLAddEdit.FrmEditShowDialog(dt.Rows[0]);
- }
- else if (LCName == "btn_DeleteUser")
- {
- DataTable dt = this.UC_Qq.SCGrid_GetChkRows();
- if (dt == null || dt.Rows.Count == 0)
- {
- MessageUtil.ShowTips("请选择编辑项!!!");
- return;
- }
- try
- {
- var result = MessageUtil.ShowYesNoAndWarning(string.Format("确定要删除用户[{0}]吗?", dt.Rows[0][WCS_UsersEnum.User_No.ToString()].ToString()));
- if (result == DialogResult.Yes)
- {
- string msg = BaseWorkflow.DeleteUser(dt.Rows[0][WCS_UsersEnum.User_No.ToString()].ToString());
- if (string.IsNullOrWhiteSpace(msg) == false)
- throw new Exception(msg);
- else
- MessageUtil.ShowTips(LangConst.DeleteSuccess);
- }
- }
- catch (Exception ex)
- {
- MessageUtil.ShowError(ex.Message);
- }
- }
- else if (LCName == "btn_ModifyPwd")
- {
- DataTable dt = this.UC_Qq.SCGrid_GetChkRows();
- if (dt == null || dt.Rows.Count == 0)
- {
- MessageUtil.ShowTips("请选择编辑项!!!");
- return;
- }
- Init_frmLEditAdminPwd();
- frmLEditAdminPwd.ShowDialog();
- }
- this.UC_Qq.RefreshData();
- }
- private void GridDoubleClickMethods(DataRow dr)
- {
- if (dr != null)
- {
- //Init_frmLAddEdit();
- //frmLAddEdit.FrmViewShowDialog(dr);
- //frmLAddEdit = null;
- }
- }
- private void ClikMethod(DataRow dr)
- {
- }
- #endregion
- #region FrmLAddEdit
- FrmLAddEdit frmLAddEdit = null;
- private DataRow GetDrMethods(int StepQty)
- {
- return this.UC_Qq.SCGrid_GetSelectRow(StepQty);
- }
- private DataRow EditDataMethods(DataRow dr)
- {
- if (dr == null)
- {
- return null;
- }
- string sql = string.Format("select * from WCS_Users where User_No='{0}'", dr["USER_NO"].ToString());
- DataTable dt = BaseWorkflow.CommonQueryUser(sql);
- if (dt == null || dt.Rows.Count == 0)
- {
- return null;
- }
- return dt.Rows[0];
- }
- private bool SaveDataMethods(DataRow dr)
- {
- if (dr == null)
- {
- throw new Exception("保存数据为空!!!");
- }
- if (CheckControl("", true))
- {
- WCS_Users acluser = new WCS_Users();
- acluser.USER_NO = dr["USER_NO"].ToString();
- acluser.Use_Name = dr["Use_Name"].ToString();
- acluser.Use_Sex = Convert.ToInt32(dr["Use_Sex"]);
- var dtsex = BaseWorkflow.CommonQuery(string.Format("SELECT * FROM WCS_Mappingentry where Mep_MappingType='Sex' and Mep_MappingNo={0}", acluser.Use_Sex));
- acluser.Use_SexCh = dtsex.Rows[0]["Mep_MappingChName"].ToString();
- acluser.Use_RoleId = Convert.ToInt32(dr["Use_RoleId"]);
- var user_role = BaseWorkflow.CommonQuery(string.Format("SELECT * FROM WCS_Mappingentry where Mep_MappingType='RoleId' and Mep_MappingNo={0}", acluser.Use_RoleId));
- acluser.Use_RoleName = user_role.Rows[0]["Mep_MappingChName"].ToString();
- acluser.Use_IsStop = Convert.ToBoolean(dr["Use_IsStop"]);
- acluser.Use_Email = dr["Use_Email"].ToString();
- acluser.Use_Address = dr["Use_Address"].ToString();
- acluser.Use_ContactText = dr["Use_ContactText"].ToString();
- acluser.Use_AddUserNo = CurrentHelper.User.USER_NO;
- acluser.Use_AddDateTime = DateTime.Now;
- acluser.Use_EditUserNo = CurrentHelper.User.USER_NO;
- acluser.Use_EditDateTime = DateTime.Now;
- acluser.Use_Notes = dr["Use_Notes"].ToString();
- //添加或修改用户
- string result = BaseWorkflow.AddEditUser(acluser);
- if (string.IsNullOrWhiteSpace(result))
- MessageUtil.ShowTips("添加或修改用户成功!!!");
- else
- MessageUtil.ShowError(result);
- return true;
- }
- return false;
- }
- private void LCItemEditMethods(FrmLAddEdit frm)
- {
- frm.LCItemIsEnable(true);
- frm.LCItemIsEnable("User_No", false);
- }
- private void LCItemNewMethods(FrmLAddEdit frm)
- {
- frm.LCItemIsEnable(true);
- }
- private void CheckControl(string LCName)
- {
- CheckControl(LCName, false);
- }
- private bool CheckControl(string LCName, bool IsALL)
- {
- if (frmLAddEdit == null)
- {
- return false;
- }
- int ErrQty = 0;
- string TmpLCName = "User_No";
- if (IsALL || LCName == TmpLCName)
- {
- object OValue = LCItemUtil.GetValue_LCItem(frmLAddEdit.GetLCItem(TmpLCName));
- if (OValue == null || string.IsNullOrEmpty(OValue.ToString()))
- {
- frmLAddEdit.SetLCItemErr(TmpLCName, "登录名不能为空!!!");
- ErrQty++;
- }
- else
- {
- frmLAddEdit.SetLCItemErr(TmpLCName, "");
- }
- }
- TmpLCName = "Use_Name";
- if (IsALL || LCName == "Use_Name")
- {
- object OValue = LCItemUtil.GetValue_LCItem(frmLAddEdit.GetLCItem(TmpLCName));
- if (OValue == null || string.IsNullOrEmpty(OValue.ToString()))
- {
- frmLAddEdit.SetLCItemErr(TmpLCName, "用户名不能为空!!!");
- ErrQty++;
- }
- else
- {
- frmLAddEdit.SetLCItemErr(TmpLCName, "");
- }
- }
- TmpLCName = "Use_Sex";
- if (IsALL || LCName == "Use_Sex")
- {
- object OValue = LCItemUtil.GetValue_LCItem(frmLAddEdit.GetLCItem(TmpLCName));
- if (OValue == null || string.IsNullOrEmpty(OValue.ToString()))
- {
- frmLAddEdit.SetLCItemErr(TmpLCName, "性别不能为空!!!");
- ErrQty++;
- }
- else
- {
- frmLAddEdit.SetLCItemErr(TmpLCName, "");
- }
- }
- TmpLCName = "Use_RoleId";
- if (IsALL || LCName == "Use_RoleId")
- {
- object OValue = LCItemUtil.GetValue_LCItem(frmLAddEdit.GetLCItem(TmpLCName));
- if (OValue == null || string.IsNullOrEmpty(OValue.ToString()))
- {
- frmLAddEdit.SetLCItemErr(TmpLCName, "角色不能为空!!!");
- ErrQty++;
- }
- else
- {
- frmLAddEdit.SetLCItemErr(TmpLCName, "");
- }
- }
- return ErrQty == 0;
- }
- /// <summary>
- /// 添加用户
- /// </summary>
- private void Init_frmLAddEdit()
- {
- frmLAddEdit = new FrmLAddEdit();
- frmLAddEdit.Size = new Size(708, 291);
- frmLAddEdit.Text = string.Format("用户基本信息编辑,新建用户默认密码[123456]");
- List<LayoutControlItem> LCIList = new List<LayoutControlItem>();
- LCIList.Add(LCItemUtil.Add_TextboxX("User_No", "登录名(*):", 99, null, CheckControl));
- LCIList.Add(LCItemUtil.Add_CheckBoxX("Use_IsStop", "是否停用", false, 80, null, null));
- LCIList[LCIList.Count - 1].WidthType = eLayoutSizeType.Absolute;
- LCIList.Add(LCItemUtil.Add_TextboxX("Use_Name", "用户名(*):", 50, null, CheckControl));
- LCIList.Add(LCItemUtil.Add_ComboBoxEx("Use_Sex", "性别", 50, null, CheckControl));
- var dtsex = BaseWorkflow.CommonQuery(string.Format("SELECT * FROM WCS_Mappingentry where Mep_MappingType='Sex'"));
- LCItemUtil.Refresh_LCItem(LCIList[LCIList.Count - 1], dtsex, "MEP_MAPPINGNO", "MEP_MAPPINGCHNAME");
- LCIList.Add(LCItemUtil.Add_ComboBoxEx("Use_RoleId", "用户角色:", 50, null, CheckControl));
- var use_roles = BaseWorkflow.CommonQuery(string.Format("SELECT * FROM WCS_Mappingentry where Mep_MappingType='RoleId'"));
- LCItemUtil.Refresh_LCItem(LCIList[LCIList.Count - 1], use_roles, "MEP_MAPPINGNO", "MEP_MAPPINGCHNAME");
- LCIList.Add(LCItemUtil.Add_TextboxX("Use_Email", "Email:", 50, null, null));
- LCIList.Add(LCItemUtil.Add_TextboxX("Use_ContactText", "联系方式:", 50, null, null));
- LCIList.Add(LCItemUtil.Add_TextboxX("Use_Address", "住址:", 100, null, null));
- LCIList.Add(LCItemUtil.Add_TextboxX("Use_Notes", "备注:", 100, null, null));
- frmLAddEdit.InitFrm(true, true, LCIList, GetDrMethods, LCItemNewMethods, LCItemEditMethods, EditDataMethods, SaveDataMethods);
- }
- #endregion
- #region frmLEditAdminPwd
- FrmLEdit frmLEditAdminPwd = null;
- private void Init_frmLEditAdminPwd()
- {
- frmLEditAdminPwd = new FrmLEdit();
- frmLEditAdminPwd.Size = new Size(708, 125);
- if (this.UC_Qq.SCGrid_GetChkRowsQty() > 1)
- {
- frmLEditAdminPwd.Text = "系统管理员批量修改用户密码!!!";
- }
- else
- {
- frmLEditAdminPwd.Text = "系统管理员修改用户密码!!!";
- }
- List<LayoutControlItem> LCIList = new List<LayoutControlItem>();
- LCIList.Add(LCItemUtil.Add_TextboxX("User_NewPwd", "新密码(*):", true, 100, null, CheckControl_AdminPwd));
- LCIList.Add(LCItemUtil.Add_TextboxX("User_TwoNewPwd", "确认新密码(*):", true, 100, null, CheckControl_AdminPwd));
- LCIList.Add(LCItemUtil.Add_SpacerItem("User_SpacerItem", 99, 30));
- LCIList.Add(LCItemUtil.Add_ButtonX("btn_AdminPwd", "修改密码", 80, 30, SubmitMethods_AdminPwd));
- LCIList.Add(LCItemUtil.Add_ButtonX("btn_AdminPwdClose", "取消", 80, 30, SubmitMethods_AdminPwd));
- frmLEditAdminPwd.InitFrm(LCIList);
- }
- private void CheckControl_AdminPwd(string LCName)
- {
- CheckControl_AdminPwd(frmLEditAdminPwd, LCName, false);
- }
- private bool CheckControl_AdminPwd(FrmLEdit TmpfrmLEditAdminPwd, string LCName, bool IsALL)
- {
- if (TmpfrmLEditAdminPwd == null)
- {
- return false;
- }
- int ErrQty = 0;
- string TmpNewPwd = "User_NewPwd";
- string TmpTwoNewPwd = "User_TwoNewPwd";
- if (IsALL || LCName == TmpNewPwd || LCName == TmpTwoNewPwd)
- {
- object ONewPwdValue = LCItemUtil.GetValue_LCItem(TmpfrmLEditAdminPwd.GetLCItem(TmpNewPwd));
- if (ONewPwdValue == null || string.IsNullOrEmpty(ONewPwdValue.ToString()))
- {
- TmpfrmLEditAdminPwd.SetLCItemErr(TmpNewPwd, "新密码不能为空!!!");
- ErrQty++;
- }
- else
- {
- TmpfrmLEditAdminPwd.SetLCItemErr(TmpNewPwd, "");
- }
- if (IsALL || LCName == TmpTwoNewPwd)
- {
- object OTwoNewPwdValue = LCItemUtil.GetValue_LCItem(TmpfrmLEditAdminPwd.GetLCItem(TmpTwoNewPwd));
- if (OTwoNewPwdValue == null || string.IsNullOrEmpty(OTwoNewPwdValue.ToString()))
- {
- TmpfrmLEditAdminPwd.SetLCItemErr(TmpTwoNewPwd, "确认新密码不能为空!!!");
- ErrQty++;
- }
- else
- {
- if (ONewPwdValue != null && ONewPwdValue.ToString() == OTwoNewPwdValue.ToString())
- {
- TmpfrmLEditAdminPwd.SetLCItemErr(TmpTwoNewPwd, "");
- }
- else
- {
- TmpfrmLEditAdminPwd.SetLCItemErr(TmpTwoNewPwd, "两次密码不一致!!!");
- ErrQty++;
- }
- }
- }
- }
- return ErrQty == 0;
- }
- private void SubmitMethods_AdminPwd(string LCName)
- {
- if (LCName == "btn_AdminPwd")
- {
- if (!CheckControl_AdminPwd(frmLEditAdminPwd, "", true))
- {
- return;
- }
- try
- {
- object OTwoNewPwdValue = LCItemUtil.GetValue_LCItem(frmLEditAdminPwd.GetLCItem("User_TwoNewPwd"));
- DataTable table = this.UC_Qq.SCGrid_GetChkRows();
- string user_no = table.Rows[0][WCS_UsersEnum.User_No.ToString()].ToString();
- string result = BaseWorkflow.AdminModifyPwd(user_no, OTwoNewPwdValue.ToString());
- if (string.IsNullOrWhiteSpace(result))
- MessageUtil.ShowTips(string.Format("用户{0}修改密码成功。", user_no));
- else
- MessageUtil.ShowError(result);
- }
- catch (Exception ex)
- {
- MessageUtil.ShowError(ex.Message);
- }
- }
- if (frmLEditAdminPwd != null)
- {
- frmLEditAdminPwd.Close();
- frmLEditAdminPwd.Dispose();
- frmLEditAdminPwd = null;
- }
- }
- #endregion
- }
- }
|