修改 PNL布局控制器 添加PNLInfo接口插入数据逻辑

chenhaozhe

2025-06-23 fdf4777d0bfcce0b36e5990f689a0d1174d3e43e

 WebAPI/Controllers/ÏîÄ¿¹ÜÀí/¹¤³ÌÏîÄ¿/PM_ProjectBillController.cs

@@ -811,7 +811,7 @@
        #region (任务类）的工程项目新增 æ ¹æ®ä»»åŠ¡å¤§ç±» ä»»åŠ¡é¡¹ç›®åˆ†ç±» æ—¥æœŸ æ›´æ–° é¡¹ç›®ä»£ç 
        [Route("PM_ProjectBill/GetHProjectHNumber")]
        [HttpGet]
        public object GetHProjectHNumber( int HDeptID, DateTime HDate,int HTaskClassID,int HTaskClassEntryID)
        public object GetHProjectHNumber( int HDeptID, DateTime HDate,int HTaskClassID,int HTaskClassEntryID,int HType)
        {
            DataSet ds;
            try
@@ -819,7 +819,7 @@
                List<object> columnNameList = new List<object>();


                ds = oCN.RunProcReturn("exec h_p_Xt_GetMaxBillNo_SubType '4750','" + HDate + "','" + HTaskClassID + "','" + HTaskClassEntryID + "','" + HDeptID + "'", "h_p_Xt_GetMaxBillNo_SubType");
                ds = oCN.RunProcReturn("exec h_p_Xt_GetMaxBillNo_SubType '4750','" + HDate + "','" + HTaskClassID + "','" + HTaskClassEntryID + "','" + HDeptID + "',"+HType, "h_p_Xt_GetMaxBillNo_SubType");

                //添加列名
                foreach (DataColumn col in ds.Tables[0].Columns)
@@ -5751,7 +5751,7 @@
        #region å·¥ç¨‹é¡¹ç›®è´¹ç”¨å¾…审核列表
        [Route("PM_ProjectBill/NeedCheckQuery")]
        [HttpGet]
        public object PM_ProjectBillNeedCheckQuery(string user)
        public object PM_ProjectBillNeedCheckQuery(string user,string sWhere)
        {
            DataSet ds;
            try
@@ -5767,7 +5767,7 @@
                //    return objJsonResult;
                //}
                //sWhere = sWhere.Replace("'", "''");
                ds = oCN.RunProcReturn("exec h_p_PM_ProjectBillNeedCheckQuery ", "h_p_PM_ProjectBillNeedCheckQuery");
                ds = oCN.RunProcReturn("exec h_p_PM_ProjectBillNeedCheckQuery " + sWhere, "h_p_PM_ProjectBillNeedCheckQuery");

                //添加列名
                foreach (DataColumn col in ds.Tables[0].Columns)
@@ -5941,7 +5941,7 @@
        #region å·¥ç¨‹é¡¹ç›®è´¹ç”¨å¾…保存列表
        [Route("PM_ProjectBill/NeedSaveQuery")]
        [HttpGet]
        public object PM_ProjectBillNeedSaveQuery(string user)
        public object PM_ProjectBillNeedSaveQuery(string user,string sWhere)
        {
            DataSet ds;
            try
@@ -5957,7 +5957,7 @@
                //    return objJsonResult;
                //}
                //sWhere = sWhere.Replace("'", "''");
                ds = oCN.RunProcReturn("exec h_p_PM_ProjectBillNeedSaveQuery ", "h_p_PM_ProjectBillNeedSaveQuery");
                ds = oCN.RunProcReturn("exec h_p_PM_ProjectBillNeedSaveQuery "+sWhere, "h_p_PM_ProjectBillNeedSaveQuery");

                //添加列名
                foreach (DataColumn col in ds.Tables[0].Columns)