增加斯莫尔 性能检测散点图报表

zrg

2025-02-25 a1c3a3d1b0b0b8c28a19e99177e4cee5a64949b7

 WebAPI/Controllers/MJGL/Sc_MouldLifeUseBillController.cs

@@ -27,6 +27,18 @@
        {
            try
            {


                //判断权限
                if (!DBUtility.ClsPub.Security_Log("Sc_MouldLifeUseBill_Query", 3, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "您没有该模块权限,请与管理员联系！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_Sc_MouldLifeUseBillList order by HMainID asc", "h_v_Sc_MouldLifeUseBillList");
@@ -533,33 +545,33 @@
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("Sc_MouldLifeUseReport/list")]
        [Route("Sc_MouldLifeUseReport/GetSc_MouldLifeUseReport")]
        [HttpGet]
        public object GetSc_MouldLifeUseReport(string sWhere, string user, string userid)
        public object GetSc_MouldLifeUseReport(string sWhere, string user)
        {
            try
            {
                List<object> columnNameList = new List<object>();
                ////查看权限
                if (!DBUtility.ClsPub.Security_Log("Sc_MouldLifeUseReport_Query", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "无查看权限！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                //if (!DBUtility.ClsPub.Security_Log("Sc_MouldLifeUseReport_Query", 1, false, user))
                //{
                //    objJsonResult.code = "0";
                //    objJsonResult.count = 0;
                //    objJsonResult.Message = "无查看权限！";
                //    objJsonResult.data = null;
                //    return objJsonResult;
                //}


                //查询
                if (sWhere == null || sWhere.Equals(""))
                {
                    string sql = "exec h_p_Sc_MouldLifeUseReport '','" + userid + "'";
                    string sql = "exec h_p_Sc_MouldLifeUseReport ''";
                    ds = oCN.RunProcReturn(sql, "h_p_Sc_MouldLifeUseReport");
                }
                else
                {
                    string sql = "exec h_p_Sc_MouldLifeUseReport  '" + sWhere + "','" + userid + "'";
                    string sql = "exec h_p_Sc_MouldLifeUseReport  '" + sWhere + "'";
                    ds = oCN.RunProcReturn(sql, "h_p_Sc_MouldLifeUseReport");
                }