using Newtonsoft.Json.Linq;
using Pub_Class;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web.Http;
using WebAPI.Models;
namespace WebAPI.Controllers
{
    public class LMESController : ApiController
    {
        public DBUtility.ClsPub.Enum_BillStatus BillStatus;
        //自定义34进制数组
        private static char[] lNCode = new char[] { '0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'J', 'K', 'L', 'M', 'N', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z' };

        private json objJsonResult = new json();

        /// <summary>
        /// 转换34进制
        /// lastNum：参数
        /// codeNum：
        /// codeLength：生成多少位
        /// </summary>
        //[Route("LEMS/GetCheckCode")]
        //[HttpGet]
        public string GetNewCodeByNum(Int64 lastNum, Int64 codeNum, Int64 codeLength)
        {
            List<string> codeList = new List<string>();
            var maxNum = lastNum + codeNum;
            var lNLength = lNCode.Length;
            for (Int64 i = lastNum; i < maxNum; i++)
            {
                char[] bgCode = GetNewCodeArray(codeLength);
                var sNum = i;//整数倍初始赋值
                for (int a = bgCode.Length - 1; a >= 0; a--)
                {
                    var yNum = sNum % lNLength;//计算余数
                    bgCode[a] = lNCode[yNum];//通过余数定位数组位置
                    sNum = (int)(sNum / lNLength);//计算剩余整数
                    if (sNum == 0)//整数倍为0，则跳出循环
                        break;
                }
                //Console.WriteLine($"生成码{i}：{new string(bgCode)}");//打印生成的序列码（测试用，正式环境请删除或者注释）
                codeList.Add(new string(bgCode));
            }
            return codeList[0];
        }

        /// <summary>
        /// 序列码初始化
        /// </summary>
        private char[] GetNewCodeArray(Int64 codeLength)
        {
            char[] bgCode = new char[codeLength];
            for (Int64 i = 0; i < codeLength; i++)
            {
                bgCode[i] = '0';
            }
            return bgCode;
        }

        /// <summary>
        /// 返回进站扫描列表|工序进站接收单列表 
        ///参数：string sql。
        ///返回值：object。    
        /// </summary>
        [Route("LEMS/MES_StationInBillList_Json")]
        [HttpGet]
        public object MES_StationInBillList_Json(string sWhere)
        {
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_MES_StationInBillList", "h_v_MES_StationInBillList");
                }
                else 
                {
                    string sql1 = "select * from h_v_MES_StationInBillList where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    ds = oCN.RunProcReturn(sql, "h_v_MES_StationInBillList");
                }
                
            }
            catch (Exception e)
            {
                ds = null;
            }
            return GetObjectJson(ds);
        }

        /// <summary>
        /// 返回工序流转卡维护列表主表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("LEMS/MES_Sc_ProcessExchangeBillQuery_Json")]
        [HttpGet]
        public object MES_Sc_ProcessExchangeBillList_Json(string sWhere)
        {
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessExchangeBillQuery", "h_v_Sc_ProcessExchangeBillQuery");
                }
                else
                {
                    string sql1 = "select * from h_v_Sc_ProcessExchangeBillQuery where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    ds = oCN.RunProcReturn(sql, "h_v_Sc_ProcessExchangeBillQuery");
                }

            }
            catch (Exception e)
            {
                ds = null;
            }
            return GetObjectJson(ds);
        }

        /// <summary>
        /// 返回工序流转卡维护列表从表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("LEMS/MES_Sc_ProcessExchangeBillQuerySub_Json")]
        [HttpGet]
        public object MES_Sc_ProcessExchangeBillSub_Json(string sWhere)
        {
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                string sql = "select * from h_v_Sc_ProcessExchangeBillQuerySub where hmainid = ";
                string sql1 = sql + sWhere;
                ds = oCN.RunProcReturn(sql1, "h_v_Sc_ProcessExchangeBillQuerySub");
            }
            catch (Exception e)
            {
                ds = null;
            }
            return GetObjectJson(ds);
        }

        /// <summary>
        /// 返回工序出站汇报单列表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("LEMS/MES_StationOutBillList_Json")]
        [HttpGet]
        public object MES_StationOutBillList_Json(string sWhere)
        {
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_MES_StationOutBillList ", "h_v_MES_StationInBillList");
                }
                else
                {
                    string sql1 = "select * from h_v_MES_StationOutBillList where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    ds = oCN.RunProcReturn(sql, "h_v_MES_StationOutBillList");
                }

            }
            catch (Exception e)
            {
                ds = null;
            }
            return GetObjectJson(ds);
        }

        /// <summary>
        /// 返回工序委外发出单列表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("LEMS/MES_StationEntrustInBillList_Json")]
        [HttpGet]
        public object MES_StationEntrustInBillList_Json(string sWhere)
        {
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_MES_StationEntrustInBillList ", "h_v_MES_StationEntrustInBillList");
                }
                else
                {
                    string sql1 = "select * from h_v_MES_StationEntrustInBillList where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    ds = oCN.RunProcReturn(sql, "h_v_MES_StationEntrustInBillList");
                }

            }
            catch (Exception e)
            {
                ds = null;
            }
            return GetObjectJson(ds);
        }

        /// <summary>
        /// 返回工艺路线列表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("LEMS/MES_Gy_RoutingBillList_Json")]
        [HttpGet]
        public object MES_Gy_RoutingBillList_Json(string sWhere)
        {
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_Gy_RoutingBillList ", "h_v_Gy_RoutingBillList");
                }
                else
                {
                    string sql1 = "select * from h_v_Gy_RoutingBillList where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    ds = oCN.RunProcReturn(sql, "h_v_Gy_RoutingBillList");
                }

            }
            catch (Exception e)
            {
                ds = null;
            }
            return GetObjectJson(ds);
        }

        /// <summary>
        /// 返回生产任务单列表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("LEMS/MES_IF_ICMOBillList_Json")]
        [HttpGet]
        public object MES_IF_ICMOBillList_Json(string sWhere)
        {
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillList ", "h_v_IF_ICMOBillList");
                }
                else
                {
                    string sql1 = "select * from h_v_IF_ICMOBillList where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    ds = oCN.RunProcReturn(sql, "h_v_IF_ICMOBillList");
                }

            }
            catch (Exception e)
            {
                ds = null;
            }
            return GetObjectJson(ds);
        }

        /// <summary>
        /// 返回工序委外接收单列表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("LEMS/MES_StationEntrustOutBillList_Json")]
        [HttpGet]
        public object MES_StationEntrustOutBillList_Json(string sWhere)
        {
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_MES_StationEntrustOutBillList ", "h_v_MES_StationEntrustOutBillList");
                }
                else
                {
                    string sql1 = "select * from h_v_MES_StationEntrustOutBillList where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    ds = oCN.RunProcReturn(sql, "h_v_MES_StationEntrustOutBillList");
                }

            }
            catch (Exception e)
            {
                ds = null;
            }
            return GetObjectJson(ds);
        }

        ///<summary>
        ///封装状态码及返回信息的公用方法。
        ///参数：DataSet。
        ///返回值：json。
        ///</summary>
        public object GetObjectJson(DataSet ds)
        {
            try
            {
                if (ds == null || ds.Tables[0].Rows.Count <= 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "没有返回任何记录！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                else
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "获取信息成功！";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }

        ///<summary>
        ///自定义错误信息方法。
        ///参数：string。
        ///返回值：object。
        ///</summary>
        public object CustomError(string msg)
        {
            objJsonResult.code = "0";
            objJsonResult.count = 0;
            objJsonResult.Message = msg;
            objJsonResult.data = null;
            return objJsonResult;
        }

        ///<summary>
        ///统一正确信息方法。
        ///参数：string。
        ///返回值：object。
        ///</summary>
        public object CustomCorrect(DataSet ds)
        {
            if (ds == null || ds.Tables[0].Rows.Count <= 0)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录！";
                objJsonResult.data = null;
                return objJsonResult;
            }
            else
            {
                objJsonResult.code = "0";
                objJsonResult.count = 1;
                objJsonResult.Message = "获取信息成功！";
                objJsonResult.data = ds.Tables[0];
                return objJsonResult;
            }
        }

        /// <summary>
        /// 返回选择生产班组列表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("LEMS/MES_GetProductionTeamList_Json")]
        [HttpGet]
        public object MES_GetProductionTeamList_Json(string sWhere)
        {
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                ds = oCN.RunProcReturn("Select HItemID,HNumber 班组代码,HName 班组 from h_v_IF_Group where HStopflag=0 " + sWhere + " Order by HItemID ", "h_v_IF_Group");
            }
            catch (Exception e)
            {
                ds = null;
            }
            return GetObjectJson(ds);
        }

        /// <summary>
        /// 返回选择生产资源列表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("LEMS/MES_GetProductionResourcesList_Json")]
        [HttpGet]
        public object MES_GetProductionResourcesList_Json(string sWhere)
        {
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                ds = oCN.RunProcReturn("Select HItemID,HNumber 生产资源代码,HName 生产资源 from Gy_Source where HStopflag=0 " + sWhere + " Order by HItemID ", "Gy_Source");
            }
            catch (Exception e)
            {
                ds = null;
            }
            return GetObjectJson(ds);
        }

        /// <summary>
        /// 扫条码方法(进站接收单、出站汇报单)
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("LEMS/TxtHBarCode_KeyDown")]
        [HttpGet]
        public object TxtHBarCode_KeyDown(string sBillBarCode)
        {
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (sBillBarCode == null || sBillBarCode.Equals(""))
                {
                    return CustomError("未输入条形码！");
                }
                else
                {
                    //拆分条形码
                    string[] NewBarCode;
                    if (sBillBarCode.CompareTo("#") > 0)
                    {
                        NewBarCode = sBillBarCode.Split(Convert.ToChar("#"));
                        sBillBarCode = NewBarCode[0];
                    }
                    string sBillNo = sBillBarCode;
                    ds = oCN.RunProcReturn("select top 1 * from h_v_Sc_ProcessExchangeBillList  where 单据号= '" + sBillNo + "'", "h_v_Sc_ProcessExchangeBillList");
                    if (ds == null || ds.Tables[0].Rows.Count == 0)
                    {
                        return CustomError("不存在此流转卡号！");
                    }
                }

            }
            catch (Exception e)
            {
                ds = null;
            }
            return CustomCorrect(ds);
        }

        /// <summary>
        /// 流水号回车方法(进站接收单、出站汇报单)
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("LEMS/TxtHProcNo_KeyDown")]
        [HttpGet]
        public object TxtHProcNo_KeyDown(string sProcNo, string sBillNo)
        {
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (sProcNo == null || sProcNo.Equals("") || sBillNo == null || sBillNo.Equals(""))
                {
                    return CustomError("流水号或流转卡号为空！");
                }
                else
                {
                    ds = oCN.RunProcReturn("select top 1 * from h_v_Sc_ProcessExchangeBillList  where 单据号= '" + sBillNo + "' and 下道流转工序<>'转' and 委外标记=0 and 流转标记=1  and 工序号='" + sProcNo + "'", "h_v_Sc_ProcessExchangeBillList");
                }

            }
            catch (Exception e)
            {
                ds = null;
            }
            return CustomCorrect(ds);
        }

        
        /// <summary>
        /// 保存提交方法
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("LEMS/Sub_SaveBill_Json")]
        [HttpPost]
        public object Sub_SaveBill_Json([FromBody]JObject oMain)
        {
            var _value = oMain["oMain"].ToString();
            string msg1 = _value.ToString();
            try
            {
                List<Model.ClsSc_StationInBillSub> lsmain = new List<Model.ClsSc_StationInBillSub>();
                ListModels oListModels = new ListModels();
                //反序列化
                msg1 = "[" + msg1.ToString() + "]";
                lsmain = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_StationInBillSub>>(msg1);

                //反序列化
                DAL.ClsSc_StationInBill BillNew = new DAL.ClsSc_StationInBill();
                DAL.ClsSc_StationInBill BillOld = new DAL.ClsSc_StationInBill();
                bool bResult;
                //赋值ID
                if (BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_Modify)
                {
                    BillNew.omodel.HInterID = BillOld.omodel.HInterID;
                }
                BillNew.omodel.HYear = 2011;
                BillNew.omodel.HPeriod = 1;
                BillNew.omodel.HBillNo = DBUtility.ClsPub.isStrNull(lsmain[0].HBillNo);
                //BillNew.omodel.HICMOBillNo = this.txtHICMOBillNo.Text.Trim();
                //BillNew.omodel.HICMOInterID = DBUtility.ClsPub.isLong(this.txtHICMOBillNo.Tag);
                //BillNew.omodel.HProcExchInterID = lngBillKey;
                //BillNew.omodel.HProcExchEntryID = lngBillSubKey;
                //BillNew.omodel.HProcExchBillNo = this.txtHProcExchBillNo.Text.Trim();
                //BillNew.omodel.HProcID = DBUtility.ClsPub.isLong(this.txtHProcID.Tag);
                //BillNew.omodel.HMaterID = DBUtility.ClsPub.isLong(this.txtHMaterID.Tag);
                //BillNew.omodel.HStationInTime = DBUtility.ClsPub.isDate(this.txtHStationInTime.Text);
                //BillNew.omodel.HEmpID = DBUtility.ClsPub.isLong(this.txtHEmpID.Tag);
                //BillNew.omodel.HSourceID = DBUtility.ClsPub.isLong(this.txtHSourceID.Tag);
                //BillNew.omodel.HGroupID = DBUtility.ClsPub.isLong(this.txtHGroupID.Tag);
                //BillNew.omodel.HICMOQty = DBUtility.ClsPub.isDoule(this.txtHICMOQty.Text);
                //BillNew.omodel.HPlanQty = DBUtility.ClsPub.isDoule(this.txtHPlanQty.Text);
                //BillNew.omodel.HQty = DBUtility.ClsPub.isDoule(this.txtHQty.Text);
                BillNew.omodel.HPieceQty = "";
                //BillNew.omodel.HSourceName = DBUtility.ClsPub.isStrNull(this.txtHSourceName.Text);
                //BillNew.omodel.HCenterID = DBUtility.ClsPub.isLong(this.txtHCenterID.Tag);

                //BillNew.omodel.HProcNo = DBUtility.ClsPub.isLong(this.txtHProcNo.Text);
                //BillNew.omodel.HOrderProcNO = DBUtility.ClsPub.isStrNull(this.txtHOrderProcNO.Text);

                //保存完毕后处理
                //if (BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew)
                //{
                //    bResult = BillNew.AddBill(ref ClsPub.sExeReturnInfo);
                //}
                //else
                //{
                //    bResult = BillNew.ModifyBill(BillNew.omodel.HInterID, ref ClsPub.sExeReturnInfo);
                //}
                bResult = BillNew.AddBill(ref ClsPub.sExeReturnInfo);
                if (bResult == true)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "生成汇报单成功！单据号为：";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                else
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "上传失败！" + DBUtility.ClsPub.sErrInfo;
                    objJsonResult.data = null;
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "上传失败！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }

        /// <summary>
        /// 扫流转卡号方法（产线包装单、产线组装追溯单）--根据流转卡号保存到temp表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("LEMS/SaveCirculationCard_Json")]
        [HttpGet]
        public object SaveCirculationCard_Json(string HBillNo, string HInterID, string HBillNo2, string HBarCode,
            string HNumber, string HName, string HModel)
        {
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (HBillNo == null || HBillNo.Equals("") || HInterID == null || HInterID.Equals("") || HBillNo2 == null || HBillNo2.Equals(""))
                {
                    return CustomError("流转卡号不能为空！");
                }
                else
                {
                    if (HBarCode == null || HBarCode.Equals(""))
                    {
                        HBarCode = " ";
                    }
                    ds = oCN.RunProcReturn("exec Save_Sc_ProcessExchangeBillMainToTmp '" + HBillNo + "','" + HInterID + "','" + HBillNo2 + "','" + HBarCode + "','" + HNumber + "','" + HName + "','" + HModel + "'", "Save_Sc_ProcessExchangeBillMainToTmp");
                }

            }
            catch (Exception e)
            {
                ds = null;
            }
            return CustomCorrect(ds);
            //return ds.Tables[0].Rows;
        }

        /// <summary>
        /// 扫子件条码方法（产线包装单、产线组装追溯单）--根据子件条码保存到temp表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("LEMS/SaveSubBarcode_Json")]
        [HttpGet]
        public object SaveSubBarcode_Json(string HBillNo, string SubBarcode, string HInterID, string HBillNo2,
            string HBillType, string sMaker, string HBarCode, string HNumber, string HName, string HModel)
        {
            DataSet ds1;
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (HBillNo == null || HBillNo.Equals("") || SubBarcode == null || SubBarcode.Equals("") || HInterID == null || HInterID.Equals("") || HBillNo2 == null || HBillNo2.Equals("") || HBillType == null || HBillType.Equals(""))
                {
                    return CustomError("流转卡号或子件条码不能为空！");
                }
                else
                {
                    ds1 = oCN.RunProcReturn("select * from KF_PonderationBillMain_Temp where HSourceBillNo = '" + SubBarcode + "' and HBillType = '" + HBillType + "'", "KF_PonderationBillMain_Temp");
                    if (ds1.Tables[0].Rows.Count > 0)
                    {
                        return CustomError("该子件条码已存在");
                    }
                    if (HBarCode == null || HBarCode.Equals(""))
                    {
                        HBarCode = " ";
                    }
                    ds = oCN.RunProcReturn("exec h_p_Save_SubBarcodeToTmp '" + HBillNo + "','" + SubBarcode + "','" + HInterID + "','" + HBillNo2 + "','" + HBillType + "','" + sMaker + "','" + HBarCode + "','" + HNumber + "','" + HName + "','" + HModel + "'", "h_p_Save_SubBarcodeToTmp");
                }

            }
            catch (Exception e)
            {
                ds = null;
            }
            return CustomCorrect(ds);
            //return ds.Tables[0].Rows;
        }

        /// <summary>
        /// 查询条码档案表里的镭雕条码的合计数量方法（产线包装单）
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("LEMS/Select_Gy_BarCodeBill_HQty")]
        [HttpGet]
        public object Select_Gy_BarCodeBill_HQty(string HBarCode)
        {
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (HBarCode == null || HBarCode.Equals(""))
                {
                    return CustomError("唯一条码不能为空！");
                }
                else
                {
                    ds = oCN.RunProcReturn("select HQty from Gy_BarCodeBill where HBarCode = '" + HBarCode + "'", "Gy_BarCodeBill");
                }

            }
            catch (Exception e)
            {
                ds = null;
            }
            return CustomCorrect(ds);
            //return ds.Tables[0].Rows;
        }

        /// <summary>
        /// 更新条码档案表里的镭雕条码的合计数量方法（产线包装单）
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("LEMS/Update_Gy_BarCodeBill_HQty")]
        [HttpGet]
        public object Update_Gy_BarCodeBill_HQty(string HBarCode,string HQty)
        {
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (HBarCode == null || HBarCode.Equals(""))
                {
                    return CustomError("唯一条码不能为空！");//h_p_Update_Gy_BarCodeBill_HQty
                }
                else
                {
                    ds = oCN.RunProcReturn("exec h_p_Update_Gy_BarCodeBill_HQty " + HBarCode + "," + HQty + "", "Gy_BarCodeBill");
                }

            }
            catch (Exception e)
            {
                ds = null;
            }
            return CustomCorrect(ds);
            //return ds.Tables[0].Rows;
        }

        /// <summary>
        /// 更新扫码记录列表方法（产线包装单、产线组装追溯单）
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("LEMS/Update_HBillNo_SubBarcodeList_Json")]
        [HttpGet]
        public object Update_HBillNo_SubBarcodeList_Json(string HBillNo)
        {
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (HBillNo == null || HBillNo.Equals(""))
                {
                    return CustomError("流转卡号不能为空！");
                }
                else
                {
                    ds = oCN.RunProcReturn("exec h_v_KF_PonderationBillMain_TempAddP '" + HBillNo + "'", "h_v_KF_PonderationBillMain_TempAddP");
                }

            }
            catch (Exception e)
            {
                ds = null;
            }
            return CustomCorrect(ds);
            //return ds.Tables[0].Rows;
        }

        /// <summary>
        /// 提交-主表方法（产线包装单）--根据流传卡号从temp表保存到主表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("LEMS/SaveToSc_PackUnionBillMain")]
        [HttpGet]
        public object SaveToSc_PackUnionBillMain(string HBillNo, string HRemark,string HProjectNum)
        {
            DataSet ds;
            DataSet dsHSNum;
            try
            {
                //项目号获取流水号
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                dsHSNum = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + HProjectNum + "'", "h_p_WMS_GetMaxNo");
                oCN.RunProc("exec h_p_WMS_SetMaxNo '" + HProjectNum + "'");
                int HSNum = ClsPub.isInt(dsHSNum.Tables[0].Rows[0][0]) + 1;
                //调用进制转换方法把流水号转换成流水号2
                string HSNum2 = GetNewCodeByNum(HSNum,1,2);
                if (HBillNo == null || HBillNo.Equals(""))
                {
                    return CustomError("流转卡号不能为空！");
                }
                else
                {
                    ds = oCN.RunProcReturn("exec h_p_Save_KF_PonderationBillMain_TempToSc_PackUnionBillMain '" + HBillNo + "','" + HRemark + "'," + HSNum + ",'" + HSNum2 + "'", "h_p_Save_KF_PonderationBillMain_TempToSc_PackUnionBillMain");
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "异常！"+e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
            return CustomCorrect(ds);
            //return ds.Tables[0].Rows;
        }

        /// <summary>
        /// 提交-子表方法（产线包装单）--根据子件条码从temp表保存到子表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("LEMS/SaveToSc_PackUnionBillSub")]
        [HttpGet]
        public object SaveToSc_PackUnionBillSub(string HitemID, string HRemark)
        {
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (HitemID == null || HitemID.Equals(""))
                {
                    return CustomError("更新失败HitemID为空！");
                }
                else
                {
                    ds = oCN.RunProcReturn("exec h_p_Save_KF_PonderationBillMain_TempToSc_PackUnionBillSub '" + HitemID + "','" + HRemark + "'", "h_p_Save_KF_PonderationBillMain_TempToSc_PackUnionBillSub");
                }

            }
            catch (Exception e)
            {
                ds = null;
            }
            return CustomCorrect(ds);
            //return ds.Tables[0].Rows;
        }

        /// <summary>
        /// 更新temp表的标记字段方法（产线包装单）
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("LEMS/Update_Flag_HRelationInterID")]
        [HttpGet]
        public object Update_Flag_HRelationInterID(string HitemID)
        {
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (HitemID == null || HitemID.Equals(""))
                {
                    return CustomError("更新失败HitemID为空！");
                }
                else
                {
                    ds = oCN.RunProcReturn("exec h_p_Update_Flag_HRelationInterID '" + HitemID + "'", "h_p_Update_Flag_HRelationInterID");
                }

            }
            catch (Exception e)
            {
                ds = null;
            }
            return CustomCorrect(ds);
            //return ds.Tables[0].Rows;
        }

        /// <summary>
        /// 提交-主表方法（产线组装追溯单）--根据流传卡号从temp表保存到主表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("LEMS/SaveToSc_AssemblyBillMain")]
        [HttpGet]
        public object SaveToSc_AssemblyBillMain(string HBillNo)
        {
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (HBillNo == null || HBillNo.Equals(""))
                {
                    return CustomError("流转卡号不能为空！");
                }
                else
                {
                    ds = oCN.RunProcReturn("exec h_p_Save_KF_PonderationBillMain_TempToSc_AssemblyBillMain '" + HBillNo + "'", "h_p_Save_KF_PonderationBillMain_TempToSc_AssemblyBillMain");
                }

            }
            catch (Exception e)
            {
                ds = null;
            }
            return CustomCorrect(ds);
            //return ds.Tables[0].Rows;
        }

        /// <summary>
        /// 提交-子表方法（产线组装追溯单）--根据子件条码从temp表保存到子表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("LEMS/SaveToSc_AssemblyBillSub")]
        [HttpGet]
        public object SaveToSc_AssemblyBillSub(string HitemID)
        {
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (HitemID == null || HitemID.Equals(""))
                {
                    return CustomError("更新失败HitemID为空！");
                }
                else
                {
                    ds = oCN.RunProcReturn("exec h_p_Save_KF_PonderationBillMain_TempToSc_AssemblyBillSub '" + HitemID + "'", "h_p_Save_KF_PonderationBillMain_TempToSc_AssemblyBillSub");
                }

            }
            catch (Exception e)
            {
                ds = null;
            }
            return CustomCorrect(ds);
            //return ds.Tables[0].Rows;
        }

        /// <summary>
        /// 生成唯一条码方法（产线包装单）--保存时生成唯一条码
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("LEMS/SaveBarCode_json")]
        [HttpGet]
        public object SaveBarCode_json(string sHMaterID, string sHUnitID, string sHBarcodeNo, string sHMaterName)
        {
            DataSet ds;
            string sTMNumber = "";
            string aDate = System.DateTime.Now.ToString();
            string sDate = System.DateTime.Now.ToShortDateString();
            string sYear = ClsPub.isDate(sDate).Year.ToString().Substring(2, 2);
            string sPeriod = "0" + ClsPub.isDate(sDate).Month.ToString();
            sPeriod = sPeriod.Substring(sPeriod.Length - 2, 2);
            string sDay = "0" + ClsPub.isDate(sDate).Day.ToString();
            sDay = sDay.Substring(sDay.Length - 2, 2);
            int LSH = 0;
            try
            {
                SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
                sTMNumber = sHMaterID + sYear + sPeriod + sDay;
                ds = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo");    //获取最大流水号
                oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'");
                LSH = ClsPub.isInt(ds.Tables[0].Rows[0][0]);
                LSH = LSH + 1;
                string LSH2 = LSH.ToString();
                while (LSH2.Length < 6)  //如果流水号小于6位数前面补0
                {
                    LSH2 = "0" + LSH2;
                }
                string TM = sTMNumber + LSH2;
                oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'");

                string HBarCode = TM;
                string HBarCodeType = "唯一条码";
                int HMaterID = ClsPub.isInt(sHMaterID);
                int HUnitID = ClsPub.isInt(sHUnitID);
                int HQty = 0;
                string HBatchNo = "";
                string HSupID = "0";
                string HGroupID = "0";
                string HMaker = ClsPub.CurUserName;
                double HPrintQty = 0;
                double HinitQty = 0;
                string HSourceInterID = "0";
                string HSourceEntryID = "0";
                string HSourceBillNo = sHBarcodeNo;
                string HSourceBillType = "";
                double HEndQty = 0;
                int HBarcodeQtys = 0;
                int HBarcodeNo = 0;
                string HDeptID = "0";
                string HWhID = "0";
                string HSPID = "0";
                string HRemark = "";
                string HCusID = "0";
                string HCusType = "";
                string HEndDate = sDate;
                string HWorkLineName = "";
                string HBarCodeDate = sDate;
                string HSTOCKORGID = "0";
                string HOWNERID = "0";
                string HSeOrderBillNo = "";
                string HMaterName = sHMaterName;
                string HMaterModel = "";
                string HPinfan = "";
                string HAuxPropID = "0";
                string HMTONo = "";
                oCn.RunProc("insert into Gy_BarCodeBill "
                    + " (HBarCode,HBarCodeType,HMaterID,HUnitID,HQty,"
                    + " HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,"
                    + " HPrintQty,HinitQty,HSourceInterID,HSourceEntryID,HSourceBillNo,"
                    + " HSourceBillType,HEndQty,HBarcodeQtys,HBarcodeNo,HDeptID,"
                    + " HWhID,HSPID,HRemark,HCusID,HCusType,"
                    + " HEndDate,HWorkLineName,HBarCodeDate,HSTOCKORGID,HOWNERID,"
                    + "HSeOrderBillNo,HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo "
                    + ") values ('" + HBarCode + "','" + HBarCodeType + "','" + sHMaterID + "','" + sHUnitID + "','" + HQty + "','"
                        + HBatchNo + "','" + HSupID + "','" + HGroupID + "','" + HMaker + "',getdate(),'"
                        + HPrintQty + "','" + HinitQty + "','" + HSourceInterID + "','" + HSourceEntryID + "','" + HSourceBillNo + "','"
                        + HSourceBillType + "','" + HEndQty + "','" + HBarcodeQtys + "','" + HBarcodeNo + "','" + HDeptID + "','"
                        + HWhID + "','" + HSPID + "','" + HRemark + "','" + HCusID + "','" + HCusType + "','"
                        + HEndDate + "','" + HWorkLineName + "','" + HBarCodeDate + "','" + HSTOCKORGID + "'," + HOWNERID + ",'"
                        + HSeOrderBillNo + "','" + HMaterName + "','" + HMaterModel + "','" + HPinfan + "','" + HAuxPropID + "','" + HMTONo + "')"
                );
                ds = oCn.RunProcReturn("select HBarCode from Gy_BarCodeBill where HSourceBillNo = '" + sHBarcodeNo + "'  order by HMakeDate desc", "Gy_BarCodeBill");
            }
            catch (Exception e)
            {
                ds = null;
            }
            return CustomCorrect(ds);
        }

        /// <summary>
        /// 返回产线包装单列表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("LEMS/MES_ProductionLinePackagingList_Json")]
        [HttpGet]
        public object MES_ProductionLinePackagingList_Json(string sWhere)
        {
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_ProductionLinePackagingList order by 唯一条码 desc", "h_v_ProductionLinePackagingList");
                }
                else
                {
                    string sql1 = "select * from h_v_ProductionLinePackagingList where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    string sql2 = " order by 唯一条码 desc";
                    sql = sql + sql2;
                    ds = oCN.RunProcReturn(sql, "h_v_ProductionLinePackagingList");
                }

            }
            catch (Exception e)
            {
                ds = null;
            }
            return GetObjectJson(ds);
        }

        /// <summary>
        /// 扫批次条码方法（产线组装追溯单）--根据批次条码到条码档案表中获取数据保存到temp表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("LEMS/Save_Gy_BarCodeBillToTmp_Json")]
        [HttpGet]
        public object Save_Gy_BarCodeBillToTmp_Json(string HInterID, string HBillNo2, string HBarCode)
        {
            DataSet ds1;
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (HInterID == null || HInterID.Equals("") || HBillNo2 == null || HBillNo2.Equals("") || HBarCode == null || HBarCode.Equals(""))
                {
                    return CustomError("流转卡号或子件条码不能为空！");
                }
                else
                {
                    ds1 = oCN.RunProcReturn("select top 1 HBarCode from Gy_BarCodeBill where HBarCode = '" + HBarCode + "'", "Gy_BarCodeBill");
                    if (ds1.Tables[0].Rows.Count == 0)
                    {
                        return CustomError("无此批次条码");
                    }
                    ds = oCN.RunProcReturn("exec h_v_Save_Gy_BarCodeBillToTmp '" + HInterID + "','" + HBillNo2 + "','" + HBarCode + "'", "h_v_Save_Gy_BarCodeBillToTmp");

                }

            }
            catch (Exception e)
            {
                ds = null;
            }
            return CustomCorrect(ds);
            //return ds.Tables[0].Rows;
        }

        /// <summary>
        /// 返回产线组装追溯单列表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("LEMS/MES_AssemblyTraceabilityList_Json")]
        [HttpGet]
        public object MES_AssemblyTraceabilityList_Json(string sWhere)
        {
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_AssemblyTraceabilityList order by 生产任务单单号 desc,条码类型排序字段 ", "h_v_ProductionLinePackagingList");
                }
                else
                {
                    string sql1 = "select * from h_v_AssemblyTraceabilityList where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    string sql2 = " order by 生产任务单单号 desc,条码类型排序字段 ";
                    sql = sql + sql2;
                    ds = oCN.RunProcReturn(sql, "h_v_AssemblyTraceabilityList");
                }

            }
            catch (Exception e)
            {
                ds = null;
            }
            return GetObjectJson(ds);
        }

        /// <summary>
        /// 返回产线组装追溯单列表--过滤条件为镭雕条码的专用方法
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("LEMS/MES_AssemblyTraceabilityList_E_Json")]
        [HttpGet]
        public object MES_AssemblyTraceabilityList_E_Json(string HICMOBillNo)
        {
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (HICMOBillNo == null || HICMOBillNo.Equals(""))
                {
                    return CustomError("流转卡号或子件条码不能为空！");
                }
                else
                {
                    ds = oCN.RunProcReturn("exec h_v_AssemblyTraceabilityList_E " + HICMOBillNo, "h_v_AssemblyTraceabilityList_E");
                }

            }
            catch (Exception e)
            {
                ds = null;
            }
            return GetObjectJson(ds);
        }

        //根据ID删除缓存表中扫码记录-产线包装单
        [Route("LEMS/DelProductionLinePackagingTable")]
        [HttpGet]
        public object DelProductionLinePackagingTable(long sHInterID,string HSourceBillNo)
        {
            try
            {
                SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
                oCn.RunProc("Delete from KF_PonderationBillMain_Temp where HInterID = " + sHInterID + " and HSourceBillNo = '" + HSourceBillNo + "'", ref DBUtility.ClsPub.sExeReturnInfo);
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "删除成功！";
                objJsonResult.data = null;
                return objJsonResult;
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "删除失败！";
                objJsonResult.data = e.ToString();
                return objJsonResult;
            }

        }

        //
    }
}