Esempio n. 1
0
        public IHttpActionResult GeneralQuery([FromUri] GeneralQueryBm uspParams)
        {
            foreach (var _uspParam in uspParams.GetType().GetProperties())
            {
                if (_uspParam.GetValue(uspParams) == null)
                {
                    _uspParam.SetValue(uspParams, "");
                }
            }
            // 传入下拉类别类型
            List <SqlParameter> paramArray = new List <SqlParameter>();

            paramArray.Add(new SqlParameter("@type", uspParams.type));
            paramArray.Add(new SqlParameter("@param2", uspParams.param2));
            paramArray.Add(new SqlParameter("@param3", uspParams.param3));
            paramArray.Add(new SqlParameter("@param4", uspParams.param4));
            paramArray.Add(new SqlParameter("@param5", uspParams.param5));

            try
            {
                var dynamicDbSet = DynamicSqlQuery(YdmDb.Database, "EXEC [dbo].[usp_prdAppGeneralQuery]  @type,@param2,@param3,@param4,@param5", paramArray.ToArray());
                return(Json(dynamicDbSet));
            }
            catch (Exception e)
            {
                var resp = new HttpResponseMessage(HttpStatusCode.NotFound)
                {
                    Content      = new StringContent(e.Message),
                    ReasonPhrase = "存储过程异常"
                };
                log.Error(e.Message);
                throw new HttpResponseException(resp);
            }
        }
        public IHttpActionResult GeneralQuery([FromUri] GeneralQueryBm p)
        {
            foreach (var _uspParam in p.GetType().GetProperties())
            {
                if (_uspParam.GetValue(p) == null)
                {
                    _uspParam.SetValue(p, "");
                }
            }

            List <SqlParameter> paramArray = new List <SqlParameter>();

            paramArray.Add(new SqlParameter("@type", p.type));
            paramArray.Add(new SqlParameter("@param2", p.param2));
            paramArray.Add(new SqlParameter("@param3", p.param3));
            paramArray.Add(new SqlParameter("@param4", p.param4));
            paramArray.Add(new SqlParameter("@param5", p.param5));

            try
            {
                var dynamicDbSet = DynamicSqlQueryClass.Instance.DynamicSqlQuery(fnmDb.Database, "EXEC [dbo].[usp_prdFnGeneralQuery]  @type,@param2,@param3,@param4,@param5", paramArray.ToArray());
                return(Json(dynamicDbSet, JsonFormatSettings.Instance.GetSettings()));
            }
            catch (Exception e)
            {
                var resp = new HttpResponseMessage(HttpStatusCode.NotFound)
                {
                    Content = new StringContent(e.Message)
                };
                log.Error(e.Message);
                throw new HttpResponseException(resp);
            }
        }