using DBUtility;
using Model;
using Newtonsoft.Json;
using Newtonsoft.Json.Converters;
using Newtonsoft.Json.Linq;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web.Http;
using WebAPI.Models;

namespace WebAPI.Controllers.仓存管理.条码生成
{
    public class Gy_BarCodeBill_OutController : ApiController
    {
        private json objJsonResult = new json();
        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
        DataSet ds;

        #region [条码归档列表]
        [Route("Gy_BarCodeBill_Out/list")]
        [HttpGet]
        public object list(string sWhere, string user)
        {
            try
            {
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_Gy_BarCodeBill_OutList order by HMainID asc", "h_v_Gy_BarCodeBill_OutList");
                }
                else
                {
                    string sql1 = "select * from h_v_Gy_BarCodeBill_OutList where 1 = 1 ";
                    string sql = sql1 + sWhere + " order by HMainID asc";
                    ds = oCN.RunProcReturn(sql, "h_v_Gy_BarCodeBill_OutList");
                }

                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "Sucess！";
                objJsonResult.data = ds.Tables[0];
                return objJsonResult;
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        #region [根据ID查找记录]
        [Route("Gy_BarCodeBill_Out/cx")]
        [HttpGet]
        public object cx(long HInterID)
        {
            try
            {

                ds = oCN.RunProcReturn("select * from h_v_Gy_BarCodeBill_OutList where HMainID =" + HInterID, "h_v_Gy_BarCodeBill_OutList");
                if (ds == null || ds.Tables[0].Rows.Count == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "false！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                else
                {
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "Sucess！";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        #region [条码归档保存/编辑]
        [Route("Gy_BarCodeBill_Out/ModifyByID")]
        [HttpPost]
        public object ModifyByID([FromBody] JObject oMain)
        {
            try
            {
                DAL.ClsGy_Employee_Ctl oDept = new DAL.ClsGy_Employee_Ctl();
                DAL.ClsGy_Employee_View oDeptHlp = new DAL.ClsGy_Employee_View();

                var _value = oMain["oMain"].ToString();
                string msg1 = _value.ToString();
                string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
                string msg2 = sArray[0].ToString();
                //string msg3 = sArray[1].ToString();
                //string msg4 = sArray[2].ToString();
                //string msg5 = sArray[3].ToString();

                //反序列化
                msg2 = "[" + msg2.ToString() + "]";
                List<Gy_BarCodeBill_Out> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_BarCodeBill_Out>>(msg2);

                long HItemID = list[0].HItemID;
                string HNumber = list[0].HNumber;
                string HName = list[0].HName;
                string HShortNumber = list[0].HNumber;
                long HParentID = list[0].HParentID;
                long HLevel = 1;
                string HHelpCode = list[0].HHelpCode ?? "";
                bool HEndFlag = list[0].HEndFlag;
                long HStopflag = list[0].HStopflag;
                string HRemark = list[0].HRemark;
                string HUseFlag = list[0].HUseFlag ?? "";

                long HInterID = list[0].HInterID;            //主内码
                long HEntryID = list[0].HEntryID; 		//子内码
                string HBillType = list[0].HBillType; 	//类型
                long HProcID = list[0].HProcID;          //工序
                string HBarCode = list[0].HBarCode;//（聚集索引）  	//条形码 	
                string HBarCodeType = list[0].HBarCodeType; 	//条码类型（物料条码，箱号条码，托号条码） 
                long HItemSubID = list[0].HItemSubID;          //对应核算项目	
                long HMaterID = list[0].HMaterID;    			//对应物料内码 
                long HUnitID = list[0].HUnitID;			//计量单位 
                long HPieceQty = list[0].HPieceQty; 			//件数
                decimal HQty = list[0].HQty; 		//数量 
                string HBatchNo = list[0].HBatchNo; 		//批次号 
                long HSupID = list[0].HSupID;                  //往来单位 
                long HGroupID = list[0].HGroupID;  			//生产班组（Gy_Group）
                long HDeptID = list[0].HDeptID; 			//部门
                long HEmpID = list[0].HEmpID; 			//业务员
                string HMaker = list[0].HMaker; 	//制作人
                string HMakeDate = list[0].HMakeDate;  			// 制作日期
                long HPrintQty = list[0].HPrintQty;            //打印次数
                long HSourceInterID = list[0].HSourceInterID; 			//源单ID 
                long HSourceEntryID = list[0].HSourceEntryID; 			//源单子ID （如果有DETAILID 则填DETAILID）
                string HSourceBillNo = list[0].HSourceBillNo; 	//源单单号 
                string HSourceBillType = list[0].HSourceBillType; 	//源单类型
                string HEndQty = list[0].HEndQty; 	//尾箱数量
                string HWei = list[0].HWei;	//尾箱标记
                string HBarCodeStatus = list[0].HBarCodeStatus;		//条码状态
                decimal HReadyQty = list[0].HReadyQty;		//
                decimal HInitQty = list[0].HInitQty;			//初始化数量
                long HBarcodeQtys = list[0].HBarcodeQtys;            //总托数
                long HBarcodeNo = list[0].HBarcodeNo;			//当前托号
                long HInstructID = list[0].HBarcodeNo;			//
                string HInstructNo = list[0].HInstructNo;	//
                long HSeOrderBillID = list[0].HSeOrderBillID;          //销售订单内码
                string HSeOrderBillNo = list[0].HSeOrderBillNo;	//客户订单号
                long HWhID = list[0].HWhID;           //默认仓库
                long HSPID = list[0].HSPID;			//默认仓位
                long HAuxPropID = list[0].HAuxPropID;			//物料辅助属性
                string HMaterName = list[0].HMaterName;		//产品规格名称
                string HMaterModel = list[0].HMaterModel;		//产品规格型号
                string HPinfan = list[0].HPinfan;	//品番
                string HMTONo = list[0].HMTONo;		//MTO号
                long HSupflag = list[0].HSupflag; 			//供应商标签标记
                DateTime HBeginDate = list[0].HBeginDate;			//开始日期
                DateTime HEndDate = list[0].HEndDate;			//结束日期
                long HExpirationDateFlag = list[0].HExpirationDateFlag;			//保质期标记
                long HSourceID = list[0].HSourceID;           //生产资源
                string HCusType = list[0].HCusType;	//
                string HWorkLineName = list[0].HWorkLineName;	//生产线
                long HCusID = list[0].HCusID;          //客户内码
                long HSTOCKORGID = list[0].HSTOCKORGID;			//库存组织
                long HOWNERID = list[0].HOWNERID;			//货主
                string HJiaYe = list[0].HJiaYe;	//加液代码
                string HPressModel = list[0].HPressModel;	//型号（韩电）
                string HCusModel = list[0].HCusModel;		//客户型号
                string HMaterialModel = list[0].HMaterialModel;		//产品规格
                string HColor = list[0].HColor;		//颜色
                string HLogo = list[0].HLogo;		//品牌
                string HPackageSize = list[0].HPackageSize;	//包装尺寸
                decimal HMaterialJQty = list[0].HMaterialJQty;   //净重
                decimal HMaterialMQty = list[0].HMaterialMQty;	//毛重
                string HCustomBatchNo = list[0].HCustomBatchNo;		//客户批次号
                DateTime HBarCodeDate = list[0].HBarCodeDate;			//条码标签日期
                string HGBBarCode = list[0].HGBBarCode;		//国标码
                long HOldBarCodeFlag = list[0].HOldBarCodeFlag;			//旧条码标记
                long HOldSourceInterID = list[0].HOldSourceInterID;           //老源单内码
                long HOldSourceEntryID = list[0].HOldSourceEntryID;			//老源单子内码
                string HOldSourceBillNo = list[0].HOldSourceBillNo;	//老源单单号
                long HOrderInterID = list[0].HOrderInterID;           //订单内码
                long HOrderEntryID = list[0].HOrderEntryID;			//订单子内码（如果有DETAILID 则填DETAILID）
                string HOrderBillNo = list[0].HOrderBillNo;	//订单单号
                string HOrderBillType = list[0].HOrderBillType;		//订单单据类型
                string HRelationNum = list[0].HRelationNum;//对应编号
                decimal HLabelQty = list[0].HLabelQty;		//打印标签数量
                decimal HMinQty = list[0].HMinQty;		//最小包装数量 
                decimal HNowQty = list[0].HNowQty;		//当前数量
                string HStopMan = list[0].HStopMan;	//禁用人
                string HStopManDate = list[0].HStopManDate;			//禁用日期
                DateTime HInStockDate = list[0].HInStockDate;
                DateTime HOutStockDate = list[0].HOutStockDate;
                string HInStockDate_XF = list[0].HInStockDate_XF;
                string HExpressNumber = list[0].HExpressNumber;
                string POOrderBillNo = list[0].POOrderBillNo;
                string HICMOReportBillNo = list[0].HICMOReportBillNo;
                DateTime HICMOReportDate = list[0].HICMOReportDate;
                long HInStockCounts = list[0].HInStockCounts;
                long HReportCounts = list[0].HReportCounts;
                long HOutStockCounts = list[0].HOutStockCounts;
                string HInStockBillNo = list[0].HInStockBillNo;
                string HOutStockBillNo = list[0].HOutStockBillNo;
                string HSendGoodsBillNo = list[0].HSendGoodsBillNo;
                string HKFDate = list[0].HKFDate;
                long HKFPeriod = list[0].HKFPeriod;
                string HKFDQDate = list[0].HKFDQDate;
                long HServerItemID = list[0].HServerItemID;
                string HBadReasonList = list[0].HBadReasonList;
                string HProdLev = list[0].HProdLev;
                long HSeOrderInterID = list[0].HSeOrderInterID;
                long HSeOrderEntryID = list[0].HSeOrderEntryID;
                string HInnerBillNo = list[0].HInnerBillNo;
                string HCusBarCode = list[0].HCusBarCode;
                string HStatus = list[0].HStatus;
                long HInitSourceEntryID = list[0].HInitSourceEntryID;
                string HOldSourceBillType = list[0].HOldSourceBillType;
                decimal HMZ = list[0].HMZ;
                long HGiveAwayFlag = list[0].HGiveAwayFlag;			//赠品标记
                long HSeOrderSEQ = list[0].HSeOrderSEQ;
                long HMaterID_OLD = list[0].HMaterID_OLD;
                string HDeleteMan = list[0].HDeleteMan;
                DateTime HDeleteDate = list[0].HDeleteDate;
                string HBarCode_Pack = list[0].HBarCode_Pack;
                long HCustomQty1 = list[0].HCustomQty1;
                DateTime HProduceDate = list[0].HProduceDate;			//生产日期（保质期用）
                DateTime HExpiryDate = list[0].HExpiryDate;         //保质期至（保质期用）

                //进行 会计期间 结账 的判断和控制
                string s = "";
                int sYear = 0;
                int sPeriod = 0;
                DateTime HDate = DateTime.Now;
                if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)
                {
                    objJsonResult.Message = s;
                    return objJsonResult;
                }

                ////判断权限
                //if (!ClsPub.Security_Log(msg5, 1, false, msg4))
                //{
                //    objJsonResult.code = "0";
                //    objJsonResult.count = 0;
                //    objJsonResult.Message = "没有找到该功能模块！";
                //    objJsonResult.data = null;
                //    return objJsonResult;
                //}

                //if (!DBUtility.ClsPub.AllowNumber(HNumber))
                //{
                //    objJsonResult.code = "0";
                //    objJsonResult.count = 0;
                //    objJsonResult.Message = "代码中不能出现连续‘.’并且首位末位不能为‘.’！";
                //    objJsonResult.data = null;
                //    return objJsonResult;
                //}

                //if (oDept.HavSameNumber(HItemID, HNumber))
                //{
                //    objJsonResult.code = "0";
                //    objJsonResult.count = 0;
                //    objJsonResult.Message = "代码重复！";
                //    objJsonResult.data = null;
                //    return objJsonResult;
                //}
                //保存
                //保存完毕后处理
                if (HItemID == 0)
                {
                    oCN.BeginTran();

                    DateTime dt = DateTime.Now;
                    //42
                    oCN.RunProc(@"Insert into Gy_BarCodeBill_Out 
                        (HInterID, HEntryID, HBillType, HProcID, HBarCode, HBarCodeType, HItemSubID, HMaterID, HUnitID,
                        HPieceQty, HQty, HBatchNo, HSupID, HGroupID, HDeptID, HEmpID, HMaker, HPrintQty, HSourceInterID, HSourceEntryID,
                        HSourceBillNo, HSourceBillType, HRemark, HUseFlag, HEndQty, HWei, HStopflag, HBarCodeStatus, HReadyQty, HInitQty,
                        HWhID, HSPID, HAuxPropID, HMTONo, HSupflag, HBeginDate, HEndDate, HExpirationDateFlag, HSourceID, HCusType,
                        HWorkLineName, HCusID, HSTOCKORGID, HOWNERID, HJiaYe, HPressModel, HCusModel, HMaterialModel, HColor, HLogo,
                        HPackageSize, HMaterialJQty, HMaterialMQty, HCustomBatchNo, HBarCodeDate, HGBBarCode, HOldBarCodeFlag, HOldSourceInterID,
                        HOldSourceEntryID, HOldSourceBillNo, HOrderInterID, HOrderEntryID, HOrderBillNo, HOrderBillType, HRelationNum,
                        HLabelQty, HMinQty, HNowQty, HStopMan, HInStockDate_XF, HExpressNumber, POOrderBillNo, HICMOReportBillNo, HInStockCounts,
                        HReportCounts, HOutStockCounts, HInStockBillNo, HOutStockBillNo, HSendGoodsBillNo, HServerItemID, HBadReasonList, HProdLev,
                        HInnerBillNo, HCusBarCode, HStatus, HInitSourceEntryID, HOldSourceBillType, HMZ, HGiveAwayFlag, HSeOrderSEQ, HMaterID_OLD,
                        HDeleteMan, HBarCode_Pack, HCustomQty1)
                    Values(" + 0 + "," + 0 + "," + 3330 + "," + HProcID + ",'" + HBarCode +
                      "','" + HBarCodeType + "'," + 0 + "," + HMaterID + "," + HUnitID + "," + HPieceQty +
                      "," + HQty + ",'" + HBatchNo + "'" + "," + HSupID + "," + HGroupID +
                      "," + HDeptID + "," + HEmpID + ",'" + HMaker + "'," + HPrintQty + "," + 0 +
                      "," + 0 + ",'" + HSourceBillNo + "','" + HSourceBillType + "','" + HRemark + "'" +
                      ",'" + HUseFlag + "','" + HEndQty + "','" + HWei + "'," + HStopflag + ",'" + HBarCodeStatus +
                      "'," + HReadyQty + "," + HInitQty + "," + HWhID + "," + HSPID + "," + HAuxPropID  +
                      ",'" + HMTONo + "'," + HSupflag + ",'" + dt + "','" + dt + "'," + HExpirationDateFlag +
                      "," + HSourceID + ",'" + HCusType + "','" + HWorkLineName + "'," + HCusID + "," + HSTOCKORGID +
                      "," + HOWNERID + ",'" + HJiaYe + "','" + HPressModel + "','" + HCusModel + "','" + HMaterialModel + "','" + HColor + "','" + HLogo + "'" +
                      ",'" + HPackageSize + "'," + HMaterialJQty + "," + HMaterialMQty + ",'" + HCustomBatchNo + "','" + dt + "','" + HGBBarCode + "'" +
                      "," + HOldBarCodeFlag + "," + HOldSourceInterID + "," + HOldSourceEntryID + ",'" + HOldSourceBillNo + "'" +
                      "," + HOrderInterID + "," + HOrderEntryID + ",'" + HOrderBillNo + "','" + HOrderBillType +
                      "','" + HRelationNum + "'" + "," + HLabelQty  + "," + HMinQty + "," + HNowQty + ",'" + HStopMan + "','" + dt +
                      "','" + HExpressNumber + "','" + POOrderBillNo + "','" + HICMOReportBillNo + "'," + HInStockCounts + "," + HReportCounts  +
                      "," + HOutStockCounts + ",'" + HInStockBillNo + "','" + HOutStockBillNo + "','" + HSendGoodsBillNo +
                      "'," + HServerItemID + ",'" + HBadReasonList + "','" + HProdLev + "','" + HInnerBillNo + "','" + HCusBarCode + "','" + HStatus + "'," + HInitSourceEntryID + ",'" + HOldSourceBillType + "','" + HMZ + "'," + HGiveAwayFlag + "," + HSeOrderSEQ + 
                      "," + HMaterID_OLD + ",'" + HDeleteMan + "','" + HBarCode_Pack + "'," + HCustomQty1 + ")", ref DBUtility.ClsPub.sExeReturnInfo);

                    //修改上级为非末级代码
                    oCN.RunProc("Update Gy_BarCodeBill_Out set HStopflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
                    oCN.Commit();
                }
                else
                {
                    //若MAINDI重复则重新获取
                    oCN.BeginTran();
                    oCN.RunProc("Update Gy_BarCodeBill_Out set " +
                    " HBarCode='" + HBarCode + "'" +
                    ",HProcID=" + HProcID + 
                    ",HBarCodeType='" + HBarCodeType + "'" +
                    ",HMaterID=" + HMaterID +
                    ",HUnitID=" + HUnitID +

                    ",HPieceQty=" + HPieceQty +
                    ",HQty=" + HQty +
                    ",HBatchNo='" + HBatchNo + "'" +
                    ",HSupID=" + HSupID +
                    ",HGroupID=" + HGroupID +
                    ",HDeptID=" + HDeptID +
                    ",HEmpID=" + HEmpID +
                    ",HEndQty=" + HEndQty +
                    ",HWhID=" + HWhID +
                    ",HSPID=" + HSPID +
                    ",HAuxPropID=" + HAuxPropID +
                    ",HCusID=" + HCusID +
                    ",HSTOCKORGID=" + HSTOCKORGID +
                    //",HEndflag=" + Convert.ToString(HEndFlag ? 1 : 0) +
                    ",HRemark= '" + HRemark.ToString() + "' Where HItemID=" + HItemID);
                    oCN.Commit();
                }
                objJsonResult.code = "0";
                objJsonResult.count = 1;
                objJsonResult.Message = "保存成功！";
                //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单");
                objJsonResult.data = 1;
                return objJsonResult;
            }
            catch (Exception e)
            {
                //oCN.RollBack();
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.Message;
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        #region [删除]
        [Route("Gy_BarCodeBill_Out/Delete")]
        [HttpGet]
        public object Delete(string HItemID, string user)
        {
            try
            {
                //进行 会计期间 结账 的判断和控制
                string s = "";
                int sYear = 0;
                int sPeriod = 0;
                DateTime HDate = DateTime.Now;
                if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)
                {
                    objJsonResult.Message = s;
                    return objJsonResult;
                }

                oCN.BeginTran();
                oCN.RunProc("Delete From Gy_BarCodeBill_Out where HItemID = " + HItemID);
                oCN.Commit();
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "删除成功！";
                objJsonResult.data = null;
                return objJsonResult;
            }
            catch (Exception e)
            {
                oCN.RollBack();
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion
    }
}