using CCWin; using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; using WCS_Client.UC; using WCS_Client.Utility; namespace WCS_Client.From { public partial class FromUser : CCSkinMain { DataTable _dt; DataRow _currentDr; public FromUser() { InitializeComponent(); } private static FromUser childFromInstanc; public static FromUser ChildFromInstanc { get { if (childFromInstanc == null || childFromInstanc.IsDisposed) { childFromInstanc = new FromUser(); } return childFromInstanc; } } private void Bind() { //pagerControl1.PageSize = 1; PageData pd = QueryPageDataMethods(pagerControl1.CurrentPage, pagerControl1.PageSize); if (pd == null) { if (_dt != null) _dt.Clear(); } else { pagerControl1.Record = pd.RowsCount; skinDgvUsers.DataSource = pd.Dt; _dt = pd.Dt; } } //获取数据集 private PageData QueryPageDataMethods(int PageIndex, int PageSize) { string _SQLText = "SELECT * FROM WCS_Users"; string _Orderby = " User_No asc"; PageData pd = BaseWorkflow.QueryPageData2(_SQLText, _Orderby, new List(), PageIndex, PageSize); return pd; } private void pagerControl1_BindSource(object sender, EventArgs e) { Bind(); } private void BtnRefresh_Click(object sender, EventArgs e) { Bind(); } private void skinDgvUsers_DataError(object sender, DataGridViewDataErrorEventArgs e) { } private void btn_adduser_Click(object sender, EventArgs e) { FormAddUser adduser = new FormAddUser(); adduser.ShowDialog(); Bind(); } protected virtual bool SelectedRow() { _currentDr = GetDgvRow("USER_NO"); if (_currentDr == null) { MessageUtil.ShowWarning("请选中行!!!"); return false; } return true; } public DataRow GetDgvRow(string cellName) { try { if (skinDgvUsers.CurrentCell == null) return null; if (skinDgvUsers.CurrentCell.RowIndex >= 0) { string no = Convert.ToString(skinDgvUsers.Rows[skinDgvUsers.CurrentCell.RowIndex].Cells[cellName].Value); return _dt.Select(cellName + "='" + no + "'")[0]; } return null; } catch (Exception ex) { return null; } } private void btn_updateuser_Click(object sender, EventArgs e) { SelectedRow(); if (_currentDr == null) { MessageUtil.ShowWarning("请选择要编辑的记录行!!!"); return; } FormEditUser edituser = new FormEditUser(_currentDr); edituser.ShowDialog(); Bind(); } private void btn_DelPwd_Click(object sender, EventArgs e) { SelectedRow(); if (_currentDr == null) { MessageUtil.ShowWarning("请选择要删除的记录行!!!"); return; } try { var result = MessageUtil.ShowYesNoAndWarning(string.Format("确定要删除用户[{0}]吗?", _currentDr[WCS_UsersEnum.User_No.ToString()].ToString())); if (result == DialogResult.Yes) { string msg = BaseWorkflow.DeleteUser(_currentDr[WCS_UsersEnum.User_No.ToString()].ToString()); if (string.IsNullOrWhiteSpace(msg) == false) throw new Exception(msg); else MessageUtil.ShowTips(LangConst.DeleteSuccess); Bind(); } } catch (Exception ex) { MessageUtil.ShowError(ex.Message); } } private void btn_updatepwd_Click(object sender, EventArgs e) { SelectedRow(); if (_currentDr == null) { MessageUtil.ShowWarning("请选择要修改密码的记录行!!!"); return; } FormEditPwd editpwd = new FormEditPwd(_currentDr); editpwd.ShowDialog(); } } }