考勤汇报单列表、 异常工时申请单列表、 定额申请单列表 客户列表， 供应商列表 分页

wtt

2024-10-15 c064b9124554626cd3c386a2648a8008d3efc44c

 WebAPI/Controllers/JHGL/Gy_RoutingBillController.cs

@@ -284,9 +284,9 @@

                    //修改
                    DataSet dss;
                    dss = oCN.RunProcReturn("select * from Gy_RoutingBillMain where hmainid=" + HInterID + " and 单据号='" + HBillNo + "'", "Gy_RoutingBillMain");
                    dss = oCN.RunProcReturn("select * from Gy_RoutingBillMain where HInterID=" + HInterID + " and HBillNo='" + HBillNo + "'", "Gy_RoutingBillMain");
                    //判断是否可编辑
                    if (dss.Tables[0].Rows[0]["审核人"].ToString() != "" && dss.Tables[0].Rows[0]["审核人"] != null)
                    if (dss.Tables[0].Rows[0]["HChecker"].ToString() != "" && dss.Tables[0].Rows[0]["HChecker"] != null)
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
@@ -294,7 +294,17 @@
                        objJsonResult.data = 1;
                        return objJsonResult;
                    }

                    dss = oCN.RunProcReturn("select COUNT(*) as number from Sc_ProcessExchangeBillMain where HRoutingBillID = " + HInterID, "Gy_RoutingBillMain");
                    //判断是否可编辑
                    if (dss.Tables[0].Rows[0]["number"].ToString() != "0")
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "此单据已经被引用，不允许修改！";
                        objJsonResult.data = 1;
                        return objJsonResult;
                    }
                    
                    oCN.RunProc("update Gy_RoutingBillMain  set " +
                       "HDate='" + HDate +
                       "',HYear='" + HYear + "',HPeriod='" + HPeriod + "',HRemark='" + HRemark + "',hupdater='" + HMaker +