孙向锦 / ARS-PPT-001

/*-------------------------------------------------------------------------------------------
 * 人员名单操窗体
 * 创建：杨斌 2011-12-13
 * 修改：杨斌 2012-03-01
 * ----------------------------------------------------------------------------------------*/
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 GeneralLib;
using System.IO;

namespace SunVoteARSPPT
{
    public partial class FrmVoterList : Form
    {
        private RosterList Roster = new RosterList();

        private string ShowImportListFile = "";
        private string[,] AryImportRoster = null;//杨斌 2018-06-28
        /// <summary>
        /// 2012-06-18 赵丽 是否需要保存名单
        /// </summary>
        private bool ReSave = false;
        /// <summary>
        /// 记录单元格更改之前的值
        /// </summary>
        private string cellOldValue = "";

        public FrmVoterList()
        {
            InitializeComponent();
        }

        private void FrmVoterList_Load(object sender, EventArgs e)
        {
            GlobalInfo.SysLanguage.SetLanguage(this.Name, this);
            if (ShowImportListFile.Length < 1)
            {
                TimerCount TimerCount = new TimerCount();
                TimerCount.StartCount();

                Roster.LoadRoster();
                LoadList();

                //lblInfo.Text = "加载数据完成。耗时毫秒：" + TimerCount.GetCountMS();
                lblInfo.Text = GlobalInfo.SysLanguage.LPT.ReadString(this.Name, "LoadSuccess", "加载数据完成");
                lblInfo.Visible = false;
            }
            //2012-08-18 赵丽 加载签到码设置选项

            LoadVoterField();

            //杨斌 2012-09-07
            LoadShowNameField();

            //键盘权重功能的开启。杨斌 2012-11-30
            bool hasVoteRate = false;
            bool hasVoteWeight = false;//杨斌 2017-06-02
            switch (GlobalInfo.OEMLogo)
            {
                case OEMLogos.SunVote:
                case OEMLogos.ZX:
                    hasVoteRate = true;
                    break;
                case OEMLogos.oemPowerVote://2017-06-02
                case OEMLogos.oemAngage://杨斌 2018-03-22
                    //hasVoteWeight = (GlobalInfo.OEMLogo2 == OEMLogos2.oemPowerVoteForORPI);
                    hasVoteWeight = true;//放开分股权投票功能。杨斌 2018-07-31
                    break;
                default:
                    break;
            }
            hasVoteRate = true;//杨斌 2014-07-11

            hasVoteRate = false;//权重移出去，在反馈面板的投票参数设置里。杨斌 2014-10-28

            lblFieldVoteRate.Visible = hasVoteRate;
            cboFieldVoteRate.Visible = hasVoteRate;

            lblFeildVoteWeight.Visible = cboFeildVoteWeight.Visible = hasVoteWeight;
        }

        private void FrmVoterList_Shown(object sender, EventArgs e)
        {
            //杨斌 2014-10-23
            lblFieldShowName.Visible = false;
            cboFiledShowName.Visible = false;

            if ((ShowImportListFile.Length > 0) || (AryImportRoster != null))//杨斌 2018-06-28
            {
                ImportList(ShowImportListFile, AryImportRoster);
                ShowImportListFile = "";
                AryImportRoster = null;//杨斌 2018-06-28
                //2012-12-11 赵丽 导入名单，字段不更新的问题
                LoadVoterField();

                LoadShowNameField();//杨斌 2014-06-05

                //杨斌 2014-08-11。默认选中第2列为姓名
                if (cboFiledShowName.Items.Count >= 2)
                    cboFiledShowName.SelectedIndex = 1;
            }
        }

        private void btnClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void btnImport_Click(object sender, EventArgs e)
        {
            ImportList();
            GlobalInfo.response.SignInCodeIndex = 0;
            LoadVoterField();

            LoadShowNameField();//杨斌 2014-06-05

            //杨斌 2014-08-11。默认选中第2列为姓名
            if (cboFiledShowName.Items.Count >= 2)
                cboFiledShowName.SelectedIndex = 1;
        }

        private void btnExport_Click(object sender, EventArgs e)
        {
            ExportList();

            //if (PublicFunction.ExportToExcel(dgvVoterList, "人员名单"))
            //    MessageBox.Show("导出成功", "ARS2011");
        }

        private void cboFieldSignInCode_SelectedIndexChanged(object sender, EventArgs e)
        {

        }

        /// <summary>
        /// 键盘编号列索引，去掉LoadList里面的变量。
        /// 杨斌 2012-08-27
        /// </summary>
        private int KeypadCol = 0;

        private void LoadList()
        {
            dgvVoterList.Rows.Clear();
            dgvVoterList.Columns.Clear();
            dgvSelectShowCol.Rows.Clear();
            dgvSelectShowCol.Columns.Clear();
            for (int i = 0; i < Roster.Columns.Count; i++)
            {
                dgvVoterList.Columns.Add(Roster.Columns[i].ColumnID.ToString(), Roster.Columns[i].ColumnName);

                DataGridViewCheckBoxColumn dc = new DataGridViewCheckBoxColumn();
                dc.Name = "_" + Roster.Columns[i].ColumnID.ToString();
                dc.HeaderText = Roster.Columns[i].ColumnName;
                if (i == 0)
                    dc.ReadOnly = true;
                //if (Roster.Columns[i].ColumnID == -100)
                //    dc.ReadOnly = true;
                dgvSelectShowCol.Columns.Add(dc);
            }

            dgvSelectShowCol.Enabled = false;
            dgvSelectShowCol.Rows.Add();
            dgvSelectShowCol.Rows[0].Cells[0].Value = 1;
            if (GlobalInfo.response.ShowReportCol.Length > 0)
            {
                string[] a = GlobalInfo.response.ShowReportCol.Split(new string[] { "||" }, StringSplitOptions.None);
                for (int i = 1; i < dgvSelectShowCol.Columns.Count; i++)
                {
                    string s = dgvSelectShowCol.Columns[i].HeaderText;
                    if (a.Contains(s))
                        dgvSelectShowCol.Rows[0].Cells[i].Value = 1;
                }
            }
            dgvSelectShowCol.Enabled = true;
            //杨斌 2016-03-01
            dgvSelectShowCol.Rows[0].Height = (int)(dgvSelectShowCol.ColumnHeadersHeight * 1.5f);
            dgvSelectShowCol.Height = dgvSelectShowCol.Rows[0].Height + dgvSelectShowCol.ColumnHeadersHeight * 2;

            for (int i = 0; i < Roster.Rows.Count; i++)
            {
                dgvVoterList.Rows.Add();
                //dgvVoterList.Rows[i].HeaderCell.Value = (i + 1).ToString();
                for (int n = 0; n < Roster.Columns.Count; n++)
                {
                    if (n == KeypadCol)//键盘编号 杨斌 2012-08-13
                    {
                        //杨斌 2013-01-28
                        //if (Roster.Rows[i].Cells[n].Length > 0)
                        //    dgvVoterList.Rows[i].Cells[n].Value = ConvertOper.Convert(Roster.Rows[i].Cells[n]);
                        //else
                        //    dgvVoterList.Rows[i].Cells[n].Value = "";

                        //杨斌 2015-01-13
                        if (!string.IsNullOrEmpty(Roster.Rows[i].Cells[n]))//杨斌 2016-03-31
                            dgvVoterList.Rows[i].Cells[n].Value = Roster.Rows[i].Cells[n];
                        else
                            dgvVoterList.Rows[i].Cells[n].Value = "";
                    }
                    else
                        dgvVoterList.Rows[i].Cells[n].Value = Roster.Rows[i].Cells[n];
                }
            }
            for (int i = dgvVoterList.Rows.Count - 1; i >= 0; i--)//杨斌 2016-03-31
            {
                bool isNullRow = true;
                for (int n = 0; n < Roster.Columns.Count; n++)
                {
                    if (!string.IsNullOrEmpty(Roster.Rows[i].Cells[n]))
                    {
                        isNullRow = false;
                        break;
                    }
                }
                //if (isNullRow)
                //    dgvVoterList.Rows.RemoveAt(i);
            }
            ControlOper.SetGridRowH(dgvVoterList);//杨斌 2016-03-04
            //2012-06-18 赵丽 保存名单
            try
            {
                cellOldValue = dgvVoterList.Rows[0].Cells[0].Value.ToString();
            }
            catch { }

            //杨斌 2017-03-30
            int lastCol = dgvVoterList.Columns.Count - 1;
            if (dgvVoterList.Columns[lastCol].Name == "-100")
                dgvVoterList.Columns[lastCol].ReadOnly = true;

            dgvVoterList.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;//杨斌 2017-03-31

            ////加载随机码            
            //Dictionary<string, string> dicRUID = GetDicRUID(Roster);
            //if (dicRUID.Count > 0)
            //{
            //    string colText = GlobalInfo.SysLanguage.LPT.ReadString("PanelSignIn", "rbtSignInModeRandom", "随机码签到");
            //    int col = dgvVoterList.Columns.Add("COL_RUID", colText);
            //    dgvVoterList.Columns[col].ReadOnly = true;
            //    for (int i = 0; i < Roster.Rows.Count; i++)
            //    {
            //        string rid = Roster.Rows[i].RowIndex + "";
            //        if (dicRUID.ContainsKey(rid))
            //            dgvVoterList.Rows[i].Cells[col].Value = dicRUID[rid];
            //    }
            //}

            //屏蔽下面代码，按名单顺序。杨斌 2015-01-14
            //try
            //{
            //    dgvVoterList.Sort(dgvVoterList.Columns[KeypadCol], ListSortDirection.Ascending);//按键盘编号排序，杨斌 2012-08-13
            //}
            //catch { }

        }

        //public static Dictionary<string, string> GetDicRUID(RosterList Roster)
        //{
        //    TagSet tagSet = new TagSet(Globals.SunVoteARSAddIn.Application.ActivePresentation.Tags);
        //    string uidRandom = tagSet.GetValue(TagKey.SignInUIDRandom).Value;
        //    string[] aryRUID = uidRandom.Split('|');
        //    Dictionary<string, string> dicRUID = new Dictionary<string, string>();
        //    if (aryRUID.Length >= 0)
        //    {
        //        foreach (var v in aryRUID)
        //        {
        //            string[] ary2 = v.Split('=');
        //            if (ary2.Length >= 2)
        //            {
        //                if (!dicRUID.ContainsKey(ary2[1]))
        //                    dicRUID.Add(ary2[1], ary2[0]);
        //            }
        //        }
        //    }
        //    return dicRUID;
        //}

        /// <summary>
        /// 从外部菜单调用导出名单，窗体不显示
        /// </summary>
        public static void ExportListNoVisible()
        {
            RosterList Roster = new RosterList();
            Roster.LoadRoster();
            string[,] aryTable = Roster.GetArrayTable();
            ExcelOper.ExportArrayToExcel(aryTable, GlobalInfo.SysLanguage.LPT.ReadString("FrmVoterList", "ExcelTitle", "人员名单"));
        }

        /// <summary>
        /// 导出名单
        /// </summary>
        public void ExportList()
        {
            this.Cursor = Cursors.WaitCursor;
            string[,] aryTable = ControlOper.AryFromDataGrid(dgvVoterList);
            ExcelOper.ExportArrayToExcel(aryTable, GlobalInfo.SysLanguage.LPT.ReadString("FrmVoterList", "ExcelTitle", "人员名单"));
            this.Cursor = Cursors.Default;
        }

        /// <summary>
        /// 导入名单
        /// </summary>
        /// <returns></returns>
        public bool ImportList()
        {
            bool res = false;

            try
            {
                this.Cursor = Cursors.WaitCursor;

                OpenFileDialog openFileDialog = new OpenFileDialog();
                //openFileDialog.InitialDirectory = @"C:\";
                //杨斌 2014-08-12
                string path = Properties.Settings.Default.VoterListPath;

                //杨斌 2014-10-21
                path = new DirectoryInfo(GlobalInfo.GetAppWorkDir()).Parent.FullName;
                path += @"\Resources\RosterList\";

                if (!string.IsNullOrEmpty(path))
                {
                    openFileDialog.InitialDirectory = Path.GetDirectoryName(path);
                    //if (File.Exists(path))
                    //    openFileDialog.InitialDirectory = new DirectoryInfo(path).Parent.FullName;
                    //else if (Directory.Exists(path))
                    //    openFileDialog.InitialDirectory = path;                    
                }

                //openFileDialog.Filter = "Excel(*.xls;*.xlsx)|*.xls;*.xlsx|CSV(*.csv)|*.csv";//杨斌 2017-10-27
                openFileDialog.Filter = "Excel(*.xlsx)|*.xlsx|CSV(*.csv)|*.csv";//杨斌 2018-12-18。不兼容2003格式

                if (openFileDialog.ShowDialog() == DialogResult.OK)
                {
                    //杨斌 2014-08-12
                    Properties.Settings.Default.VoterListPath = openFileDialog.FileName;
                    Properties.Settings.Default.Save();

                    res = ImportList(openFileDialog.FileName);
                }
            }
            catch (Exception ex)
            {
                SystemLog.WriterLog(ex);
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }

            return res;
        }

        /// <summary>
        /// 从外部菜单调用导入名单，并显示窗体
        /// </summary>
        /// <param name="fileName"></param>
        public void ShowImportList(string fileName, string[,] aryData = null)
        {
            //this.Hide();
            //ImportList(fileName);
            //this.ShowDialog();

            ShowImportListFile = fileName;
            AryImportRoster = aryData;//杨斌 2018-06-28
            this.ShowDialog();
        }

        /// <summary>
        /// 2013-2-26 赵丽 暂时修改空列报错，把空列设置为“未设”
        /// </summary>
        /// <param name="ary"></param>
        /// <returns></returns>
        public string[,] ReEditRosterList(string[,] ary)
        {
            try
            {
                for (int i = 0; i <= ary.GetUpperBound(1); i++)
                {
                    if (ary[0, i] == "")
                        ary[0, i] = GlobalInfo.SysLanguage.LPT.ReadString(this.Name, "Unsetting", "未设置");
                }
                return ary;
            }
            catch { return ary; }
        }

        /// <summary>
        /// 导入名单
        /// </summary>
        /// <param name="fileName">文件路径</param>
        /// <returns></returns>
        public bool ImportList(string fileName, string[,] aryData = null)
        {
            bool res = false;

            try
            {
                this.Cursor = Cursors.WaitCursor;

                lblInfo.Visible = true;

                TimerCount TimerCount = new TimerCount();
                TimerCount.StartCount();
                lblInfo.Text = GlobalInfo.SysLanguage.LPT.ReadString(this.Name, "ImportStart", "开始导入数据...");

                //dgvVoterList.Visible = false;
                dgvVoterList.Rows.Clear();
                dgvVoterList.Columns.Clear();
                string[,] aryTable = null;

                if (aryData != null)//从数据源导入。杨斌 2018-06-28
                {
                    aryTable = aryData;
                }
                else
                {
                    bool isCSV = (Path.GetExtension(fileName).ToLower() == ".csv");//杨斌 2018-05-14
                    if (isCSV)
                    {
                        aryTable = ExcelOper.ImportCSV(fileName);
                    }
                    else
                    {
                        ExcelOper exl = new ExcelOper();
                        exl.OpenExcel(fileName);
                        aryTable = exl.ImportToSheetBySheetNum(1);
                        exl.CloseExcel();
                    }
                    aryTable = ReEditRosterList(aryTable); //2013-2-26 赵丽 暂时修改空列报错，把空列设置为“未设”
                }

                //判断有效性 //ToDo:翻译消息框
                bool isOK = true;
                string msgNotNumber = GlobalInfo.SysLanguage.LPT.ReadString(this.Name, "KeypadFormat", "键盘编号必须为1-9999之间的数字");
                if (aryTable == null)
                {
                    isOK = false;
                    MessageBox.Show(msgNotNumber);
                }
                else
                {
                    List<string> lstKey = new List<string>();
                    for (int i = 1; i <= aryTable.GetUpperBound(0); i++)
                    {
                        string keyId = aryTable[i, 0];
                        //int num = 0;

                        if (keyId.Length > 0)//杨斌 2017-08-18
                        {
                            if (lstKey.Contains(keyId))//判断是否重复
                            {
                                isOK = false;
                                MessageBox.Show(GlobalInfo.SysLanguage.LPT.ReadString(this.Name, "KeypadRepeat", "键盘编号重复"));
                            }
                            else
                            {
                                lstKey.Add(keyId);
                            }
                        }

                        //杨斌 2017-08-18。屏蔽下面
                        //if (keyId.Length == 12)//SN号。杨斌 2015-01-13
                        //{
                        //    if (lstKey.Contains(keyId))//判断是否重复
                        //    {
                        //        isOK = false;
                        //        MessageBox.Show(GlobalInfo.SysLanguage.LPT.ReadString(this.Name, "KeypadRepeat", "键盘编号重复"));
                        //    }
                        //    else
                        //    {
                        //        lstKey.Add(keyId);
                        //    }
                        //}
                        //else if (keyId.Length > 0)//杨斌 2013-01-28
                        //{
                        //    if (int.TryParse(keyId, out num))//判断是否整数
                        //    {
                        //        if ((num < HardWareInfo.KeypadID_Min) || (num > HardWareInfo.KeypadID_Max))//判断范围
                        //        {
                        //            isOK = false;
                        //            MessageBox.Show(msgNotNumber);
                        //        }
                        //        else
                        //        {
                        //            if (lstKey.Contains(keyId))//判断是否重复
                        //            {
                        //                isOK = false;
                        //                MessageBox.Show(GlobalInfo.SysLanguage.LPT.ReadString(this.Name, "KeypadRepeat", "键盘编号重复"));
                        //            }
                        //            else
                        //            {
                        //                lstKey.Add(keyId);
                        //            }
                        //        }
                        //    }
                        //    else
                        //    {
                        //        MessageBox.Show(msgNotNumber);
                        //        isOK = false;
                        //    }
                        //}
                        if (!isOK) break;
                    }
                }

                //lblInfo.Text = "获取Excel数据完成。耗时毫秒：" + TimerCount.GetCountMS();
                lblInfo.Text = GlobalInfo.SysLanguage.LPT.ReadString(this.Name, "GetExcelData", "获取Excel数据完成");
                //TimerCount.StartCount();

                this.Cursor = Cursors.WaitCursor;

                if (isOK)
                {
                    if (Roster.SaveRoster(aryTable, true, GlobalInfo.DBOperation, false))
                    {
                        //lblInfo.Text = "保存数据完成。耗时毫秒：" + TimerCount.GetCountMS();
                        //TimerCount.StartCount();
                        lblInfo.Text = GlobalInfo.SysLanguage.LPT.ReadString(this.Name, "SaveSuccess", "保存数据完成");

                        //杨斌 2017-03-30
                        TagSet tagSet = new TagSet(Globals.SunVoteARSAddIn.Application.ActivePresentation.Tags);
                        tagSet.SetValue(TagKey.SignInUIDRandom, "");

                        ////LoadList();//杨斌 2015-04-02。屏蔽。在下面加载
                        //AryToDataGrid(dgvVoterList, aryTable);
                        //lblInfo.Text = "加载数据完成。耗时毫秒：" + TimerCount.GetCountMS();
                        //杨斌 2014-08-11
                        //lblInfo.Text = GlobalInfo.SysLanguage.LPT.ReadString("FrmPollList", "ImportSuccess", "导入成功");
                        //lblInfo.Text = GlobalInfo.SysLanguage.LPT.ReadString("FrmVoterList", "ImportSuccess", "导入成功");//屏蔽词条。杨斌 2015-01-14

                        //姓名固定为第2列。杨斌 2014-10-23
                        if (Roster.Columns.Count > 1)
                            GlobalInfo.response.ShowNameCol = Roster.Columns[1].ColumnName;
                        else
                            GlobalInfo.response.ShowNameCol = "";

                        SaveRosterToTempDB(aryTable);//杨斌 2015-03-31
                        //保存系统库后需重新加载。杨斌 2015-04-02
                        Roster.LoadRoster();
                        LoadList();

                        //杨斌 2018-02-02
                        if (RosterList.RosterLoad == null)
                            RosterList.RosterLoad = new RosterList();
                        RosterList.RosterLoad.LoadRoster();
                    }

                    //导入名单后自动启用名单
                    //2012-11-22 日本默认不启用名单 赵丽
                    if (GlobalInfo.OEMLogo != OEMLogos.oem3eAnalyzer)
                        GlobalInfo.response.EnableList = true;

                    //清除所有幻灯片的名单授权
                    PPTOper.ClearPersonAuthor();

                    (Globals.SunVoteARSAddIn.PPTEdit.Panel.PanelShow as IPanel).LoadData();//杨斌 2015-01-15

                    res = true;
                }
                else
                {
                    lblInfo.Text = GlobalInfo.SysLanguage.LPT.ReadString("FrmPollList", "ImportFail", "导入失败");
                }
            }
            catch (Exception ex)
            {
                SystemLog.WriterLog(ex);
            }
            finally
            {
                //dgvVoterList.Visible = true;
                this.Cursor = Cursors.Default;
            }

            return res;
        }

        /// <summary>
        /// 将名单存到模板数据库。杨斌 2015-03-31
        /// </summary>
        /// <returns></returns>
        private bool SaveRosterToTempDB(string[,] aryTable)
        {
            bool res = false;
            try
            {
                DBOper dbOper = new DBOper();
                //杨斌 2018-06-28
                dbOper.InitConnStrAccess(GlobalInfo.ACCESS_DATASOUREMODE, "");
                dbOper.OpenConn();
                GlobalInfo.UpdateDB(dbOper);//杨斌 2015-01-05
                Roster.SaveRoster(aryTable, true, dbOper, false);
                dbOper.CloseConn();
                res = true;
            }
            catch (Exception ex)
            {
                SystemLog.WriterLog(ex);
            }
            return res;
        }

        /// <summary>
        /// 创建 赵丽 2012-06-18 
        /// 删除名单
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnDelete_Click(object sender, EventArgs e)
        {
            ReSave = true;
            try
            {
                foreach (DataGridViewRow v in dgvVoterList.SelectedRows)//杨斌 2017-12-06
                {
                    dgvVoterList.Rows.Remove(v);
                }
                //if (dgvVoterList.CurrentRow != null)
                //    dgvVoterList.Rows.Remove(dgvVoterList.CurrentRow);
            }
            catch (Exception ex)
            {
                SystemLog.WriterLog(ex);
            }
        }

        /// <summary>
        /// 创建 赵丽 2012-06-18
        /// 添加名单
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnInsert_Click(object sender, EventArgs e)
        {
            ReSave = true;
            try
            {
                if (dgvVoterList.CurrentRow != null)
                    dgvVoterList.Rows.Insert(dgvVoterList.CurrentRow.Index + 1, 1);
                else
                    dgvVoterList.Rows.Add();
                ControlOper.SetGridRowH(dgvVoterList);//杨斌 2016-03-04
            }
            catch (Exception ex)
            {
                SystemLog.WriterLog(ex);
            }

        }

        /// <summary>
        /// 创建 赵丽 2012-06-18
        /// 检验数据
        /// </summary>
        /// <returns></returns>
        private bool CheckVoterData(out string msg)
        {
            List<string> keyidList = new List<string>();
            List<string> codeList = new List<string>();

            msg = "";
            //键盘编号不能为空，且不能重复
            for (int i = 0; i < dgvVoterList.Rows.Count; i++)
            {
                string keyID = "";
                string code = "";
                try
                {
                    keyID = dgvVoterList.Rows[i].Cells[0].EditedFormattedValue.ToString();
                }
                catch { }
                if (keyID.Length > 0)//加入签到码功能后，键盘编号可以为空。杨斌 2013-01-28
                {
                    //杨斌 2015-01-14 屏蔽检测
                    //if (!PublicFunction.IsMatchWith(keyID, "^[0-9]+"))
                    //{
                    //    msg = GlobalInfo.SysLanguage.LPT.ReadString(this.Name, "KeyIDFormat", "键盘编号只允许输入正整数"); return false;
                    //}
                    //if (Convert.ToInt32(keyID) == 0)
                    //{
                    //    msg = GlobalInfo.SysLanguage.LPT.ReadString(this.Name, "KeyIDFormat", "键盘编号只允许输入正整数"); return false;
                    //}

                    if (keyID == "") { msg = GlobalInfo.SysLanguage.LPT.ReadString(this.Name, "KeyIDNull", "键盘编号不允许为空"); return false; }
                    //keyID = Convert.ToInt32(keyID).ToString();//屏蔽。杨斌 2015-01-14
                    if (keyidList.Contains(keyID)) { msg = GlobalInfo.SysLanguage.LPT.ReadString(this.Name, "KeyIDRep", "键盘编号不允许重复"); return false; }
                    keyidList.Add(keyID);
                }
                if (GlobalInfo.response.SignInCodeIndex != 0)
                {
                    try
                    {
                        code = dgvVoterList.Rows[i].Cells[GlobalInfo.response.SignInCodeIndex].EditedFormattedValue.ToString();
                    }
                    catch { }
                    if (!PublicFunction.IsMatchWith(code, "^[0-9]+"))
                    {
                        msg = GlobalInfo.SysLanguage.LPT.ReadString(this.Name,
                            "SignCodeFormat", "签到码只允许输入数字"); return false;
                    }
                    if (code == "") { msg = GlobalInfo.SysLanguage.LPT.ReadString(this.Name, "SignCodeNull", "签到码字段不允许为空"); return false; }
                    if (codeList.Contains(code)) { msg = GlobalInfo.SysLanguage.LPT.ReadString(this.Name, "SignCodeRep", "签到码字段不允许重复"); return false; }
                    codeList.Add(code);
                }
            }
            //签到码的字段不能为空，且不能重复，不能为文字
            return true;
        }

        /// <summary>
        /// 创建 赵丽 2012-06-18 
        /// 判断是否含有中文
        /// </summary>
        /// <param name="srcString"></param>
        /// <returns></returns>
        private bool CheckEncode(string srcString)
        {
            int strLen = srcString.Length;
            //字符串的长度，一个字母和汉字都算一个  
            int bytLeng = System.Text.Encoding.UTF8.GetBytes(srcString).Length;
            //字符串的字节数，字母占1位，汉字占2位,注意，一定要UTF8  
            bool chkResult = false;
            if (strLen < bytLeng)
            //如果字符串的长度比字符串的字节数小，当然就是其中有汉字啦^-^  
            {
                chkResult = true;
            }
            return chkResult;
        }

        /// <summary>
        /// 创建 赵丽 2012-06-18
        /// 获取人员名单字段
        /// </summary>
        private void LoadVoterField()
        {
            try
            {
                cboFieldSignInCode.Items.Clear();
                for (int i = 0; i < dgvVoterList.ColumnCount; i++)
                {
                    cboFieldSignInCode.Items.Add(dgvVoterList.Columns[i].HeaderText);
                }
                cboFieldSignInCode.Items[0] = "";//杨斌 2013-01-30
                cboFieldSignInCode.SelectedIndex = GlobalInfo.response.SignInCodeIndex;

                //投票键盘权重。杨斌 2012-11-27
                cboFieldVoteRate.Items.Clear();
                cboFieldVoteRate.Items.Add("");
                for (int i = 1; i < dgvVoterList.ColumnCount; i++)
                {
                    cboFieldVoteRate.Items.Add(dgvVoterList.Columns[i].HeaderText);
                }
                cboFieldVoteRate.SelectedIndex = GlobalInfo.response.VoteRateIndex;
            }
            catch (Exception ex)
            {
            }

            try
            {
                //投票键盘权重限制，用于数字表决。杨斌 2017-06-02
                cboFeildVoteWeight.Items.Clear();
                cboFeildVoteWeight.Items.Add("");
                for (int i = 1; i < dgvVoterList.ColumnCount; i++)
                {
                    cboFeildVoteWeight.Items.Add(dgvVoterList.Columns[i].HeaderText);
                }

                if (cboFeildVoteWeight.Items.Contains(GlobalInfo.response.VoteWeightCol))
                    cboFeildVoteWeight.Text = GlobalInfo.response.VoteWeightCol;
                else
                    cboFeildVoteWeight.SelectedIndex = 0;
            }
            catch (Exception ex)
            {
            }
        }

        /// <summary>
        /// 创建：杨斌 2012-09-07
        /// 加载显示姓名的字段列表，以及显示学号的字段列表
        /// </summary>
        private void LoadShowNameField()
        {
            try
            {
                cboFiledShowName.Items.Clear();
                for (int i = 0; i < dgvVoterList.ColumnCount; i++)
                {
                    cboFiledShowName.Items.Add(dgvVoterList.Columns[i].HeaderText);
                }
                cboFiledShowName.Items[0] = "";
                if (cboFiledShowName.Items.Contains(GlobalInfo.response.ShowNameCol))//杨斌 2015-09-22
                    cboFiledShowName.Text = GlobalInfo.response.ShowNameCol;//杨斌 2013-12-23                 
            }
            catch (Exception ex)
            {
                SystemLog.WriterLog(ex, false);
            }

            try//杨斌 2015-09-22
            {
                cboFieldUID.Items.Clear();
                for (int i = 0; i < dgvVoterList.ColumnCount; i++)
                {
                    cboFieldUID.Items.Add(dgvVoterList.Columns[i].HeaderText);
                }
                cboFieldUID.Items[0] = "";

                cboFieldUID.Enabled = false;
                if (cboFieldUID.Items.Contains(GlobalInfo.response.UIDCol))
                    cboFieldUID.Text = GlobalInfo.response.UIDCol;//杨斌 2013-12-23                 
                cboFieldUID.Enabled = true;
            }
            catch (Exception ex)
            {
                SystemLog.WriterLog(ex, false);
                cboFieldUID.Enabled = true;
            }
        }

        /// <summary>.0
        /// 设置显示姓名的字段
        /// 杨斌 2013-12-23
        /// </summary>
        private void cboFiledShowName_SelectedIndexChanged(object sender, EventArgs e)
        {
            //屏蔽下面代码。固定第2列，放到导入后。杨斌 2014-10-23
            //GlobalInfo.response.ShowNameCol = cboFiledShowName.Text;
        }

        /// <summary>
        /// 2012-06-18
        /// 保存名单
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnSave_Click(object sender, EventArgs e)
        {
            string msg = "";
            if (CheckVoterData(out msg))
            {
                string[,] aryVoter = new string[dgvVoterList.Rows.Count + 1, dgvVoterList.Columns.Count];
                //添加表头
                for (int i = 0; i < dgvVoterList.ColumnCount; i++)
                {
                    try
                    {
                        aryVoter[0, i] = dgvVoterList.Columns[i].HeaderText;
                    }
                    catch { }
                }
                //添加名单内容
                for (int i = 0; i < dgvVoterList.Rows.Count; i++)
                {
                    for (int j = 0; j < dgvVoterList.Columns.Count; j++)
                    {
                        try
                        {
                            aryVoter[i + 1, j] = dgvVoterList.Rows[i].Cells[j].EditedFormattedValue.ToString();
                        }
                        catch { aryVoter[i + 1, j] = ""; }
                    }
                }
                //System.Diagnostics.Stopwatch t = System.Diagnostics.Stopwatch.StartNew();
                Roster.SaveRoster(aryVoter, false);//杨斌 2014-04-11。修正修改名单(非导入)后，按名单授权设置丢失
                //MessageBox.Show("SaveRoster" + t.ElapsedMilliseconds);//保存1000个5列名单要2秒。杨斌 2017-12-08
                ReSave = false;

                //this.Close();                
                //保存时不退出，并且按键盘编号重新排序。杨斌 2012-08-27   
                //1000个排序很慢。杨斌 2017-12-08
                //dgvVoterList.Visible = false;
                //for (int i = 0; i < dgvVoterList.Rows.Count; i++)
                //{
                //    if (dgvVoterList.Rows[i].Cells[KeypadCol].Value != null)//杨斌 2013-01-28
                //    {
                //        if (dgvVoterList.Rows[i].Cells[KeypadCol].Value.ToString().Length > 0)
                //        {
                //            int keyNo = 0;
                //            if (int.TryParse(dgvVoterList.Rows[i].Cells[KeypadCol].Value.ToString(), out keyNo))
                //                dgvVoterList.Rows[i].Cells[KeypadCol].Value = keyNo;

                //        }
                //    }
                //}
                //try
                //{                    
                //    dgvVoterList.Sort(dgvVoterList.Columns[KeypadCol], ListSortDirection.Ascending);
                //}
                //catch { }
                //dgvVoterList.Visible = true;

                //杨斌 2018-02-02
                if (RosterList.RosterLoad == null)
                    RosterList.RosterLoad = new RosterList();
                RosterList.RosterLoad.LoadRoster();
            }//数据符合规范
            else
            {
                MessageBox.Show(msg);
            }//数据不符合规范
        }

        /// <summary>
        /// 2012-06-18
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void cboFieldSignInCode_SelectedIndexChanged_1(object sender, EventArgs e)
        {
            GlobalInfo.response.SignInCodeIndex = cboFieldSignInCode.SelectedIndex;
        }

        /// <summary>
        /// 投票键盘权重
        /// 创建：杨斌 2012-11-27
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void cboFieldVoteRate_SelectedIndexChanged(object sender, EventArgs e)
        {
            GlobalInfo.response.VoteRateIndex = cboFieldVoteRate.SelectedIndex;
            GlobalInfo.response.EnableList = GlobalInfo.response.EnableList;//杨斌 2012-11-30
        }

        /// <summary>
        /// 2012-06-18 赵丽 添加签到码签到的列表
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void FrmVoterList_FormClosed(object sender, FormClosedEventArgs e)
        {
            //2013-2-25 赵丽 退出名单时 初始化名单信息
            GlobalInfo.response.InitRosterInfo();
            //保存签到码签到的信息
            GlobalInfo.response.SignInCode.Clear();
            for (int i = 0; i < dgvVoterList.Rows.Count; i++)
            {
                try
                {
                    GlobalInfo.response.SignInCode.Add(dgvVoterList.Rows[i].Cells[0].EditedFormattedValue.ToString(),
                         dgvVoterList.Rows[i].Cells[GlobalInfo.response.SignInCodeIndex].Value.ToString());
                }
                catch { }
            }
        }

        /// <summary>
        /// 2012-06-18 赵丽 
        /// 记录原值
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void dgvVoterList_CellEnter(object sender, DataGridViewCellEventArgs e)
        {

            try
            {
                cellOldValue = dgvVoterList.Rows[e.RowIndex].Cells[e.ColumnIndex].EditedFormattedValue.ToString();
            }
            catch
            {
                cellOldValue = "";
            }
        }

        /// <summary>
        /// 2012-06-18 赵丽
        /// 记录更改后的值，判断是否更新
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void dgvVoterList_CellEndEdit(object sender, DataGridViewCellEventArgs e)
        {
            string cellNewValue = "";
            try
            {
                cellNewValue = dgvVoterList.Rows[e.RowIndex].Cells[e.ColumnIndex].EditedFormattedValue.ToString();
            }
            catch { cellNewValue = ""; }
            if (cellOldValue != cellNewValue)
            {
                ReSave = true;
                //btnSave.Focus();
                btnSave_Click(null, null);
            }
            cellOldValue = cellNewValue;

        }

        /// <summary>
        /// 2012-06-18 赵丽
        /// 关闭窗口判断是否有更新
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void FrmVoterList_FormClosing(object sender, FormClosingEventArgs e)
        {
            string cellNewValue = "";
            try
            {
                cellNewValue = dgvVoterList.CurrentCell.EditedFormattedValue.ToString();
            }
            catch { cellNewValue = ""; }
            if (cellOldValue != cellNewValue)
                ReSave = true;
            cellOldValue = cellNewValue;
            if (ReSave)
            {
                btnSave_Click(null, null);
                //询问用户是否保存
                if (MessageBox.Show(GlobalInfo.SysLanguage.LPT.ReadString(this.Name, "IsSave", "当前数据已修改，是否保存"), GlobalInfo.GetAppName(), MessageBoxButtons.YesNo,
                    MessageBoxIcon.Question) == DialogResult.Yes)
                {
                    e.Cancel = true;
                    btnSave_Click(null, null);
                    e.Cancel = false;
                }
            }
            else
                e.Cancel = false;


        }

        /// <summary>
        /// 设置UID字段
        /// 杨斌 2015-09-22
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void cboFieldUID_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (!cboFieldUID.Visible)
                return;
            if (!cboFieldUID.Enabled)
                return;

            GlobalInfo.response.UIDCol = cboFieldUID.Text;

        }

        private void cboFeildVoteWeight_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (!cboFeildVoteWeight.Visible)
                return;
            if (!cboFeildVoteWeight.Enabled)
                return;

            GlobalInfo.response.VoteWeightCol = cboFeildVoteWeight.Text;
        }

        private void lblFieldUID_Click(object sender, EventArgs e)
        {

        }

        private void chkSelectShowCol_CheckedChanged(object sender, EventArgs e)
        {
            dgvSelectShowCol.Visible = chkSelectShowCol.Checked;
            if (dgvSelectShowCol.Visible)
                dgvVoterList.Top = dgvSelectShowCol.Bottom + 3;
            else
                dgvVoterList.Top = dgvSelectShowCol.Top;
            dgvVoterList.Height = pnlFill.Height - dgvVoterList.Top;
        }

        private void dgvSelectShowCol_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            if (!dgvSelectShowCol.Enabled)
                return;
            int row = e.RowIndex;
            int col = e.ColumnIndex;
            if (row < 0)
                return;
            if (col < 1)
                return;
            List<string> lstSel = new List<string>();
            for (int i = 1; i < dgvSelectShowCol.ColumnCount; i++)
            {
                DataGridViewCell dgcell = dgvSelectShowCol.Rows[row].Cells[i];
                bool ischk1 = (bool)dgcell.FormattedValue;//选中前  
                bool ischk2 = (bool)dgcell.EditedFormattedValue;//选中后  

                if (ischk2)
                    lstSel.Add(dgvSelectShowCol.Columns[i].HeaderText);
            }
            string selCol = string.Join("||", lstSel);
            ////this.Text = selCol;
            GlobalInfo.response.ShowReportCol = selCol;
        }

    }
}