lserp_cs_6.0/插件库/Lskj.PubBillDetail2/FrmImportBarCode.cs

/***********************
* 说明：条码导入模块
* 创建人：龚宇超
* 创建日期：2018-05-02
* 修改人：
* 修改日期：
* 修改备注：
* 版本：1.0.0.0
***********************/
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 Lskj.Control;
using Lskj.Control.Model;
using Lskj.Util;
using Lskj.Business.Impl;
using Lskj.Data;
using DevExpress.XtraGrid.Columns;
using Lskj.Business;

namespace Lskj.PubBillDetail
{
    public partial class FrmImportBarCode : BaseForm
    {
        public FrmImportBarCode()
        {
            InitializeComponent();
        }
        /// <summary>
        /// 注册事件
        /// </summary>
        /// <param name="uCode"></param>
        /// <param name="uAmount"></param>
        /// <param name="uGroup"></param>
        /// <param name="uJydh"></param>
        public delegate bool AddBarCodeEventHandler(string uCode, string uAmount, string uGroup, string uJydh);
        public AddBarCodeEventHandler AddBaeCodeEvent;
        /// <summary>
        /// 导入数据源
        /// </summary>
        private DataTable _dtImport = new DataTable();

        /// <summary>
        /// <para>说明：窗体加载时</para>
        /// <para>创建人：龚宇超</para>
        /// <para>创建日期：2018-05-02 </para>
        /// <para>修改人：</para>
        /// <para>修改日期：</para>
        /// <para>修改备注：</para>
        /// <para>版本：1.0</para>
        /// </summary>
        /// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param>
        protected override void OnLoad(EventArgs e)
        {
            try
            {
                this.gridImport.SetEditColumns(BillImpl.SetBarCodeImportantColumns());
            }
            catch (Exception ex)
            {
                string Message = ErrorMessage.PromptErrorMessage(ex);
                MessageUtil.Show(Message,ex.Message);
            }
        }
        /// <summary>
        /// <para>说明：读取Excel</para>
        /// <para>创建人：龚宇超</para>
        /// <para>创建日期：2018-05-02 </para>
        /// <para>修改人：</para>
        /// <para>修改日期：</para>
        /// <para>修改备注：</para>
        /// <para>版本：1.0</para>
        /// </summary>
        private void btnReadExl_Click(object sender, EventArgs e)
        {
            try
            {
                OpenFileDialog ofd = new OpenFileDialog();
                ofd.Title = "导入文件选择";
                ofd.Filter = "Excel文件(*.xls)|*.xls";
                if (ofd.ShowDialog() == DialogResult.OK)
                {
                    _dtImport = this.gridImport.GridView.ToExcelDataTable(ofd.FileName, "");
                    DataColumn check = new DataColumn();
                    check.ColumnName = "xd";
                    check.DataType = System.Type.GetType("System.Boolean");
                    check.DefaultValue = false;
                    _dtImport.Columns.Add(check);
                    this.gridImport.SetGridViewDataSource(_dtImport);
                }
            }
            catch (Exception ex)
            {
                string Message = ErrorMessage.PromptErrorMessage(ex);
                MessageUtil.Show(Message,ex.Message);
            }
        }
        /// <summary>
        /// <para>说明：确认导入</para>
        /// <para>创建人：龚宇超</para>
        /// <para>创建日期：2018-05-02 </para>
        /// <para>修改人：</para>
        /// <para>修改日期：</para>
        /// <para>修改备注：</para>
        /// <para>版本：1.0</para>
        /// </summary>
        private void btnConfirmImport_Click(object sender, EventArgs e)
        {
            try
            {
                if (MessageUtil.Show(ResourceKeys.IsImportantSelectBarCode, MessageBoxButtons.YesNo) == DialogResult.Yes)
                {
                    for (int i = 0; i < gridImport.GridView.DataRowCount; i++)
                    {
                        DataRow row = this.gridImport.GridView.GetDataRow(i);
                        if (Convert.ToBoolean(row["xd"]))
                        {
                            if (!AddBaeCodeEvent(row["条码"] + "", row["数量"] + "", row["分组"] + "", row["检验单号"] + "")) return;
                        }
                    }
                    MessageUtil.Show(ResourceKeys.BarCodeImportFinish);
                    for (int row = gridImport.GridView.DataRowCount - 1; row >= 0; row--)
                    {
                        DataRow dataRow = this.gridImport.GridView.GetDataRow(row);
                        if (Convert.ToBoolean(dataRow["xd"]))
                        {
                            dataRow.Delete();
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                LogUtil.WriteError("确认导入出错！", ex);
                //MessageUtil.Show("确认导入出错！" + ex);
                string Message = ErrorMessage.PromptErrorMessage(ex);
                MessageUtil.Show(Message,ex.Message);
            }

        }
        /// <summary>
        /// <para>说明：关闭</para>
        /// <para>创建人：龚宇超</para>
        /// <para>创建日期：2018-05-02 </para>
        /// <para>修改人：</para>
        /// <para>修改日期：</para>
        /// <para>修改备注：</para>
        /// <para>版本：1.0</para>
        /// </summary>
        private void btnClose_Click(object sender, EventArgs e)
        {
            try
            {
                this.DialogResult = DialogResult.Cancel;
            }
            catch (Exception ex)
            {
                //MessageUtil.Show(ex);
                string Message = ErrorMessage.PromptErrorMessage(ex);
                MessageUtil.Show(Message,ex.Message);
            }

        }
        /// <summary>
        /// <para>说明：全选</para>
        /// <para>创建人：龚宇超</para>
        /// <para>创建日期：2018-05-02 </para>
        /// <para>修改人：</para>
        /// <para>修改日期：</para>
        /// <para>修改备注：</para>
        /// <para>版本：1.0</para>
        /// </summary>
        private void btnAllSelect_Click(object sender, EventArgs e)
        {
            try
            {
                foreach (DataRow datarow in _dtImport.Rows)
                {
                    if (Convert.ToBoolean(datarow["xd"]) == false)
                    {
                        datarow["xd"] = true;
                    }
                }
            }
            catch (Exception ex)
            {
                //MessageUtil.Show(ex);
                string Message = ErrorMessage.PromptErrorMessage(ex);
                MessageUtil.Show(Message,ex.Message);
            }

        }
        /// <summary>
        /// <para>说明：反选</para>
        /// <para>创建人：龚宇超</para>
        /// <para>创建日期：2018-05-02 </para>
        /// <para>修改人：</para>
        /// <para>修改日期：</para>
        /// <para>修改备注：</para>
        /// <para>版本：1.0</para>
        /// </summary>
        private void btnInverseSelect_Click(object sender, EventArgs e)
        {
            try
            {
                foreach (DataRow row in _dtImport.Rows)
                {
                    row["xd"] = !Convert.ToBoolean(row["xd"]);
                }
                this.gridImport.SetGridViewDataSource(_dtImport);
            }
            catch (Exception ex)
            {
                //MessageUtil.Show(ex);
                string Message = ErrorMessage.PromptErrorMessage(ex);
                MessageUtil.Show(Message,ex.Message);
            }

        }
        /// <summary>
        /// <para>说明：导出</para>
        /// <para>创建人：龚宇超</para>
        /// <para>创建日期：2018-05-02 </para>
        /// <para>修改人：</para>
        /// <para>修改日期：</para>
        /// <para>修改备注：</para>
        /// <para>版本：1.0</para>
        /// </summary>
        private void btnExport_Click(object sender, EventArgs e)
        {
            try
            {
                GridColumn Column = gridImport.GridView.Columns.ColumnByFieldName("xd");
                Column.Visible = false;
                this.gridImport.gridControl.ToExcel("条码导出");
                Column.Visible = true;
            }
            catch (Exception ex)
            {
                //MessageUtil.Show(ex); 
                string Message = ErrorMessage.PromptErrorMessage(ex);
                MessageUtil.Show(Message,ex.Message);
            }

        }
    }
}