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