YG-PVC-WCS/WCS_Client/From/From_User/FromUser.cs

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<string>(), 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();
        }
    }
}