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