//查询原料
public List <v_crude_genre> QueryCrude(string crudename, int genreid, string categoryName, string itemName, int state = -1)
{
try
{
DianDianEntities db = new DianDianEntities();
var crudeList = db.v_crude_genre.Where(p => p.shopkey == Properties.Settings.Default.shopkey);
if (!crudename.Equals(""))
{
crudeList = crudeList.Where(p => p.crudename.Contains(crudename));
}
if (genreid != 0)
{
crudeList = crudeList.Where(p => p.genreid == genreid);
}
if (state != -1)
{
crudeList = crudeList.Where(p => p.state == state);
}
return(crudeList.ToList());
}
catch (Exception e)
{
log.Error("QueryCrude error. msg=" + e.Message);
throw;
}
}
//保存原料分类
public void SaveGenre(int genreId, string genrename)
{
try
{
DianDianEntities db = new DianDianEntities();
storage_genre genre = db.storage_genre.Find(genreId);
if (genre == null)
{
genre = new storage_genre();
genre.createdate = DateTime.Now;
genre.genrename = genrename;
genre.shopkey = Properties.Settings.Default.shopkey;
genre.state = 1;
genre.orderno = 999;
db.storage_genre.Add(genre);
}
else
{
genre.genrename = genrename;
db.storage_genre.Attach(genre);
var stateEntity = ((IObjectContextAdapter)db).ObjectContext.ObjectStateManager.GetObjectStateEntry(genre);
stateEntity.SetModifiedProperty("genrename");
}
db.SaveChanges();
}
catch (Exception e)
{
log.Error("SaveGenre error. msg=" + e.Message);
throw;
}
}
//修改有效期
public void StockModifyValidate(int crudeid, DateTime validate, DateTime changedate)
{
try
{
DianDianEntities db = new DianDianEntities();
var stock = db.storage_stock.Where(p => p.crudeid == crudeid && p.validate == validate).FirstOrDefault();
if (stock != null)
{
stock.validate = changedate;
if (stock.backdate != null)
{
stock.backdate = changedate;
}
db.storage_stock.Attach(stock);
var stateEntity = ((IObjectContextAdapter)db).ObjectContext.ObjectStateManager.GetObjectStateEntry(stock);
stateEntity.SetModifiedProperty("backdate");
stateEntity.SetModifiedProperty("validate");
db.SaveChanges();
}
else
{
log.Error("StockModifyValidate error, msg = can not find record");
}
}
catch (Exception e)
{
log.Error("StockModifyValidate error. msg=" + e.Message);
throw;
}
}
public void SaveEmployee(int memberkey, string name, int posid, List <int> floorList)
{
try
{
DianDianEntities db = new DianDianEntities();
var mem = db.member.Find(memberkey);
if (mem == null)
{
mem = new member();
mem.name = name;
mem.role = posid;
mem.isDel = 0;
db.member.Add(mem);
}
else
{
mem.name = name;
mem.role = posid;
db.member.Attach(mem);
var stateEntity = ((IObjectContextAdapter)db).ObjectContext.ObjectStateManager.GetObjectStateEntry(mem);
stateEntity.SetModifiedProperty("name");
stateEntity.SetModifiedProperty("role");
}
var delList = db.dd_emp_floor.Where(p => p.memberkey == memberkey && !floorList.Contains(p.floorid.Value)).ToList();
foreach (var item in delList)
{
db.dd_emp_floor.Attach(item);
db.dd_emp_floor.Remove(item);
}
foreach (int floorid in floorList)
{
dd_emp_floor fl = db.dd_emp_floor.Where(p => p.floorid == floorid && p.memberkey == memberkey).FirstOrDefault();
if (fl == null)
{
fl = new dd_emp_floor();
fl.floorid = floorid;
fl.memberkey = memberkey;
db.dd_emp_floor.Add(fl);
}
else
{
fl.floorid = floorid;
fl.memberkey = memberkey;
db.dd_emp_floor.Attach(fl);
var stateEntity = ((IObjectContextAdapter)db).ObjectContext.ObjectStateManager.GetObjectStateEntry(fl);
stateEntity.SetModifiedProperty("floorid");
stateEntity.SetModifiedProperty("memberkey");
}
}
db.SaveChanges();
}
catch (Exception e)
{
log.Error("SaveEmployee error. msg=" + e.Message);
throw;
}
}
//退单
/*
* paytype string 支付类型对应dd_shop_payway表id字段
* itemkey string 菜品id
* cfmealkey string 就餐订单key
* mainkey string 分单key
* num string 退菜数量
* guigeid string 退菜规格
* exc string 退菜理由
* excstr string 解决方案
*/
public void Tuicai(int paytype, int itemkey, int cfmealkey, int mainkey, int num, int guigeid, string exc, string excstr)
{
try
{
//本地业务
DianDianEntities db = new DianDianEntities();
remote_request rr = new remote_request();
rr.create_time = DateTime.Now;
rr.deal_flag = 0;
rr.request_type = "GET";
rr.request_url = ConfirmBillUrl;
rr.request_param = "m=tuicai&paytype=" + paytype;
rr.request_param += "&itemkey=" + itemkey;
rr.request_param += "&cfmealkey=" + cfmealkey;
rr.request_param += "&mainkey=" + mainkey;
rr.request_param += "&num=" + num;
rr.request_param += "&guigeid=" + guigeid;
rr.request_param += "&exc=" + exc;
rr.request_param += "&excstr=" + excstr;
db.remote_request.Add(rr);
db.SaveChanges();
}
catch (Exception e)
{
log.Error("Tuicai error. msg=" + e.Message);
throw;
}
}
//按支付方式分类统计
public RecordGroupTotleBean QueryRecordGroupByPayType(DateTime sdate, DateTime edate)
{
try
{
DianDianEntities db = new DianDianEntities();
List <v_cfmainaccount> recordList = db.v_cfmainaccount.Where(p => p.shopkey == Properties.Settings.Default.shopkey &&
p.createdate >= sdate && p.createdate <= edate).ToList();
var rslList = recordList.GroupBy(p => p.paytype);
RecordGroupTotleBean rslbean = new RecordGroupTotleBean();
rslbean.totleCount = recordList.Count();
rslbean.sumMoney = recordList.Sum(p => p.money - p.brokerage).Value;
rslbean.groupList = new List <RecordGroupBean>();
foreach (var rsl in rslList)
{
RecordGroupBean bean = new RecordGroupBean();
bean.keyName = (rsl.FirstOrDefault().payway);
bean.sumMoney = rsl.Sum(p => p.money - p.brokerage).Value;
bean.recList = rsl.ToList();
rslbean.groupList.Add(bean);
}
return(rslbean);
}
catch (Exception e)
{
log.Error("QueryRecordGroupByPayType error. msg=" + e.Message);
throw;
}
}
public void AddPrinter(string printername)
{
try
{
DianDianEntities db = new DianDianEntities();
dd_printers printer = QueryPrinters(2, printername).FirstOrDefault();
if (printer == null)
{
printer = new dd_printers();
printer.printername = printername;
printer.status = 0;
printer.shopid = Properties.Settings.Default.shopkey;
printer.pstatus = "0";
printer.psize = 58;
printer.pbites = 19200;
printer.isdefault = 0;
db.dd_printers.Add(printer);
db.SaveChanges();
}
else
{
printer.pstatus = "0";
db.dd_printers.Attach(printer);
var stateEntity = ((IObjectContextAdapter)db).ObjectContext.ObjectStateManager.GetObjectStateEntry(printer);
stateEntity.SetModifiedProperty("pstatus");;
db.SaveChanges();
}
}
catch (Exception e)
{
log.Error("AddPrinter error. msg=" + e.Message);
throw;
}
}
//16. 删除档口接口
public void Delwindow(int id)
{
try
{
DianDianEntities db = new DianDianEntities();
//本地业务
dd_shop_windows window = new dd_shop_windows();
window.windowid = id;
db.dd_shop_windows.Attach(window);
db.dd_shop_windows.Remove(window);
//异步通知服务器
remote_request rr = new remote_request();
rr.create_time = DateTime.Now;
rr.deal_flag = 0;
rr.request_type = "GET";
rr.request_url = WindowsUrl;
rr.request_param = "m=update&id=" + id;
db.remote_request.Add(rr);
db.SaveChanges();
}
catch (Exception e)
{
log.Error("Delwindow error. msg=" + e.Message);
throw;
}
}
public void setdprint(string dprinter)
{
try
{
DianDianEntities db = new DianDianEntities();
dd_user user = db.dd_user.Where(p => p.shopid == Properties.Settings.Default.shopkey).FirstOrDefault();
user.dprinter = dprinter;
db.dd_user.Attach(user);
var stateEntity = ((IObjectContextAdapter)db).ObjectContext.ObjectStateManager.GetObjectStateEntry(user);
stateEntity.SetModifiedProperty("dprinter");
db.Database.ExecuteSqlCommand("update dd_printers set isdefault=0");
var printer = db.dd_printers.Where(p => p.printername.Equals("dprinter")).FirstOrDefault();
printer.isdefault = 1;
db.dd_printers.Attach(printer);
var stateEntity2 = ((IObjectContextAdapter)db).ObjectContext.ObjectStateManager.GetObjectStateEntry(printer);
stateEntity2.SetModifiedProperty("isdefault");
db.SaveChanges();
}
catch (Exception e)
{
log.Error("setdprint error. msg=" + e.Message);
throw;
}
}
public void TaoCanFood(int itemkey)
{
try
{
DianDianEntities db = new DianDianEntities();
MyModels.selected_category_items.list.Clear();
var a = db.item_set.Where(p => p.itemkey == itemkey);
if (a.Count() > 0)
{
foreach (var b in a)
{
insert_selected_category_items_list(b.itemnum.Value, b.tcItemKey.Value, b.guigeid.Value);
}
}
else
{
var c = db.item_set.Where(p => p.tcItemKey == itemkey);
foreach (var b in c)
{
insert_selected_category_items_list(b.itemnum.Value, b.itemkey.Value, b.guigeid.Value);
}
}
}
catch (Exception e)
{
log.Error("TaoCanFoodID error. msg=" + e.Message);
throw;
}
}
public void AddActivity(string cname, DateTime sdate, DateTime edate, string istogether, string memtogether, int isonlineok, int ifmoney, int okjian, string extendway, decimal minmoney)
{
try
{
DianDianEntities db = new DianDianEntities();
dd_coupons activity = new dd_coupons
{
addtime = DateTime.Now.ToString("yyyy-MM-dd HH::ss:mm"),
cname = cname,
sdate = sdate.ToString("yyyy-MM-dd"),
edate = edate.ToString("yyyy-MM-dd"),
shopid = Properties.Settings.Default.shopkey,
istogether = istogether,
memtogether = memtogether,
isonlineok = isonlineok,
ifmoney = ifmoney,
okjian = okjian,
extendway = extendway,
minmoney = minmoney
};
db.dd_coupons.Add(activity);
db.SaveChanges();
}
catch (Exception e)
{
log.Error("AddActivity error. msg=" + e.Message);
throw;
}
}
private void SyncWindowsInfo()
{
try
{
var json = "";
DianDianEntities db = new DianDianEntities();
RestClient client = new RestClient();
client.ContentType = "application/json";
client.Method = HttpVerb.POST;
List <dd_shop_windows> request = new List <dd_shop_windows>();
int shopkey = Properties.Settings.Default.shopkey;
request = db.dd_shop_windows.Where(p => p.shopid == shopkey && p.syncFlag == 1).ToList();
client.EndPoint = SysConstant.BASE_URI + SysConstant.SYNC_ITEM_URL + MyModels.userinfo.user.token;
JsonSerializerSettings settings = new JsonSerializerSettings();
settings.ReferenceLoopHandling = ReferenceLoopHandling.Ignore;
client.PostData = JsonConvert.SerializeObject(request, settings);
log.Debug(client.PostData);
json = client.MakeRequest();
log.Debug(json.ToString());
var res = JsonConvert.DeserializeObject <Models.CommonResponseBean>(json);
if (res.code == 100)
{
//db.ClearTablePosSync
}
}
catch (Exception e)
{
log.Error("Login SyncWindowsInfo, msg = " + e.Message);
throw;
}
}
//查询交易流水
public List <v_cfmainaccount> QueryShopAccount(int paytype, string type, int state, string billNo, int tableNo, DateTime sdate, DateTime edate)
{
try
{
DianDianEntities db = new DianDianEntities();
var rslList = db.v_cfmainaccount.Where(p => p.shopkey == Properties.Settings.Default.shopkey &&
p.createdate >= sdate && p.createdate <= edate);
if (!billNo.Equals(""))
{
rslList = rslList.Where(p => p.type.Equals(billNo));
}
if (paytype != 0)
{
rslList = rslList.Where(p => p.paytype == paytype);
}
if (state != 0)
{
rslList = rslList.Where(p => p.state == state);
}
if (!type.Equals(""))
{
rslList = rslList.Where(p => p.type.Equals(type));
}
if (tableNo != 0)
{
rslList = rslList.Where(p => p.tableNo == tableNo);
}
return(rslList.ToList());
}
catch (Exception e)
{
log.Error("QueryShopAccount error. msg=" + e.Message);
throw;
}
}
//转台
public void ChangeTable(int tableposkey, int newtableno)
{
try
{
DianDianEntities db = new DianDianEntities();
//本地业务
//异步通知服务器
remote_request rr = new remote_request();
rr.create_time = DateTime.Now;
rr.deal_flag = 0;
rr.request_type = "GET";
rr.request_url = ConfirmBillUrl;
rr.request_param = "m=clearTable&tableposkey=" + tableposkey;
rr.request_param += "&newtableno=" + newtableno;
db.remote_request.Add(rr);
db.SaveChanges();
}
catch (Exception e)
{
log.Error("ChangeTable error. msg=" + e.Message);
throw;
}
}
public void EditSignUser(int signuserId, string name, string tel, int maxusernums, decimal maxprice)
{
try
{
DianDianEntities db = new DianDianEntities();
var user = db.dd_shop_signusers.Find(signuserId);
user.maxprice = maxprice;
user.maxusenums = maxusernums;
user.name = name;
user.telno = tel;
db.dd_shop_signusers.Attach(user);
var stateEntity = ((IObjectContextAdapter)db).ObjectContext.ObjectStateManager.GetObjectStateEntry(user);
stateEntity.SetModifiedProperty("maxprice");
stateEntity.SetModifiedProperty("maxusenums");
stateEntity.SetModifiedProperty("name");
stateEntity.SetModifiedProperty("telno");
db.SaveChanges();
}
catch (Exception e)
{
log.Error("EditSignUser error. msg=" + e.Message);
throw;
}
}
//11. 餐桌订单优惠接口
public void Saveyouhui(double youhui, int cfmainkey)
{
try
{
//本地业务
DianDianEntities db = new DianDianEntities();
//异步通知服务器
remote_request rr = new remote_request();
rr.create_time = DateTime.Now;
rr.deal_flag = 0;
rr.request_type = "GET";
rr.request_url = ConfirmBillUrl;
rr.request_param = "m=Saveyouhui&youhui=" + youhui;
rr.request_param += "&cfmainkey=" + cfmainkey;
db.remote_request.Add(rr);
db.SaveChanges();
}
catch (Exception e)
{
log.Error("Saveyouhui error. msg=" + e.Message);
throw;
}
}
public List <dd_shop_signusers> QuerySignUser(string name, string tel, DateTime?sdate, DateTime?edate)
{
try
{
DianDianEntities db = new DianDianEntities();
var userList = db.dd_shop_signusers.Where(p => p.shopkey == Properties.Settings.Default.shopkey);
if (!name.Equals(""))
{
userList = userList.Where(p => p.name.Contains(name));
}
if (!tel.Equals(""))
{
userList = userList.Where(p => p.telno.Contains(tel));
}
if (sdate != null)
{
userList = userList.Where(p => p.addtime >= sdate.Value);
}
if (edate != null)
{
userList = userList.Where(p => p.addtime <= edate.Value);
}
return(userList.ToList());
}
catch (Exception e)
{
log.Error("QuerySignUser error. msg=" + e.Message);
throw;
}
}
public void AddSignUser(string name, string tel, int maxusernums, decimal maxprice)
{
try
{
DianDianEntities db = new DianDianEntities();
dd_shop_signusers user = new dd_shop_signusers
{
addtime = DateTime.Now,
maxprice = maxprice,
maxusenums = maxusernums,
name = name,
shopkey = Properties.Settings.Default.shopkey,
signmoney = 0,
signnums = 0,
state = 1,
telno = tel
};
db.dd_shop_signusers.Add(user);
db.SaveChanges();
}
catch (Exception e)
{
log.Error("AddSignUser error. msg=" + e.Message);
throw;
}
}
public List <dd_mem_card> QueryMembers(string name, string tel, DateTime?sdate, DateTime?edate)
{
try
{
DianDianEntities db = new DianDianEntities();
var cardList = db.dd_mem_card.Where(p => p.shopkey == Properties.Settings.Default.shopkey);
if (!name.Equals(""))
{
cardList = cardList.Where(p => p.realname.Contains(name));
}
if (!tel.Equals(""))
{
cardList = cardList.Where(p => p.telno.Contains(tel));
}
DateTime startTime = TimeZone.CurrentTimeZone.ToLocalTime(new DateTime(1970, 1, 1));
if (sdate != null)
{
long timeStamp = (long)(sdate.Value - startTime).TotalSeconds;
cardList = cardList.Where(p => p.addtime >= timeStamp);
}
if (edate != null)
{
long timeStamp = (long)(edate.Value - startTime).TotalSeconds;
cardList = cardList.Where(p => p.addtime <= timeStamp);
}
return(cardList.ToList());
}
catch (Exception e)
{
log.Error("QueryMembers error. msg=" + e.Message);
throw;
}
}
public void EditMemberRule(int roleId, string title, int money, int songmoney)
{
try
{
DianDianEntities db = new DianDianEntities();
var rule = db.dd_chargecar_rule.Find(roleId);
rule.money = money + songmoney;
rule.realmoney = money;
rule.rname = title;
rule.userid = BizLoginController.userid;
db.dd_chargecar_rule.Attach(rule);
var stateEntity = ((IObjectContextAdapter)db).ObjectContext.ObjectStateManager.GetObjectStateEntry(rule);
stateEntity.SetModifiedProperty("money");
stateEntity.SetModifiedProperty("realmoney");
stateEntity.SetModifiedProperty("rname");
stateEntity.SetModifiedProperty("userid");
db.SaveChanges();
}
catch (Exception e)
{
log.Error("EditMemberRule error. msg=" + e.Message);
throw;
}
}
//13. 下单接口
public void SubmitBill(int peopleNum, string remark, string scTime, int signid, int cardid, string str, int tableposkey, string customRemark)
{
//本地业务
try
{
DianDianEntities db = new DianDianEntities();
//异步通知服务器
remote_request rr = new remote_request();
rr.create_time = DateTime.Now;
rr.deal_flag = 0;
rr.request_type = "GET";
rr.request_url = ConfirmBillUrl;
rr.request_param = "m=submitBill&peopleNum=" + peopleNum;
rr.request_param += "&remark=" + remark;
rr.request_param += "&scTime=" + scTime;
rr.request_param += "&signid=" + signid;
rr.request_param += "&cardid=" + cardid;
rr.request_param += "&str=" + str;
rr.request_param += "&tableposkey=" + tableposkey;
rr.request_param += "&customRemark=" + customRemark;
db.remote_request.Add(rr);
db.SaveChanges();
}catch (Exception e)
{
log.Error("SubmitBill error. msg=" + e.Message);
throw;
}
}
public List <v_card_record_shop> QueryCardUseRecord(int cardId, int type, DateTime?sdate, DateTime?edate)
{
try
{
DianDianEntities db = new DianDianEntities();
var recList = db.v_card_record_shop
.Where(p => p.cardid == cardId);
if (type == 1 || type == 0)
{
recList = recList.Where(p => p.type == type);
}
if (sdate != null)
{
recList = recList.Where(p => p.addtime >= sdate);
}
if (edate != null)
{
recList = recList.Where(p => p.addtime <= edate);
}
recList = recList.OrderByDescending(p => p.addtime);
return(recList.ToList());
}
catch (Exception e)
{
log.Error("QueryCardUseRecord error. msg=" + e.Message);
throw;
}
}
//12. 买单接口
public void Maidan(int payway, int cardid, int tableposkey, int isClear, double amount, double realPay)
{
try
{
//本地业务
DianDianEntities db = new DianDianEntities();
//异步通知服务器
remote_request rr = new remote_request();
rr.create_time = DateTime.Now;
rr.deal_flag = 0;
rr.request_type = "GET";
rr.request_url = ConfirmBillUrl;
rr.request_param = "m=Maidan&payway=" + payway;
rr.request_param += "&cardid=" + cardid;
rr.request_param += "&tableposkey=" + tableposkey;
rr.request_param += "&isClear=" + isClear;
rr.request_param += "&amount=" + amount;
rr.request_param += "&realPay=" + realPay;
db.remote_request.Add(rr);
db.SaveChanges();
}
catch (Exception e)
{
log.Error("Maidan error. msg=" + e.Message);
throw;
}
}
//添加入库详情
public void AddDepotInInfo(int depotinid, int genreid, int crudeid, decimal cost, int num, DateTime?validity, DateTime?productiondate,
DateTime?backdate, String maker, string remarks, string supplier)
{
try
{
DianDianEntities db = new DianDianEntities();
storage_depotin_info deportininfo = new storage_depotin_info();
deportininfo.depotinid = depotinid;
deportininfo.crudeid = crudeid;
deportininfo.cost = cost;
deportininfo.num = num;
deportininfo.validity = validity;
deportininfo.productiondate = productiondate;
deportininfo.backdate = backdate;
deportininfo.maker = maker;
deportininfo.remarks = remarks;
deportininfo.supplier = supplier;
db.storage_depotin_info.Add(deportininfo);
db.SaveChanges();
}
catch (Exception e)
{
log.Error("AddDepotInInfo error. msg=" + e.Message);
throw;
}
}
//10. 菜品打折接口
public void Dazhe(double price, int cfdetailkey, int cfmainkey)
{
try
{
//本地业务
DianDianEntities db = new DianDianEntities();
//异步通知服务器
remote_request rr = new remote_request();
rr.create_time = DateTime.Now;
rr.deal_flag = 0;
rr.request_type = "GET";
rr.request_url = GetBillRequestUrl;
rr.request_param = "m=dazhe&price=" + price;
rr.request_param += "&cfdetailkey=" + cfdetailkey;
rr.request_param += "&cfmainkey=" + cfmainkey;
db.remote_request.Add(rr);
db.SaveChanges();
}
catch (Exception e)
{
log.Error("Dazhe error. msg=" + e.Message);
throw;
}
}
//修改分类
public void EditItemCategory(int itemCategoryKey, string categoryName, string code, int orderNo, int enable)
{
try
{
DianDianEntities db = new DianDianEntities();
item_category ic = db.item_category.Find(itemCategoryKey);
ic.name = categoryName;
ic.itemCategoryCode = code;
ic.orderNo = orderNo;
ic.enable = enable;
ic.syncFlag = 1;
db.item_category.Attach(ic);
var stateEntity = ((IObjectContextAdapter)db).ObjectContext.ObjectStateManager.GetObjectStateEntry(ic);
stateEntity.SetModifiedProperty("name");
stateEntity.SetModifiedProperty("itemCategoryCode");
stateEntity.SetModifiedProperty("orderNo");
stateEntity.SetModifiedProperty("enable");
stateEntity.SetModifiedProperty("syncFlag");
db.SaveChanges();
}
catch (Exception e)
{
log.Error("EditItemCategory error. msg=" + e.Message);
throw;
}
}
//订单管理 134
//餐桌管理 137
//桌位结算 159
//菜品管理 133
//营业详情 144
//商户设置 147
//员工管理 148
//会员管理 150
public void SavePosition(int posId, string posName, List <int> rightList)
{
try
{
DianDianEntities db = new DianDianEntities();
var pos = db.sys_role.Find(posId);
if (pos == null)
{
pos = new sys_role();
pos.rolename = posName;
pos.createtime = DateTime.Now.ToString();
pos.isdel = "0";
pos.state = "1";
pos.shopkey = Properties.Settings.Default.shopkey;
db.sys_role.Add(pos);
}
else
{
pos.rolename = posName;
db.sys_role.Attach(pos);
var stateEntity = ((IObjectContextAdapter)db).ObjectContext.ObjectStateManager.GetObjectStateEntry(pos);
stateEntity.SetModifiedProperty("rolename");
}
var delList = db.sys_right.Where(p => p.sysroleid == pos.sysroleid & !rightList.Contains(p.menuid.Value)).ToList();
foreach (var item in delList)
{
db.sys_right.Attach(item);
db.sys_right.Remove(item);
}
db.SaveChanges();
foreach (int menuId in rightList)
{
var item = db.sys_right.Where(p => p.menuid == menuId && p.sysroleid == pos.sysroleid).FirstOrDefault();
if (item == null)
{
item = new sys_right();
item.menuid = menuId;
item.sysroleid = Convert.ToInt32(pos.sysroleid);
item.userid = 1000;
item.type = "menu1";
item.optime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
db.sys_right.Add(item);
}
}
db.SaveChanges();
}
catch (Exception e)
{
log.Error("SavePosition error. msg=" + e.Message);
throw;
}
}
//入库
public List <v_depotin_crude> QueryDepotIn(string itemname, DateTime validate, DateTime sdate, DateTime edate, string dutyperson, string deliveryman, string categoryname)
{
try
{
bool includeItem = false;
DianDianEntities db = new DianDianEntities();
var itemList = db.v_category_items.Where(p => p.shopkey == Properties.Settings.Default.shopkey);
if (!itemname.Equals(""))
{
itemList = itemList.Where(p => p.itemName.Contains(itemname));
includeItem = true;
}
if (!categoryname.Equals(""))
{
itemList = itemList.Where(p => p.categoryName.Contains(categoryname));
includeItem = true;
}
var itemcrudeList = itemList.Select(p => p.itemkey).Distinct().ToList();
var includeCrudeList = db.v_item_crude.Where(p => itemcrudeList.Contains(p.itemkey)).Select(p => p.crudeid).ToList();
var depotInList = db.v_depotin_crude.Where(p => p.shopkey == Properties.Settings.Default.shopkey);
if (validate != null)
{
depotInList = depotInList.Where(p => p.validity <= validate);
}
if (sdate != null)
{
depotInList = depotInList.Where(p => p.productiondate >= sdate);
}
if (edate != null)
{
depotInList = depotInList.Where(p => p.productiondate <= edate);
}
if (!dutyperson.Equals(""))
{
depotInList = depotInList.Where(p => p.dutyperson.Contains(dutyperson));
}
if (!deliveryman.Equals(""))
{
depotInList = depotInList.Where(p => p.deliveryman.Contains(deliveryman));
}
if (includeItem)
{
depotInList = depotInList.Where(p => includeCrudeList.Contains(p.crudeid));
}
return(depotInList.ToList());
}
catch (Exception e)
{
log.Error("QueryDepotIn error. msg=" + e.Message);
throw;
}
}
//15. 添加修改档口
public void UpdateStall(int id, string name, string desc, string printname, int printnum, bool isdefault, int status, bool isprintexcep, bool isyicaiyidan)
{
try
{
DianDianEntities db = new DianDianEntities();
//本地业务
dd_shop_windows window = db.dd_shop_windows.FirstOrDefault(p => p.windowid == id);
if (window == null)
{
window = new dd_shop_windows();
window.shopid = Properties.Settings.Default.shopkey;
window.windowname = name;
window.windowdesc = desc;
window.printname = printname;
window.printnum = printnum;
window.isdefault = isdefault;
window.status = status;
window.isyicaiyidan = isyicaiyidan;
window.isprintexcep = isprintexcep;
db.dd_shop_windows.Add(window);
}
else
{
window.shopid = Properties.Settings.Default.shopkey;
window.windowname = name;
window.windowdesc = desc;
window.printname = printname;
window.printnum = printnum;
window.isdefault = isdefault;
window.status = status;
window.isyicaiyidan = isyicaiyidan;
window.isprintexcep = isprintexcep;
db.dd_shop_windows.Attach(window);
var stateEntity = ((IObjectContextAdapter)db).ObjectContext.ObjectStateManager.GetObjectStateEntry(window);
stateEntity.SetModifiedProperty("shopid");
stateEntity.SetModifiedProperty("windowname");
stateEntity.SetModifiedProperty("windowdesc");
stateEntity.SetModifiedProperty("printname");
stateEntity.SetModifiedProperty("printnum");
stateEntity.SetModifiedProperty("isdefault");
stateEntity.SetModifiedProperty("status");
stateEntity.SetModifiedProperty("isyicaiyidan");
stateEntity.SetModifiedProperty("isprintexcep");
}
db.SaveChanges();
}
catch (Exception e)
{
log.Error("UpdateStall error. msg=" + e.Message);
throw;
}
}
//菜品分类
public List <item_category> GetFoodFL()
{
try
{
DianDianEntities db = new DianDianEntities();
return(db.item_category.Where(p => p.shopkey == Properties.Settings.Default.shopkey && p.isDel == 0).ToList());
}
catch (Exception e)
{
log.Error("GetFoodFL error. msg=" + e.Message);
throw;
}
}
