//public public dataJson GetCommodity(int start, int count) { try { int end = start + count; var tables = CommodityService.Query(start, end); if (tables.TotalCount > 0) { var list = tables.ModelList.Select(x => new CommodityModel(x, ImageUrl)).ToList(); return(new dataJson() { count = count, events = list, start = start, total = tables.TotalCount }); } return(new dataJson() { count = count, events = null, start = start, total = tables.TotalCount }); } catch (Exception ex) { logService.Insert(ex); return(null); } }
public ActionResult GetCommodityInfoMain(string id) { string key = HotelCloud.Common.HCRequest.GetString("key");//"酒店微信id@用户微信id" string weixinid = HotelCloud.Common.HCRequest.GetString("weixinID"); string userweixinid = HotelCloud.Common.HCRequest.GetString("userweixinID"); string MallSearch = HotelCloud.Common.HCRequest.GetString("MallSearch"); string type = HotelCloud.Common.HCRequest.GetString("type"); string sort = HotelCloud.Common.HCRequest.GetString("sort"); string price = HotelCloud.Common.HCRequest.GetString("price"); string selectCity = HotelCloud.Common.HCRequest.GetString("selectCity"); string cityName = HotelCloud.Common.HCRequest.GetString("cityName"); string subitem = HotelCloud.Common.HCRequest.GetString("subitem"); int curpage = HotelCloud.Common.HCRequest.getInt("curpage"); int pagesize = HotelCloud.Common.HCRequest.getInt("pagesize"); int dataCount = HotelCloud.Common.HCRequest.getInt("dataCount"); if (pagesize < 1) { pagesize = 6; } if (!key.Equals("") && key.Contains("@")) { weixinid = key.Split('@')[0];//酒店微信id userweixinid = key.Split('@')[1]; } DataTable commodityDataTable = CommodityService.GetCommodityListMain(sort, MallSearch, type, price, subitem, selectCity, cityName, curpage, weixinid, id, false, ref dataCount, pagesize); return(Json(new { dataCount = dataCount, data = SerializeDataTable(commodityDataTable) }, JsonRequestBehavior.AllowGet)); }
public SellerBackgroundController(ModelContext context, IHostingEnvironment hostingEnvironment) { _context = context; shopService = new ShopService(_context); commodityService = new CommodityService(_context); _hostingEnvironment = hostingEnvironment; }
public ActionResult CommodityRichText(string id) { string hotelId = id; string key = HotelCloud.Common.HCRequest.GetString("key"); //"酒店微信id@用户微信id" string weixinid = HotelCloud.Common.HCRequest.GetString("weixinID"); //酒店微信id string commodityId = HotelCloud.Common.HCRequest.GetString("CommodityID"); //酒店微信id string userweixinid = ""; if (!key.Equals("") && key.Contains("@")) { weixinid = key.Split('@')[0];//酒店微信id userweixinid = key.Split('@')[1]; } var DataTable = CommodityService.GetDataById(commodityId); var hotelData = GetHotelBySupermarket(int.Parse(id)).Rows[0]; ViewData["myPoints"] = 0; var userDt = orderService.GetScoreByUser(weixinid, userweixinid); if (userDt.Rows.Count > 0) { ViewData["myPoints"] = userDt.Rows[0]["Emoney"]; } ViewData["Address"] = hotelData["address"]; ViewData["soldCount"] = SupermarketOrderDetailService.GetSoldCount(commodityId).Rows[0][0]; ViewData["hotelName"] = DishOrderLogic.GetHotelName(hotelId); ViewData["commodityTable"] = DataTable; ViewData["hotelId"] = id; ViewData["weixinid"] = weixinid; ViewData["userweixinid"] = userweixinid; ViewData["CommodityID"] = commodityId; return(View()); }
public IMessageProvider Save() { if (string.IsNullOrWhiteSpace(commodityNo)) { AddError(1, "请输入商品编码"); return(this); } var commdity = CommodityService.GetBycommodityNo(commodityNo); if (commdity == null) { AddError(1, "商品编码不存在"); return(this); } var model = SecondKillCommoditysService.GetById(Id); if (model != null) { model.commodityId = commdity.commodityId; model.num = num; model.price = price; model.surplusNum = num - model.payNum; model.commodityNo = commodityNo; SecondKillCommoditysService.Update(model); } AddMessage("success"); return(this); }
public void loadForm(bool isDeleteMU) { numbTotalBefore = 0m; shouldRemoveRow = isDeleteMU; btnUpdateMu.Enabled = false; dgvMiniUnits.Rows.Clear(); string cmdtyCode; string gradeCode; string custName; { var withBlock = My.MyProject.Forms.FrmEditAddRailList; if (isDeleteMU == false) { tempDt = withBlock.miniUnitDT; } else { tempDt = tempDeletedMUDT; } // Populate dgv string totalbStr; foreach (var mu in tempDt) { if (withBlock.cboCargoType.Text.Equals("BULK")) { mu.TotalBilled = Convert.ToDecimal(mu.TotalBilled); } // totalbStr = FormatNumber(mu.TotalBilled.ToString, 3) else { mu.TotalBilled = Convert.ToInt32(mu.TotalBilled); // totalbStr = FormatNumber(mu.TotalBilled.ToString, 0) } cmdtyCode = CommodityService.GetById(mu.CommodityId).CommodityCode; gradeCode = GradeService.GetById(mu.GradeId).GradeCode; custName = CompanyService.GetVWById(mu.CustomerId).CompanyName; dgvMiniUnits.Rows.Add(withBlock.txtUnitNumber.Text + "(" + MdlBookingManagement.digitToLetter((object)mu.MiniUnitOrder).ToUpper() + ")", custName, cmdtyCode + " " + gradeCode, (object)mu.TotalBilled); numbTotalBefore = (decimal)(numbTotalBefore + mu.TotalBilled); } // Set texts. if (withBlock.cboCargoType.Text.Equals("BULK")) { labelTotalSomething.Text = "Total Weight:"; lbltotalNumber.Text = withBlock.nudTotalBilledWeight.Value.ToString("0.###"); numbToReassign = withBlock.nudTotalBilledWeight.Value - numbTotalBefore; lblTotaltoBeAsgn.Text = numbToReassign.ToString("0.###"); nucTotal.DecimalPlaces = 3; } else { labelTotalSomething.Text = "Total Pieces:"; lbltotalNumber.Text = withBlock.nudTotalBilledWeight.Value.ToString("#"); numbToReassign = withBlock.nudTotalBilledWeight.Value - numbTotalBefore; lblTotaltoBeAsgn.Text = numbToReassign.ToString("#"); nucTotal.DecimalPlaces = 0; } } }
public void Read() { var account = this.AccountService.GetById(InnerObject.AccountId); string myName = "无会员信息"; var my = AccountService.QueryAccountWithOwner(new Services.AccountRequest() { Ids = new int[] { InnerObject.AccountId } }).FirstOrDefault(); if (my != null) { myName = my.OwnerDisplayName; } OrderId = InnerObject.OrderId; TotalMoney = InnerObject.TotalMoney.ToString("C"); CreateDate = InnerObject.createDate.ToString("yyyy-MM-dd HH:mm:ss"); Creater = InnerObject.Creater; AccountName = account.Name; AccountDiaplayName = myName; Phone = InnerObject.Phone; Address = InnerObject.Address; State = ModelHelper.GetBoundText(InnerObject, x => x.State); Sender = (string.IsNullOrWhiteSpace(InnerObject.Sender)?"无派送信息":InnerObject.Sender); detials = OrderService.GetByorderId(InnerObject.OrderId).Select(x => new OrderDetialBase(x)).ToList(); foreach (var item in detials) { var good = CommodityService.GetById(item.GoodId); item.GoodName = good.Name; item.DisplayName = good.DisplayName; } }
private void btnEditCommodity_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtCommodity.Text) | string.IsNullOrEmpty(txtCommodityCode.Text)) { My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Fields Empty !", "The Commodity or Commodity Code fields cannot be empty.", this); } else if (CommodityService.VerifyByCommodityCode(txtCommodityCode.Text)) { My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Warning!", "This registration code already exists!", this); } else if (CommodityId == 0) { if (CommodityService.Insert(txtCommodityCode.Text, txtCommodity.Text)) { My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Success", "Commodity inserted successfully.", this); My.MyProject.Forms.frmCommodityGrainMain.LoadCommodity(); Close(); } else { My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Error!", "There was an error when changing the Commodity, please contact the IT department. Error # 0121", this); } } else if (CommodityService.Update(CommodityId, txtCommodityCode.Text, txtCommodity.Text)) { My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Success", "Commodity updated successfully.", this); My.MyProject.Forms.frmCommodityGrainMain.LoadCommodity(); Close(); } else { My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Error!", "There was an error when changing the Commodity, please contact the IT department. Error # 0121", this); } }
public ActionResult Index(string id) { string hotelId = id; string key = HotelCloud.Common.HCRequest.GetString("key"); //"酒店微信id@用户微信id" string weixinid = HotelCloud.Common.HCRequest.GetString("weixinID"); //酒店微信id string userweixinid = ""; if (!key.Equals("") && key.Contains("@")) { weixinid = key.Split('@')[0];//酒店微信id userweixinid = key.Split('@')[1]; } string search = HotelCloud.Common.HCRequest.GetString("SupermarketSearch"); DataTable commodityDataTable = CommodityService.GetDataByUserId(weixinid, id, userweixinid); List <DataRow> rows = commodityDataTable.AsEnumerable().ToList(); if (!string.IsNullOrWhiteSpace(search)) { rows = rows.Where(r => WeiXinPublic.ConvertHelper.ToString(r["Name"]).Contains(search)).ToList(); } string hotelName = DishOrderLogic.GetHotelName(hotelId); ViewData["SupermarketSearch"] = search; ViewData["hotelId"] = id; ViewData["Address"] = hotelName; ViewData["weixinid"] = weixinid; ViewData["userweixinid"] = userweixinid; ViewData["commodityDataTable"] = commodityDataTable; ViewData["commodityList"] = rows; ViewData["CommodityTypeTable"] = CommodityService.GetCommodityTypeByhotelId(weixinid, hotelId, ""); return(View()); }
public ActionResult ShoppingMallByLingZong(string id) { string hotelId = id; string key = HotelCloud.Common.HCRequest.GetString("key"); //"酒店微信id@用户微信id" string weixinid = HotelCloud.Common.HCRequest.GetString("weixinID"); //酒店微信id string userweixinid = ""; string search = HotelCloud.Common.HCRequest.GetString("MallSearch"); if (!key.Equals("") && key.Contains("@")) { weixinid = key.Split('@')[0];//酒店微信id userweixinid = key.Split('@')[1]; } //促销显示 var pList = CommodityService.GetSaleProductsListToList(weixinid, search, "", ""); ViewData["products"] = pList; ViewData["MallSearch"] = search; ViewData["hotelId"] = id; ViewData["weixinid"] = weixinid; ViewData["userweixinid"] = userweixinid; ViewData["CommodityTypeTable"] = CommodityService.GetCommodityTypeByWeixinId(weixinid, "", search); ViewData["CommodityAllTypeTable"] = CommodityService.GetCommodityTypeByWeixinId(weixinid, "", ""); ViewData["CommodityExtensionTable"] = CommodityService.GetCommodityExtensionByWeixinId(weixinid); return(View()); }
public void Ready() { var qq = CommodityService.Query(new Services.CommodityRequest() { State = CommodityStates.Normal }).Select(x => new ListCommodity(x)).ToList(); this.Detial.Merge(qq); }
public CommodityDetail GetByCommodity(int id) { // Load(); var item = CommodityService.GetById(id); if (item != null && item.commodityState == CommodityStates.putaway) { var list = new List <SpecificationAndSpecificationDetail>(); if (!string.IsNullOrWhiteSpace(item.specificationId)) { string[] spIds = item.specificationId.Split(','); for (int i = 0; i < spIds.Count(); i++) { int specificationId = 0; int.TryParse(spIds[i], out specificationId); var specification = SpecificationService.GetSpecificationAndSpecificationDetailById(specificationId); if (specification != null) { list.Add(specification); } } //return new CommodityDetail(item, ImageUrl, list,null); } //int userId = 0; //var user = _securityHelper.GetCurrentUser(); //if (user != null) // userId = user.CurrentUser.UserId; //var request = new ReviewRequest(); //request.CommodityId = item.commodityId; //request.State = ReviewStates.Show; //request.UserId = userId; ////request.State = ReviewStates.Show; //ListReviewView ListRv = new ListReviewView(); //var Review = ReviewService.MicroMallQuery(request); //if(Review!=null) //{ // ListRv.TotalCount = Review.TotalCount; // int TotalPage = Math.Max((Review.TotalCount + request.PageSize - 1) / request.PageSize, 1); // if (1 == TotalPage) // { // ListRv.NextPage = 0; // } // else if (1 < TotalPage) // { // ListRv.NextPage = 2; // } // ListRv.List = Review.ModelList.Select(x => new ReviewView() {Content=x.Content, ReviewId=x.ReviewId, SubmitTime=x.SubmitTime.ToString(), UserId=x.UserId, UserName=x.UserName }).ToList(); //} var site = SiteService.Query(new SiteRequest()).FirstOrDefault(); if (site != null) { ImageUrl = site.imageUrl; } return(new CommodityDetail(item, ImageUrl, list, null)); } return(new CommodityDetail(null, "", null, null)); }
void worker() { Invoke(new Action(() => txtName.Text = "")); Invoke(new Action(() => txtBrand.Text = "")); Invoke(new Action(() => txtPrice.Text = "")); Invoke(new Action(() => lblBarcode.Text = "- - -")); Invoke(new Action(() => lblMessageCommodity.Text = "")); grpPrice.BackColor = grpName.BackColor = grpPrice.BackColor = grpBrand.BackColor = Color.WhiteSmoke; long barcode = 0; long.TryParse(txtBarcode.Text.Trim(), out barcode); if (string.IsNullOrEmpty(txtBarcode.Text) || barcode == 0) { timer1.Enabled = false; return; } try { commodity = CommodityService.get(barcode); if (commodity != null) { Invoke(new Action(() => txtName.Text = commodity.Name)); Invoke(new Action(() => txtBrand.Text = commodity.Brand)); Invoke(new Action(() => txtPrice.Text = commodity.Price == 0 ? "" : commodity.Price.ToString("N0"))); Invoke(new Action(() => lblMessageCommodity.Text = "")); Invoke(new Action(() => lblMessageBarcode.Text = "")); Invoke(new Action(() => lblBarcode.Text = txtBarcode.Text)); Invoke(new Action(() => txtBarcode.Text = "")); Invoke(new Action(() => txtPrice.Focus())); } else { Invoke(new Action(() => lblMessageCommodity.Text = "")); Invoke(new Action(() => lblMessageBarcode.Text = "")); Invoke(new Action(() => lblMessageCommodity.Text = "هیچ کالایی با این بارکد از پایگاه داده یافت نشد")); Invoke(new Action(() => lblBarcode.Text = txtBarcode.Text)); Invoke(new Action(() => txtBrand.Focus())); } } catch (Exception ex) { Invoke(new Action(() => lblMessageCommodity.Text = "")); Invoke(new Action(() => lblMessageBarcode.Text = "")); Invoke(new Action(() => lblMessageBarcode.Text = "فرمت بارکد وارد شده اشتباه می باشد")); } timer1.Enabled = false; }
private void btnSave_Click(object sender, EventArgs e) { try { if (validate()) { if (commodity == null) { Commodity comm = new Commodity(); if (string.IsNullOrWhiteSpace(lblBarcode.Text) || lblBarcode.Text == "- - -") { comm.BarCode = 0; } else { comm.BarCode = long.Parse(lblBarcode.Text.Trim()); } comm.Name = txtName.Text.Trim(); comm.Brand = txtBrand.Text; comm.Price = int.Parse(txtPrice.Text.Replace(",", "")); CommodityService.add(comm); lblMessageCommodity.Text = comm.Name + " - با موفقیت دخیره شد"; } else { if (ISChangeValue()) { commodity.State = 3; } else { commodity.State = 2; } commodity.BarCode = long.Parse(lblBarcode.Text.Trim()); commodity.Name = txtName.Text.Trim(); commodity.Brand = txtBrand.Text; commodity.Price = int.Parse(txtPrice.Text.Replace(",", "")); CommodityService.update(commodity); lblMessageCommodity.Text = commodity.Name + " - با موفقیت دخیره شد"; } bindGrid(); txtBarcode.Focus(); } else { //lblMessageCommodity.Text = "ورودی اطلاعات دارای اشکال می باشد"; } } catch (Exception ex) { lblMessageCommodity.Text = ex.Message; } }
private void frmEditCommodity_Load(object sender, EventArgs e) { if (CommodityId != 0) { var L = CommodityService.GetById(CommodityId); txtCommodity.Text = L.CommodityName; txtCommodityCode.Text = L.CommodityCode; } }
/* TODO ERROR: Skipped EndRegionDirectiveTrivia *//* TODO ERROR: Skipped RegionDirectiveTrivia */ public void LoadCommodity() { listCommodity = CommodityService.GetAll(); var Lc = from b in listCommodity where b.CommodityId > 0 select b; CommodityBindingSource.DataSource = Lc.ToList(); ListCommodityByColumn = Lc.ToList(); }
void bindGrid() { radGridView1.DataSource = CommodityService.getall(); if (radGridView1.Rows.Count() > 0) { radGridView1.Rows[radGridView1.Rows.Count - 1].IsCurrent = true; } lblUser.Text = "کالاهای افزوده شده : " + radGridView1.Rows.Count; }
public void Resume(int id) { var item = this.CommodityService.GetById(id); if (item != null && item.State == CommodityStates.Invalid) { item.State = CommodityStates.Normal; CommodityService.Update(item); Logger.LogWithSerialNo(LogTypes.CommodityResume, SerialNoHelper.Create(), id, item.Name); AddMessage("resume.success", item.Name); } }
public IMessageProvider Create() { var serialNo = SerialNoHelper.Create(); // InnerObject.AccountLevel = AccountLevel; InnerObject.State = PointRebateStates.Normal; CommodityService.Create(InnerObject); AddMessage("success", InnerObject.DisplayName); Logger.LogWithSerialNo(LogTypes.CommodityCreate, serialNo, InnerObject.CommodityId, InnerObject.DisplayName); return(this); }
private void FrmGrainInvList_Load(object sender, EventArgs e) { firstLoad = true; var giService = new GrainInventoryService(); dgvInventory.DataSource = GrainInventoryService.GetAllGrainInventory(); using (var db = new WTCCeresEntities()) { { var withBlock = cboCustomer; var categories = new List <int>(); categories.Add((int)MdlEnum.CompanyCategory.CUSTOMER); categories.Add((int)MdlEnum.CompanyCategory.CUSTOMER_VENDOR); withBlock.DataSource = CompanyService.GetByCompanyCategoryId(categories, db); withBlock.DisplayMember = "CompanyName"; withBlock.ValueMember = "CompanyId"; } var exclusionList = new List <string>(); exclusionList.Add("RELEASED"); { var withBlock1 = cboUnitNumber; var newUs = new VW_UnitSourceMiniUnit(); newUs.MiniunitNumber = ""; newUs.MiniUnitId = 0; var uslist = MiniUnitService.GetAll(exclusionList, db); uslist.Insert(0, newUs); withBlock1.DataSource = uslist; withBlock1.DisplayMember = "MiniUnitNumber"; withBlock1.ValueMember = "MiniUnitId"; withBlock1.SelectedIndex = -1; } { var withBlock2 = cboCommodity; withBlock2.DataSource = CommodityService.GetAll(db); withBlock2.DisplayMember = "CommodityCode"; withBlock2.ValueMember = "CommodityId"; } { var withBlock3 = cboGrade; withBlock3.DataSource = GradeService.GetAll(db); withBlock3.DisplayMember = "GradeCode"; withBlock3.ValueMember = "GradeId"; } } firstLoad = false; }
public void Save() { var serialNo = SerialNoHelper.Create(); var item = CommodityService.GetById(CommodityId); if (item != null) { item.DisplayName = DisplayName; item.Name = Name; item.Price = Price; CommodityService.Update(item); AddMessage("success", item.DisplayName); Logger.LogWithSerialNo(LogTypes.CommodityEdit, serialNo, item.CommodityId, item.DisplayName); } }
public int GetAllCount(int companyId, int customerId, int commodityId, int commodityTypeId, int brandId, int warsehouseId, int status, DateTime? startDate, DateTime? endDate, int userId) { var commoditySvc = new CommodityService(); var companySvc = new CompanyService(); var listCommodity = commoditySvc.GetCommodityByUser(userId); var listCompany = companySvc.GetAllCompanyByUser((int)CustomerType.Internal, userId); if (listCompany.Count > 0 && listCommodity.Count > 0) { List<int> listComm = listCommodity.Select(o => o.Id).ToList(); List<int> listComp = listCompany.Select(o => o.Id).ToList(); var sorts = new List<SortCol> { new SortCol { ColName = "Id", IsDescending = false } }; var func1 = GetQueryExp(companyId, customerId, commodityId, commodityTypeId, brandId, warsehouseId, status, startDate, endDate, listComm, listComp); return SalesOrderDAL.GetCount(func1); } return 0; }
public void Query() { var request = new CommodityRequest(); // fill condition if (State != States.All) { request.State = State; } request.DisplayNameWith = DisplayName; request.NameWith = Name; var query = CommodityService.Query(request); this.List = query.ToList(this, x => new ListCommodity(x)); }
public void Ready() { var qq = CommodityService.Query(new Services.CommodityRequest() { State = CommodityStates.Normal }).Select(x => new ListCommodity(x)).ToList(); if (Detial == null) { this.Detial = new MultiCheckList <ListCommodity>(CommodityService.Query(new Services.CommodityRequest() { State = CommodityStates.Normal }).Select(x => new ListCommodity(x)).ToList()); } this.Detial.Merge(qq); }
private void radGridView1_CellClick(object sender, Telerik.WinControls.UI.GridViewCellEventArgs e) { if (e.Row.Cells[0].Value == null) { return; } long barcode = 0; long.TryParse(e.Row.Cells[0].Value.ToString(), out barcode); Invoke(new Action(() => txtName.Text = "")); Invoke(new Action(() => txtBrand.Text = "")); Invoke(new Action(() => txtPrice.Text = "")); Invoke(new Action(() => lblBarcode.Text = "- - -")); Invoke(new Action(() => lblMessageCommodity.Text = "")); grpPrice.BackColor = grpName.BackColor = grpPrice.BackColor = grpBrand.BackColor = Color.WhiteSmoke; if (e.ColumnIndex == 5) { if (MessageBox.Show("آیا از حذف این کالا مطمئن هستید ؟", "حذف کالا", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { CommodityService.removeCommodity(barcode, e.Row.Cells[1].Value.ToString()); bindGrid(); } return; } commodity = CommodityService.get(barcode, e.Row.Cells[1].Value.ToString()); if (commodity != null) { Invoke(new Action(() => txtName.Text = commodity.Name)); Invoke(new Action(() => txtBrand.Text = commodity.Brand)); Invoke(new Action(() => txtPrice.Text = commodity.Price == 0 ? "" : commodity.Price.ToString("N0"))); Invoke(new Action(() => lblMessageCommodity.Text = "")); Invoke(new Action(() => lblMessageBarcode.Text = "")); Invoke(new Action(() => lblBarcode.Text = commodity.BarCode + "")); Invoke(new Action(() => txtPrice.Focus())); } }
public void Read(string phone) { AccountMsg = OrderService.GetAccountByPhone(phone); if (AccountMsg == null) { this.AddError(LogTypes.AddOrder, "找不到电话号码对应的会员", AccountMsg); return; } Address = AccountMsg.Address; gender = AccountMsg.Gender == 1 ? "先生" : AccountMsg.Gender == 2 ? "女士" : "保密"; AccountId = AccountMsg.AccountId; _accountName = AccountMsg.AccountName; Phone = phone; this.Detial = new MultiCheckList <ListCommodity>(CommodityService.Query(new Services.CommodityRequest() { State = CommodityStates.Normal }).Select(x => new ListCommodity(x)).ToList()); }
public ActionResult GetDataTravelAgencyCommdityLocat(string id) { string key = HotelCloud.Common.HCRequest.GetString("key");//"酒店微信id@用户微信id" string weixinid = HotelCloud.Common.HCRequest.GetString("weixinID"); string userweixinid = HotelCloud.Common.HCRequest.GetString("userweixinID"); string type = HotelCloud.Common.HCRequest.GetString("type"); string MallSearch = HotelCloud.Common.HCRequest.GetString("MallSearch"); if (!key.Equals("") && key.Contains("@")) { weixinid = key.Split('@')[0];//酒店微信id userweixinid = key.Split('@')[1]; } DataTable commodityDataTable = CommodityService.GetDataTravelAgencyCommdityLocat(weixinid, type, MallSearch); return(Json(new { data = SerializeDataTable(commodityDataTable) }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 购物车列表 /// </summary> /// <param name="openId"></param> /// <returns></returns> public ListCartDetail GetShoppingCart(int userId) { //var tran = TransactionHelper.BeginTransaction(); var model = new ListCartDetail(); try { var GetShoppingCart = ShoppingCartService.GetByAccountId(userId);//检测完毕后第二次获取信息 if (GetShoppingCart != null && GetShoppingCart.ModelList != null && GetShoppingCart.ModelList.Count > 0) { foreach (var item in GetShoppingCart.ModelList) { var model1 = new CartDetailsModel(); var comm = CommodityService.GetById(item.commodityId); if (comm != null) { model1.commodityId = comm.commodityId; model1.Freight = comm.commodityFreight; model1.Id = item.shoppingCartId; model1.Image = GetFirstImage(comm.images); model1.Price = comm.commodityPrice; model1.quantity = item.quantity; model1.CommodityStock = comm.commodityInventory; model1.specification = item.specification; model1.Title = comm.commodityName; model.CartDetailsList.Add(model1); //model.TotalAmt += model1.Price * model1.quantity; //model.Freight += model1.Freight; } } } } catch (Exception ex) { logService.Insert(ex); return(null); } return(model); }
/// <summary> /// 获取促销产品信息 /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult GetSaleProductsListToList(string id) { string key = HotelCloud.Common.HCRequest.GetString("key"); //"酒店微信id@用户微信id" string weixinid = HotelCloud.Common.HCRequest.GetString("weixinID"); //酒店微信id string userweixinid = ""; if (!key.Equals("") && key.Contains("@")) { weixinid = key.Split('@')[0];//酒店微信id userweixinid = key.Split('@')[1]; } string MallSearch = HotelCloud.Common.HCRequest.GetString("MallSearch"); string cityName = HotelCloud.Common.HCRequest.GetString("cityName"); string price = HotelCloud.Common.HCRequest.GetString("price"); var pList = CommodityService.GetSaleProductsListToList(weixinid, MallSearch, cityName, price); JavaScriptSerializer serializer = new JavaScriptSerializer(); return(Json(new { data = serializer.Serialize(pList) }, JsonRequestBehavior.AllowGet)); }
public void Read() { //var accounts = AccountService.QueryAccountWithOwner(new Services.AccountRequest()); //List<IdNamePair> accountBounded = new List<IdNamePair>(); //int[] ids=new int[accounts.Count()]; //int i=0; //foreach (var item in accounts) //{ // ids[i] = item.AccountId; i += 1; // accountBounded.Add(new IdNamePair() {Key=item.AccountId,Name=item.OwnerDisplayName }); //} //var accounts2 = AccountService.Query(new Services.AccountRequest()).Where(x => !ids.Contains(x.AccountId)); //foreach (var item in accounts2) //{ // accountBounded.Add(new IdNamePair() { Key=item.AccountId,Name=item.Name }); //} //AccountId.Bind(accountBounded); this.Detial = new MultiCheckList <ListCommodity>(CommodityService.Query(new Services.CommodityRequest() { State = CommodityStates.Normal }).Select(x => new ListCommodity(x)).ToList()); }
public JsonResult GetCommoditiesByCode(string code, string name, string originalName, int commodityTypeID, int commodityCategoryID) { try { var commodityResult = new { CommodityID = 0, Code = "", Name = "", VATPercent = new decimal(0) }; var result = commodityRepository.SearchCommoditiesByName(code, null).Select(s => new { s.CommodityID, s.Code, s.Name, s.CommodityCategory.VATPercent }); if (result.Count() > 0) { commodityResult = new { CommodityID = result.First().CommodityID, Code = result.First().Code, Name = result.First().Name, VATPercent = result.First().VATPercent } } ; else { CommodityDTO commodityDTO = new CommodityDTO(); commodityDTO.Code = code; commodityDTO.Name = name; commodityDTO.OfficialName = name; commodityDTO.OriginalName = originalName; commodityDTO.CommodityTypeID = commodityTypeID; commodityDTO.CommodityCategoryID = commodityCategoryID; CommodityService commodityService = new CommodityService(this.commodityRepository); commodityService.UserID = 2; //Ai cung co quyen add Commodity, boi viec add can cu theo UserID = 2: [email protected] if (commodityService.Save(commodityDTO)) { commodityResult = new { CommodityID = commodityDTO.CommodityID, Code = commodityDTO.Code, Name = commodityDTO.Name, VATPercent = new decimal(10) } } ; } return(Json(commodityResult, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { CommodityID = 0, Code = ex.Message, Name = ex.Message, VATPercent = new decimal(10) }, JsonRequestBehavior.AllowGet)); } }
public JsonResult GetCommoditiesByCode(string code, string name, string originalName, int commodityTypeID, int commodityCategoryID) { try { var commodityResult = new { CommodityID = 0, Code = "", Name = "", CommodityTypeID = 0, VATPercent = new decimal(0) }; var result = commodityRepository.SearchCommoditiesByName(code, null, true).Select(s => new { s.CommodityID, s.Code, s.Name, s.CommodityTypeID, s.CommodityCategory.VATPercent }); if (result.Count() > 0) commodityResult = new { CommodityID = result.First().CommodityID, Code = result.First().Code, Name = result.First().Name, CommodityTypeID = result.First().CommodityTypeID, VATPercent = result.First().VATPercent }; else { CommodityDTO commodityDTO = new CommodityDTO(); commodityDTO.Code = MVCBase.CommonExpressions.ComposeCommodityCode(code, commodityTypeID); commodityDTO.Name = name; commodityDTO.OfficialName = name; commodityDTO.OriginalName = originalName; commodityDTO.CommodityTypeID = commodityTypeID; commodityDTO.CommodityCategoryID = commodityCategoryID; CommodityService commodityService = new CommodityService(this.commodityRepository); commodityService.UserID = 2; //Ai cung co quyen add Commodity, boi viec add can cu theo UserID = 2: [email protected] commodityDTO.PreparedPersonID = commodityService.UserID; if (commodityService.Save(commodityDTO)) commodityResult = new { CommodityID = commodityDTO.CommodityID, Code = commodityDTO.Code, Name = commodityDTO.Name, CommodityTypeID = commodityDTO.CommodityTypeID, VATPercent = new decimal(10) }; } return Json(commodityResult, JsonRequestBehavior.AllowGet); } catch (Exception ex) { return Json(new { CommodityID = 0, Code = ex.Message, Name = ex.Message, VATPercent = new decimal(10) }, JsonRequestBehavior.AllowGet); } }
public ActionResult UpdateCommodityIsOpen(int comId, bool isOpen) { var commSvc = new CommodityService(); var errorCode = commSvc.UpdateCommodityIsOpen(comId, isOpen); return MyAjaxHelper.RedirectAjax(errorCode, null); }
public override ActionResult Index() { var commSvc = new CommodityService(); ViewBag.AllCommodities = commSvc.GetAllCommodities(); return View(); }
public List<SalesOrderViewVM> GetSalesOrderByRange(int from, int to, int companyId, int customerId, int commodityId, int commodityTypeId, int brandId, int warsehouseId, int status, DateTime? startDate, DateTime? endDate, int userId) { List<SalesOrderViewVM> list = new List<SalesOrderViewVM>(); var commoditySvc = new CommodityService(); var companySvc = new CompanyService(); var listCommodity = commoditySvc.GetCommodityByUser(userId); var listCompany = companySvc.GetAllCompanyByUser((int)CustomerType.Internal, userId); if (listCompany.Count > 0 && listCommodity.Count > 0) { List<int> listComm = listCommodity.Select(o => o.Id).ToList(); List<int> listComp = listCompany.Select(o => o.Id).ToList(); var sorts = new List<SortCol> { new SortCol { ColName = "Id", IsDescending = false } }; var func1 = GetQueryExp(companyId, customerId, commodityId, commodityTypeId, brandId, warsehouseId, status, startDate, endDate, listComm, listComp); var result = SalesOrderDAL.Query(func1, sorts, from, to, new List<string> { "Company", "Stock.Company", "Stock.Warehouse", "Stock.Commodity", "Stock.CommodityType", "Stock.Brand" }); foreach (var r in result) { SalesOrderViewVM order = new SalesOrderViewVM() { Id = r.Id, Date = r.Date.ToString("yyyy-MM-dd"), Qty = r.Quantity, Price = r.Price ?? 0, Remark = r.Comment, Status = r.Status, CustomerName = r.Company.Name, InterCompanyName = r.Stock.Company.Name, CommodityName = r.Stock.Commodity.Name, CommodityTypeName = r.Stock.CommodityType.Name, BrandName = r.Stock.Brand.Name, WarsehouseName = r.Stock.Warehouse.Name }; Type orderStatus = typeof(SalesOrderStatus); var item = (SalesOrderStatus)Enum.ToObject(orderStatus, r.Status); string description = EnumHelper.GetDescription<SalesOrderStatus>(item); var des = description.Split(new char[] { ',' }); order.StatusMsg = des[0]; if (des.Length > 1) { order.OptionMsg = des[1]; } list.Add(order); } } return list; }