using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Stone.WinBiz.BasicData;
using Stone.Entity;
using System.Windows.Forms;
using Stone.Common;
using Stone.WinBiz.SystemData;
using System.Data;
using Gm_WMS.DataAccess.DataService;

namespace Stone.WinBiz.JisData
{
    public class F_SequenceNo : F_Base
    {
        public string address = "";
        public F_SequenceNo(string _address)
        {
            address = _address;

            this.type = "SequenceNo";
            this.dateWhere = "[sysdtm]>='{0}' and [sysdtm]<='{1}'";
            this.strOrder = "[SequenceNo] asc";
            this.entity = new Entity_t_SequenceNo();
            this.name = $"连续号管理-{F_Common.GetAddress(_address)}";

        }       

        public override void GetView(DataGridView dgv)
        {
            base.GetView(dgv);

        }

        public override void BindPageData(string strWhere)
        {
            if (entityView == null) entityView = entity;

            dsMain = entityView.GetData("", $"({strWhere}) and [Address]='{address}'", strOrder);
            dsMain.Tables[0].TableName = "Data";
        }

        public override void Input(string filename)
        {
            DataSet dsInput = null;

            Stone.Common.MyExcelDatabase.OpenDatabase(filename, true);
            dsInput = Stone.Common.MyExcelDatabase.ExecuteDataSet("select * from [TCFlastweek$]");
            Stone.Common.MyExcelDatabase.CloseDatabase();



            LocalDBService db = null;
            try
            {

                db = new LocalDBService();
                db.BeginTrans();

                InputData(dsInput, db);

                db.Commit();
            }
            catch (Exception ex)
            {
                if (db != null) db.Rollback();
                throw new Exception("导入数据失败!\r\n" + "原因为：\r\n" + ex.Message);
            }
            finally
            {
                if (db != null) db.EndTrans();
            }


            Stone.WinBiz.BasicData.F_Log.WriteLog("导入Excel[" + this.name + "]");


        }

        public override void InputData(DataSet dsData, LocalDBService db)
        {
            Entity_t_SequenceNo t_SequenceNo = new Entity_t_SequenceNo(db);
            Entity_t_CarType t_CarType = new Entity_t_CarType(db);
            var carType = t_CarType.GetData().Tables[0];
            var importBatch = DateTime.Now.ToString("yyMMddHHmm");
            foreach (DataRow drData in dsData.Tables[0].Rows)
            {
                string ProductionNo = drData["Production number"].ToString().Trim();
                string SequenceNo = drData["Shift numbers"].ToString();
                string Model = drData["Model"].ToString().Trim().ToUpper();

                if (ProductionNo == "") continue;
                if (SequenceNo == "") continue;

                // if (Model != "156" && Model != "177" && Model != "247" && Model != "H247")  //过滤车型
                //     continue;
                var compareModel = Model.Substring(Model.Length - 3);
                //获取系统中的车型
                var isFind = 0;
                for (int i = 0; i < carType.Rows.Count; i++)
                {
                    var sysCarType = carType.Rows[i]["Code"].ToString();
                    if (sysCarType.Contains(compareModel))
                    {
                        isFind = 1;
                        break;
                    }
                }
                if(isFind == 0) continue;

                DataTable dtSequenceNo = t_SequenceNo.GetData($"[Address]='{address}' and [ProductionNo]='{ProductionNo}'").Tables[0];
                if (dtSequenceNo.Rows.Count > 0)
                {
                    if(dtSequenceNo.Rows[0]["SequenceNo"].ToString().Trim() == "")
                    {
                        t_SequenceNo.Del(dtSequenceNo.Rows[0]);
                    }
                    else
                    {
                        t_SequenceNo.Del(dtSequenceNo.Rows[0]);
                        // continue;
                    }
                }

                if(SequenceNo.Length > 3)
                {
                    SequenceNo = SequenceNo.Substring(0, 12) + SequenceNo.Substring(SequenceNo.Length - 3, 3);
                }


                DataRow drInput = t_SequenceNo.Table.NewRow();
                drInput["Address"] = address;
                drInput["ProductionNo"] = ProductionNo;
                drInput["Model"] = Model;
                drInput["SequenceNo"] = SequenceNo;
                drInput["UserName"] = User.UserInfo.UserName;
                drInput["ImportBatch"] = importBatch;
                t_SequenceNo.Add(drInput);
            }

        }

    }
}