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);
}
