public async Task <string> PageGetSupplierInfo(string info) { PageSupplierQueryInfo pageSupplierQueryInfo = new PageSupplierQueryInfo(); if (!string.IsNullOrWhiteSpace(info)) { pageSupplierQueryInfo = JsonConvert.DeserializeObject <PageSupplierQueryInfo>(info); } SupplierDal dal = new SupplierDal(); var result = await dal.PageGetSupplierInfo(pageSupplierQueryInfo); if (result.ResultCode != 0) { return(JsonConvert.SerializeObject(new { status = "fail", message = result.ResultMsg, date = DateTime.Now.ToShortDateString() })); } return(JsonConvert.SerializeObject(new { status = "success", data = result.Data, date = DateTime.Now.ToShortDateString() })); }
/// <summary> /// 分页查询供应商信息 /// </summary> /// <param name="pageSupplierQueryInfo"></param> /// <returns></returns> public async Task <VMResult <PageSupplierInfo> > PageGetSupplierInfo(PageSupplierQueryInfo pageSupplierQueryInfo) { VMResult <PageSupplierInfo> r = new VMResult <PageSupplierInfo>(); try { using (var conn = DapperHelper.CreateConnection()) { StringBuilder strSql = new StringBuilder(); StringBuilder strPageSql = new StringBuilder(); DynamicParameters paras = new DynamicParameters(); strSql.Append(@"SELECT * FROM Supplier s where 1=1"); if (!string.IsNullOrWhiteSpace(pageSupplierQueryInfo.supplierQueryInfo.Name)) { strSql.Append(" and s.Name='" + pageSupplierQueryInfo.supplierQueryInfo.Name + "'"); } if (!string.IsNullOrWhiteSpace(pageSupplierQueryInfo.supplierQueryInfo.Mobile)) { strSql.Append(" and s.Mobile='" + pageSupplierQueryInfo.supplierQueryInfo.Mobile + "'"); } if (!string.IsNullOrWhiteSpace(pageSupplierQueryInfo.supplierQueryInfo.LinkName)) { strSql.Append(" and s.LinkName='" + pageSupplierQueryInfo.supplierQueryInfo.LinkName + "'"); } int total = (await conn.QueryAsync <SupplierInfo>(strSql.ToString())).Count(); int startNumber = (pageSupplierQueryInfo.CurrentPage - 1) * pageSupplierQueryInfo.PageSize; strPageSql.Append(@"SELECT DATA.* FROM (" + strSql + ") DATA ORDER BY 1 OFFSET " + startNumber + "ROWS FETCH NEXT " + pageSupplierQueryInfo.PageSize + "ROWS ONLY"); var value = await conn.QueryAsync <SupplierInfo>(strPageSql.ToString()); if (value == null) { r.ResultMsg = "分页查询失败"; } else { r.Data.SupplierInfos = value; r.Data.total = total; r.ResultCode = 0; } } } catch (Exception ex) { r.ResultMsg = ex.Message; } return(r); }