/// <summary> /// @xis 待入库列表 /// </summary> /// <param name="reqmodel"></param> /// <returns></returns> public async Task <Result> SearchStockPaginerAsync(reqmodel <SearchStockPreModel> reqmodel) { Result <PaginerData <SearchStockPrePaginerResult> > result = new Result <PaginerData <SearchStockPrePaginerResult> > { status = ErrorCodeConst.ERROR_200, code = ErrorCodeConst.ERROR_200 }; IWhere <t_stock> stock_data_mkr = g_sqlMaker.Select <t_stock>(s => new { s.id, s.product_name }).Where(); IWhere <t_stockin_pre> stock_pre_data_mkr = g_sqlMaker.Select <t_stockin_pre>(s => new { s.id, s.stock_id, s.quantity }).Where(); IWhere <t_stockin_pre> stock_pre_total_mkr = g_sqlMaker.Select <t_stockin_pre>().Count().Where(); //模糊查询产品 List <t_stock> stock_list = new List <t_stock>(); if (!string.IsNullOrWhiteSpace(reqmodel.Data.name)) { stock_data_mkr = stock_data_mkr.And("product_name", "like", "@product_name"); stock_pre_data_mkr = stock_pre_data_mkr.And("stock_id", "in", "@stock_id"); stock_pre_total_mkr = stock_pre_total_mkr.And("stock_id", "in", "@stock_id"); stock_list = await g_dbHelper.QueryListAsync <t_stock>(stock_data_mkr.ToSQL(), new { product_name = $"%{reqmodel.Data.name}%" }); } //查询待入库 string stock_pre_data_sql = stock_pre_data_mkr.OrderByDesc("add_time").Pager(reqmodel.Data.page_index, reqmodel.Data.page_size).ToSQL(); List <t_stockin_pre> stock_pre_list = await g_dbHelper.QueryListAsync <t_stockin_pre>(stock_pre_data_sql, new { stock_id = stock_list.Select(s => s.id) }); int total = await g_dbHelper.QueryAsync <int>(stock_pre_total_mkr.ToSQL(), new { stock_id = stock_list.Select(s => s.id) }); if (string.IsNullOrWhiteSpace(reqmodel.Data.name) && stock_pre_list.Count > 0) { stock_list = await g_dbHelper.QueryListAsync <t_stock>(stock_data_mkr.And("id", "in", "@stock_id").ToSQL(), new { stock_id = stock_pre_list.Select(s => s.stock_id) }); } List <SearchStockPrePaginerResult> search_list = new List <SearchStockPrePaginerResult>(); foreach (var item in stock_pre_list) { t_stock stock = stock_list.First(f => f.id == item.stock_id); search_list.Add(new SearchStockPrePaginerResult { id = item.id, stock_id = item.stock_id, quantity = item.quantity, product_name = stock.product_name, }); } PaginerData <SearchStockPrePaginerResult> paginer = new PaginerData <SearchStockPrePaginerResult> { page_index = reqmodel.Data.page_index, page_size = reqmodel.Data.page_size, Data = search_list, total = total }; result.data = paginer; return(result); }
/// <summary> /// @lx 获取所有仓库信息 /// </summary> /// <param name="selector">选择器</param> /// <param name="normal"></param> /// <returns></returns> public async Task <List <t_ware> > GetAllWares(Func <t_ware, dynamic> selector, bool normal = true) { IWhere <t_ware> sql_select = g_sqlMaker.Select(selector).Where(); if (normal) { sql_select = sql_select.And("status", "=", "@status").And("state", "=", "@state"); } List <t_ware> data_list = await g_dbHelper.QueryListAsync <t_ware>(sql_select.ToSQL(), new { status = (int)EnumStatus.Enable, state = (int)EnumState.Normal }); return(data_list); }
/// <summary> /// @xis 名称模糊查询供货商 /// </summary> /// <param name="selector"></param> /// <param name="name"></param> /// <param name="page_index"></param> /// <param name="page_size"></param> /// <returns></returns> public async Task <PaginerData <SearchFactoryResult> > SearchFactoryByVagueName(string name, int page_index, int page_size = 15) { IWhere <t_factory> where_data = g_sqlMaker.Select <t_factory>(s => new { s.id, s.factory_name, s.factory_person_name, s.factory_tel }).Where(); IWhere <t_factory> where_count = g_sqlMaker.Select <t_factory>().Count().Where(); if (!string.IsNullOrWhiteSpace(name)) { where_data.And("name", "like", "@name"); where_count.And("name", "like", "@name"); } where_data.And("status", "=", "@status").And("state", "=", "@state").OrderByDesc("add_time").Pager(page_index, page_size); where_count.And("status", "=", "@status").And("state", "=", "@state"); List <t_factory> data_list = await g_dbHelper.QueryListAsync <t_factory>(where_data.ToSQL(), new { factory_name = $"%{name}%", status = (int)EnumStatus.Enable, state = (int)EnumState.Normal }); int total = await g_dbHelper.QueryAsync <int>(where_count.ToSQL(), new { factory_name = $"%{name}%", status = (int)EnumStatus.Enable, state = (int)EnumState.Normal }); List <SearchFactoryResult> list = new List <SearchFactoryResult>(); foreach (var item in data_list) { list.Add(new SearchFactoryResult { id = item.id, factory_name = item.factory_name, factory_person_name = item.factory_person_name, factory_tel = item.factory_tel }); } PaginerData <SearchFactoryResult> paginer_data = new PaginerData <SearchFactoryResult> { Data = list, page_index = page_index, page_size = page_size, total = total }; return(paginer_data); }
public async Task <PaginerData <StockPaginerResult> > GetStockPaginer(string name, int page_index, int page_size) { IWhere <t_stock> where_data = g_sqlMaker.Select <t_stock>(s => new { s.product_name }).Distinct().Where(); IWhere <t_stock> where_total = g_sqlMaker.Select <t_stock>(null).Count("DISTINCT product_name").Where(); if (!string.IsNullOrWhiteSpace(name)) { where_data = where_data.And("product_name", "like", "@product_name"); where_total = where_total.And("product_name", "like", "@product_name"); } string sql_data = where_data.Pager(page_index, page_size).ToSQL(); string sql_total = where_total.ToSQL(); List <StockPaginerResult> list = new List <StockPaginerResult>(); List <string> name_list = await g_dbHelper.QueryListAsync <string>(sql_data, new { product_name = $"%{name?.Trim()}%" }); string sql = "select product_name, sum(quantity) as quantity from t_stock where product_name in @product_name group by product_name"; List <t_stock> data_list = await g_dbHelper.QueryListAsync <t_stock>(sql, new { product_name = name_list }); foreach (var item in data_list) { list.Add(new StockPaginerResult { name = item.product_name, quantility = item.quantity }); } PaginerData <StockPaginerResult> paginer = new PaginerData <StockPaginerResult> { page_index = page_index, page_size = page_size, total = await g_dbHelper.QueryAsync <int>(sql_total, new { product_name = $"%{name?.Trim()}%" }), Data = list }; return(paginer); }