采购订单 内外箱条码

王 垚

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)
        {
@@ -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">