王 垚
2021-12-06 b386a0c4ce29a5ae61ee900fdb2522d8e6b52ca2
工资结算单(个人)
1个文件已删除
3个文件已修改
3个文件已添加
825 ■■■■ 已修改文件
WebAPI/Controllers/Pay_SingleBalBillController.cs 339 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/工资管理/Pay_SingleBalBillController.cs 370 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/DLL/ClsPay_SingleBalBill.cs 12 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/ListModels.cs 41 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Models/工资管理/ClsPay_SingleBalBillMain.cs 17 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Models/工资管理/ClsPay_SingleBalBillSub.cs 42 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/WebAPI.csproj 4 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/Pay_SingleBalBillController.cs
File was deleted
WebAPI/Controllers/¹¤×ʹÜÀí/Pay_SingleBalBillController.cs
New file
@@ -0,0 +1,370 @@
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.Web.Http;
using WebAPI.Models;
namespace WebAPI.Controllers
{
    public class Pay_SingleBalBillController : ApiController
    {
        public DBUtility.ClsPub.Enum_BillStatus BillStatus;
        private json objJsonResult = new json();
        public DataSet ds = new DataSet();
        public WebServer webserver = new WebServer();
        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
        public DLL.ClsPay_SingleBalBill BillNew0 = new DLL.ClsPay_SingleBalBill();   //
        public DLL.ClsPay_SingleBalBill BillOld0 = new DLL.ClsPay_SingleBalBill();   //
        /// <summary>
        /// è¿”回工资结算个人列表
        ///参数:string sql。
        ///返回值:object。
        /// </summary>
        [Route("Pay_SingleBalBill/GetSingleBalBill")]
        [HttpGet]
        public object GetSingleBalBill(string sWhere)
        {
            try
            {
                ds = Sc_GetSingleBalBill(sWhere);
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "返回记录成功!";
                objJsonResult.data = ds.Tables[0];
                return objJsonResult;
            }
            catch (Exception ex)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录!" + ex.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        public static DataSet Sc_GetSingleBalBill(string sWhere)
        {
            if (sWhere == null || sWhere.Equals(""))
            {
                return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Pay_SingleBalBillList order by æ—¥æœŸ desc", "h_v_Pay_SingleBalBillList");
            }
            else
            {
                string sql1 = "select * from h_v_Pay_SingleBalBillList where 1 = 1 ";
                string sql = sql1 + sWhere + "order by æ—¥æœŸ desc";
                return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Pay_SingleBalBillList");
            }
        }
        #region[工资结算个人单编辑时获取表头数据]
        [Route("Pay_SingleBalBill/Pay_SingleBalBillListCheckDetail")]
        [HttpGet]
        public ApiResult<DataSet> Pay_SingleBalBillListCheckDetail(string HID)
        {
            if (string.IsNullOrEmpty(HID))
                return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };
            SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
            var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Pay_SingleBalBillList  where hmainid= " + HID + " ", "h_v_Pay_SingleBalBillList");
            if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
                return new ApiResult<DataSet> { code = -1, msg = "不存在结算单号" };
            return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet };
        }
        #endregion
        #region[工资结算个人单编辑时获取表体数据]
        [Route("Pay_SingleBalBill/Pay_SingleBalBillListProjectDetai")]
        [HttpGet]
        public object Pay_SingleBalBillListProjectDetai(string sqlWhere)
        {
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                string sql1 = "SELECT HMaterID,HMaterCode,HMaterName, HDeptID,部门代码,部门" +
                    ",HGroupID,班组代码,班组,工资类型,摘要,内部单据号,表头备注,制单人,制单日期" +
                    ",审核人,审核日期,修改人,修改日期,关闭人, å…³é—­æ—¥æœŸ,HProcID,HProcNumber,HProcName" +
                    ",HEmpID,HEmpNumber,HEmpName,工时 HTimes ,数量 HQty,工价 HPrice,金额 HMoney ,表体备注 as HRemark FROM h_v_Pay_SingleBalBillList where 1 = 1 ";
                string sql = sql1 + sqlWhere;
                ds = oCN.RunProcReturn(sql, "h_v_Pay_SingleBalBillList");
                objJsonResult.code = "0";
                objJsonResult.count = 1;
                objJsonResult.Message = "获取信息成功!";
                objJsonResult.data = ds.Tables[0];
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录!" + e.ToString();
                objJsonResult.data = null;
            }
            return objJsonResult;
        }
        [Route("Pay_SingleBalBill/SaveGetSingleBalBillList")]
        [HttpPost]
        #endregion
        /// <summary>
        /// æ–°å¢žå•据-保存按钮
        ///参数:string sql。
        ///返回值:object。
        /// </summary>
        public object SaveGetSingleBalBillList([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 refSav = sArray[2].ToString();
            //string msg4 = sArray[3].ToString();
            string UserName = "";
            string s = "";
            long mouldid;
            ListModels oListModels = new ListModels();
            try
            {
                ////编辑权限
                //if (!DBUtility.ClsPub.Security_Log_second("Pay_SingleBalBill_Edit", 1, true, msg4))
                //{
                //    objJsonResult.code = "0";
                //    objJsonResult.count = 0;
                //    objJsonResult.Message = "无保存权限!";
                //    objJsonResult.data = null;
                //    return objJsonResult;
                //}
                DLL.ClsPay_SingleBalBill oBill = new DLL.ClsPay_SingleBalBill();
                List<Models.ClsPay_SingleBalBillMain> lsmain = new List<Models.ClsPay_SingleBalBillMain>();
                msg2 = msg2.Replace("\\", "");
                msg2 = msg2.Replace("\n", "");  //\n
                lsmain = oListModels.getObjectByJson_Pay_SingleBalBillMain(msg2);
                foreach (Models.ClsPay_SingleBalBillMain oItem in lsmain)
                {
                    if (refSav == "Add")
                    {
                        //单据号是否重复
                        if (BillNew0.IsExistBillNo(ref ClsPub.sExeReturnInfo, oItem.HBillNo, BillStatus, BillOld0.omodel.HInterID))
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "单据号重复!不允许保存!";
                            objJsonResult.data = 1;
                            return objJsonResult;
                        }
                    }
                    if (refSav == "Update")
                    {
                        if (BillOld0.ShowBill(oItem.HInterID, ref s) == false)
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "此单据有误!";
                            objJsonResult.data = 1;
                            return objJsonResult;
                        }
                        //判断是否可编辑
                        if (BillOld0.omodel.HChecker != "" && BillOld0.omodel.HChecker != null)
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "此单据已经被审核,不允许修改!";
                            objJsonResult.data = 1;
                            return objJsonResult;
                        }
                        if (BillOld0.omodel.HBillStatus > 1)
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "此单据处于不可编辑状态,不允许修改!";
                            objJsonResult.data = 1;
                            return objJsonResult;
                        }
                        if (!DBUtility.Xt_BaseBillFun.Fun_AllowEditBill(BillOld0, ref s))
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = s + ",不允许修改";
                            objJsonResult.data = 1;
                            return objJsonResult;
                        }
                    }
                    //oItem.HMaker = "";
                    UserName = oItem.HMaker;  //制单人
                    oItem.HBillType = "2205";
                    oItem.HBillSubType = "2205";
                    //oItem.HBillNo = "";    //单据号
                    //oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));//  --日期
                    //oItem.HInnerBillNo = "";  //  --内部单据号
                    oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
                    oItem.HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month);
                    oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd"));
                    //oItem.HEquipID = 0;    //设备ID(Gy_EquipMent)
                    //oItem.HPeriod = 0;
                    //oItem.HCheckBeginDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));  //  --维修日期
                    //oItem.HCheckResult = "";     //验收结论--(正常,异常)
                    //oItem.HEmpID = 0;           //验收人(Gy_Employee)
                    //oItem.HManagerID = 0;      //负责人(Gy_Employee)
                    //oItem.HDeptID = 0;        //验收部门(Gy_Department)
                    //oItem.HExplanation = "";  //摘要(故障描述)
                    //oItem.HRemark = "";       //备注
                    //oItem.HMainSourceInterID = oItem.HInterID;
                    //oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo);
                    if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "")
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "保存失败!没有单据日期,无法保存!";
                        objJsonResult.data = 1;
                        return objJsonResult;
                    }
                    oBill.omodel = oItem;
                }
                //表体数据
                //按 },{来拆分数组 //去掉【和】
                msg3 = msg3.Substring(1, msg3.Length - 2);
                msg3 = msg3.Replace("\\", "");
                msg3 = msg3.Replace("\n", "");  //\n
                //msg2 = msg2.Replace("'", "’");
                List<Models.ClsPay_SingleBalBillSub> ls = new List<Models.ClsPay_SingleBalBillSub>();
                ls = oListModels.getObjectByJson_Pay_SingleBalBillSub(msg3);
                int i = 0;
                foreach (Models.ClsPay_SingleBalBillSub oItemSub in ls)
                {
                    i++;
                    oItemSub.HEntryID = i;
                    mouldid = oItemSub.HMaterID;
                    //oItemSub.HRepairCheckID = 0;   //验收项目ID
                    //oItemSub.HRepairCheckContent = ""; //验收内容
                    //oItemSub.HManagerID = 0;   //负责人ID
                    //oItemSub.HCloseMan = "";       //行关闭
                    oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);
                    oItemSub.HCloseType = false;   //关闭类型
                    //oItemSub.HRemark = "";         //备注
                    oItemSub.HSourceInterID = 0;     // æºå•主内码
                    oItemSub.HSourceEntryID = 0;   //源单子内码
                    //oItemSub.HSourceBillNo = "";  //源单单号
                    //oItemSub.HSourceBillType = ""; //源单类型
                    //oItemSub.HRelationQty = 0;     //关联数量
                    //oItemSub.HRelationMoney = 0;   //关联金额
                    //oItemSub.HRepairID = 0;       //维修项目
                    //oItemSub.HRepairExplanation ="";   //维修要求
                    //oItemSub.HMoney = 0;        //维修费用
                    oBill.DetailColl.Add(oItemSub);
                }
                //保存
                //保存完毕后处理
                bool bResult;
                if (oBill.omodel.HInterID == 0)
                {
                    // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
                    bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
                }
                else
                {
                    bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
                }
                if (bResult)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "保存成功!";
                    //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单");
                    objJsonResult.data = 1;
                    return objJsonResult;
                }
                else
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "保存失败!" + DBUtility.ClsPub.sExeReturnInfo;
                    objJsonResult.data = 1;
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "保存失败!" + e.ToString();
                objJsonResult.data = 1;
                return objJsonResult;
            }
        }
        /// <summary>
        ///工资结算个人单删除功能
        /// </summary>
        /// <returns></returns>
        [Route("Pay_SingleBalBill/DeltetSingleBalBill")]
        [HttpGet]
        public object Pay_SingleBalBill(string HInterID)
        {
            try
            {
                oCN.BeginTran();
                oCN.RunProc("Delete From Pay_SingleBalBillMain where HInterID = " + HInterID);
                oCN.RunProc("Delete From Pay_SingleBalBillSub where HInterID = " + HInterID);
                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;
            }
        }
        [Route("Pay_SingleBalBill/getSingleBalBillPrice")]
        [HttpGet]
        public object getSingleBalBillPrice(string HMaterID,string HProcID)
        {
            try
            {
                DataSet ds = oCN.RunProcReturn("select å•ä»· from h_v_Gy_ProcPriceList where HMaterID='" + HMaterID + "' and HProcID='" + HProcID + "'", "h_v_Gy_ProcPriceList");
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "查询成功!";
                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;
            }
        }
        //
    }
}
WebAPI/DLL/ClsPay_SingleBalBill.cs
@@ -3,12 +3,12 @@
using System.Text;
using System.Data;
namespace DAL
namespace WebAPI.DLL
{
    public class ClsPay_SingleBalBill : DBUtility.ClsXt_BaseBill
    {
        public Model.ClsPay_SingleBalBillMain omodel = new Model.ClsPay_SingleBalBillMain();
        public List<Model.ClsPay_SingleBalBillSub> DetailColl = new List<Model.ClsPay_SingleBalBillSub>();
        public Models.ClsPay_SingleBalBillMain omodel = new Models.ClsPay_SingleBalBillMain();
        public List<Models.ClsPay_SingleBalBillSub> DetailColl = new List<Models.ClsPay_SingleBalBillSub>();
        public ClsPay_SingleBalBill()
        {
@@ -61,7 +61,7 @@
                DeleteBillSub(lngBillKey);
                //插入子表
                omodel.HInterID = lngBillKey;
                foreach (Model.ClsPay_SingleBalBillSub oSub in DetailColl)
                foreach (Models.ClsPay_SingleBalBillSub oSub in DetailColl)
                {
                    oCn.RunProc("Insert into Pay_SingleBalBillSub " +
                      " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" +
@@ -125,7 +125,7 @@
                ", " + omodel.HGroupID.ToString() + "," + omodel.HDeptID.ToString() + "," + omodel.HEmpID.ToString() + "," + omodel.HPayType.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'" +
                ") ");
                //插入子表
                foreach (Model.ClsPay_SingleBalBillSub oSub in DetailColl)
                foreach (Models.ClsPay_SingleBalBillSub oSub in DetailColl)
                {
                    oCn.RunProc("Insert into Pay_SingleBalBillSub " +
                      " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" +
@@ -224,7 +224,7 @@
                DetailColl.Clear();//清空
                for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++)
                {
                    Model.ClsPay_SingleBalBillSub oSub = new Model.ClsPay_SingleBalBillSub();
                    Models.ClsPay_SingleBalBillSub oSub = new Models.ClsPay_SingleBalBillSub();
                    // å›ºå®šèµ‹å€¼===============================================
                    oSub.HInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HInterID"]);
                    oSub.HEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HEntryID"]);
WebAPI/ListModels.cs
@@ -1317,31 +1317,7 @@
            return list;
        }
        /// <summary>
        /// å¤„理工资个人结算单主表的json
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsPay_SingleBalBillMain> getObjectByJson_Pay_SingleBalBillMain(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsPay_SingleBalBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsPay_SingleBalBillMain>>(jsonString);
            return list;
        }
        /// <summary>
        /// å¤„理工资个人结算单子表的json
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsPay_SingleBalBillSub> getObjectByJson_Pay_SingleBalBillSub(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsPay_SingleBalBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsPay_SingleBalBillSub>>(jsonString);
            return list;
        }
        /// <summary>
        /// å¤„理新增模具寿命调整单主表的json
        /// å¤„理新增模具寿命调整单子表的json
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
@@ -1351,7 +1327,6 @@
            List<Model.ClsSc_MouldLifeChangeBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_MouldLifeChangeBillMain>>(jsonString);
            return list;
        }
        /// <summary>
        /// å¤„理新增模具寿命调整单子表的json
@@ -1815,5 +1790,19 @@
            List<Models.ClsKf_ICStockBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsKf_ICStockBillSub>>(jsonString);
            return list;
        }
        //工资管理 å·¥èµ„结算单
        public List<Models.ClsPay_SingleBalBillMain> getObjectByJson_Pay_SingleBalBillMain(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Models.ClsPay_SingleBalBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsPay_SingleBalBillMain>>(jsonString);
            return list;
        }
        public List<Models.ClsPay_SingleBalBillSub> getObjectByJson_Pay_SingleBalBillSub(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Models.ClsPay_SingleBalBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsPay_SingleBalBillSub>>(jsonString);
            return list;
        }
    }
WebAPI/Models/¹¤×ʹÜÀí/ClsPay_SingleBalBillMain.cs
New file
@@ -0,0 +1,17 @@
using System;
using System.Collections.Generic;
using System.Text;
namespace WebAPI.Models
{
    public class ClsPay_SingleBalBillMain:DBUtility.ClsXt_BaseBillMain
    {
        public Int64 HGroupID;//    int    //班组ID
        public Int64 HDeptID;//        int    //
        public Int64 HEmpID;//        int
        public Int64 HPayType;//        int     //工资类型
        public string HExplanation;//   varchar(200)        --ÕªÒª
        public string HInnerBillNo;//  varchar(50)         --内部单据号
        public bool HSaveFlag;
    }
}
WebAPI/Models/¹¤×ʹÜÀí/ClsPay_SingleBalBillSub.cs
New file
@@ -0,0 +1,42 @@
using System;
using System.Collections.Generic;
using System.Text;
namespace WebAPI.Models
{
    public class ClsPay_SingleBalBillSub : DBUtility.ClsXt_BaseBillSub
    {
        public DateTime HEntryCloseDate;//   datetime      --行关闭 (默认为'')        new
        public string HRemark;//         varchar(200)        --备注
        public Int64 HMaterID;//    int        --物料ID
        public Int64 HProcID;//        int        --工序ID
        public Int64 HEmpID;//        int        --Ö°Ô±ID
        public double HTimes;//        decimal(18,8)        --工时
        public double HQty;//        decimal(18,8)        --数量
        public double HPrice;//        decimal(18,8)        --工价
        public Single HPriceRate;//         money      -- å®šé¢æµ®åŠ¨æ¯”çŽ‡
        public Single HSubsidyTotal;//         money      -- è¡¥è´´åˆè®¡
        public Single HDeuctTotal;//         money      -- æ‰£æ¬¾å°è®¡
        public double HMoney;//        decimal(18,8)        --金额
        public Int64 HICMOInterID;//    int        --生产任务单ID
        public string HICMOBillNo;//    varchar(50)        --生产任务单号
        public Int64 HProcReportInterID;//        int      --工序汇报单ID
        public Int64 HProcReportEntryID;//    int    --工序汇报单子ID
        public string HProcReportBillNo;//    varchar(50)    --工序汇报单号
        public Int64 HProcPlanInterID;//    int    --工序计划单ID
        public Int64 HProcPlanEntryID;//    int    --工序计划单子ID
        public string HProcPlanBillNo;//        varchar(50)    --工序计划单号
        public Int64 HSourceID;
        public long HSubsidyID;//         money      -- è¡¥è´´åˆè®¡
        public long HDeuctID;//         money      -- æ‰£æ¬¾å°è®¡
        public double HPackQty;//  dec(18,8)  --包装数量  --addnew
        public double HPackPrice;//  dec(18,8)  --包装单价  --addnew
        public double HPackMoney;//  dec(18,8)  --包装金额  --addnew
        public Int64 HPackMaterID;//  int   --包装类型  --addnew
        public double HSubsidyQty;
        public double HSubsidyMoney;
        public double HSqty;
    }
}
WebAPI/WebAPI.csproj
@@ -352,7 +352,7 @@
    <Compile Include="Controllers\PurchaseOrderController.cs" />
    <Compile Include="Controllers\QC_POStockInCheckBillController.cs" />
    <Compile Include="Controllers\Pay_WorkTimesBillController.cs" />
    <Compile Include="Controllers\Pay_SingleBalBillController.cs" />
    <Compile Include="Controllers\工资管理\Pay_SingleBalBillController.cs" />
    <Compile Include="Controllers\ProductionOrderController.cs" />
    <Compile Include="Controllers\PublicPageMethodController.cs" />
    <Compile Include="Controllers\ReportFromController.cs" />
@@ -472,6 +472,8 @@
    <Compile Include="Models\ClsKf_MateOutBillSub.cs" />
    <Compile Include="Models\ClsOA_InformBillMain.cs" />
    <Compile Include="Models\ClsOA_InformBillSub.cs" />
    <Compile Include="Models\工资管理\ClsPay_SingleBalBillMain.cs" />
    <Compile Include="Models\工资管理\ClsPay_SingleBalBillSub.cs" />
    <Compile Include="Models\ClsSb_EquipDotCheckRuleBillMain.cs" />
    <Compile Include="Models\ClsSb_EquipDotCheckRuleBillSub.cs" />
    <Compile Include="Models\ClsSb_EquipMaintainRuleBillMain.cs" />