/// <summary>
/// 门店进销存月报表
/// </summary>
/// <param name="model">产品信息</param>
/// <param name="SumModel">汇总方式</param>
/// <param name="SubStoreID">部门</param>
/// <param name="dStime">开始时间</param>
/// <param name="dEtime">结束时间</param>
/// <param name="BatchNo">批次</param>
/// <param name="EFIndex">扩展索引</param>
/// <param name="EFDesc">扩展条件</param>
/// <param name="pageIndex">页数</param>
/// <param name="pageCount">每页数</param>
/// <param name="OrderBy">排序</param>
/// <param name="totalCount">总数</param>
/// <returns></returns>
public static DataTable GetSubStoreMonthReport(ProductInfoModel model, bool SumModel, string SubStoreID
, DateTime dStime, DateTime dEtime, string BatchNo, string EFIndex, string EFDesc
, int pageIndex, int pageCount, string OrderBy, ref int totalCount)
{
return(SubStoreMonthReportDBHelper.GetSubStoreMonthReport(model, SumModel, SubStoreID, dStime, dEtime, BatchNo, EFIndex, EFDesc
, pageIndex, pageCount, OrderBy, ref totalCount));
}
/// <summary>变更SKU数据
/// </summary>
/// <param name="id">商品ID</param>
public void ChangeProductSKU(long id)
{
string redisKey = RedisKeyConst.GetProductInfoKey(id).Key;
ProductInfoModel prodInfo = CN100.Redis.Client.RedisClientUtility.GetData <ProductInfoModel>(redisKey);
if (prodInfo == null)
{
PublishProduct(id);
}
else
{
using (WcfTcpClient <IProductService> clint = factory.CreateClient <IProductService>())
{
prodInfo.SkuList = clint.Channel.GetProductSKUList(id);
}
if (prodInfo != null)
{
CN100.Redis.Client.RedisClientUtility.SetData <ProductInfoModel>(redisKey, prodInfo);
ChangeProductSKUDetail(prodInfo.SkuList, prodInfo.ProductActivityList, RedisKeyConst.GetProductSKUKey(id).Key);
}
else
{
DeleteByKey(redisKey);
}
}
}
/// <summary>
/// 插入物品档案信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool InsertProductInfo(ProductInfoModel model, out string ID, Hashtable htExtAttr)
{
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
ID = "0";
try
{
bool succ = false;
LogInfoModel logModel = InitLogInfo(model.ProdNo);
logModel.Element = ConstUtil.LOG_PROCESS_INSERT;
succ = ProductInfoDBHelper.InsertProductInfo(model, out ID, htExtAttr);
if (!succ)
{
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
}
else
{
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
LogDBHelper.InsertLog(logModel);
return(succ);
}
catch (Exception ex)
{
WriteSystemLog(userInfo, ex);
return(false);
}
}
/// <summary>产品发布
/// </summary>
/// <param name="redisKey"></param>
/// <param name="pid"></param>
public void PublishProduct(long pid)
{
string ProductInfoKey = RedisKeyConst.GetProductInfoKey(pid).Key; //商品信息
//获取商品信息
using (WcfTcpClient <IProductService> clint = factory.CreateClient <IProductService>())
{
ProductInfoModel productInfo = clint.Channel.GetProductInfo(pid);
//保存商品数据
if (productInfo != null)
{
CN100.Redis.Client.RedisClientUtility.SetData(ProductInfoKey, productInfo);
}
else
{
CN100.Redis.Client.RedisClientUtility.DelBySearchKey("Pro_*_" + pid);
return;
}
}
//生成SKU价格
ChangeProductSKUDetail(pid);
//生成商品统计信息
ChangeProductStatistics(pid);
//生成默认运费模板
ChangeProductDefaultFreight(pid);
}
// Gets called from JQuery In main.js
public ActionResult RemoveFilterParam(string key, string value)
{
ProductInfoModel model = new ProductInfoModel();
Dictionary <string, List <string> > FilterQuery = Session["FilterQuery"] as Dictionary <string, List <string> >;
if (FilterQuery.ContainsKey(key))
{
FilterQuery[key].Remove(value);
}
model.Filters = FilterQuery;
Session["Products"] = null;
//Check if Filter query is empty
var empty = false;
foreach (KeyValuePair <string, List <string> > index in FilterQuery)
{
foreach (var param in index.Value)
{
empty = true;
}
}
if (!empty)
{
Session["Facets"] = null;
}
return(PartialView("FilterRow", model));
}
public HttpResponseMessage TipReceivePacket(ProductInfoModel model)
{
string Result = string.Empty;
try
{
//请求中包含的固定参数
model.SOURCE = ParametersFilter.FilterSqlHtml(model.SOURCE, 24);
model.CREDENTIALS = ParametersFilter.FilterSqlHtml(model.CREDENTIALS, 24);
model.ADDRESS = HttpHelper.IPAddress();
model.TERMINAL = ParametersFilter.FilterSqlHtml(model.TERMINAL, 1);
model.INDEX = ParametersFilter.FilterSqlHtml(model.INDEX, 24);
model.METHOD = ParametersFilter.FilterSqlHtml(model.METHOD, 24);
//去除用户参数中包含的特殊字符
model.CommodityName = ParametersFilter.FilterSqlHtml(model.CommodityName, 50);
//返回结果
Result = ApiHelper.HttpRequest(username, password, Url, model);
///写日志
string RequestAction = "api/" + username + "/" + HttpContext.Current.Request.RequestContext.RouteData.Values["action"].ToString() + "：";
LogHelper.LogResopnse(RequestAction + Result);
}
catch (Exception ex)
{
LogHelper.LogError(ex.ToString());
}
HttpResponseMessage Respend = new HttpResponseMessage {
Content = new StringContent(Result, Encoding.GetEncoding("UTF-8"), "application/json")
};
return(Respend);
}
/// <summary>
/// 模型数据改变
/// </summary>
/// <param name="obj"></param>
private void dataChanged(ProductInfoModel productInfoModel)
{
getPageData(pageRepuestParams.PageIndex, pageRepuestParams.PageSize);
var tmpModel = ProductInfoList.FirstOrDefault(a => a.Id == productInfoModel.Id);
this.ProductInfo = ProductInfoList.FirstOrDefault();
}
public async Task <IActionResult> Post([FromBody] ProductInfoModel model)
{
var productId = await ControllerServices.CreateNewProduct(model);
_logger.LogInformation("New product created with id {productId}", productId);
return(CreatedAtAction(nameof(Get), new { id = productId }, productId));
}
/// <summary>
/// 进销存汇总表
/// </summary>
/// <param name="model"></param>
/// <param name="DailyDate"></param>
/// <param name="EFIndex"></param>
/// <param name="EFDesc"></param>
/// <param name="pageIndex"></param>
/// <param name="pageCount"></param>
/// <param name="OrderBy"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public static DataTable GetAllStorageInAndOutInfo(ProductInfoModel model, string DailyDate, string EndDate, string BatchNo, string EFIndex, string EFDesc, int pageIndex, int pageCount, string OrderBy, out DataTable dt, ref int totalCount)
{
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
#region 查询语句
//查询SQL拼写
StringBuilder searchSql = new StringBuilder();
searchSql.AppendLine("SELECT CONVERT(varchar(10),a.DailyDate,120) as DailyDate,");
searchSql.AppendLine(" isnull((");
searchSql.AppendLine(" select SUM(b.TodayCount) from officedba.StorageDaily b");
searchSql.AppendLine(" where b.Companycd='" + userInfo.CompanyCD + "' ");
searchSql.AppendLine(" and CONVERT(CHAR(10), b.DailyDate, 23)=");
searchSql.AppendLine(" CONVERT(CHAR(10), dateadd(dd,-1,CONVERT(varchar(10),a.DailyDate,120)), 23) ) ,0 ) as YestodayCount,");
searchSql.AppendLine(" SUM(Convert(numeric(22,2),a.PhurInCount)) as PhurInCount,SUM(Convert(numeric(22,2),a.MakeInCount)) as MakeInCount,");
searchSql.AppendLine(" SUM(Convert(numeric(22,2),a.DispInCount)) as DispInCount,");
searchSql.AppendLine(" SUM(Convert(numeric(22,2),a.OtherInCount)) as OtherInCount,SUM(Convert(numeric(22,2),a.SendInCount)) as SendInCount,SUM(Convert(numeric(22,2),a.SubSaleBackInCount)) as SubSaleBackInCount,");
searchSql.AppendLine(" SUM(Convert(numeric(22,2),a.TakeInCount)) as TakeInCount,SUM(Convert(numeric(22,2),a.InTotal)) as InTotal,SUM(Convert(numeric(22,2),a.SaleFee)) as SaleFee,SUM(Convert(numeric(22,2),a.PhurBackFee)) as PhurBackFee,");
searchSql.AppendLine(" SUM(Convert(numeric(22,2),a.InitInCount)) as InitInCount,SUM(Convert(numeric(22,2),a.InitBatchCount)) as InitBatchCount,SUM(Convert(numeric(22,2),a.SaleBackInCount)) as SaleBackInCount,");
searchSql.AppendLine(" SUM(Convert(numeric(22,2),a.RedInCount)) as RedInCount,SUM(Convert(numeric(22,2),a.BackInCount)) as BackInCount,");
searchSql.AppendLine(" ");
searchSql.AppendLine(" SUM(Convert(numeric(22,2),a.SaleOutCount)) as SaleOutCount,SUM(Convert(numeric(22,2),a.TakeOutCount)) as TakeOutCount,");
searchSql.AppendLine(" SUM(Convert(numeric(22,2),a.DispOutCount)) as DispOutCount,SUM(Convert(numeric(22,2),a.BadCount)) as BadCount,");
searchSql.AppendLine(" SUM(Convert(numeric(22,2),a.OtherOutCount)) as OtherOutCount,SUM(Convert(numeric(22,2),a.SendOutCount)) as SendOutCount,SUM(Convert(numeric(22,2),a.SubSaleOutCount)) as SubSaleOutCount,");
searchSql.AppendLine(" SUM(Convert(numeric(22,2),a.OutTotal)) as OutTotal,SUM(Convert(numeric(22,2),a.PhurFee)) as PhurFee,SUM(Convert(numeric(22,2),a.SaleBackFee)) as SaleBackFee,");
searchSql.AppendLine(" SUM(Convert(numeric(22,2),a.PhurBackOutCount)) as PhurBackOutCount,SUM(Convert(numeric(22,2),a.RedOutCount)) as RedOutCount,SUM(Convert(numeric(22,2),a.LendCount)) as LendCount,");
searchSql.AppendLine(" SUM(Convert(numeric(22,2),ABS(a.CheckCount))) as CheckCount,SUM(Convert(numeric(22,2),ABS(a.AdjustCount))) as AdjustCount,");
searchSql.AppendLine(" SUM(Convert(numeric(22,2),ABS(a.TodayCount))) as TodayCount ");
searchSql.AppendLine("FROM officedba.StorageDaily a ");
searchSql.AppendLine("where a.CompanyCD=@CompanyCD ");
#endregion
//定义查询的命令
SqlCommand comm = new SqlCommand();
//添加公司代码参数
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));
//开始日期
if (!string.IsNullOrEmpty(DailyDate))
{
searchSql.AppendLine(" and a.DailyDate>=@DailyDate");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@DailyDate", DailyDate));
}
//结束日期
if (!string.IsNullOrEmpty(EndDate))
{
searchSql.AppendLine(" and a.DailyDate<=@EndDate");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@EndDate", EndDate));
}
searchSql.AppendLine(" GROUP BY CONVERT(varchar(10),a.DailyDate,120)");
//指定命令的SQL文
comm.CommandText = searchSql.ToString();
//执行查询
dt = GetAllTotal(model, DailyDate, EndDate, BatchNo, EFIndex, EFDesc, false);
return(SqlHelper.PagerWithCommand(comm, pageIndex, pageCount, OrderBy, ref totalCount));
}
/// <summary>
/// 获取商品详情
/// </summary>
public JsonResult checkQty(string sku, int pid)
{
IList <ProductInfoModel> productsDetail = new List <ProductInfoModel>();
ProductInfoModel productInfoModel = new ProductInfoModel();
productsDetail = productBll.GetProductFightDetail(sku, base.ExchangeRate, pid);
productInfoModel = productsDetail.FirstOrDefault();
return(Json(new { ForOrderQty = productInfoModel.ForOrderQty }, JsonRequestBehavior.AllowGet));
}
public ProductInfoModel GetProductInfoModel(int productId)
{
var config = new MapperConfiguration(cfg => cfg.CreateMap <ProductInfoDTO, ProductInfoModel>());
Mapper mapper = new Mapper(config);
ProductInfoModel productInfoModel = mapper.Map <ProductInfoModel>(_productsHelper.GetProductInfoById(productId));
return(productInfoModel);
}
/// <summary>
/// 门店进销存月报表(导出使用)
/// </summary>
/// <param name="model">产品信息</param>
/// <param name="SumModel">汇总方式</param>
/// <param name="SubStoreID">部门</param>
/// <param name="dStime">开始时间</param>
/// <param name="dEtime">结束时间</param>
/// <param name="BatchNo">批次</param>
/// <param name="EFIndex">扩展索引</param>
/// <param name="EFDesc">扩展条件</param>
/// <returns></returns>
public static DataTable GetSubReportToExel(ProductInfoModel model, bool SumModel, string SubStoreID
, DateTime dStime, DateTime dEtime, string BatchNo, string EFIndex, string EFDesc)
{
//定义查询的命令
SqlCommand comm = GetSubStoreCommand(model, SumModel, SubStoreID, dStime, dEtime, BatchNo, EFIndex, EFDesc, false);
//执行查询
return(SqlHelper.ExecuteSearch(comm));
}
/// <summary>
/// 门店进销存月报表
/// </summary>
/// <param name="model">产品信息</param>
/// <param name="SumModel">汇总方式</param>
/// <param name="SubStoreID">部门</param>
/// <param name="dStime">开始时间</param>
/// <param name="dEtime">结束时间</param>
/// <param name="BatchNo">批次</param>
/// <param name="EFIndex">扩展索引</param>
/// <param name="EFDesc">扩展条件</param>
/// <param name="pageIndex">页数</param>
/// <param name="pageCount">每页数</param>
/// <param name="OrderBy">排序</param>
/// <param name="totalCount">总数</param>
/// <returns></returns>
public static DataTable GetSubStoreMonthReport(ProductInfoModel model, bool SumModel, string SubStoreID
, DateTime dStime, DateTime dEtime, string BatchNo, string EFIndex, string EFDesc
, int pageIndex, int pageCount, string OrderBy, ref int totalCount)
{
//定义查询的命令
SqlCommand comm = GetSubStoreCommand(model, SumModel, SubStoreID, dStime, dEtime, BatchNo, EFIndex, EFDesc, false);
//执行查询
return(SqlHelper.PagerWithCommand(comm, pageIndex, pageCount, OrderBy, ref totalCount));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="pc">pc</param>
/// <returns>影响的记录行数</returns>
public int DeleteMultiple(ParameterCollection pc)
{
int ret = 0;
ProductInfoModel productinfo = new ProductInfoModel();
ret = DbUtil.Current.DeleteMultiple(productinfo, pc);
return(ret);
}
public object Show(int id)
{
Product product = BllFactory.GetProductBLL().GetProductById(id);
if( product == null )
throw new MyMessageException("指定的ID值无效。不能找到对应的记录。");
List<Category> categories = BllFactory.GetCategoryBLL().GetList();
ProductInfoModel data = new ProductInfoModel(categories, product);
return new PageResult("/Pages/Style1/Controls/ProductInfo.cshtml", data);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="productinfo">实体</param>
/// <param name="pc">pc</param>
/// <returns>影响的记录行数</returns>
public int UpdateMultiple(ProductInfoModel productinfo, ParameterCollection pc)
{
int ret = 0;
productinfo.ModifiedBy = SessionUtil.Current.UserId;
productinfo.ModifiedOn = DateTime.Now;
ret = DbUtil.Current.UpdateMultiple(productinfo, pc);
return(ret);
}
/// <summary>
/// Get the ProductDetails
/// </summary>
private void GetProductDetails()
{
for (int i = 0; i < 40; i++)
{
ProductInfoModel p = new ProductInfoModel();
p.ProductName = ProductNames[r.Next(ProductNames.Count() - 1)];
p.Year2008 = r.Next(100, 300);
p.Year2009 = r.Next(400, 600);
this.productDetails.Add(p);
}
}
/// <summary>
/// 进销存日报表明细
/// </summary>
/// <param name="CompanyCD"></param>
/// <param name="HappenDate"></param>
/// <param name="pageIndex"></param>
/// <param name="pageCount"></param>
/// <param name="OrderBy"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public static DataTable GetBuyingSellingStockingByDayDetail(ProductInfoModel model, string DailyDate, string BatchNo, int pageIndex, int pageCount, string OrderBy, ref int totalCount)
{
try
{
return(BuyingSellingStockingDBHelper.GetBuyingSellingStockingByDayDetail(model, DailyDate, BatchNo, pageIndex, pageCount, OrderBy, ref totalCount));
}
catch (System.Exception ex)
{
throw ex;
}
}
/// <summary>
/// 进销存日报表总计
/// </summary>
/// <param name="model"></param>
/// <param name="DailyDate"></param>
/// <param name="BatchNo"></param>
/// <param name="EFIndex"></param>
/// <param name="EFDesc"></param>
/// <returns></returns>
public static DataTable GetSumBuyingSellingStockingByDay(ProductInfoModel model, string DailyDate, string BatchNo, string EFIndex, string EFDesc)
{
try
{
return(BuyingSellingStockingDBHelper.GetSumBuyingSellingStockingByDay(model, DailyDate, BatchNo, EFIndex, EFDesc));
}
catch (System.Exception ex)
{
throw ex;
}
}
public async Task UpdateProductInfo(Guid productId, ProductInfoModel model)
{
var url = UrlBuilder.UpdateProductInfoUrl(productId);
var response = await Client.PutAsJsonAsync(url, model);
if (!response.IsSuccessStatusCode)
{
throw new ApplicationException($"Update product {productId} call ended with status code {response.StatusCode}");
}
}
/// <summary>
/// 进销存日报表总计
/// </summary>
/// <param name="model"></param>
/// <param name="DailyDate"></param>
/// <param name="BatchNo"></param>
/// <param name="EFIndex"></param>
/// <param name="EFDesc"></param>
/// <returns></returns>
public static DataTable GetAllTotal(ProductInfoModel model, string DailyDate, string EndDate, string BatchNo, string EFIndex, string EFDesc, bool flag)
{
try
{
return(StorageDBHelper.GetAllTotal(model, DailyDate, EndDate, BatchNo, EFIndex, EFDesc, flag));
}
catch (System.Exception ex)
{
throw ex;
}
}
//采购用
public static DataTable GetProductInfoTableBycondition(ProductInfoModel model, int pageIndex, int pageCount, string OrderBy, ref int totalCount)
{
try
{
return(ProductInfoDBHelper.GetProductInfoTableBycondition(model, pageIndex, pageCount, OrderBy, ref totalCount));
}
catch (Exception ex)
{
throw ex;
}
}
public async Task CreateProduct(ProductInfoModel model)
{
var url = UrlBuilder.CreateProductUrl();
var response = await Client.PostAsJsonAsync(url, model);
if (!response.IsSuccessStatusCode)
{
throw new ApplicationException($"Create new product call ended with status code {response.StatusCode}");
}
}
/// <summary>
/// 更新
/// </summary>
/// <param name="productinfo">实体</param>
/// <returns>影响的记录行数</returns>
public int Update(ProductInfoModel productinfo)
{
int ret = 0;
productinfo.ModifiedBy = SessionUtil.Current.UserId;
productinfo.ModifiedOn = DateTime.Now;
ret = DbUtil.Current.Update(productinfo);
return(ret);
}
/// <summary>
/// 进销存汇总表
/// </summary>
/// <param name="model"></param>
/// <param name="DailyDate"></param>
/// <param name="EFIndex"></param>
/// <param name="EFDesc"></param>
/// <param name="pageIndex"></param>
/// <param name="pageCount"></param>
/// <param name="OrderBy"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public static DataTable GetStorageInAndOutTotalInfo(ProductInfoModel model, string DailyDate, string EndDate, string BatchNo, string EFIndex, string EFDesc, int pageIndex, int pageCount, string OrderBy, out DataTable dt, ref int totalCount)
{
try
{
return(MonthDayDBHelper.GetStorageInAndOutTotalInfo(model, DailyDate, EndDate, BatchNo, EFIndex, EFDesc, pageIndex, pageCount, OrderBy, out dt, ref totalCount));
}
catch (System.Exception ex)
{
throw ex;
}
}
public ActionResult ProductInfo(int id)
{
var productModel = ProductModel.ConvertToProductModel(ProductModel.GetProduct(id));
var productinfoModel = new ProductInfoModel()
{
ProductModel = productModel,
ReviewModel = null
};
return(View(productinfoModel));
}
// Gets called from JQuery
public ActionResult RenderPagenationProducts()
{
ProductInfoModel model = new ProductInfoModel();
List <productinfo> products = Session["Products"] as List <productinfo>;
var start = products.Count;
var query = getPaginationQuery(start);
SolrResponse solrResponse = _searchService.GetProductsFromQuery(query);
updateSessionParamsWithSolrValues(solrResponse, false);
model.Products = solrResponse.Data;
return(PartialView("ProductList", model));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="productid"></param>
/// <returns>影响的记录行数</returns>
public int Delete(string productid)
{
int ret = 0;
ProductInfoModel productinfo = new ProductInfoModel();
productinfo.ProductId = productid;
ret = DbUtil.Current.Delete(productinfo);
return(ret);
}
private void comboBoxProduct_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
string productTitle = comboBoxProduct.SelectedItem.ToString();
int productId = (from p in _products
where p.ProductTitle.Equals(productTitle)
select p.ProductId)
.FirstOrDefault();
productInfoModel = _controller.GetProductInfoModel(productId);
labelMeasureUnit.Content = productInfoModel.MeasureUnit;
}
public async Task <IActionResult> ProductInfo([FromQuery] Guid?templateId)
{
var model = new ProductInfoModel
{
Templates = await _mediator.Send(new GetTemplatesRequest()),
TemplateId = templateId.GetValueOrDefault(),
ReportOptions = _reportOptions
};
_prePopulatedValuesSetter.Execute(model);
return(View(model));
}
/// <summary>
/// 查询获取物品信息
/// </summary>
/// <param name="Model"></param>
/// <returns></returns>
public static DataTable GetProductInfo(ProductInfoModel Model, string EFIndex, string EFDesc, int pageIndex, int pageCount, string OrderBy, ref int totalCount)
{
try
{
return(ProductInfoDBHelper.GetProductInfo(Model, EFIndex, EFDesc, pageIndex, pageCount, OrderBy, ref totalCount));
}
catch (Exception ex)
{
return(null);
throw ex;
}
}
