/// <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); } } }
/// <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); } } }
/// <summary> /// 菜品价格修改日志 /// </summary> /// <param name="model"></param> /// <param name="oldbigprice"></param> /// <param name="oldsmallpirce"></param> private void AddPriceChangeLog(VEGETABLESINFO model, decimal oldbigprice, decimal oldsmallpirce) { if (model.BIGPRICE != 0) { DateTime nowdt = Convert.ToDateTime(DateTime.Now.ToShortDateString()); var list = DbContext.VEGETABLESINFOCHANGELOG.Where(o => (o.VEGETABLESID == model.VEGETABLESID) && (o.PACKRULE == model.PACKRULE) && (o.STOREID == model.STOREID) && (o.CHANGEDATE == nowdt)).ToList(); if (list.Count() > 0) { foreach (var vimodel in list) { vimodel.NEWBIGPRICE = model.BIGPRICE; //最新大包装价格 vimodel.NEWSMALLPRICE = model.SMALLPRICE; //最新小包装价格 DbContext.Entry(vimodel).State = System.Data.EntityState.Modified; } } else { VEGETABLESINFOCHANGELOG vimodel = new VEGETABLESINFOCHANGELOG(); vimodel.GUID = Guid.NewGuid(); vimodel.BIGUNIT = model.BIGUNIT; vimodel.CREATEDATETIME = DateTime.Now; //vimodel.CREATEUSERID = C_UserID; //vimodel.CREATEUSERNAME = C_FullName; vimodel.PACKRULE = model.PACKRULE; vimodel.SMALLUNIT = model.SMALLUNIT; vimodel.STOREID = model.STOREID; vimodel.STORENAME = model.STORENAME; vimodel.TYPEID = model.TYPEID; vimodel.TYPENAME = model.TYPENAME; vimodel.VEGETABLESID = model.VEGETABLESID; vimodel.VEGETABLESNAME = model.VEGETABLESNAME; vimodel.CHANGEDATE = Convert.ToDateTime(DateTime.Now.ToShortDateString()); //修改日期 vimodel.NEWBIGPRICE = model.BIGPRICE; //最新大包装价格 vimodel.NEWSMALLPRICE = model.SMALLPRICE; //最新小包装价格 vimodel.OLDBIGPRICE = oldbigprice; //上次大包装价格 vimodel.OLDSMALLPRICE = oldsmallpirce; //上次小包装价格 DbContext.VEGETABLESINFOCHANGELOG.Add(vimodel); } } }