private VEGETABLESNAMEBASE FillModel(FormCollection collection) { VEGETABLESNAMEBASE model = new VEGETABLESNAMEBASE(); model.GUID = Tool.String2Guid(collection["GUID"].ToString()); model.SEQUENCE = Convert.ToDecimal(collection["SEQUENCE"] == null ? "0" : collection["SEQUENCE"].ToString()); model.CREATEDATETIME = DateTime.Now; model.CREATEUSERID = Guid.NewGuid(); model.CREATEUSERNAME = "******"; model.BIGIMAGEURL = "../Upload/" + collection["hid_path"]; model.SMALLIMAGEURL = "../Upload/" + collection["hid_path"]; model.BIGUNIT = collection["BIGUNIT"]; model.PACKRULE = Convert.ToInt32(collection["PACKRULE"]); model.REMARK = collection["REMARK"]; model.SEQUENCE = Convert.ToDecimal(collection["SEQUENCE"]); model.SMALLUNIT = collection["SMALLUNIT"]; model.VEGETABLESDES = collection["VEGETABLESDES"]; model.VEGETABLESNAME = collection["VEGETABLESNAME"]; model.ISDELETED = 0; //model.TYPEID = ""; //model.TYPENAME = ""; model.BUSINESSAREAIDS = collection["BUSINESSAREAIDS"]; model.BUSINESSAREANAMES = collection["BUSINESSAREANAMES"]; return(model); }
/// <summary> /// 添加菜品名称时,根据选择的区域自动生成VEGETABLESINFO表中的数据 /// </summary> /// <param name="model"></param> private void AddVegeInfo(VEGETABLESNAMEBASE model) { if (model.BUSINESSAREAIDS != "") { string[] arrArea = model.BUSINESSAREAIDS.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); string[] arrAreaName = model.BUSINESSAREANAMES.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); for (int i = 0; i < arrArea.Length; i++) { VEGETABLESINFO vimodel = new VEGETABLESINFO(); vimodel.GUID = Guid.NewGuid(); vimodel.BIGIMAGEURL = model.BIGIMAGEURL; vimodel.BIGUNIT = model.BIGUNIT; vimodel.CREATEDATETIME = model.CREATEDATETIME; vimodel.CREATEUSERID = model.CREATEUSERID; vimodel.CREATEUSERNAME = model.CREATEUSERNAME; vimodel.ISDELETED = 0; vimodel.PACKRULE = model.PACKRULE; vimodel.SMALLIMAGEURL = model.SMALLIMAGEURL; vimodel.SMALLUNIT = model.SMALLUNIT; vimodel.STOREID = Tool.String2Guid(arrArea[i]); vimodel.STORENAME = arrAreaName[i].ToString(); vimodel.TYPEID = model.TYPEID; vimodel.TYPENAME = model.TYPENAME; vimodel.VEGETABLESDES = model.VEGETABLESDES; vimodel.VEGETABLESID = model.GUID; vimodel.VEGETABLESNAME = model.VEGETABLESNAME; DbContext.VEGETABLESINFO.Add(vimodel); } } }
public ActionResult Create(FormCollection collection) { try { VEGETABLESNAMEBASE model = FillModel(collection); if (model.GUID == Guid.Empty) { model.GUID = Guid.NewGuid(); DbContext.VEGETABLESNAMEBASE.Add(model); AddVegeInfo(model); } else { DbContext.Entry(model).State = System.Data.EntityState.Modified; UpdateVegeInfo(model); } if (DbContext.SaveChanges() >= 0) { return(new JsonM().ToJson(true, MsgHelper.SaveSuccess, null, model.GUID.ToString())); } else { return(new JsonM().ToJson(false, MsgHelper.SaveFail)); } } catch (Exception ex) { return(new JsonM().ToJson(false, MsgHelper.SaveFail)); } }
/// <summary> /// 修改菜品名称时,根据选择的区域自动更新VEGETABLESINFO表中的数据 /// </summary> /// <param name="model"></param> private void UpdateVegeInfo(VEGETABLESNAMEBASE model) { var list = DbContext.VEGETABLESINFO.Where(o => o.VEGETABLESID == model.GUID).ToList(); string[] arrArea = model.BUSINESSAREAIDS.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); string[] arrAreaName = model.BUSINESSAREANAMES.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); foreach (var vimodel in list) { vimodel.BIGIMAGEURL = model.BIGIMAGEURL; vimodel.BIGUNIT = model.BIGUNIT; vimodel.CREATEDATETIME = model.CREATEDATETIME; vimodel.CREATEUSERID = model.CREATEUSERID; vimodel.CREATEUSERNAME = model.CREATEUSERNAME; vimodel.PACKRULE = model.PACKRULE; vimodel.SMALLIMAGEURL = model.SMALLIMAGEURL; vimodel.SMALLUNIT = model.SMALLUNIT; vimodel.TYPEID = model.TYPEID; vimodel.TYPENAME = model.TYPENAME; vimodel.VEGETABLESDES = model.VEGETABLESDES; vimodel.VEGETABLESNAME = model.VEGETABLESNAME; if (arrArea.Contains(vimodel.STOREID.ToString().ToUpper())) { vimodel.ISDELETED = 0; } else { vimodel.ISDELETED = 1; } DbContext.Entry(vimodel).State = System.Data.EntityState.Modified; } for (int i = 0; i < arrArea.Length; i++) { if (list.Where(o => o.STOREID == Tool.String2Guid(arrArea[i])).ToList().Count() == 0) { VEGETABLESINFO vimodel = new VEGETABLESINFO(); vimodel.GUID = Guid.NewGuid(); vimodel.BIGIMAGEURL = model.BIGIMAGEURL; vimodel.BIGUNIT = model.BIGUNIT; vimodel.CREATEDATETIME = model.CREATEDATETIME; vimodel.CREATEUSERID = model.CREATEUSERID; vimodel.CREATEUSERNAME = model.CREATEUSERNAME; vimodel.ISDELETED = 0; vimodel.PACKRULE = model.PACKRULE; vimodel.SMALLIMAGEURL = model.SMALLIMAGEURL; vimodel.SMALLUNIT = model.SMALLUNIT; vimodel.STOREID = Tool.String2Guid(arrArea[i]); vimodel.STORENAME = arrAreaName[i].ToString(); vimodel.TYPEID = model.TYPEID; vimodel.TYPENAME = model.TYPENAME; vimodel.VEGETABLESDES = model.VEGETABLESDES; vimodel.VEGETABLESID = model.GUID; vimodel.VEGETABLESNAME = model.VEGETABLESNAME; DbContext.VEGETABLESINFO.Add(vimodel); } } }
public ActionResult Create(string id = "") { VEGETABLESNAMEBASE model = new VEGETABLESNAMEBASE(); if (id != "") { Guid guid = Tool.String2Guid(id); model = DbContext.VEGETABLESNAMEBASE.FirstOrDefault(o => o.GUID == guid); } return(View(model)); }
/// <summary> /// 修改菜品名称时,根据选择的区域自动更新VEGETABLESINFO表中的数据 /// </summary> /// <param name="model"></param> private void DelVegeInfo(VEGETABLESNAMEBASE model) { var list = DbContext.VEGETABLESINFO.Where(o => o.VEGETABLESID == model.GUID).ToList(); foreach (var vimodel in list) { vimodel.ISDELETED = 1; vimodel.DELETEDATE = model.DELETEDATE; vimodel.DELETEUSER = model.DELETEUSER; DbContext.Entry(vimodel).State = System.Data.EntityState.Modified; } }