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 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);
}
}
}
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 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;
}
}
/// <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);
}
}
}
