| | |
|---|
| | | return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "操作成功！"); |
|---|
| | | } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 读取列表，支持分页 |
|---|
| | | /// </summary> |
|---|
| | | /// <param name="model"></param> |
|---|
| | | /// <returns></returns> |
|---|
| | | [RequestMethod(RequestMethods.POST)] |
|---|
| | | public ReturnDto<PageList<dynamic>> Getbly([FromBody] dynamic model) |
|---|
| | | { |
|---|
| | | int currentPage = model.currentPage; |
|---|
| | | int everyPageSize = model.everyPageSize; |
|---|
| | | string sortName = model.sortName; |
|---|
| | | string keyWhere = model.keyWhere; |
|---|
| | | string guid = model.guid; |
|---|
| | | SqlParameter[] parameters = |
|---|
| | | { |
|---|
| | | new("@inCurrentPage", currentPage), |
|---|
| | | new("@inEveryPageSize", everyPageSize), |
|---|
| | | new("@inSortName", sortName), |
|---|
| | | new("@inSortOrder", ""), |
|---|
| | | new("@inQueryWhere", keyWhere), |
|---|
| | | new("@guid", guid), |
|---|
| | | new("@inP1", ""), |
|---|
| | | new("@inP2", ""), |
|---|
| | | new("@inP3", ""), |
|---|
| | | new("@inP4", "") |
|---|
| | | }; |
|---|
| | | var dset = new DataSet(); |
|---|
| | | var _pglist = new PageList<dynamic> |
|---|
| | | { |
|---|
| | | total = 0, |
|---|
| | | everyPageSize = 0, |
|---|
| | | pages = 0, |
|---|
| | | list = new List<dynamic>() |
|---|
| | | }; |
|---|
| | | try |
|---|
| | | { |
|---|
| | | dset = DbHelperSQL.RunProcedure("prc_wom_bly_lst", parameters, "0"); |
|---|
| | | if (dset != null && dset.Tables.Count > 0 && |
|---|
| | | dset.Tables[0].Rows.Count > 0) //有数据 |
|---|
| | | { |
|---|
| | | var intTotal = |
|---|
| | | int.Parse(dset.Tables[1].Rows[0]["intTotal"].ToString()); |
|---|
| | | var pages = intTotal % everyPageSize != 0 |
|---|
| | | ? intTotal / everyPageSize + 1 |
|---|
| | | : intTotal / everyPageSize; |
|---|
| | | _pglist.total = intTotal; |
|---|
| | | _pglist.everyPageSize = everyPageSize; |
|---|
| | | _pglist.pages = pages; |
|---|
| | | var _dy = dset.Tables[0].TableToDynamicList(); |
|---|
| | | _pglist.list = _dy; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | catch (Exception ex) |
|---|
| | | { |
|---|
| | | LogHelper.Debug(ToString(), ex.Message); |
|---|
| | | return ReturnDto<PageList<dynamic>>.QuickReturn(_pglist, |
|---|
| | | ReturnCode.Exception, ex.Message); |
|---|
| | | } |
|---|
| | | |
|---|
| | | return ReturnDto<PageList<dynamic>>.QuickReturn(_pglist, |
|---|
| | | ReturnCode.Success, "读取成功"); |
|---|
| | | } |
|---|
| | | |
|---|
| | | } |
|---|
