using DBUtility;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using SQLHelper;
using System;
using System.Collections.Generic;
using System.Data;
using System.IO;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web;
using System.Web.Http;
using System.Web.Script.Serialization;
using WebAPI.Code;
using WebAPI.Models;
using WebAPI.Utility;

namespace WebAPI.Controllers
{
    public class SRM_MaterialBarCodeBillController : ApiController
    {
        private JsonResult objJsonResult = new JsonResult();
        private json objjson = new json();
        public new ClsCN oCn = new ClsCN();
        //获取系统参数
        Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();
        // GET: SRM_MaterialBarCodeBill
        #region 条码批量生辰
        [Route("GetSRMHBarCodeShowBillMain")]
        public object GetSRMHBarCodeShowBillMain(string HInterID)
        {
            try
            {
                DataSet ds;
                string s = "";
                string ShowItem = " * ";//显示的字段
                //if (DBUtility.ClsPub.isLong(HInterID) == 0)
                //{
                //    objjson.code = "0";
                //    objjson.count = 0;
                //    objjson.Message = "获取失败";
                //    objjson.data = null;
                //    return objjson;
                //}
                DAL.ClsWeb_BarCodeBill oClsWeb_BarCodeBill = new DAL.ClsWeb_BarCodeBill();
                //string sql = string.Format(@"select * from h_v_Cg_POOrderBillMain_ForWeb2 where HInterID = " + sMsg);
                string sql = string.Format(@"select * from h_v_SRM_BarCodeBill where HItemID in  ( " + HInterID + ")");
                ds = oCn.RunProcReturn(sql, "h_v_SRM_BarCodeBill");
                //ds = oClsWeb_BarCodeBill.ShowBillMain1(DBUtility.ClsPub.isLong(sMsg), ShowItem, ref DBUtility.ClsPub.sExeReturnInfo);
                if (ds == null || ds.Tables[0].Rows.Count == 0)
                {
                    objjson.code = "0";
                    objjson.count = 0;
                    objjson.Message = "获取失败";
                    objjson.data = null;
                    return objjson;
                }
                else
                {

                    objjson.code = "0";
                    objjson.count = 10000;
                    objjson.Message = "获取成功";
                    objjson.data = ds.Tables[0];
                    return objjson;
                }
            }
            catch (Exception e)
            {
                objjson.code = "0";
                objjson.count = 0;
                objjson.Message = "获取失败" + e.ToString();
                objjson.data = null;
                return objjson;
            }
        }
        #endregion

        #region 条码保存
        [Route("SRM_MaterialBarCodeBillController/GetBarcodeSaveBillBoxBycg")]
        [HttpPost]
        /// <summary>
        /// 生成条码 
        /// </summary>
        /// <param name="msg"></param>
        /// <param name="msg2"></param>
        /// <returns></returns>
        public object GetBarcodeSaveBillBoxBycg([FromBody] JObject msg)
        {
            string FCusName = oSystemParameter.GetSingleSystemParameter("WMS_CampanyName", ref DBUtility.ClsPub.sExeReturnInfo);
            var _value = msg["msg"].ToString();
            string msg1 = _value.ToString();
            string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
            string msg2 = sArray[0].ToString();//
            string msg3 = sArray[1].ToString();// 
            string UserName = sArray[2].ToString();
            string OrganizationID = sArray[3].ToString();
            ListModels oListModels = new ListModels();
            try
            {
                #region 获取用户以及相关参数
                List<Model.Cls_MaterialHandingModel> lsmain = new List<Model.Cls_MaterialHandingModel>();
                msg2 = msg2.Replace("\\", "");
                msg2 = msg2.Replace("\n", "");  //\n
                lsmain = oListModels.getObjectByJson_MaterialHanding(msg2);
                int get_BarCodecount = 0;
                
                foreach (Model.Cls_MaterialHandingModel oItem in lsmain)
                {
                    get_BarCodecount++;
                    //UserName = oItem.HMaker;
                }
                DAL.ClsWeb_BarCodeBill oBill = new DAL.ClsWeb_BarCodeBill();
                msg3 = msg3.Substring(1, msg3.Length - 2);
                msg3 = msg3.Replace("\\", "");
                msg3 = msg3.Replace("\n", "");  //\n
                #endregion
                List<Model.ClsGy_MaterialBarCodeBillModel> ls = new List<Model.ClsGy_MaterialBarCodeBillModel>();

                ls = oListModels.getObjectByJson_BarCodeBill(msg3);//列表数据model

                if (ls.Count > 1)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "每次只允许选择一个物料生成条码，请退出重新选择一行物料，不允许选择多行物料！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                #region 数据准备
                long linterid = Pub_Class.ClsPub.CreateBillID_SRMProd("8888", ref DBUtility.ClsPub.sExeReturnInfo);
                int LSHlen = 6;             //流水号长度
                int SumLen = 10;            //总长度
                string TM = "";             //条码
                double HSumQty = 0;         //产品数量
                int LSH = 0;                //流水号
                string LSH2 = "";           //流水号转换成字符
                string sDate = "";            //日期
                string sYear = "";          //年
                string sPeriod = "";        //月
                string sDay = "";            //日
                string WeiShu = ""; //尾数
                string HKFDQDate= ls[0].HKFDQDate;//到期日期
                long HKFPeriod= (ls[0].HKFPeriod.ToString()==""?0: ls[0].HKFPeriod);//保质期
                string HKFDate= ls[0].HKFDQDate==null? DateTime.Now.ToString("yyyy/MM/dd"): ls[0].HKFDQDate;//生产日期
                string HKFDate_1 = string.Join("", HKFDate.Split('/').Select(x => x.PadLeft(2, '0')));
                double HMinQty= ls[0].HMinQty;//标准包装数
                string HStatusMan = ls[0].HStatusMan;//工号
                //string HBarCodeDate = ls[0].HBarCodeDate;//工号
                string HBarCodeDate = ls[0].HBarCodeDate == null ? DateTime.Now.ToString("yyyy/MM/dd") : ls[0].HBarCodeDate;//条码日期
                string HBarCodeDate_1 = string.Join("", HBarCodeDate.Split('-').Select(x => x.PadLeft(2, '0')));

                double HBQty = ls[0].HBQty;//最小包装数
                long HISKFPERIOD= ls[0].HISKFPERIOD;//是否启用保质期
                long HBatchManager= ls[0].HBatchManager;//是否启用批号

                string HSourceBillType= ls[0].HSourceBillType;//条码类型

                string HBatchNo= ls[0].HBatchNo==null?"": ls[0].HBatchNo;//批号
                //物料
                long HMaterID=ls[0].HMaterID;
                string HMaterNumber= ls[0].HMaterNumber;
                string HMaterShortNumber = ls[0].HMaterShortNumber;
                string HMaterName = ls[0].HMaterName;
                //供应商
                long HSupID = lsmain[0].HSupID;
                string HMaker= ls[0].HMaker;
                DateTime HMakeDate= ls[0].HMakeDate;
                double HQty= ls[0].HQty; //本次生成条码数量
                double biaoqianzhangshu= ls[0].biaoqianzhangshu;
        //流水号
        DataSet Ds;
                SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
                oCn.BeginTran();
                //Ds = oCn.RunProcReturn("exec GetLSH '" + DateTime.Today + "'", "GetLSH");
                Ds = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + HSupID+"_"+ HMaterID+"_" + HBarCodeDate + "'", "GetLSH");
                LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]);
                #endregion

                //// 存储生成的条码列表
                List<string> generatedBarcodes = new List<string>();

                var biaoqianCount = 0;
                foreach (Model.ClsGy_MaterialBarCodeBillModel oItemSub in ls)
                {
                    biaoqianzhangshu = ls[biaoqianCount].biaoqianzhangshu;
                    biaoqianCount++;
                    //数量为0 跳过
                    if (oItemSub.HQty == 0 || oItemSub.HMinQty == 0 )
                        continue;
                    if(oItemSub.HBatchManager!=0&&oItemSub.HBatchNo=="")
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "已启用批号，批号不能为空，请核对";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                    if (oItemSub.HISKFPERIOD != 0 && oItemSub.HKFPeriod == 0)
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "已启用保质期，保质期不能为0，请核对";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                    string sql = "";
                    if (ClsPub.isLong(oItemSub.HMaterID) != 0)
                    {

                        HMaterID = oItemSub.HMaterID;//物料代码
                        HQty = ClsPub.isDoule(oItemSub.HQty);//本次生成条码数量
                        HBQty = ClsPub.isInt(oItemSub.HBQty);//最小包装数（内箱数）
                        HMinQty = ClsPub.isDoule(oItemSub.HMinQty);//标准包装数
                        int virtualCount = 1;//实际上插入数量
                        // HSumQty = ClsPub.isDoule(oItemSub.HQty);  //产品数量
                       for (int i = 0; i < biaoqianzhangshu; i++)
                        {
                            double currentQty = (i == biaoqianzhangshu - 1 && (HQty % HMinQty != 0))
                              ? (HQty % HMinQty)
                              : HMinQty;
                            ///供应商名称+@+物料代码+@+物料简称+@+数量+@条码数+@+日期+@+流水号  
                            LSH += 1;
                            TM = $"{oItemSub.HSupName}@{oItemSub.HMaterNumber}@{oItemSub.HSubjoin}@{currentQty}@{HBarCodeDate_1}@{LSH.ToString("D7")}";
                            //TM = $"{oItemSub.HSupName}@{oItemSub.HMaterID}@{oItemSub.HMaterName}@{oItemSub.biaoqianzhangshu}@{HKFDate_1}@{LSH}";
                            // 添加到生成的条码列表
                            generatedBarcodes.Add(TM);
                            Model.ClsGy_BarCodeBill_WMS_Model bar = new Model.ClsGy_BarCodeBill_WMS_Model();

                           // var HBarCode_verify = TM.Split('@'); //校验条码信息
                           // var HMaterNumber_verify = HBarCode_verify[0]; //校验物料编码
                           // var HMaterName_verify = HBarCode_verify[1]; //校验物料名称
                           // //var HMaterModel_verify = HBarCode_verify[2]; //校验规格型号
                           // var HSupName_verify = HBarCode_verify[7]; //校验供应商
                           //// var HSourceBillNo_verify = HBarCode_verify[8]; //校验采购订单号

                           // sql = $"select * from Gy_Material where HNumber = '{HMaterNumber_verify}' and HName = '{HMaterName_verify}'";
                           // DataSet verifyMatInfo = oCn.RunProcReturn(sql, "tables");


                           // sql = $"select * from Gy_Supplier where HName = '{HSupName_verify}'";
                           // DataSet verifySupInfo = oCn.RunProcReturn(sql, "tables");
                            string HBarCodeType = "唯一条码";
                            //sql = "insert into Gy_BarCodeBill (HInterID,HBarCode,HBarCodeType,HMaterID,HUnitID,HQty,HKFDate,HKFPeriod,HKFDQDate" +
                            //               ",HBatchNo,HBarcodeQtys,HBarcodeNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HEndQty,HSupflag" +
                            //               ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HMTONO,HProduceDate,HExpiryDate,HISKFPERIOD" +
                            //               ") values ("
                            //               + linterid.ToString() + ",'" + TM + "','" + HBarCodeType + "'," + HMaterID + "," + "" + "," + HQty + ",'" + HKFDate + "'," + HKFPeriod + ",'" + HKFDQDate
                            //               + "','" + HBatchNo + "','" + get_BarCodecount + "','" + virtualCount + "'," + HSupID + "," + "" + ",'" + ClsPub.CurUserName + "','" + DateTime.Today + "'," + "1" + ",'" + DateTime.Today + "',1"
                            //               + "," + "1" + "," + "1" + ",'" + "1" + "','" + HSourceBillType + "','" + "1" + "','"
                            //               + HKFDate + "','" + HKFDQDate + "'," + HISKFPERIOD + ")";
                            sql = "INSERT INTO Gy_BarCodeBill (HInterID, HBarCode, HBarCodeType, HMaterID, HUnitID, HQty, HKFDate, HKFPeriod, HKFDQDate, " +
       "HBatchNo, HBarcodeQtys, HBarcodeNo, HSupID, HGroupID, HMaker, HMakeDate, HPrintQty, HEndQty, HSupflag, " +
       "HSourceInterID, HSourceEntryID, HSourceBillNo, HSourceBillType, HMTONO, HProduceDate, HExpiryDate, HISKFPERIOD,HStatusMan,HBarCodeDate,HinitQty,HSTOCKORGID,HOWNERID) " +
      "VALUES (" +
       linterid.ToString() + ", '" + TM + "', '" + HBarCodeType + "', " + HMaterID + ", " + "0" + ", " + currentQty + ", '" + null + "', " + HKFPeriod + ", '" + null + "', " +
       "'" + HBatchNo + "', " + get_BarCodecount + ", '" + virtualCount + "', " + HSupID + ", " + "0" + ", '" + UserName + "',getdate()" + "," + "0" + ", " + "0" + ", 1, " +
       "0, 0, '', '" + HSourceBillType + "', '', '" +
       null + "', '" + null + "', " + HISKFPERIOD + ",'" + HStatusMan + "','" + HBarCodeDate + "','" + currentQty + "'," + OrganizationID + "," + OrganizationID + "," + null + ")";
                            LogService.Write("生成条码： " + sql);
                            oCn.RunProc(sql); 
                            oCn.RunProc("exec h_p_WMS_SetMaxNo '" + HSupID + "_" + HMaterID + "_" + HBarCodeDate + "'");
                            virtualCount++;
                           }

                        }
                }
                oCn.Commit();
                // 返回生成的条码列表
                objJsonResult.code = "0";
                objJsonResult.count = 1;
                objJsonResult.Message = "生成条码成功！";
                objJsonResult.data =string.Join("~", generatedBarcodes); // 返回生成的条码列表
                WebAPIController.Add_Log("条码下推", UserName, "生成条码");
                return objJsonResult;
            }
            catch (Exception e)
            {
                LogService.Write("生成条码发生错误： " + e);
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "" + e.Message + DBUtility.ClsPub.sExeReturnInfo;
                objJsonResult.data = null;
                return objJsonResult;
            }

            
        }
        #endregion

        #region 条码列表
        [Route("showHBarCodeBillDetail")]
        [HttpGet]
        public object showHBarCodeBillDetail(string sMsg,string user)
        {
            try
            {
                DataSet ds;
                string s = "";
                string ShowItem = " * ";//显示的字段
                if (sMsg == "")
                {
                    objjson.code = "0";
                    objjson.count = 0;
                    objjson.Message = "获取失败";
                    objjson.data = null;
                    return objjson;
                }
                string sql = string.Format(@"select * from h_v_Gy_UserMaterRelationPrint where HItemID in (   " + sMsg)+")";
                ds = oCn.RunProcReturn(sql, "h_v_Gy_UserMaterRelationPrint");
                if (ds == null || ds.Tables[0].Rows.Count == 0)
                {
                    objjson.code = "0";
                    objjson.count = 0;
                    objjson.Message = "获取失败" + DBUtility.ClsPub.sExeReturnInfo;
                    objjson.data = null;
                    return objjson;
                }
                else
                {
                    objjson.code = "0";
                    objjson.count = 1;
                    objjson.Message = "获取成功！";
                    objjson.data = ds.Tables[0];
                    return objjson;

                }
            }
            catch (Exception e)
            {
                objjson.code = "0";
                objjson.count = 0;
                objjson.Message = "获取单据表体失败:" + e.Message;
                objjson.data = null;
                return objjson;
            }
        }
        #endregion

        #region 根据条码获取条码详情
        [Route("GetBarcodeDetails")]
        [HttpGet]
        public object GetBarcodeDetails(string barcodes)
        {
            try
            {
                if (string.IsNullOrEmpty(barcodes))
                {
                    objjson.code = "0";
                    objjson.count = 0;
                    objjson.Message = "条码参数不能为空";
                    objjson.data = null;
                    return objjson;
                }

                // 将逗号分隔的条码转换为SQL IN查询条件
                var barcodeList = barcodes.Split('~');

                // 构建IN子句，为每个条码添加单引号
                var inValues = new List<string>();
                foreach (var barcode in barcodeList)
                {
                    inValues.Add("'" + barcode.Replace("'", "''") + "'"); // 处理单引号转义
                }

                string inClause = string.Join(",", inValues);
                string sql = $"SELECT * FROM h_v_Gy_UserMaterRelationPrint WHERE HBarCode IN ({inClause})" + " order by 物料代码,cast(流水号 as int)";

                // 直接执行SQL查询
                DataSet ds = oCn.RunProcReturn(sql, "h_v_Gy_UserMaterRelationPrint");

                if (ds == null || ds.Tables[0].Rows.Count == 0)
                {
                    objjson.code = "0";
                    objjson.count = 0;
                    objjson.Message = "未找到相关条码信息";
                    objjson.data = null;
                    return objjson;
                }

                objjson.code = "0";
                objjson.count = ds.Tables[0].Rows.Count;
                objjson.Message = "获取成功";
                objjson.data = ds.Tables[0];
                return objjson;
            }
            catch (Exception e)
            {
                objjson.code = "0";
                objjson.count = 0;
                objjson.Message = "获取条码详情失败:" + e.Message;
                objjson.data = null;
                return objjson;
            }
        }
        #endregion



    }
}