MES_Client/TGMES/Core.StlMes.Client.ZGMil/Cost/FrmTqnqc15.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Collections;
using System.Data;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Reflection;
using System.Text;
using System.Windows.Forms;
using com.steering.mes.mcp.entity;
using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Format;
using Core.Mes.Client.Comm.Tool;
using CoreFS.CA06;
using Infragistics.Win;
using Infragistics.Win.UltraWinGrid;
using NPOI.SS.UserModel;
using Core.StlMes.Client.ZGMil.Entity;

namespace Core.StlMes.Client.ZGMil.Cost
{
    public partial class FrmTqnqc15 : FrmBase
    {
        public FrmTqnqc15()
        {
            InitializeComponent();
        }

        private void FrmTqnqc14_Load(object sender, EventArgs e)
        {
            
            EntityHelper.ShowGridCaption<Tqnqc15Entity>(ultraGrid1.DisplayLayout.Bands[0]);
            Query();
        }
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "DoQuery":
                    Query();
                    break;
                case "doImport":
                    Import();
                    break;
                case "doSave":
                    break;
                case "doUpdate":
                    Update();
                    break;
                case "doDelete":
                    delete();
                    break;
                case "Close":
                    Close();
                    break;
            }
        }
        //导入
        private void Import() 
        {
            List<Tqnqc15Entity> list = null;
            var openFileDialog = new OpenFileDialog
            {
                Filter = "合金价格基础信息|*.xls;*.xlsx"
            };
            if (openFileDialog.ShowDialog() == DialogResult.OK)
            {
                list = ReadExcelToRtdTqnqc14Entity(openFileDialog.FileName);

            }
            if (list == null) return;
            if (list.Count <= 0)
            {
                MessageBox.Show("Excel无数据");
                return;
            }
            string userName = UserInfo.GetUserName();
            var ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.cost.FrmTqnqc15";
            ccp.MethodName = "DoAddTqnqc15";
            ccp.ServerParams = new object[]
                {
                    list.Select(JSONFormat.Format).ToList(),
                    userName
                };
            ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("新增成功"))
                {
                    Query();
                }
            }
        }

        private void delete()
        {
            this.ultraGrid1.UpdateData();
            IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowTips("请选择需要删除的数据！");
                return;
            }
            ArrayList parm = new ArrayList();
            foreach (UltraGridRow uRow in checkMagRows)
            {
                Tqnqc15Entity Tqnqc15Result = (Tqnqc15Entity)uRow.ListObject;
                string Tqnqc15Results = JSONFormat.Format(Tqnqc15Result);
                parm.Add(Tqnqc15Results);
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.cost.FrmTqnqc15";
            ccp.MethodName = "doDelete";
            ccp.ServerParams = new object[] { parm };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                if (ccp.ReturnInfo.Equals("操作成功"))
                {
                    // DoQueryInList();
                    Query();
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
            }
        }

        private void Update()
        {
            this.ultraGrid1.UpdateData();
            IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowTips("请选择需要修改的数据！");
                return;
            }
            ArrayList parm = new ArrayList();
            foreach (UltraGridRow uRow in checkMagRows)
            {
                Tqnqc15Entity entity = (Tqnqc15Entity)uRow.ListObject;
                entity.RecRevisor = UserInfo.GetUserName();
                string Tqnqc15ResultTity = JSONFormat.Format(entity);
                parm.Add(Tqnqc15ResultTity);
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.cost.FrmTqnqc15";
            ccp.MethodName = "doSave";
            ccp.ServerParams = new object[] { parm };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                if (ccp.ReturnInfo.Equals("操作成功"))
                {
                    // DoQueryInList();
                    Query();
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
            }
        }
        private void Query()
        {

            string name = "";
            string code = "";
            string yearmonth = "";
            if (chk_name.Checked == true)
            {
                name = text_name.Text;
            }
            if (chk_code.Checked == true)
            {
                code = text_code.Text;
            }
            if (chkTim.Checked == true)
            {
                yearmonth = this.StartTime.Value.ToString("yyyyMM");
            }
            List<Tqnqc15Entity> listSource = EntityHelper.GetData<Tqnqc15Entity>(
               "com.steering.mes.cost.FrmTqnqc15.doQuery", new object[] { name, code, yearmonth }, this.ob);
            tqnqc15EntityBindingSource.DataSource = listSource;
           // GridHelper.RefreshAndAutoSize(ultraGrid1);
        }

        public List<Tqnqc15Entity> ReadExcelToRtdTqnqc14Entity(string fileName)
        {
            //定义要返回的datatable对象
            List<Tqnqc15Entity> Tqnqc15Entitys = new List<Tqnqc15Entity>();
            try
            {
                if (!File.Exists(fileName))
                {
                    return null;
                }
                //根据指定路径读取文件
                using (FileStream fs = new FileStream(fileName, FileMode.Open, FileAccess.Read))
                {
                    //根据文件流创建excel数据结构
                    NPOI.SS.UserModel.IWorkbook workbook = NPOI.SS.UserModel.WorkbookFactory.Create(fs);
                    //IWorkbook workbook = new HSSFWorkbook(fs);

                    for (int k = 0; k < workbook.NumberOfSheets; k++)
                    {
                        NPOI.SS.UserModel.ISheet sheet = workbook.GetSheetAt(k);
                        if (sheet != null)
                        {
                            //最后一列的标号
                            int rowCount = sheet.LastRowNum;
                            for (int i = 1; i <= rowCount; ++i)
                            {
                                Tqnqc15Entity entity = new Tqnqc15Entity();
                                NPOI.SS.UserModel.IRow row = sheet.GetRow(i);
                                if (row == null) continue; //没有数据的行默认是null　　　　　　　

                                if (row.Cells.Count < 6)
                                {
                                    throw new Exception("无足够列");
                                }

                                string yearMonth = GetCellValue(row.Cells[0]);
                                string mName = GetCellValue(row.Cells[1]);
                                string mCode = GetCellValue(row.Cells[2]);

                                if (yearMonth == "" || yearMonth == null)
                                {
                                    throw new Exception("月份不能为空");
                                }
                                if (mName == "" || mName == null)
                                {
                                    throw new Exception("物料名称不能为空");
                                }
                                if (mCode == "" || mCode == null)
                                {
                                    throw new Exception("物料编码不能为空");
                                }
                                decimal alloyPrice;
                                decimal alloyPriceNext;
                                decimal alloyPriceNow;

                                decimal.TryParse(GetCellValue(row.Cells[3]), out alloyPrice);
                                decimal.TryParse(GetCellValue(row.Cells[4]), out alloyPriceNext);
                                decimal.TryParse(GetCellValue(row.Cells[4]), out alloyPriceNow);
                                if (alloyPrice == null || alloyPrice <= 0)
                                {
                                    throw new Exception("当前市场采购价异常");
                                }
                                if (alloyPriceNext == null || alloyPriceNext <= 0)
                                {
                                    throw new Exception("次月市场采购价异常");
                                }
                                if (alloyPriceNow == null || alloyPriceNow <= 0)
                                {
                                    throw new Exception("当前库存价异常");
                                }
                                entity.YearMonth = yearMonth;
                                entity.MaterialName = mName;
                                entity.MaterialCode = mCode;
                                entity.AlloyPrice = alloyPrice;
                                entity.AlloyPriceNext = alloyPriceNext;
                                entity.AlloyPriceNow = alloyPriceNow;
                                entity.RecCreator = UserInfo.GetUserName();
                                Tqnqc15Entitys.Add(entity);
                            }

                        }
                    }
                }
                return Tqnqc15Entitys;
            }
            catch (Exception ex)
            {
                MessageBox.Show("EXCEL格式错误:" + ex.Message);
                return null;
            }
        }

        private string GetCellValue(ICell cell)
        {
            string value = "";
            switch (cell.CellType)
            {
                case CellType.Blank:
                    value = "";
                    break;
                case CellType.Numeric:
                    short format = cell.CellStyle.DataFormat;

                    value = cell.NumericCellValue.ToString2();
                    break;
                case CellType.String:
                    value = cell.StringCellValue;
                    break;
            }
            return value;
        }


    }
}