雅琪诺报工台切出页面(走工序)

YL

2021-12-07 c8d8f25fd2b1a5d5db0a59225ee5c7d6795e6f3e

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

File was renamed from WebAPI/Controllers/Pay_GroupBalBillController.cs
@@ -27,7 +27,7 @@
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
       [Route("Pay_GroupBalBill/GetGroupBalBill")]
        [Route("Pay_GroupBalBill/GetGroupBalBill")]
        [HttpGet]
        public object GetGroupBalBill(string sWhere)
        {
@@ -65,7 +65,7 @@
            }

        }
       

        #region[工资结算集体单编辑时获取表头数据]
        [Route("Pay_GroupBalBill/Pay_GroupBalBillListCheckDetail")]
        [HttpGet]
@@ -89,19 +89,25 @@
        public object Pay_GroupBalBillListProjectDetai(string sqlWhere)
        {
            DataSet ds;
            DataSet ds1;
            List<object> list = new List<object>();
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                string sql1 = "SELECT HMaterID,HMaterCode,HMaterName, HDeptID,部门代码,部门" +
                    ",HGroupID,班组代码,班组,摘要,内部单据号,表头备注,制单人,制单日期" +
                    ",审核人,审核日期,修改人,修改日期,关闭人, å…³é—­æ—¥æœŸ,HProcID,HProcNumber,HProcName" +
                    ",数量,金额 FROM h_v_Pay_GroupBalBillList where 1 = 1 ";
                string sql = sql1 + sqlWhere;
                string sql = @"SELECT HMaterID,HMaterCode,HMaterName,规格型号 HMaterSpec,HUnitID,HUnitNumber,HUnitName
                    HProcID,HProcNumber,HProcName,HSourceID,HSourceNumber,HSourceName,工时 HTimes,数量 HQty,工价 HPrice,金额 HMoney, HSumMoney,HOtherSubsidy,HOtherDeduct,HPayMoney FROM h_v_Pay_GroupBalBillList where 1 = 1 " + sqlWhere;
                ds = oCN.RunProcReturn(sql, "h_v_Pay_GroupBalBillList");
                string sql1 = @"select 
 HEmpID ,b.HNumber HEmpNumber, b.HName HEmpName, b.HEmpRate HEmpRate, HBaseTimes, HMoney, HOtherSubsidy, HOtherSubsidy, HYF,'' HISZF ,'' HISFT , a.HRemark
from Pay_GroupBalBillEmp a
 left join Gy_Employee b on a.HEmpID = b.HItemID " + sqlWhere.Replace("hmainid", "HInterID");
                ds1 = oCN.RunProcReturn(sql1, "Pay_GroupBalBillEmp");
                list.Add(ds.Tables[0]);
                list.Add(ds1.Tables[0]);
                objJsonResult.code = "0";
                objJsonResult.count = 1;
                objJsonResult.Message = "获取信息成功！";
                objJsonResult.data = ds.Tables[0];
                objJsonResult.list = list;
            }
            catch (Exception e)
            {
@@ -113,7 +119,7 @@
            return objJsonResult;
        }
        #endregion
     

        /// <summary>
        ///工资结算个人单删除功能
        /// </summary>
@@ -148,7 +154,7 @@

        [Route("Pay_GroupBalBill/getGroupBalBillPrice")]
        [HttpGet]
        public object getGroupBalBillPrice(string HMaterID,string HProcID)
        public object getGroupBalBillPrice(string HMaterID, string HProcID)
        {
            try
            {