public string Post([FromBody] CommodityParameter commodity) { DataSet ds = new DataSet(); ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@FDate", commodity.FDate)); sqlParameters.Add(new KeyValuePair <string, string>("@ToDate", commodity.ToDate)); sqlParameters.Add(new KeyValuePair <string, string>("@Godcode", commodity.GCode)); sqlParameters.Add(new KeyValuePair <string, string>("@ITCode", commodity.TRCode)); sqlParameters.Add(new KeyValuePair <string, string>("@RCode", commodity.RCode)); sqlParameters.Add(new KeyValuePair <string, string>("@IssuedToGodown", Convert.ToString(commodity.IssueToGodown))); sqlParameters.Add(new KeyValuePair <string, string>("@IssuedToDepositor", Convert.ToString(commodity.IssueToDepositor))); ds = manageSQLConnection.GetDataSetValues("GetCommodityIssueMemo", sqlParameters); CommodityIssueMemo commodityIssueMemo = new CommodityIssueMemo(); ManageReport manageReport = new ManageReport(); //filter condotions if (manageReport.CheckDataAvailable(ds)) { CommonEntity entity = new CommonEntity { dataSet = ds, GCode = commodity.GCode, FromDate = commodity.FDate, Todate = commodity.ToDate, UserName = commodity.UserName }; // commodityIssueMemo.GenerateCommodityIssueMemoReport(entity); Task.Run(() => commodityIssueMemo.GenerateCommodityIssueMemoReport(entity)); //Generate the Report } return(JsonConvert.SerializeObject(ds.Tables[0])); }
public string Post([FromBody] CommodityParameter commodity) { DataSet ds = new DataSet(); ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@FDATE", commodity.FDate)); sqlParameters.Add(new KeyValuePair <string, string>("@ToDate", commodity.ToDate)); sqlParameters.Add(new KeyValuePair <string, string>("@Godcode", commodity.GCode)); sqlParameters.Add(new KeyValuePair <string, string>("@RCode", commodity.RCode)); sqlParameters.Add(new KeyValuePair <string, string>("@ScCode", commodity.TRCode)); ds = manageSQLConnection.GetDataSetValues("GetSchemeIssueMemo", sqlParameters); SchemeIssueMemo schemeIssue = new SchemeIssueMemo(); ManageReport manageReport = new ManageReport(); if (manageReport.CheckDataAvailable(ds)) { CommonEntity entity = new CommonEntity { dataSet = ds, GCode = commodity.GCode, FromDate = commodity.FDate, Todate = commodity.ToDate, UserName = commodity.UserName }; Task.Run(() => schemeIssue.GenerateSchemeIssueMemoReport(entity)); //Generate the Report } return(JsonConvert.SerializeObject(ds.Tables[0])); }
/// <summary> /// 获取上部商品信息 /// </summary> /// <param name="parameter"> ///根据parameter 进行过滤和搜索 /// </param> /// <returns></returns> public async Task <IEnumerable <CommoditymodelView> > GetProductsasync(CommodityParameter parameter) { var result = new List <CommoditymodelView>(); var WebServerPath = _hostingEnvironment.ContentRootPath; try { if (string.IsNullOrWhiteSpace(parameter.Commoditycategoryname) && string.IsNullOrWhiteSpace(parameter.Commodityname) && string.IsNullOrWhiteSpace(parameter.transactionway) && string.IsNullOrWhiteSpace(parameter.SearchItem)) { var query = from commodity in _productdb.commodities join CommodityCategory in _productdb.commodityCategories on commodity.CommoditycategoryId equals CommodityCategory.Id join users in _productdb.users on commodity.UserId equals users.Id select new CommoditymodelView { Id = commodity.Id, Commodityname = commodity.Commodityname, Filepath = WebServerPath + commodity.Filepath, Price = commodity.Price, // Username = users.Username != null ? users.Username : null, Commoditycategoryname = CommodityCategory.Categoryname != null ? CommodityCategory.Categoryname : "未选择商品类型", startdate = commodity.startdate, transactionway = commodity.transactionway, // days = commodity.days, expiredate = commodity.expiredate != null ? commodity.expiredate : null, status = commodity.status != true ? false : false, phone = commodity.phone != null ? commodity.phone : null }; result = await query.ToListAsync(); } // var queryExpression = _productdb.commodities as IQueryable<CommoditymodelView>; //商品名过滤 if (!string.IsNullOrWhiteSpace(parameter.Commodityname)) { //获取服务器路径 //var WebServerPath = _hostingEnvironment.ContentRootPath; //联查根据商品名过滤数据 var query = from commodity in _productdb.commodities join CommodityCategory in _productdb.commodityCategories on commodity.CommoditycategoryId equals CommodityCategory.Id join users in _productdb.users on commodity.UserId equals users.Id // where commodity.Commodityname == parameter.Commodityname //模糊查询 where (commodity.Commodityname.Contains(parameter.Commodityname)) select new CommoditymodelView { Id = commodity.Id, Commodityname = commodity.Commodityname, Filepath = WebServerPath + commodity.Filepath, Price = commodity.Price, // Username = users.Username != null ? users.Username : null, Commoditycategoryname = CommodityCategory.Categoryname != null ? CommodityCategory.Categoryname : "未选择商品类型", startdate = commodity.startdate, transactionway = commodity.transactionway, // days = commodity.days, expiredate = commodity.expiredate != null ? commodity.expiredate : null, status = commodity.status != true ? false : false, phone = commodity.phone != null ? commodity.phone : null }; result = await query.ToListAsync(); //parameter.Commodityname = parameter.Commodityname.Trim(); //queryExpression = queryExpression.Where(x => x.Commodityname == parameter.Commodityname); } //交易方式过滤 //问题:过滤出来得数据,只显示商品为ID 1 和 2 的 if (!string.IsNullOrWhiteSpace(parameter.transactionway)) { var query = from commodity in _productdb.commodities join CommodityCategory in _productdb.commodityCategories on commodity.CommoditycategoryId equals CommodityCategory.Id join users in _productdb.users on commodity.UserId equals users.Id where commodity.transactionway == parameter.transactionway select new CommoditymodelView { Id = commodity.Id, Commodityname = commodity.Commodityname, Filepath = WebServerPath + commodity.Filepath, Price = commodity.Price, // Username = users.Username != null ? users.Username : null, Commoditycategoryname = CommodityCategory.Categoryname != null ? CommodityCategory.Categoryname : "未选择商品类型", startdate = commodity.startdate, transactionway = commodity.transactionway, // days = commodity.days, expiredate = commodity.expiredate != null ? commodity.expiredate : null, status = commodity.status != true ? false : false, phone = commodity.phone != null ? commodity.phone : null }; result = await query.ToListAsync(); } //商品类别过滤 if (!string.IsNullOrWhiteSpace(parameter.Commoditycategoryname)) { var query = from commodity in _productdb.commodities join CommodityCategory in _productdb.commodityCategories on commodity.CommoditycategoryId equals CommodityCategory.Id join users in _productdb.users on commodity.UserId equals users.Id where CommodityCategory.Categoryname == parameter.Commoditycategoryname select new CommoditymodelView { Id = commodity.Id, Commodityname = commodity.Commodityname, Filepath = WebServerPath + commodity.Filepath, Price = commodity.Price, // Username = users.Username != null ? users.Username : null, Commoditycategoryname = CommodityCategory.Categoryname != null ? CommodityCategory.Categoryname : "未选择商品类型", startdate = commodity.startdate, transactionway = commodity.transactionway, // days = commodity.days, expiredate = commodity.expiredate != null ? commodity.expiredate : null, status = commodity.status != true ? false : false, phone = commodity.phone != null ? commodity.phone : null }; result = await query.ToListAsync(); } //查询(多个关联的模糊查询) if (!string.IsNullOrWhiteSpace(parameter.SearchItem)) { //parameter.SearchItem = parameter.SearchItem.Trim(); //queryExpression = queryExpression.Where(x => x.Commodityname.Contains(parameter.SearchItem) || // x.transactionway.Contains(parameter.SearchItem)|| // x.Desc.Contains(parameter.SearchItem)|| // x.Commoditycategoryname.Contains(parameter.SearchItem)); var query = from commodity in _productdb.commodities join CommodityCategory in _productdb.commodityCategories on commodity.CommoditycategoryId equals CommodityCategory.Id join users in _productdb.users on commodity.UserId equals users.Id where (commodity.Commodityname.Contains(parameter.SearchItem) || commodity.Commodityname.Contains(parameter.SearchItem) || commodity.transactionway.Contains(parameter.SearchItem)) select new CommoditymodelView { Id = commodity.Id, Commodityname = commodity.Commodityname, Filepath = WebServerPath + commodity.Filepath, Price = commodity.Price, // Username = users.Username != null ? users.Username : null, Commoditycategoryname = CommodityCategory.Categoryname != null ? CommodityCategory.Categoryname : "未选择商品类型", startdate = commodity.startdate, transactionway = commodity.transactionway, // days = commodity.days, expiredate = commodity.expiredate != null ? commodity.expiredate : null, status = commodity.status != true ? false : false, phone = commodity.phone != null ? commodity.phone : null }; result = await query.ToListAsync(); } // return await queryExpression.ToListAsync(); //var query = await _productdb.commodities.ToListAsync(); // return query; //return query; //result = await _productdb.commodities.ToListAsync(); //分页数据获取为空,但结果是有4个,返回的结果确实0 return(result.Skip(parameter.PageSize * (parameter.PageNumber - 1)).Take(parameter.PageSize)); //return null; } catch (Exception ex) { throw ex; } }
public async Task <IEnumerable <CommoditymodelView> > GetProducts([FromQuery] CommodityParameter model) { var result = await _productsInterface.GetProductsasync(model); return(result); }