//获取餐厅图片
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));
}
