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