采购订单 内外箱条码

王 垚

2021-10-27 12e7f0f026d22cd041bfea7865044a6f86de0792

采购订单 内外箱条码

 WebAPI/Controllers/BarCodeController.cs

@@ -20,7 +20,7 @@
    {
        private JsonResult objJsonResult = new JsonResult();
        private json objjson = new json();

        public new ClsCNSRM oCn = new ClsCNSRM();

        public T ScriptDeserialize<T>(string strJson)
        {
@@ -37,7 +37,7 @@
        /// <returns></returns>
        [Route("UpdateBarcodePrintQty")]
        [HttpPost]
        public object UpdateBarcodePrintQty([FromBody]JObject msg)
        public object UpdateBarcodePrintQty([FromBody] JObject msg)
        {
            var _value = msg["msg"].ToString();
            string msg1 = _value.ToString();
@@ -68,14 +68,14 @@
        /// <param name="msg"></param>
        /// <param name="msg2"></param>
        /// <returns></returns>
        public object GetBarcodeSaveBill_Varieties([FromBody]JObject msg)
        public object GetBarcodeSaveBill_Varieties([FromBody] JObject msg)
        {
            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 = "";            
            string UserName = "";
            ListModels oListModels = new ListModels();
            try
            {
@@ -134,7 +134,7 @@
                    if (ClsPub.isLong(oItemSub.HMaterID) != 0)
                    {
                        HNumber = oItemSub.HMaterID.ToString();
                        HMTONO=ClsPub.isStrNull(oItemSub.HMTONO);
                        HMTONO = ClsPub.isStrNull(oItemSub.HMTONO);
                        //

                        HQty = ClsPub.isDoule(oItemSub.HQty);
@@ -264,7 +264,7 @@
        /// <param name="msg"></param>
        /// <param name="msg2"></param>
        /// <returns></returns>
        public object GetBarcodeSaveBill_Only([FromBody]JObject msg)
        public object GetBarcodeSaveBill_Only([FromBody] JObject msg)
        {
            var _value = msg["msg"].ToString();
            string msg1 = _value.ToString();
@@ -316,7 +316,7 @@
                    }
                }
                //int i = 1;
                long linterid = Pub_Class.ClsPub.CreateBillID_SRMProd("8888", ref DBUtility.ClsPub.sExeReturnInfo);    
                long linterid = Pub_Class.ClsPub.CreateBillID_SRMProd("8888", ref DBUtility.ClsPub.sExeReturnInfo);
                int LSHlen = 6;             //流水号长度
                int SumLen = 10;            //总长度
                string TM = "";             //条码
@@ -345,8 +345,8 @@
                        HNumber = oItemSub.HMaterID.ToString();
                        //

                        HQty =ClsPub.isDoule(oItemSub.HQty);
                        HBQty =  ClsPub.isInt(oItemSub.HBQty);
                        HQty = ClsPub.isDoule(oItemSub.HQty);
                        HBQty = ClsPub.isInt(oItemSub.HBQty);
                        HMinQty = ClsPub.isDoule(oItemSub.HMinQty);
                        HSumQty = ClsPub.isDoule(oItemSub.HQty);
                        for (int i = 0; i < HBQty; i++)
@@ -369,7 +369,7 @@
                            {
                                TM = "0" + TM;
                            }
                           TM = "SRM" + TM; 
                            TM = "SRM" + TM;
                            //TM = "B" + TM;
                            if (HSumQty - HMinQty > 0)
                            {
@@ -408,7 +408,7 @@
                            bar.HSupID = oItemSub.HSupID;
                            bar.HMinQty = oItemSub.HMinQty;
                            bar.HMTONO = oItemSub.HMTONO;
                            

                            ls2.Add(bar);
                        }
                    }
@@ -464,7 +464,7 @@
                }
                //暂时只回填关联数量
                oCn.RunProc("exec H_p_SRM_BarCodeBill_Update_UpdateBillRelateData " + linterid.ToString());
                

                oCn.Commit();
            }
            catch (Exception e)
@@ -476,13 +476,13 @@
                return objJsonResult;
            }

                objJsonResult.code = "0";
                objJsonResult.count = 1;
                objJsonResult.Message = "生成条码成功！";
                WebAPIController.Add_Log("条码下推", UserName, "生成条码");
                objJsonResult.data = null;
                return objJsonResult;
            }
            objJsonResult.code = "0";
            objJsonResult.count = 1;
            objJsonResult.Message = "生成条码成功！";
            WebAPIController.Add_Log("条码下推", UserName, "生成条码");
            objJsonResult.data = null;
            return objJsonResult;
        }

        [Route("GetBarcodeSaveBillBox")]
        [HttpPost]
@@ -492,7 +492,7 @@
        /// <param name="msg"></param>
        /// <param name="msg2"></param>
        /// <returns></returns>
        public object GetBarcodeSaveBill_Box([FromBody]JObject msg)
        public object GetBarcodeSaveBill_Box([FromBody] JObject msg)
        {
            var _value = msg["msg"].ToString();
            string msg1 = _value.ToString();
@@ -553,62 +553,62 @@
                    }
                }
                long linterid = Pub_Class.ClsPub.CreateBillID_SRMProd("8888", ref DBUtility.ClsPub.sExeReturnInfo);
            int LSHlen = 6;             //流水号长度
            int SumLen = 10;            //总长度
            string TM = "";             //条码
            string HNumber = "";        //物料代码
            double HSumQty = 0;         //产品数量
            double HMinQty = 0;         //最小包装数
            int HBQty = 0;              //箱数
            double HQty = 0;            //数量
            int LSH = 0;                //流水号
            string LSH2 = "";           //流水号转换成字符
            string sDate = "";            //日期
            string sYear = "";          //年
            string sPeriod = "";        //月
            string sDay = "";            //日
            string WeiShu = ""; //尾数
            DataSet Ds;
            SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM();
            Ds = oCn.RunProcReturn("exec GetLSH '" + DateTime.Today + "'", "GetLSH");
            LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]);
             foreach (Model.ClsGy_MaterialList_WMS_Model oItemSub in ls)
            {
                if (ClsPub.isLong(oItemSub.HMaterID) != 0)
                int LSHlen = 6;             //流水号长度
                int SumLen = 10;            //总长度
                string TM = "";             //条码
                string HNumber = "";        //物料代码
                double HSumQty = 0;         //产品数量
                double HMinQty = 0;         //最小包装数
                int HBQty = 0;              //箱数
                double HQty = 0;            //数量
                int LSH = 0;                //流水号
                string LSH2 = "";           //流水号转换成字符
                string sDate = "";            //日期
                string sYear = "";          //年
                string sPeriod = "";        //月
                string sDay = "";            //日
                string WeiShu = ""; //尾数
                DataSet Ds;
                SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM();
                Ds = oCn.RunProcReturn("exec GetLSH '" + DateTime.Today + "'", "GetLSH");
                LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]);
                foreach (Model.ClsGy_MaterialList_WMS_Model oItemSub in ls)
                {
                    HNumber = oItemSub.HMaterID.ToString();
                    //HNumber = HNumber.Replace(".", "");
                    //
                    if (ClsPub.isLong(oItemSub.HMaterID) != 0)
                    {
                        HNumber = oItemSub.HMaterID.ToString();
                        //HNumber = HNumber.Replace(".", "");
                        //

                        //HQty = Math.Ceiling(HBQty + ClsPub.isDoule(oItemSub.HWBQty));

                    HQty = ClsPub.isDoule(oItemSub.HWBQty);
                    HBQty = ClsPub.isInt(oItemSub.HWBQty);
                    HMinQty = ClsPub.isDoule(oItemSub.HWXQty);
                    HSumQty = ClsPub.isDoule(oItemSub.HQty);  //HWXQtyCol
                    for (int i = 0; i < HBQty; i++)
                    {
                        LSH = LSH + 1;
                        LSH2 = LSH.ToString();
                        while (LSH2.Length < LSHlen)  //如果流水号小于6位数前面补0
                        HQty = ClsPub.isDoule(oItemSub.HWBQty);
                        HBQty = ClsPub.isInt(oItemSub.HWBQty);
                        HMinQty = ClsPub.isDoule(oItemSub.HWXQty);
                        HSumQty = ClsPub.isDoule(oItemSub.HQty);  //HWXQtyCol
                        for (int i = 0; i < HBQty; i++)
                        {
                            LSH2 = "0" + LSH2;
                        }
                        sDate = ClsPub.GetServerDate(0);
                        sYear = ClsPub.isDate(sDate).Year.ToString().Substring(2, 2);
                        sPeriod = "0" + ClsPub.isDate(sDate).Month.ToString();
                        sPeriod = sPeriod.Substring(sPeriod.Length - 2, 2);
                        sDay = "0" + ClsPub.isDate(sDate).Day.ToString();
                        sDay = sDay.Substring(sDay.Length - 2, 2);
                        //==================================
                        TM = HNumber + sYear + sPeriod + sDay + LSH2;
                        while (TM.Length < SumLen)  //如果条码小于12位数前面补0
                        {
                            TM = "0" + TM;
                        }
                            LSH = LSH + 1;
                            LSH2 = LSH.ToString();
                            while (LSH2.Length < LSHlen)  //如果流水号小于6位数前面补0
                            {
                                LSH2 = "0" + LSH2;
                            }
                            sDate = ClsPub.GetServerDate(0);
                            sYear = ClsPub.isDate(sDate).Year.ToString().Substring(2, 2);
                            sPeriod = "0" + ClsPub.isDate(sDate).Month.ToString();
                            sPeriod = sPeriod.Substring(sPeriod.Length - 2, 2);
                            sDay = "0" + ClsPub.isDate(sDate).Day.ToString();
                            sDay = sDay.Substring(sDay.Length - 2, 2);
                            //==================================
                            TM = HNumber + sYear + sPeriod + sDay + LSH2;
                            while (TM.Length < SumLen)  //如果条码小于12位数前面补0
                            {
                                TM = "0" + TM;
                            }
                            //TM = "B" + TM;
                            TM = "SRM" + "B" + TM;
                        

                            if (HSumQty - HMinQty > 0)
                            {
                                WeiShu = "";
@@ -626,136 +626,136 @@
                                }
                                HMinQty = HSumQty;
                            }
 
                        Model.ClsGy_BarCodeBill_WMS_Model bar = new Model.ClsGy_BarCodeBill_WMS_Model();
                        bar.HBarCode = TM;
                        bar.HMaterID = oItemSub.HMaterID;
                        //bar.HMaterNumber = oItemSub.HMaterNumber;
                        //bar.HMaterName = oItemSub.HMaterName;
                        //bar.HMaterModel = oItemSub.HMaterModel;
                      //  bar.HModel2 = oItemSub.HModel;

                        bar.HUnitID = oItemSub.HUnitID;
                        //bar.HUnitNumber2 = oItemSub.HUnitNumber;
                        //bar.HUnitName2 = oItemSub.HUnitName;
                            Model.ClsGy_BarCodeBill_WMS_Model bar = new Model.ClsGy_BarCodeBill_WMS_Model();
                            bar.HBarCode = TM;
                            bar.HMaterID = oItemSub.HMaterID;
                            //bar.HMaterNumber = oItemSub.HMaterNumber;
                            //bar.HMaterName = oItemSub.HMaterName;
                            //bar.HMaterModel = oItemSub.HMaterModel;
                            //  bar.HModel2 = oItemSub.HModel;

                        bar.HQty = HMinQty;
                        bar.HBatchNo = oItemSub.HBatchNo; 
                        bar.HKFDate = oItemSub.HKFDate;
                        bar.HKFPeriod = oItemSub.HKFPeriod;
                        bar.HKFDQDate = oItemSub.HKFDQDate;
                        bar.HSourceInterID = oItemSub.HSourceInterID;
                        bar.HSourceEntryID = oItemSub.HSourceEntryID;
                        bar.HSourceBillNo = oItemSub.HSourceBillNo;
                        bar.HSourceBillType = oItemSub.HSourceBillType;
                        bar.HMinQty = oItemSub.HMinQty;
                        bar.HSupID = oItemSub.HSupID;
                        bar.HEndQty = WeiShu;
                        bar.HMTONO = oItemSub.HMTONO;
                        ls2.Add(bar);
                            bar.HUnitID = oItemSub.HUnitID;
                            //bar.HUnitNumber2 = oItemSub.HUnitNumber;
                            //bar.HUnitName2 = oItemSub.HUnitName;

                            bar.HQty = HMinQty;
                            bar.HBatchNo = oItemSub.HBatchNo;
                            bar.HKFDate = oItemSub.HKFDate;
                            bar.HKFPeriod = oItemSub.HKFPeriod;
                            bar.HKFDQDate = oItemSub.HKFDQDate;
                            bar.HSourceInterID = oItemSub.HSourceInterID;
                            bar.HSourceEntryID = oItemSub.HSourceEntryID;
                            bar.HSourceBillNo = oItemSub.HSourceBillNo;
                            bar.HSourceBillType = oItemSub.HSourceBillType;
                            bar.HMinQty = oItemSub.HMinQty;
                            bar.HSupID = oItemSub.HSupID;
                            bar.HEndQty = WeiShu;
                            bar.HMTONO = oItemSub.HMTONO;
                            ls2.Add(bar);
                        }
                    }
                }
            }
            foreach (Model.ClsGy_BarCodeBill_WMS_Model oItemSub2 in ls2)
            {
                if (ClsPub.isLong(oItemSub2.HMaterID) != 0)
                foreach (Model.ClsGy_BarCodeBill_WMS_Model oItemSub2 in ls2)
                {
                    long sMaterID = ClsPub.isLong(oItemSub2.HMaterID);
                    Ds = oCn.RunProcReturn("exec GetLSH " + sMaterID.ToString(), "GetLSH");
                    string WeiShu1 = ""; //尾数
                    int SumLen2 = 4;
                    string TM2 = "";
                    double HWXQty = 0;
     
                    LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]) + 1;
                    //
                    HNumber = oItemSub2.HMaterID.ToString();
                    //HMinQty = ClsPub.isDoule(oItemSub2.HMinQtyCol2].Value);
                    HWXQty = ClsPub.isDoule(oItemSub2.HMinQty);
                    HSumQty = ClsPub.isDoule(oItemSub2.HQty);
                    HBQty = ClsPub.isInt(Math.Ceiling(HSumQty / HWXQty));
                    double NXTMQTY = 0;
                    for (int i = 0; i < HBQty; i++)
                    if (ClsPub.isLong(oItemSub2.HMaterID) != 0)
                    {
                        if (HSumQty <= 0 || HWXQty <= 0)
                        long sMaterID = ClsPub.isLong(oItemSub2.HMaterID);
                        Ds = oCn.RunProcReturn("exec GetLSH " + sMaterID.ToString(), "GetLSH");
                        string WeiShu1 = ""; //尾数
                        int SumLen2 = 4;
                        string TM2 = "";
                        double HWXQty = 0;

                        LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]) + 1;
                        //
                        HNumber = oItemSub2.HMaterID.ToString();
                        //HMinQty = ClsPub.isDoule(oItemSub2.HMinQtyCol2].Value);
                        HWXQty = ClsPub.isDoule(oItemSub2.HMinQty);
                        HSumQty = ClsPub.isDoule(oItemSub2.HQty);
                        HBQty = ClsPub.isInt(Math.Ceiling(HSumQty / HWXQty));
                        double NXTMQTY = 0;
                        for (int i = 0; i < HBQty; i++)
                        {
                            break;
                        }
                        if (HSumQty - HWXQty > 0)
                        {
                            WeiShu1 = "";
                            NXTMQTY = HWXQty;
                            HSumQty = HSumQty - HWXQty;
                        }
                        else
                        {
                            if (HSumQty == HWXQty)
                            if (HSumQty <= 0 || HWXQty <= 0)
                            {
                                break;
                            }
                            if (HSumQty - HWXQty > 0)
                            {
                                WeiShu1 = "";
                                NXTMQTY = HWXQty;
                                HSumQty = HSumQty - HWXQty;
                            }
                            else
                            {
                                WeiShu1 = "尾数";
                                if (HSumQty == HWXQty)
                                {
                                    WeiShu1 = "";
                                }
                                else
                                {
                                    WeiShu1 = "尾数";
                                }
                                NXTMQTY = HSumQty;  //HWXQty
                                HWXQty = HSumQty;
                                HSumQty = 0;
                            }
                            NXTMQTY = HSumQty;  //HWXQty
                            HWXQty = HSumQty;
                            HSumQty = 0;
                            sDate = ClsPub.GetServerDate(0);
                            sYear = ClsPub.isDate(sDate).Year.ToString().Substring(2, 2);
                            sPeriod = "0" + ClsPub.isDate(sDate).Month.ToString();
                            sPeriod = sPeriod.Substring(sPeriod.Length - 2, 2);
                            sDay = "0" + ClsPub.isDate(sDate).Day.ToString();
                            sDay = sDay.Substring(sDay.Length - 2, 2);
                            //
                            //   TM = HNumber + sYear + sPeriod + sDay; //条码
                            //
                            Model.ClsGy_BarCodeBill_WMS_Model bar2 = new Model.ClsGy_BarCodeBill_WMS_Model();
                            TM2 = (i + 1).ToString();
                            while (TM2.Length < SumLen2)  //如果条码小于12位数前面补0
                            {
                                TM2 = "0" + TM2;
                            }
                            bar2.HMaterID = oItemSub2.HMaterID;


                            bar2.HBarCode = oItemSub2.HBarCode + "-" + TM2;

                            bar2.HUnitID = oItemSub2.HUnitID;
                            bar2.HQty = HWXQty;
                            bar2.HBatchNo = DBUtility.ClsPub.isStrNull(oItemSub2.HBatchNo);
                            bar2.HKFDate = DBUtility.ClsPub.isStrNull(oItemSub2.HKFDate);
                            bar2.HKFDQDate = DBUtility.ClsPub.isStrNull(oItemSub2.HKFDQDate);
                            bar2.HKFPeriod = DBUtility.ClsPub.isInt(oItemSub2.HKFPeriod);
                            bar2.HSourceInterID = oItemSub2.HSourceInterID;
                            bar2.HSourceEntryID = oItemSub2.HSourceEntryID;
                            bar2.HSourceBillNo = oItemSub2.HSourceBillNo;
                            bar2.HSourceBillType = oItemSub2.HSourceBillType;
                            bar2.HSupID = oItemSub2.HSupID;
                            bar2.HEndQty = WeiShu1;
                            bar2.HMTONO = oItemSub2.HMTONO;
                            ls3.Add(bar2);
                        }
                        sDate = ClsPub.GetServerDate(0);
                        sYear = ClsPub.isDate(sDate).Year.ToString().Substring(2, 2);
                        sPeriod = "0" + ClsPub.isDate(sDate).Month.ToString();
                        sPeriod = sPeriod.Substring(sPeriod.Length - 2, 2);
                        sDay = "0" + ClsPub.isDate(sDate).Day.ToString();
                        sDay = sDay.Substring(sDay.Length - 2, 2);
                        //
                     //   TM = HNumber + sYear + sPeriod + sDay; //条码
                        //
                        Model.ClsGy_BarCodeBill_WMS_Model bar2 = new Model.ClsGy_BarCodeBill_WMS_Model();
                        TM2 = (i + 1).ToString();
                        while (TM2.Length < SumLen2)  //如果条码小于12位数前面补0
                        {
                            TM2 = "0" + TM2;
                        }                        
                        bar2.HMaterID = oItemSub2.HMaterID;


                        bar2.HBarCode = oItemSub2.HBarCode + "-" + TM2;

                        bar2.HUnitID = oItemSub2.HUnitID;
                        bar2.HQty = HWXQty;
                        bar2.HBatchNo = DBUtility.ClsPub.isStrNull(oItemSub2.HBatchNo);
                        bar2.HKFDate = DBUtility.ClsPub.isStrNull(oItemSub2.HKFDate);
                        bar2.HKFDQDate = DBUtility.ClsPub.isStrNull(oItemSub2.HKFDQDate);
                        bar2.HKFPeriod = DBUtility.ClsPub.isInt(oItemSub2.HKFPeriod);
                        bar2.HSourceInterID = oItemSub2.HSourceInterID;
                        bar2.HSourceEntryID = oItemSub2.HSourceEntryID;
                        bar2.HSourceBillNo = oItemSub2.HSourceBillNo;
                        bar2.HSourceBillType = oItemSub2.HSourceBillType;
                        bar2.HSupID = oItemSub2.HSupID;
                        bar2.HEndQty = WeiShu1;
                        bar2.HMTONO = oItemSub2.HMTONO;
                        ls3.Add(bar2);
                    }
                }
            }     
            string HBarCode = "";
            string HBarCodeType = "";
            Int64 HMaterID = 0;
            Int64 HUnitID = 0;
            double HQty2 = 0;
            string HBatchNo = "";
            Int64 HSupID = 0;
            Int64 HGroupID = 0;
            int HPrintQty = 0;
            Int64 HSourceInterID = 0;
            Int64 HSourceEntryID = 0;
            string HSourceBillNo = "";
            string HSourceBillType = "";
            Int64 HKFPeriod = 0;
            string HKFDate = "";
            string HKFDQDate = "";
            string HWei = "";
            string HMTONO = "";
                string HBarCode = "";
                string HBarCodeType = "";
                Int64 HMaterID = 0;
                Int64 HUnitID = 0;
                double HQty2 = 0;
                string HBatchNo = "";
                Int64 HSupID = 0;
                Int64 HGroupID = 0;
                int HPrintQty = 0;
                Int64 HSourceInterID = 0;
                Int64 HSourceEntryID = 0;
                string HSourceBillNo = "";
                string HSourceBillType = "";
                Int64 HKFPeriod = 0;
                string HKFDate = "";
                string HKFDQDate = "";
                string HWei = "";
                string HMTONO = "";
                oCn.BeginTran();
                foreach (Model.ClsGy_BarCodeBill_WMS_Model oItemSub in ls2)
                {
@@ -1163,5 +1163,111 @@

        }


        [Route("GetHBarCodeShowBillMainBycg")]
        /// <summary>
        /// 条码生成表头（采购订单）
        /// </summary>
        /// <param name="sMsg"></param>
        /// <returns></returns>
        public object GetHBarCodeShowBillMainBycg(string sMsg)
        {
            try
            {
                DataSet ds;
                string s = "";
                string ShowItem = " * ";//显示的字段
                if (DBUtility.ClsPub.isLong(sMsg) == 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);
                ds = oCn.RunProcReturn(sql, "h_v_Cg_POOrderBillMain_ForWeb2");
                //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;
            }
        }
        [Route("GetHBarCodeShowBillSubBycg")]
        [HttpGet]
        /// <summary>
        /// 条码生成表体（采购订单）
        /// </summary>
        /// <param name="sMsg"></param>
        /// <returns></returns>
        public object GetHBarCodeShowBillSubBycg(string sMsg)
        {
            try
            {
                DataSet ds;
                string s = "";
                string ShowItem = " * ";//显示的字段
                if (DBUtility.ClsPub.isLong(sMsg) == 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_POOrderBillSub_ForWeb2 where HInterID = " + sMsg);
                ds = oCn.RunProcReturn(sql, "h_v_Cg_POOrderBillSub_ForWeb2");
                //ds = oClsWeb_BarCodeBill.ShowBillSub(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;
            }
        }

    }
}

 WebAPI/Models/ClsCg_POInStockBillMains.cs

New file
@@ -0,0 +1,20 @@
using System;
using System.Collections.Generic;
using System.Text;

namespace Model
{
    public class ClsCg_POInStockBillMains : DBUtility.ClsXt_BaseBillMain
    {
        public string HAddress;//     varchar(200)                --交货地点 
        public Int64 HSupID;//      int                 --供应商 （Gy_Supplier）
        public Int64 HCurID;//    int                  --币别 (Gy_Currency)
        public Int64 HWHID;//      int     --仓库
        public Single HExRate;//    money                  --汇率  (选择完币别带出)
        public Int64 HEmpID;//     int                   --业务员  (Gy_Employee)
        public Int64 HManagerID;//  int                 --主管    (Gy_Employee)
        public Int64 HDeptID;//     int                 --部门    (Gy_Employee)
        public string HExplanation;//  varchar(200)             --ժҪ 
        public string HInnerBillNo;//  varchar(50)             --内部单据号
    }
}

 WebAPI/Models/ClsCg_POInStockBillSubs.cs

New file
@@ -0,0 +1,26 @@
using System;
using System.Collections.Generic;
using System.Text;

namespace Model
{
    public class ClsCg_POInStockBillSubs : DBUtility.ClsXt_BaseBillSub
    { 
        public DateTime HEntryCloseDate;//   datetime      --行关闭 (默认为'')        new
        public string HRemark;//         varchar(200)        --备注 
        public Int64 HMaterID;//  int      --物料ID (Gy_Material)
        public Int64 HUnitID;//    int    --计量单位 (Gy_Unit)
        public double HQty;//     dec(18,8)         --数量
        public double HCheckQty;        //检验数
        public double HPassQty;         //合格数
        public double HBadQty;          //不合格数
        public double HPrice;//   dec(18,8)         --原币单价
        public double HMoney;//   dec(18,8)         --原币金额
        public double HTaxPrice;//   dec(18,8)         --含税单价
        public double HTaxMoney;//   dec(18,8)         --含税金额
        public Int64 HWHID;//              --收料仓库
        public Int64 HPOOrderInterID;//
        public Int64 HPOOrderEntryID;//
        public string HPOOrderBillNo;//
    }
}

 WebAPI/WebAPI.csproj

@@ -173,6 +173,8 @@
    <Compile Include="Controllers\ReportController.cs" />
    <Compile Include="ListModels.cs" />
    <Compile Include="Models\ClsCg_POInStockBill.cs" />
    <Compile Include="Models\ClsCg_POInStockBillMains.cs" />
    <Compile Include="Models\ClsCg_POInStockBillSubs.cs" />
    <Compile Include="Models\json.cs" />
    <Compile Include="Controllers\WebAPIController.cs" />
    <Compile Include="Global.asax.cs">