价目表 价目表页面没有”按钮设置“选项。没有导出功能，需要添加。 价目表 价目表编辑，保存时判断单价不能为0。 价目表 新增界面审核按钮有问题，按不了...

llj

2025-08-07 a0758f5f02b7796dcfc4b082054feb26f60b905f

价目表 价目表页面没有”按钮设置“选项。没有导出功能，需要添加。
价目表 价目表编辑，保存时判断单价不能为0。
价目表 新增界面审核按钮有问题，按不了
编辑、删除、审核、禁用、导出权限

 WebAPI/Controllers/»ù´¡×ÊÁÏ/»ù´¡×ÊÁÏ/Gy_MatePriceController.cs

@@ -28,7 +28,7 @@
            {
                List<object> columnNameList = new List<object>();
                //编辑权限
                if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldUpperBill_Query", 1, false, user))
                if (!DBUtility.ClsPub.Security_Log_second("Gy_MatePrice_Query", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
@@ -37,8 +37,7 @@
                    return objJsonResult;
                }
                string sql1 = string.Format(@"select * from h_v_Gy_MaterPrice where 1 = 1 ");

                string sql = sql1 + sWhere;
                string sql = sql1 + sWhere+ "order by åˆ›å»ºæ—¶é—´ DESC ";
                ds = oCN.RunProcReturn(sql, "h_v_Gy_MaterPrice");

                //添加列名
@@ -76,7 +75,7 @@
            {
                List<object> columnNameList = new List<object>();
                //编辑权限
                if (!DBUtility.ClsPub.Security_Log_second("Gy_MatePriceSupList_Query", 1, false, user))
                if (!DBUtility.ClsPub.Security_Log_second("Gy_MatePrice_Edit", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
@@ -117,15 +116,15 @@
            string msg1 = sArray[0].ToString();
            string msg2 = sArray[1].ToString();

            ////编辑权限
            //if (!DBUtility.ClsPub.Security_Log_second("Gy_MatePriceSupList_Edit", 1, false, msg2))
            //{
            //    objJsonResult.code = "0";
            //    objJsonResult.count = 0;
            //    objJsonResult.Message = "无保存权限！";
            //    objJsonResult.data = null;
            //    return objJsonResult;
            //}
            //编辑权限
            if (!DBUtility.ClsPub.Security_Log_second("Gy_MatePrice_Edit", 1, false, msg2))
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "无保存权限！";
                objJsonResult.data = null;
                return objJsonResult;
            }
            ListModels oListModels = new ListModels();

            try
@@ -262,7 +261,7 @@
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                //删除权限
                if (!DBUtility.ClsPub.Security_Log("Gy_MatePriceSupList_Delete", 1, false, user))
                if (!DBUtility.ClsPub.Security_Log("Gy_MatePrice_Delete", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
@@ -326,10 +325,14 @@
        [HttpGet]
        public object MatePriceCheck(int HInterID, int IsAudit, string CurUserName)
        {
            Int64 lngBillKey = 0;
            lngBillKey = DBUtility.ClsPub.isLong(HInterID);
            DAL.ClsGy_MatePrice_Ctl oBill = new DAL.ClsGy_MatePrice_Ctl();
            List<Model.ClsGy_MatePrice_Model> lsmain = new List<Model.ClsGy_MatePrice_Model>();
            try
            {
                //审核权限
                if (!DBUtility.ClsPub.Security_Log_second("Gy_TechnologyParameterUnit_Check", 1, false, CurUserName))
                if (!DBUtility.ClsPub.Security_Log_second("Gy_MatePrice_Check", 1, false, CurUserName))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
@@ -337,6 +340,42 @@
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                if(lngBillKey==0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                ////针对需要进行的操作，检验当前单据的状态是否支持需要进行的操作
                //if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))                    //根据HInterID获取该单据的数据
                //{
                //    if (oBill.oModel.HCheckEmp.Trim() != "")
                //    {
                //        objJsonResult.code = "0";
                //        objJsonResult.count = 0;
                //        objJsonResult.Message = "单据已关闭!不能再次审核！";
                //        objJsonResult.data = null;
                //        return objJsonResult;
                //    }
                //    //if (oBill.omodel.HDeleteMan.Trim() != "")
                //    //{
                //    //    objJsonResult.code = "0";
                //    //    objJsonResult.count = 0;
                //    //    objJsonResult.Message = "单据已作废!不能再次审核！";
                //    //    objJsonResult.data = null;
                //    //    return objJsonResult;
                //    //}
                //}
                //else
                //{
                //    objJsonResult.code = "0";
                //    objJsonResult.count = 0;
                //    objJsonResult.Message = "单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;
                //    objJsonResult.data = null;
                //    return objJsonResult;
                //}

                var ds = oCN.RunProcReturn("select * from Gy_MaterPrice where HItemID=" + HInterID, "Gy_MaterPrice");
                if (ds.Tables[0].Rows.Count > 0)
@@ -523,7 +562,7 @@
            try
            {
                //禁用权限
                if (!DBUtility.ClsPub.Security_Log_second("Gy_TechnologyParameterUnit_Stop", 1, false, CurUserName))
                if (!DBUtility.ClsPub.Security_Log_second("Gy_MatePrice_Stop", 1, false, CurUserName))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;