销售发货看板、采购收料看板

duhe

2024-08-08 63ae5fc4f972960fa9728a7f4be0a0309c9f7ed6

 WebAPI/Controllers/MJGL/Sc_MouldLifeUseBillController.cs

@@ -533,33 +533,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");
                }