//获取餐厅图片 public ActionResult GetMenuImageUrls(string dirNo) { ServiceReturnMsg srm = new ServiceReturnMsg(); try { //string dirName = Request.Form["dName"]; if (string.IsNullOrEmpty(dirNo)) { srm.ReturnCode = 0; srm.ReturnMsg = "参数不能为空"; return(Json(srm)); } //图片初始目录 string imageFile = ConfigManage.ImageFileHead; //图片浏览URL string imageUrl = ConfigManage.ImageUrlHead; //获取该目录所有文件夹 //string[] dir = Directory.GetDirectories(imageFile+dirNo); string dtPath = dirNo + "\\大堂照片\\"; string cdPath = dirNo + "\\菜单照片\\"; string ImgUrl = "{"; //获取大堂照片所有文件 if (Directory.Exists(imageFile + dtPath) && Directory.GetFiles(imageFile + dtPath).Length > 0) { string[] files = Directory.GetFiles(imageFile + dtPath); ImgUrl += "\"dt\":["; foreach (var fls in files) { string filename = Path.GetFileName(fls); ImgUrl += "{\"imgsrc\":\"" + imageUrl + dtPath + filename + "\"},"; } ImgUrl = ImgUrl.Remove(ImgUrl.Length - 1); ImgUrl = ImgUrl + "],"; } if (Directory.Exists(imageFile + cdPath) && Directory.GetFiles(imageFile + cdPath).Length > 0) { //获取菜单照片所有文件 string[] files1 = Directory.GetFiles(imageFile + cdPath); ImgUrl += "\"cd\":["; foreach (var fls in files1) { string filename = Path.GetFileName(fls); ImgUrl += "{\"imgsrc\":\"" + imageUrl + cdPath + filename + "\"},"; } ImgUrl = ImgUrl.Remove(ImgUrl.Length - 1); ImgUrl = ImgUrl + "]"; } else if (ImgUrl != "{") { //只有一组图片数据删除最后一个逗号 ImgUrl = ImgUrl.Remove(ImgUrl.Length - 1); } ImgUrl += "}"; ImgUrl = ImgUrl.Replace("\\", "/"); srm.ReturnCode = 1; srm.ReturnData = ImgUrl; } catch (Exception ex) { srm.ReturnCode = 0; srm.ReturnMsg = "获取餐厅图片出错," + ex.Message; } return(Json(srm)); }
public ActionResult MenuEdit(RestaurantMenu menu) { ServiceReturnMsg srm = new ServiceReturnMsg(); try { //价格,备注不判断重复,查不到说明改了价格或者备注 string field = Request["fld"]; //List<RestaurantMenu> lst = db.RestaurantMenu.Where(t => t.Id == menu.Id && t.Price == menu.Price ).ToList();//from u in db.RestaurantMenu where (u.Id == menu.Id && u.Price == menu.Price ) select u; //string remark = menu.Remark == null ? "" : menu.Remark; //if (lst.Count > 0 && lst[0].Remark == null&&lst.Count==0) //{ // remark = null; //} //var q1 = from u in db.RestaurantMenu where (u.Id == menu.Id && u.Remark == remark) select u.Id; //List<RestaurantMenu> lst = null; //if (menu.Remark!=null) //{ // lst = db.RestaurantMenu.Where(t => t.Id == menu.Id && t.Price == menu.Price && t.Remark == menu.Remark).ToList(); //} //else //{ // lst = db.RestaurantMenu.Where(t=>t.Id == menu.Id && (t.Price == menu.Price && t.Remark == menu.Remark || t.Remark == "")).ToList(); //} if (field != "Price" && field != "Remark" && field != "Type")//lst.Count>0 && q1.FirstOrDefault() != null { string unit = menu.Unit == null ? "-" : menu.Unit; var qs = from u in db.RestaurantMenu where (u.RestaurantId == menu.RestaurantId && u.Name == menu.Name && u.Unit == unit) select u.Id; if (qs.FirstOrDefault() != null) { srm.ReturnCode = 0; srm.ReturnMsg = "您修改的记录存在相同单位的菜名"; return(Json(srm)); } } //RestaurantMenu entity = db.RestaurantMenu.Where(it => it.Id == menu.Id).FirstOrDefault<RestaurantMenu>(); //RestaurantMenu rmenu = new RestaurantMenu(); //rmenu.Id = menu.Id; //var newuser = db.RestaurantMenu.Attach(rmenu); //if(entity.Name!=menu.Name) // entity.Name = menu.Name; //if (entity.Type != menu.Type) // entity.Type = menu.Type; //if (entity.Price != menu.Price) // entity.Price = menu.Price; //if (entity.Unit != menu.Unit) // entity.Unit = menu.Unit; //if (entity.Remark != menu.Remark) // entity.Remark = menu.Remark; //entity.modified = DateTime.Now; //db.Entry(entity).State = EntityState.Modified; //int row = db.SaveChanges(); string sql = "update RestaurantMenu set Name=@Name,Type=@Type,Price=@Price,Unit=@Unit,Remark=@Remark,modified=@modified where Id=@Id"; var param = new SqlParameter[] { new SqlParameter("@Name", menu.Name), new SqlParameter("@Type", menu.Type), new SqlParameter("@Price", menu.Price), new SqlParameter("@Unit", menu.Unit == null ? "-" : menu.Unit), new SqlParameter("@Remark", menu.Remark == null?"":menu.Remark),// new SqlParameter("@modified", DateTime.Now), new SqlParameter("@Id", menu.Id) }; int row = db.Database.ExecuteSqlCommand(sql, param); srm.ReturnCode = row > 0 ? 1 : 0; srm.ReturnMsg = row > 0 ? "保存成功!" : "保存失败!"; } catch (Exception ex) { srm.ReturnCode = 0; srm.ReturnMsg = "保存出错," + ex.Message; } return(Json(srm)); }
public ActionResult AddShopRecord(RestaurantEnvInfo model) { ServiceReturnMsg srm = new ServiceReturnMsg(); Restaurant restaurant = new Restaurant(); string rname = Request.Form["RestaurantName"]; string DPId = Request.Form["DPId"]; string MeanPrice = Request.Form["MeanPrice"]; string Address = Request.Form["Address"]; try { if (!ModelState.IsValid) { var msg = string.Empty; foreach (var value in ModelState.Values) { if (value.Errors.Count > 0) { foreach (var error in value.Errors) { //msg = msg + error.ErrorMessage; srm.ReturnCode = 0; srm.ReturnMsg = error.ErrorMessage; return(Json(srm)); } } } } if (ModelState.IsValid) { if (db.Restaurant.FirstOrDefault(r => r.Name == rname) != null) { srm.ReturnCode = 0; srm.ReturnMsg = "该餐厅已存在"; return(Json(srm)); } string fwryxx = Request["服务人员形象"]; string cjts = Request["餐具特色"]; string zm = Request["照明"]; string cdcx = Request["菜单呈现"]; string wsjsn = Request["卫生间室内"]; string wsjxst = Request["卫生间洗手台"]; string wsjzcj = Request["卫生间坐厕间"]; #region 保存餐厅环境数据 model.务人员形象 = SumValue(fwryxx); model.餐具特色 = SumValue(cjts); model.照明 = SumValue(zm); model.菜单呈现 = SumValue(cdcx); model.卫生间室内 = SumValue(wsjsn); model.卫生间洗手台 = SumValue(wsjxst); model.卫生间坐厕间 = SumValue(wsjzcj); string xc = model.新菜 == null ? "" : model.新菜; string dnmj = model.店内面积 == null ? "" : model.店内面积; model.新菜 = xc; model.店内面积 = dnmj; model.RestaurantId = Guid.NewGuid(); db.RestaurantEnvInfo.Add(model); db.SaveChanges(); #endregion //============================================= #region 保存餐厅基础数据 restaurant.Name = rname; restaurant.DPId = DPId; restaurant.MeanPrice = Convert.ToInt32(MeanPrice); restaurant.Address = Address; string UserName = Request.Cookies["UserInfo"].Values["UserName"].ToString(); string UserId = Request.Cookies["UserInfo"].Values["UserId"].ToString(); restaurant.Creator = HttpUtility.UrlDecode(UserName); restaurant.UserId = Convert.ToInt32(UserId); restaurant.Id = Guid.NewGuid(); restaurant.RestaurantEnvInfoId = model.RestaurantId; restaurant.created = DateTime.Now; db.Restaurant.Add(restaurant); int row = db.SaveChanges(); #endregion //============================================= srm.ReturnCode = row > 0 ? 1 : 0; srm.ReturnMsg = row > 0 ? "添加成功!" : "添加失败!"; } } catch (Exception ex) { srm.ReturnCode = 0; srm.ReturnMsg = "添加出错," + ex.Message; } return(Json(srm)); //View(restaurant); }
public ActionResult MenuAdd(Menus menus) { //string Message = string.Empty; ServiceReturnMsg srm = new ServiceReturnMsg(); int row = 0; try { string UserName = Request.Cookies["UserInfo"].Values["UserName"].ToString(); string UserId = Request.Cookies["UserInfo"].Values["UserId"].ToString(); Guid SId = new Guid(); if (string.IsNullOrEmpty(Request.Form["RestaurantId"]) || string.IsNullOrEmpty(Request.Form["RestaurantName"])) { srm.ReturnCode = 0; srm.ReturnMsg = "参数传递失败"; return(Json(srm)); } SId = Guid.Parse(Request.Form["RestaurantId"]); string SName = Request.Form["RestaurantName"]; //新增餐厅 //if (SId.ToString()== "00000000-0000-0000-0000-000000000000") //{ // //新增一个餐厅 // SId = RestaurantAdd(SName); //} //else //{ //导入餐厅没有录入人的修改 Restaurant restaurant = db.Restaurant.Find(SId); if (string.IsNullOrEmpty(restaurant.Creator)) { restaurant.Creator = HttpUtility.UrlDecode(UserName); restaurant.UserId = Convert.ToInt32(UserId); restaurant.created = DateTime.Now; restaurant.modified = DateTime.Now; db.Entry(restaurant).State = EntityState.Modified; db.SaveChanges(); } string pid = restaurant.DPId == null ? "" :restaurant.DPId;// //} var listMenu = menus.Menu; //判断输入多个同类型菜名是否重复 //bool bl1 = listMenu.GroupBy(l => l.Type).Where(g => g.Count() > 1).Count() > 0; //bool bl2 = listMenu.GroupBy(l => l.Name).Where(g => g.Count() > 1).Count() > 0; //bool bl3 = false; //int count = 0; for (int j = 0; j < listMenu.Count; j++) { RestaurantMenu c = listMenu[j]; //判断相同菜名相同单位是否重复 //bl3 = listMenu.Where(l => l.Name == c.Name).GroupBy(l => l.Unit).Where(g => g.Count() > 1).Count() > 0; int count = listMenu.Where(l => l.Name == c.Name && l.Unit == c.Unit).Count(); if (count > 1)//验证输入的数据 { srm.ReturnCode = 0; srm.ReturnMsg = "该餐厅相同单位的【" + c.Name + "】已存在"; return(Json(srm)); } //if (c.Unit != null) //{ // count += 1; //} string unit = c.Unit == null ? "-" : c.Unit; //判断同个餐厅同单位菜名是否重复 var q = from u in db.RestaurantMenu where (u.RestaurantId == SId && u.Name == c.Name && u.Unit == unit) select u; //&& u.Type == c.Type if (q.FirstOrDefault() != null) //验证数据库 { srm.ReturnCode = 0; srm.ReturnMsg = "该餐厅相同单位的【" + c.Name + "】已存在"; return(Json(srm)); } } //判断两条不为空的单位是否重复 //if (count>1) //{ // bl3 = listMenu.GroupBy(l => l.Unit).Where(g => g.Count() > 1).Count() > 0; //} for (int i = 0; i < listMenu.Count; i++) { RestaurantMenu c = listMenu[i]; if (!string.IsNullOrEmpty(c.Type) && !string.IsNullOrEmpty(c.Name) && c.Price != 0) { //c.Id = Guid.NewGuid(); //c.RestaurantId = SId; //餐厅id //c.RestaurantName = SName;//餐厅名 //c.DPId = pid;//点评 //c.created = DateTime.Now; //c.Unit = c.Unit == null ? "-" : c.Unit; //c.DPDishId = ""; //c.DPRecommand = 0; //c.DPImgSrc = ""; //c.Remark = c.Remark == null ? "" : c.Remark; //c.modified = DateTime.Now; //db.RestaurantMenu.Add(c); string sql = "insert into RestaurantMenu (Id,RestaurantId,RestaurantName,DPId,Name,Type,Price,Unit,created,Creator,UserId) " + " values(@Id,@RestaurantId,@RestaurantName,@DPId,@Name,@Type,@Price,@Unit,@created,@Creator,@UserId)"; //Remark, var param = new SqlParameter[] { new SqlParameter("@Id", Guid.NewGuid()), new SqlParameter("@RestaurantId", SId), new SqlParameter("@RestaurantName", SName), new SqlParameter("@DPId", pid), new SqlParameter("@Name", c.Name), new SqlParameter("@Type", c.Type), new SqlParameter("@Price", c.Price), new SqlParameter("@Unit", c.Unit == null ? "-" : c.Unit), //new SqlParameter("@Remark",c.Remark==null?"":c.Remark), new SqlParameter("@created", DateTime.Now), new SqlParameter("@Creator", HttpUtility.UrlDecode(UserName)), //录入人 new SqlParameter("@UserId", UserId) //录入人id }; row = db.Database.ExecuteSqlCommand(sql, param); } else { srm.ReturnCode = 0; srm.ReturnMsg = "类型或菜名或价格为空,请填写完整信息"; return(Json(srm)); } } //int row = db.SaveChanges(); srm.ReturnData = SId + "," + SName + "," + pid; srm.ReturnCode = row > 0 ? 1 : 0; srm.ReturnMsg = row > 0 ? "保存成功!" : "保存失败!"; } catch (Exception ex) { srm.ReturnCode = 0; srm.ReturnMsg = "保存出错," + ex.Message; } return(Json(srm)); }
public ActionResult UpdateShopRecord(RestaurantEnvInfo model) { ServiceReturnMsg srm = new ServiceReturnMsg(); string rname = Request.Form["RestaurantName"]; string DPId = Request.Form["DPId"]; string MeanPrice = Request.Form["MeanPrice"]; string Address = Request.Form["Address"]; Guid resid = Guid.Parse(Request.Form["Resid"]); try { if (!ModelState.IsValid) { var msg = string.Empty; foreach (var value in ModelState.Values) { if (value.Errors.Count > 0) { foreach (var error in value.Errors) { //msg = msg + error.ErrorMessage; srm.ReturnCode = 0; srm.ReturnMsg = error.ErrorMessage; return(Json(srm)); } } } } if (ModelState.IsValid) { Restaurant resEntity = db.Restaurant.FirstOrDefault(t => t.RestaurantEnvInfoId == resid); //RestaurantEnvInfo envInfoEntity = db.RestaurantEnvInfo.FirstOrDefault(t => t.RestaurantId == model.RestaurantId); //保存餐厅环境数据 string fwryxx = Request["服务人员形象"]; string cjts = Request["餐具特色"]; string zm = Request["照明"]; string cdcx = Request["菜单呈现"]; string wsjsn = Request["卫生间室内"]; string wsjxst = Request["卫生间洗手台"]; string wsjzcj = Request["卫生间坐厕间"]; #region 保存餐厅环境数据 model.务人员形象 = SumValue(fwryxx); model.餐具特色 = SumValue(cjts); model.照明 = SumValue(zm); model.菜单呈现 = SumValue(cdcx); model.卫生间室内 = SumValue(wsjsn); model.卫生间洗手台 = SumValue(wsjxst); model.卫生间坐厕间 = SumValue(wsjzcj); string xc = model.新菜 == null ? "" : model.新菜; string dnmj = model.店内面积 == null ? "" : model.店内面积; model.新菜 = xc; model.店内面积 = dnmj; model.RestaurantId = resid; db.Entry(model).State = EntityState.Modified; db.SaveChanges(); #endregion //============================================= #region 保存餐厅基础数据 resEntity.Name = rname; resEntity.DPId = DPId; resEntity.MeanPrice = Convert.ToInt32(MeanPrice); resEntity.Address = Address; resEntity.modified = DateTime.Now; db.Entry(resEntity).State = EntityState.Modified; int row = db.SaveChanges(); #endregion //============================================= srm.ReturnCode = row > 0 ? 1 : 0; srm.ReturnMsg = row > 0 ? "修改成功!" : "修改失败!"; } } catch (Exception ex) { srm.ReturnCode = 0; srm.ReturnMsg = "修改出错," + ex.Message; } return(Json(srm)); }