public JsonResult editDict(Dictionary dict) { using (DBContext db = new DBContext()) { Dictionary oldOne = db.Dictionary.Where(q => q.ID.Equals(dict.ID)).FirstOrDefault(); if (oldOne == null) { dict.CreatorID = UserContext.user.ID; dict.Creator = UserContext.user.DisplayName; db.Dictionary.Add(dict); } else { oldOne.SortOrder = dict.SortOrder; oldOne.Name = dict.Name; //只有子项的值可以修改 if (!string.IsNullOrEmpty(oldOne.ParentCode)) { oldOne.Code = dict.Code; } oldOne.ModifyTime = DateTime.Now; db.Entry(oldOne).State = EntityState.Modified; } db.SaveChanges(); } return Json(new { code = 1, msg = "保存成功" }); }
public PartialViewResult ListOfNumber(string ProductName, string StartDate, string EndDate, int pi = 1) { using (DBContext db = new DBContext()) { var itemQuery = db.OrderItem.AsQueryable(); var orderQuery = db.Order.AsQueryable(); orderQuery = GetOrderQuery(orderQuery, StartDate, EndDate); if (!string.IsNullOrEmpty(ProductName)) { itemQuery = itemQuery.Where(q => q.ProductName.Equals(ProductName)); } ViewBag.list = (from q in itemQuery join o in orderQuery on q.OrderId equals o.ID group q by new { q.ProductName, q.ProductCode } into s select new CXSL() { ProductName = s.Key.ProductName, ProductCode = s.Key.ProductCode, ProductNumber = s.Sum(p => p.RealNumber) }).OrderByDescending(q => q.ProductNumber).Skip((pi - 1) * 10).Take(10).ToList(); double totalCount = (from q in itemQuery join o in orderQuery on q.OrderId equals o.ID group q by new { q.ProductName } into s select new { s.Key.ProductName }).Count(); ViewBag.pager = new Pager() { _TotalCount = totalCount, _PageIndex = pi }; return PartialView(); } }
public JsonResult editCourier(Courier courier) { using (DBContext db = new DBContext()) { Courier oldCourier = db.Courier.Where(q => q.ID.Equals(courier.ID)).FirstOrDefault(); if (oldCourier == null) { Guser user = UserContext.user; Store store = UserContext.store; courier.CreatorID = user.ID; courier.Creator = user.DisplayName; courier.StoreId = store.ID; courier.Status = Status.enable; db.Courier.Add(courier); } else { oldCourier.ModifyTime = DateTime.Now; oldCourier.CourierTel = courier.CourierTel; oldCourier.Status = courier.Status; db.Entry(oldCourier).State = EntityState.Modified; } db.SaveChanges(); } return Json(new { code = 1, msg = "保存成功" }); }
public JsonResult getArea(string levelType, string pId, string key, int page = 1) { using (DBContext db = new DBContext()) { var query = db.Area.AsQueryable(); query = query.Where(q => q.LevelType.Equals(levelType)); if (!string.IsNullOrEmpty(pId)) { query = query.Where(q => q.ParentId.Equals(pId)); } if (!string.IsNullOrEmpty(key)) { query = query.Where(q => q.Name.Contains(key) || q.Pinyin.Contains(key)); } ArrayList results = new ArrayList(); List<Area> list = query.OrderBy(q => q.CityCode).Skip((page - 1) * 10).Take(10).ToList(); foreach (var item in list) { results.Add(new { id = item.ID, name = item.Name, code = item.CityCode }); } int total = query.Count(); return Json(new { results = results, total = total, pageSize = 10 }, JsonRequestBehavior.AllowGet); } }
public JsonResult editNumber(StoreProduct product) { using (DBContext db = new DBContext()) { Store store = UserContext.store; //判断是否已存在相同商品 StoreProduct sameProduct = db.StoreProduct.Where(q => q.ProductID.Equals(product.ProductID) && q.StoreID.Equals(store.ID) && !q.ID.Equals(product.ID)).FirstOrDefault(); if (sameProduct != null) { return Json(new { code = -1, msg = "已存在相同商品" }); } StoreProduct oldOne = db.StoreProduct.Where(q => q.ID.Equals(product.ID)).FirstOrDefault(); if (oldOne == null) { product.ID = StringUtil.UniqueID(); product.StoreID = store.ID; db.StoreProduct.Add(product); } else { oldOne.ProductNumber = product.ProductNumber; oldOne.OnlinePrice = product.OnlinePrice; oldOne.OfflinePrice = product.OfflinePrice; db.Entry(oldOne).State = EntityState.Modified; } db.SaveChanges(); } return Json(new { code = 1, msg = "保存成功" }); }
public ActionResult Index(string key, int pi = 1) { using (DBContext db = new DBContext()) { var query = db.Product.AsQueryable(); if (!string.IsNullOrEmpty(key)) { query = query.Where(q => q.ProductName.Contains(key) || q.ProductCode.Contains(key)); } if (UserContext.store == null) { //管理员只维护并查看总店的商品 query = query.Where(q => q.StoreId == null); } else { //分店可以查看总店在市商品并维护自己添加的商品 query = query.Where(q => ((q.StoreId == null && q.Status == Status.enable) || q.StoreId.Equals(UserContext.store.ID))); } PagedList<Product> cards = query.OrderByDescending(q => q.ModifyTime).ToPagedList(pi, 10); if (null == cards) cards = new PagedList<Product>(new List<Product>(), 10, 0); if (Request.IsAjaxRequest()) return PartialView("List", cards); return View(cards); } }
public PartialViewResult ListOfDetail(string storeId, string StartDate, string EndDate, string storeType, int pi = 1) { using (DBContext db = new DBContext()) { var orderQuery = db.Order.AsQueryable(); orderQuery = SetQuery(orderQuery, storeId, StartDate, EndDate); var storeQuery = db.Store.AsQueryable(); if (!string.IsNullOrEmpty(storeType)) { StoreType type = (StoreType)Convert.ToInt16(storeType); storeQuery = storeQuery.Where(q => q.StoreType == type); } ViewBag.list = (from q in db.OrderItem join o in orderQuery on q.OrderId equals o.ID join t in storeQuery on o.StoreId equals t.ID group q by new { o.StoreId, o.StoreName, q.ProductName, q.ProductCode } into s orderby new { s.Key.StoreName, s.Key.ProductName } select new PSMX() { StoreName = s.Key.StoreName, ProductName = s.Key.ProductName, ProductCode = s.Key.ProductCode, ProductNumber = s.Sum(p => p.RealNumber) }).Skip((pi - 1) * 10).Take(10).ToList(); double totalCount = (from q in db.OrderItem join o in orderQuery on q.OrderId equals o.ID join t in storeQuery on o.StoreId equals t.ID group q by new { o.StoreId, o.StoreName, q.ProductName, q.ProductCode } into s select new { s.Key.StoreId, s.Key.ProductCode }).Count(); ViewBag.pager = new Pager() { _TotalCount = totalCount, _PageIndex = pi }; return PartialView(); } }
public JsonResult editItem(OrderItem item) { using (DBContext db = new DBContext()) { //判断订单是否存在 Order order = db.Order.Where(q => q.ID.Equals(item.OrderId)).FirstOrDefault(); if (order == null) { return Json(new { code = -1, msg = "找不到对应订单" }); } if (order.Status == OrderStatus.Sended) { return Json(new { code = -2, msg = "订单已发货,无法修改" }); } if (order.Status == OrderStatus.Reject) { return Json(new { code = -3, msg = "订单已被驳回,无法修改" }); } OrderItem oldItem = db.OrderItem.Where(q => q.ID.Equals(item.ID)).FirstOrDefault(); if (oldItem == null) { return Json(new { code = -4, msg = "找不到对应商品" }); } oldItem.Discount = item.Discount; oldItem.RealNumber = item.RealNumber; db.Entry(oldItem).State = EntityState.Modified; db.SaveChanges(); } decimal pay = Order.RefreshPay(item.OrderId); return Json(new { code = 1, msg = "保存成功", pay = pay }); }
public FileResult Export(string OrderCode, string StoreId, string Tel, string StartDate, string EndDate, string Status) { using (DBContext db = new DBContext()) { var query = db.Order.AsQueryable(); Store store = UserContext.store; StoreId = store == null ? StoreId : store.ID; query = SetQuery(query, OrderCode, StoreId, Tel, StartDate, EndDate, Status); //获取list数据 var list = query.OrderByDescending(q => q.SubmitTime).ToList(); //创建Excel文件的对象 NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook(); //添加一个sheet NPOI.SS.UserModel.ISheet sheet1 = book.CreateSheet("Sheet1"); //给sheet1添加第一行的头部标题 NPOI.SS.UserModel.IRow row1 = sheet1.CreateRow(0); row1.CreateCell(0).SetCellValue("订单号"); row1.CreateCell(1).SetCellValue("采购单位"); row1.CreateCell(2).SetCellValue("负责人"); row1.CreateCell(3).SetCellValue("联系电话"); row1.CreateCell(4).SetCellValue("下单时间"); row1.CreateCell(5).SetCellValue("订单金额"); row1.CreateCell(6).SetCellValue("订单状态"); string status = string.Empty; //将数据逐步写入sheet1各个行 for (int i = 0; i < list.Count; i++) { switch (list[i].Status) { case OrderStatus.BeforeSend: status = "待发货"; break; case OrderStatus.BeforeSubmit: status = "待提交"; break; case OrderStatus.Reject: status = "驳回"; break; case OrderStatus.Sended: status = "已发货"; break; } NPOI.SS.UserModel.IRow rowtemp = sheet1.CreateRow(i + 1); rowtemp.CreateCell(0).SetCellValue(list[i].OrderCode); rowtemp.CreateCell(1).SetCellValue(list[i].StoreName); rowtemp.CreateCell(2).SetCellValue(list[i].Creator); rowtemp.CreateCell(3).SetCellValue(list[i].Tel); rowtemp.CreateCell(4).SetCellValue(list[i].SubmitTime.ToString()); rowtemp.CreateCell(5).SetCellValue(list[i].Paid.ToString()); rowtemp.CreateCell(6).SetCellValue(status); } DateTime now = DateTime.Now; // 写入到客户端 return ExportExcel(book, now.ToString("yyMMddHHmmssfff")); } }
public string getMap(string city) { using (DBContext db = new DBContext()) { var list = db.Store.Where(q => q.City.Equals(city)).ToList(); return new JavaScriptSerializer().Serialize(list); } }
public ActionResult getTable() { using (DBContext db = new DBContext()) { List<GuserRole> roles = db.GuserRole.ToList(); return PartialView("List", roles); } }
public FileResult Export(string StoreId, string StartDate, string EndDate, int pi = 1) { using (DBContext db = new DBContext()) { var storeQuery = db.Store.AsQueryable(); if (!string.IsNullOrEmpty(StoreId)) { storeQuery = storeQuery.Where(q => q.ID.Equals(StoreId)); } var orderQuery = db.AppOrder.AsQueryable(); DateTime now = DateTime.Now; //不选择开始日期默认为本月1号 DateTime start = string.IsNullOrEmpty(StartDate) ? DateTime.Parse(string.Format("{0}/{1}/{2}", now.Year.ToString(), now.Month.ToString(), "01")) : DateTime.Parse(StartDate); DateTime end = string.IsNullOrEmpty(EndDate) ? now : DateTime.Parse(EndDate).AddDays(1); if (start > end) { DateTime temp = DateTime.MinValue; temp = end; end = start; start = temp; } orderQuery = orderQuery.Where(q => q.CreateTime.CompareTo(start) > 0 && q.CreateTime.CompareTo(end) < 0 && q.Status == 5); var list = (from q in storeQuery join o in orderQuery on q.ID equals o.StoreId into o_join from os in o_join.DefaultIfEmpty() group new { q.StoreName, os.Payable } by new { q.StoreName } into s select new PSJE() { StoreName = s.Key.StoreName, Pay = s.Sum(p => p.Payable == null ? 0 : p.Payable) }).OrderByDescending(q => q.Pay).ToList(); //创建Excel文件的对象 NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook(); //添加一个sheet NPOI.SS.UserModel.ISheet sheet1 = book.CreateSheet("Sheet1"); //给sheet1添加第一行的头部标题 NPOI.SS.UserModel.IRow row1 = sheet1.CreateRow(0); row1.CreateCell(0).SetCellValue("采购单位"); row1.CreateCell(1).SetCellValue("销售额"); string status = string.Empty; //将数据逐步写入sheet1各个行 for (int i = 0; i < list.Count; i++) { NPOI.SS.UserModel.IRow rowtemp = sheet1.CreateRow(i + 1); rowtemp.CreateCell(0).SetCellValue(list[i].StoreName); rowtemp.CreateCell(1).SetCellValue(list[i].Pay.ToString()); } // 写入到客户端 return ExportExcel(book, now.ToString("yyMMddHHmmssfff")); } }
public ActionResult Index() { HttpRequest request = System.Web.HttpContext.Current.Request; HttpCookie cookie = request.Cookies["session-cookie-name"]; if (cookie == null) { return View(); } string cookieAccountId = cookie["cookie-account-id-key"]; if (string.IsNullOrEmpty(cookieAccountId)) { cookie.Expires = DateTime.Now.AddDays(-1); System.Web.HttpContext.Current.Response.Cookies.Add(cookie); return View(); } using (var db = new DBContext()) { Guser user = db.Guser.Include("Role").Where(q => q.ID.Equals(cookieAccountId)).FirstOrDefault(); if (user == null || user.Status == Status.disable || Convert.ToInt32(user.Role.RoleVal) == 0) { cookie.Expires = DateTime.Now.AddDays(-1); System.Web.HttpContext.Current.Response.Cookies.Add(cookie); return View(); } UserContext.user = user; List<Store> stores = db.Store.Where(q => q.UserId.Equals(user.ID)).OrderBy(q => q.StoreCode).ToList(); if (stores.Count > 0) { Store selectStore = stores[0]; UserContext.store = selectStore; stores.RemoveAt(0); UserContext.stores = stores; } List<Menu> menus = XmlHelper.XmlDeserializeFromFile<List<Menu>>(Server.MapPath("~/route.config"), Encoding.UTF8); MenuContext.menus = menus; string url = GetFirstMenu(menus, Convert.ToInt32(user.Role.RoleVal)); return RedirectToAction("Index", url); } }
public PartialViewResult List(string Province, string City, string Country, string StoreId, string StartDate, string EndDate, int pi = 1) { using (DBContext db = new DBContext()) { var storeQuery = db.Store.AsQueryable(); if (!string.IsNullOrEmpty(Province)) { storeQuery = storeQuery.Where(q => q.Province.Equals(Province)); } if (!string.IsNullOrEmpty(City)) { storeQuery = storeQuery.Where(q => q.City.Equals(City)); } if (!string.IsNullOrEmpty(Country)) { storeQuery = storeQuery.Where(q => q.Country.Equals(Country)); } if (!string.IsNullOrEmpty(StoreId)) { storeQuery = storeQuery.Where(q => q.ID.Equals(StoreId)); } var offQuery = db.OfflineSell.AsQueryable(); var olQuery = db.AppOrder.AsQueryable(); DateTime now = DateTime.Now; //不选择开始日期默认为本月1号 DateTime start = string.IsNullOrEmpty(StartDate) ? DateTime.Parse(string.Format("{0}/{1}/{2}", now.Year.ToString(), now.Month.ToString(), "01")) : DateTime.Parse(StartDate); DateTime end = string.IsNullOrEmpty(EndDate) ? now : DateTime.Parse(EndDate).AddDays(1); if (start > end) { DateTime temp = DateTime.MinValue; temp = end; end = start; start = temp; } offQuery = offQuery.Where(q => q.XFRQ.CompareTo(start) > 0 && q.XFRQ.CompareTo(end) < 0 && q.bFinish == Finish.YJS); olQuery = olQuery.Where(q => q.CreateTime.CompareTo(start) > 0 && q.CreateTime.CompareTo(end) < 0 && q.Status == 5); ViewBag.list = (from q in storeQuery join off in offQuery on q.ID equals off.StationID into off_join from o in off_join.DefaultIfEmpty() join ol in olQuery on q.ID equals ol.StoreId into ol_join from l in ol_join.DefaultIfEmpty() group new { q.StoreName, o.JE, l.Payable } by new { q.StoreName } into s select new PSJE() { StoreName = s.Key.StoreName, Pay = s.Sum(p => (p.JE == null ? 0 : p.JE) + (p.Payable == null ? 0 : p.Payable)) }).OrderByDescending(q => q.Pay).Skip((pi - 1) * 10).Take(10).ToList(); ViewBag.pager = new Pager() { _TotalCount = storeQuery.Count(), _PageIndex = pi }; } return PartialView(); }
public JsonResult signIn(string account, string pwd, string remeberMe) { string returnUrl = string.Empty; using (var db = new DBContext()) { string _pass = StringUtil.Md5Encrypt(pwd); Guser user = db.Guser.Include("Role").Where(q => q.Account.Equals(account) && q.PassWord.Equals(_pass)).FirstOrDefault(); if (user == null) { return Json(new { code = -1, msg = "用户名或密码错误" }); } if (user.Status == Status.disable) { return Json(new { code = -2, msg = "此用户已禁用,请联系管理员" }); } int roleVal = Convert.ToInt32(user.Role.RoleVal); if (roleVal == 0) { return Json(new { code = -3, msg = "此用户角色未分配权限,请联系管理员" }); } UserContext.user = user; List<Store> stores = db.Store.Where(q => q.UserId.Equals(user.ID)).OrderBy(q => q.StoreCode).ToList(); if (stores.Count > 0) { Store selectStore = stores[0]; UserContext.store = selectStore; stores.RemoveAt(0); UserContext.stores = stores; } List<Menu> menus = XmlHelper.XmlDeserializeFromFile<List<Menu>>(Server.MapPath("~/route.config"), Encoding.UTF8); MenuContext.menus = menus; //暂时设置为自动保存自动登录 remeberMe = ""; if (!string.IsNullOrEmpty(remeberMe)) { HttpCookie cookie = new HttpCookie("session-cookie-name"); cookie["cookie-account-id-key"] = UserContext.user.ID; cookie.Expires = DateTime.Now.AddDays(7); System.Web.HttpContext.Current.Response.Cookies.Add(cookie); } returnUrl = GetFirstMenu(menus, roleVal); } return Json(new { code = 1, msg = "登录成功", url = returnUrl }); }
public object queryViewDialog(string productId) { using (DBContext db = new DBContext()) { Product product = db.Product.Where(q => q.ID.Equals(productId)).FirstOrDefault(); if (product == null) { return Json(new { code = -1, msg = "找不到指定商品" }); } ViewBag.product = product; return PartialView("View"); } }
public JsonResult editItem(OrderItem item) { using (DBContext db = new DBContext()) { //判断订单是否存在 Order order = db.Order.Where(q => q.ID.Equals(item.OrderId)).FirstOrDefault(); if (order == null) { return Json(new { code = -1, msg = "找不到对应订单" }); } if (order.Status > OrderStatus.BeforeSubmit && UserContext.store != null) { return Json(new { code = -2, msg = "您没有权限修改已提交过的订单" }); } if (order.Status == OrderStatus.Sended) { return Json(new { code = -3, msg = "订单已发货,无法修改" }); } if (order.Status == OrderStatus.Reject) { return Json(new { code = -4, msg = "订单已被驳回,无法修改" }); } //判断订单中是否已有此样商品 OrderItem sameItem = db.OrderItem.Where(q => q.OrderId.Equals(item.OrderId) && q.ProductId.Equals(item.ProductId) && !q.ID.Equals(item.ID)).FirstOrDefault(); if (sameItem != null) { return Json(new { code = -5, msg = "订单中已有相同商品" }); } OrderItem oldItem = db.OrderItem.Where(q => q.ID.Equals(item.ID)).FirstOrDefault(); if (oldItem == null) { Product product = db.Product.Where(q => q.ID.Equals(item.ProductId)).FirstOrDefault(); if (product == null) { return Json(new { code = -6, msg = "抱歉,找不到对应商品" }); } item.ID = StringUtil.UniqueID(); item.ProductCode = product.ProductCode; item.ProductName = product.ProductName; item.Price = product.Price; item.RealNumber = item.OrderNumber; db.OrderItem.Add(item); } else { oldItem.OrderNumber = item.OrderNumber; oldItem.RealNumber = item.OrderNumber; db.Entry(oldItem).State = EntityState.Modified; } db.SaveChanges(); } Order.RefreshPay(item.OrderId); return Json(new { code = 1, msg = "保存成功" }); }
public JsonResult editStore(Store store) { using (DBContext db = new DBContext()) { //判断店名是否重复 Store sameName = db.Store.Where(q => q.StoreName.Equals(store.StoreName) && !q.ID.Equals(store.ID)).FirstOrDefault(); if (sameName != null) { return Json(new { code = -1, msg = "门店名称已被注册" }); } Store oldStore = db.Store.Where(q => q.ID.Equals(store.ID)).FirstOrDefault(); if (oldStore == null) { //生成流水号 int code = db.Store.Count() == 0 ? 80000 : Convert.ToInt32(db.Store.Max(q => q.StoreCode)) + 1; store.StoreCode = code.ToString(); store.CreatorID = UserContext.user.ID; store.Creator = UserContext.user.DisplayName; store.Name = store.StoreName; store.Status = Status.enable; db.Store.Add(store); } else { oldStore.ModifyTime = DateTime.Now; oldStore.Name = store.StoreName; oldStore.UserId = store.UserId; oldStore.Address = store.Address; oldStore.Lng = store.Lng; oldStore.Lat = store.Lat; oldStore.Presider = store.Presider; oldStore.Tel = store.Tel; oldStore.StoreType = store.StoreType; oldStore.Discount = store.Discount; oldStore.Alipay = store.Alipay; oldStore.WeiXin = store.WeiXin; oldStore.Bank = store.Bank; oldStore.BankName = store.BankName; oldStore.BankAccount = store.BankAccount; oldStore.Status = store.Status; db.Entry(oldStore).State = EntityState.Modified; } db.SaveChanges(); } return Json(new { code = 1, msg = "保存成功" }); }
public ActionResult Index(string OrderCode, string StoreId, string Tel, string StartDate, string EndDate, int pi = 1) { using (DBContext db = new DBContext()) { var query = db.Order.AsQueryable(); if (!string.IsNullOrEmpty(OrderCode)) { query = query.Where(q => q.OrderCode.Contains(OrderCode)); } if (!string.IsNullOrEmpty(Tel)) { query = query.Where(q => q.Tel.Contains(Tel)); } DateTime now = DateTime.Now; //不选择开始日期默认为本月1号 DateTime start = string.IsNullOrEmpty(StartDate) ? DateTime.Parse(string.Format("{0}/{1}/{2}", now.Year.ToString(), now.Month.ToString(), "01")) : DateTime.Parse(StartDate); DateTime end = string.IsNullOrEmpty(EndDate) ? now : DateTime.Parse(EndDate); if (start > end) { DateTime temp = DateTime.MinValue; temp = end; end = start; start = temp; } //只显示代发货的订单 query = query.Where(q => q.SubmitTime.CompareTo(start) > 0 && q.SubmitTime.CompareTo(end) < 0 && q.Status == OrderStatus.BeforeSend); Store store = UserContext.store; if (store == null) { query = query.Where(q => q.Status != 0); if (!string.IsNullOrEmpty(StoreId)) { query = query.Where(q => q.StoreId.Contains(StoreId)); } } else { query = query.Where(q => q.StoreId.Equals(store.ID)); } PagedList<Order> cards = query.OrderByDescending(q => q.ModifyTime).ToPagedList(pi, 10); if (null == cards) cards = new PagedList<Order>(new List<Order>(), 10, 0); if (Request.IsAjaxRequest()) return PartialView("List", cards); return View(cards); } }
public JsonResult editProduct(Product product) { using (DBContext db = new DBContext()) { //判断编号是否重复 Product sameCode = db.Product.Where(q => q.ProductCode.Equals(product.ProductCode) && !q.ID.Equals(product.ID)).FirstOrDefault(); if (sameCode != null) { return Json(new { code = -1, msg = "商品编号已被注册" }); } Product oldProduct = db.Product.Where(q => q.ID.Equals(product.ID)).FirstOrDefault(); if (oldProduct == null) { product.CreatorID = UserContext.user.ID; product.Creator = UserContext.user.DisplayName; product.Name = product.ProductName; product.Status = Status.enable; product.StoreId = UserContext.store.ID; db.Product.Add(product); } else { if (UserContext.store != null && UserContext.store.ID != oldProduct.StoreId) { return Json(new { code = -2, msg = "抱歉,您没有权限修改本商品" }); } if (!string.IsNullOrEmpty(oldProduct.DocId) && !oldProduct.DocId.Equals(product.DocId)) { string basePath = string.Format(@"{0}Upload\", Server.MapPath("/")); Doc.delete(oldProduct.DocId, basePath); } oldProduct.ModifyTime = DateTime.Now; oldProduct.ProductCode = product.ProductCode; oldProduct.Name = product.ProductName; oldProduct.ProductType = product.ProductType; oldProduct.Price = product.Price; oldProduct.AllowReturn = product.AllowReturn; oldProduct.Remark = product.Remark; oldProduct.DocId = product.DocId; oldProduct.Status = product.Status; db.Entry(oldProduct).State = EntityState.Modified; } db.SaveChanges(); } return Json(new { code = 1, msg = "保存成功" }); }
public static void delete(string id, string basePath) { using (DBContext db = new DBContext()) { Doc doc = db.Doc.Where(q => q.ID.Equals(id)).FirstOrDefault(); if (doc == null) { return; } DirectoryInfo dir = new DirectoryInfo(string.Format("{0}{1}", basePath, doc.DirPath)); dir.Delete(true); db.Doc.Remove(doc); db.SaveChanges(); } }
public FileResult ExportDetail(string storeId, string StartDate, string EndDate, string storeType) { using (DBContext db = new DBContext()) { var orderQuery = db.Order.AsQueryable(); orderQuery = SetQuery(orderQuery, storeId, StartDate, EndDate); var storeQuery = db.Store.AsQueryable(); if (!string.IsNullOrEmpty(storeType)) { StoreType type = (StoreType)Convert.ToInt16(storeType); storeQuery = storeQuery.Where(q => q.StoreType == type); } var list = (from q in db.OrderItem join o in orderQuery on q.OrderId equals o.ID join t in storeQuery on o.StoreId equals t.ID group q by new { o.StoreId, o.StoreName, q.ProductName, q.ProductCode } into s orderby new { s.Key.StoreName, s.Key.ProductName } select new PSMX() { StoreName = s.Key.StoreName, ProductName = s.Key.ProductName, ProductCode = s.Key.ProductCode, ProductNumber = s.Sum(p => p.RealNumber) }).ToList(); //创建Excel文件的对象 NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook(); //添加一个sheet NPOI.SS.UserModel.ISheet sheet1 = book.CreateSheet("Sheet1"); //给sheet1添加第一行的头部标题 NPOI.SS.UserModel.IRow row1 = sheet1.CreateRow(0); row1.CreateCell(0).SetCellValue("分店"); row1.CreateCell(1).SetCellValue("商品名称"); row1.CreateCell(2).SetCellValue("商品编号"); row1.CreateCell(3).SetCellValue("采购总数"); string status = string.Empty; //将数据逐步写入sheet1各个行 for (int i = 0; i < list.Count; i++) { NPOI.SS.UserModel.IRow rowtemp = sheet1.CreateRow(i + 1); rowtemp.CreateCell(0).SetCellValue(list[i].StoreName); rowtemp.CreateCell(1).SetCellValue(list[i].ProductName); rowtemp.CreateCell(2).SetCellValue(list[i].ProductCode); rowtemp.CreateCell(3).SetCellValue(list[i].ProductNumber); } DateTime now = DateTime.Now; // 写入到客户端 return ExportExcel(book, now.ToString("yyMMddHHmmssfff")); } }
public JsonResult delOrder(string orderId) { using (DBContext db = new DBContext()) { Order order = db.Order.Where(q => q.ID.Equals(orderId)).FirstOrDefault(); if (order == null) { return Json(new { code = -1, msg = "找不到对应订单" }); } db.OrderItem.RemoveRange(db.OrderItem.Where(q => q.OrderId.Equals(orderId))); db.Order.Remove(order); db.SaveChanges(); return Json(new { code = 1, msg = "删除成功" }); } }
public JsonResult queryTree(string roleId) { ArrayList zNodes = new ArrayList(); GuserRole role = null; if (!string.IsNullOrEmpty(roleId)) { DBContext db = new DBContext(); role = db.GuserRole.Where(q => q.ID.Equals(roleId)).FirstOrDefault(); } addNodes(zNodes, MenuContext.menus, "0", role); return Json(new { code = 1, tree = new JavaScriptSerializer().Serialize(zNodes) }); }
public object queryDialog(string id) { using (DBContext db = new DBContext()) { if (!string.IsNullOrEmpty(id)) { StoreProduct product = db.StoreProduct.Include("Product").Where(q => q.ID.Equals(id)).FirstOrDefault(); if (product == null) { return Json(new { code = -1, msg = "找不到指定商品" }); } ViewBag.product = product; return PartialView("Edit"); } return PartialView("Add"); } }
public object queryDialog(string id) { using (DBContext db = new DBContext()) { if (!string.IsNullOrEmpty(id)) { Dictionary dict = db.Dictionary.Where(q => q.ID.Equals(id)).FirstOrDefault(); if (dict == null) { return Json(new { code = -1, msg = "找不到指定参数" }); } ViewBag.dict = dict; return PartialView("Edit"); } return PartialView("Add"); } }
public object queryDialog(string roleId) { using (DBContext db = new DBContext()) { if (!string.IsNullOrEmpty(roleId)) { GuserRole role = db.GuserRole.Where(q => q.ID.Equals(roleId)).FirstOrDefault(); if (role == null) { return Json(new { code = -1, msg = "找不到指定角色" }); } ViewBag.role = role; return PartialView("Edit"); } return PartialView("Add"); } }
public object queryDialog(string courierId) { using (DBContext db = new DBContext()) { if (!string.IsNullOrEmpty(courierId)) { Courier courier = db.Courier.Include("Store").Where(q => q.ID.Equals(courierId)).FirstOrDefault(); if (courier == null) { return Json(new { code = -1, msg = "找不到指定送餐员" }); } ViewBag.courier = courier; return PartialView("Edit"); } return PartialView("Add"); } }
public static decimal RefreshPay(string id) { using (DBContext db = new DBContext()) { Order order = db.Order.Where(q => q.ID.Equals(id)).FirstOrDefault(); decimal pay = db.OrderItem.Where(q => q.OrderId.Equals(id)).Sum(q => q.Price * q.RealNumber * q.Discount); order.Payable = pay; order.Paid = pay; db.Entry(order).State = EntityState.Modified; db.SaveChanges(); return pay; } }
public JsonResult checkOrder(string orderId, string checkremark) { using (DBContext db = new DBContext()) { Order order = db.Order.Where(q => q.ID.Equals(orderId)).FirstOrDefault(); if (order == null) { return Json(new { code = -1, msg = "找不到对应订单" }); } if (order.Status != OrderStatus.Sended) { return Json(new { code = -2, msg = "非已发货状态的订单不能驳回" }); } order.ModifyTime = DateTime.Now; order.RejectReason = checkremark; order.Status = OrderStatus.Checked; db.SaveChanges(); } return Json(new { code = 1, msg = "对账成功" }); }