工资结算单 集体

王 垚

2021-12-07 97fd362bc8b849b89cb8087e2d86ad7f8280b0f5

工资结算单 集体

 WebAPI/Controllers/¹¤×ʹÜÀí/Pay_GroupBalBillController.cs

 WebAPI/DLL/¹¤×ʹÜÀí/ClsPay_GroupBalBill.cs

@@ -7,9 +7,9 @@
{
    public class ClsPay_GroupBalBill : DBUtility.ClsXt_BaseBill
    {
        public Model.ClsPay_GroupBalBillMain omodel = new Model.ClsPay_GroupBalBillMain();
        public List<Model.ClsPay_GroupBalBillSub> DetailColl = new List<Model.ClsPay_GroupBalBillSub>();
        public List<Model.ClsPay_GroupBalBillEmp> DetailEmpColl = new List<Model.ClsPay_GroupBalBillEmp>();
        public Models.ClsPay_GroupBalBillMain omodel = new Models.ClsPay_GroupBalBillMain();
        public List<Models.ClsPay_GroupBalBillSub> DetailColl = new List<Models.ClsPay_GroupBalBillSub>();
        public List<Models.ClsPay_GroupBalBillEmp> DetailEmpColl = new List<Models.ClsPay_GroupBalBillEmp>();

        public ClsPay_GroupBalBill()
        {
@@ -66,7 +66,7 @@
                DeleteBillSub2(lngBillKey);
                //插入子表
                omodel.HInterID = lngBillKey;
                foreach (Model.ClsPay_GroupBalBillSub oSub in DetailColl)
                foreach (Models.ClsPay_GroupBalBillSub oSub in DetailColl)
                {
                    oCn.RunProc("Insert into Pay_GroupBalBillSub " +
                      " (HInterID,HEntryID,HRemark" +
@@ -84,7 +84,7 @@
                }
                //
                //插入子表2
                foreach (Model.ClsPay_GroupBalBillEmp oSubSec in DetailEmpColl)
                foreach (Models.ClsPay_GroupBalBillEmp oSubSec in DetailEmpColl)
                {
                    oCn.RunProc("Insert into Pay_GroupBalBillEmp " +
                      " (HInterID,HEntryID,HRemark" +
@@ -102,7 +102,7 @@
                        "," + oSubSec.HBaseDays.ToString() + "," + oSubSec.HOverDays.ToString() + "," + oSubSec.HLeaveDays.ToString() + "," + oSubSec.HYf.ToString() +
                        "," + oSubSec.HMoney.ToString() + "," + oSubSec.HOtherSubsidy.ToString() + "," + oSubSec.HOtherDeduct.ToString() + "," + Convert.ToString(oSubSec.HIsPay ? 1 : 0) + "," + Convert.ToString(oSubSec.HAvgFlag ? 1 : 0) + ") ");
                }
                //foreach (Model.ClsPay_GroupBalBillSub oSub in DetailColl)
                //foreach (Models.ClsPay_GroupBalBillSub oSub in DetailColl)
                //{
                //    Ds = oCn.RunProcReturn("exec h_p_Pay_GroupBalBill_Qty " + oSub.HICMOInterID, "");
                //    if (Ds.Tables[0].Rows.Count == 0)
@@ -149,7 +149,7 @@
                ") ");
                //
                //插入子表
                foreach (Model.ClsPay_GroupBalBillSub oSub in DetailColl)
                foreach (Models.ClsPay_GroupBalBillSub oSub in DetailColl)
                {
                    oCn.RunProc("Insert into Pay_GroupBalBillSub " +
                      " (HInterID,HEntryID,HRemark" +
@@ -167,7 +167,7 @@
                }
                //
                //插入子表2
                foreach (Model.ClsPay_GroupBalBillEmp oSubSec in DetailEmpColl)
                foreach (Models.ClsPay_GroupBalBillEmp oSubSec in DetailEmpColl)
                {
                    oCn.RunProc("Insert into Pay_GroupBalBillEmp " +
                      " (HInterID,HEntryID,HRemark" +
@@ -186,7 +186,7 @@
                        "," + oSubSec.HMoney.ToString() + "," + oSubSec.HOtherSubsidy.ToString() + "," + oSubSec.HOtherDeduct.ToString() + "," + Convert.ToString(oSubSec.HIsPay ? 1 : 0) + "," + Convert.ToString(oSubSec.HAvgFlag ? 1 : 0) + ") ");
                }
                //
                //foreach (Model.ClsPay_GroupBalBillSub oSub in DetailColl)
                //foreach (Models.ClsPay_GroupBalBillSub oSub in DetailColl)
                //{
                //    Ds = oCn.RunProcReturn("exec h_p_Pay_GroupBalBill_Qty " + oSub.HICMOInterID, "");
                //    if (Ds.Tables[0].Rows.Count == 0)
@@ -266,7 +266,7 @@
                DetailColl.Clear();//清空
                for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++)
                {
                    Model.ClsPay_GroupBalBillSub oSub = new Model.ClsPay_GroupBalBillSub();
                    Models.ClsPay_GroupBalBillSub oSub = new Models.ClsPay_GroupBalBillSub();
                    // å›ºå®šèµ‹å€¼===============================================
                    oSub.HInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HInterID"]);
                    oSub.HEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HEntryID"]);
@@ -306,7 +306,7 @@
                DetailEmpColl.Clear();//清空
                for (int i = 0; i < DsSubSec.Tables[0].Rows.Count; i++)
                {
                    Model.ClsPay_GroupBalBillEmp oSubSec = new Model.ClsPay_GroupBalBillEmp();
                    Models.ClsPay_GroupBalBillEmp oSubSec = new Models.ClsPay_GroupBalBillEmp();
                    // å›ºå®šèµ‹å€¼===============================================
                    oSubSec.HInterID = DBUtility.ClsPub.isLong(DsSubSec.Tables[0].Rows[i]["HInterID"]);
                    oSubSec.HEntryID = DBUtility.ClsPub.isLong(DsSubSec.Tables[0].Rows[i]["HEntryID"]);

 WebAPI/Models/¹¤×ʹÜÀí/ClsPay_GroupBalBillEmp.cs

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

namespace WebAPI.Models
{
    public class ClsPay_GroupBalBillEmp:DBUtility.ClsXt_BaseBillSub
    {
        public DateTime HEntryCloseDate;//   datetime      --行关闭 (默认为'')        new
        public Int64 HEmpID;
        public double HEmpRate;          //职员系数
        public double HBaseTimes;      //基本工时
        public double HOverTimes;      //加班工时
        public double HLeaveTimes;       //请假工时
        public Int64 HCTPrjID;          //核算方式ID
        public double HBaseDays;         //基本天数
        public double HOverDays;         //加班天数
        public double HLeaveDays;       //请假天数
        public double HMoney;           //计件工资
        public double HOtherSubsidy;     //其他补贴
        public double HOtherDeduct;      //其他扣款
        public double HYf;            //应付工资
        public bool HIsPay;            //是否支付
        public bool HAvgFlag;
    }
}

 WebAPI/Models/¹¤×ʹÜÀí/ClsPay_GroupBalBillMain.cs

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

namespace WebAPI.Models
{
    public class ClsPay_GroupBalBillMain:DBUtility.ClsXt_BaseBillMain
    {
        public Int64 HDeptID;
        public Int64 HGroupID;
        public Int64 HPayType;
        public double HOtherDeduct;
        public double HOtherSubsidy;
        public double HPayMoney;
        public double HSumMoney;
        public string HExplanation;
        public string HInnerBillNo;
    }
}

 WebAPI/Models/¹¤×ʹÜÀí/ClsPay_GroupBalBillSub.cs

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

namespace WebAPI.Models
{
    public class ClsPay_GroupBalBillSub:DBUtility.ClsXt_BaseBillSub
    { 
        public DateTime HEntryCloseDate;//   datetime      --行关闭 (默认为'')        new
        public Int64 HMaterID;//    int        --物料ID
        public Int64 HProcID;//        int        --工序ID
        public Int64 HUnitID;//        int        --单位ID
        public Int64 HSourceID;//        int        --资源ID
        public double HTimes;//        decimal(18,8)        --工时
        public double HQty;//        decimal(18,8)        --数量
        public double HPrice;//        decimal(18,8)        --工价
        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 double HSqty;
    }
}

 WebAPI/WebAPI.csproj

@@ -348,7 +348,7 @@
    <Compile Include="Controllers\MoveStockBillController.cs" />
    <Compile Include="Controllers\Open_PrintTemController.cs" />
    <Compile Include="Controllers\工资管理\Pay_OtherBalBillController.cs" />
    <Compile Include="Controllers\Pay_GroupBalBillController.cs" />
    <Compile Include="Controllers\工资管理\Pay_GroupBalBillController.cs" />
    <Compile Include="Controllers\PurchaseOrderController.cs" />
    <Compile Include="Controllers\QC_POStockInCheckBillController.cs" />
    <Compile Include="Controllers\Pay_WorkTimesBillController.cs" />
@@ -440,6 +440,9 @@
    <Compile Include="DLL\ClsSc_MouldOtherInBill.cs" />
    <Compile Include="DLL\ClsSc_MouldMoveStockStepOutBill.cs" />
    <Compile Include="DLL\工资管理\ClsPay_GroupBalBill.cs" />
    <Compile Include="Models\工资管理\ClsPay_GroupBalBillEmp.cs" />
    <Compile Include="Models\工资管理\ClsPay_GroupBalBillMain.cs" />
    <Compile Include="Models\工资管理\ClsPay_GroupBalBillSub.cs" />
    <Compile Include="DLL\工资管理\ClsPay_SingleBalBill.cs" />
    <Compile Include="DLL\ClsSc_MouldProdBackBill.cs" />
    <Compile Include="DLL\工资管理\ClsPay_OtherBalBill.cs" />