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 setdcomm(string dcomm) { try { DianDianEntities db = new DianDianEntities(); dd_user user = db.dd_user.Where(p => p.shopid == Properties.Settings.Default.shopkey).FirstOrDefault(); user.dcomm = dcomm; db.dd_user.Attach(user); var stateEntity = ((IObjectContextAdapter)db).ObjectContext.ObjectStateManager.GetObjectStateEntry(user); stateEntity.SetModifiedProperty("dcomm"); db.SaveChanges(); } catch (Exception e) { log.Error("setdcomm error. msg=" + e.Message); throw; } }
//本地登录 public int LocalLogin(String username, String password) { DianDianEntities db = new DianDianEntities(); string result = ""; List <member> rsl = db.member.Where(t => t.loginName.Equals(username) && t.pwd.Equals(password) && t.shopkey == Properties.Settings.Default.shopkey && t.enable == 1).ToList(); if (rsl.Count > 0) { int shopkey = rsl.First().shopkey.Value; dd_user user = db.dd_user.Where(p => p.shopid == shopkey).FirstOrDefault(); if (user == null) { //本地登录逻辑 user = new dd_user(); user.userid = rsl.First().memberkey; user.username = rsl.First().name; user.shopid = shopkey; db.dd_user.Add(user); } else { user.userid = rsl.First().memberkey; user.username = rsl.First().name; db.dd_user.Attach(user); var stateEntity = ((IObjectContextAdapter)db).ObjectContext.ObjectStateManager.GetObjectStateEntry(user); stateEntity.SetModifiedProperty("userid"); stateEntity.SetModifiedProperty("username"); } db.SaveChanges(); MyModels.userinfo.user.uid = rsl.First().memberkey; MyModels.userinfo.user.uname = rsl.First().name; MyModels.userinfo.user.token = "1507700568237"; return(0); } return(-1); }
public void setAutoConfrim(int status) { try { DianDianEntities db = new DianDianEntities(); dd_user user = db.dd_user.Where(p => p.shopid == Properties.Settings.Default.shopkey).FirstOrDefault(); if (user != null) { user.autoconfirm = status; db.dd_user.Attach(user); var stateEntity = ((IObjectContextAdapter)db).ObjectContext.ObjectStateManager.GetObjectStateEntry(user); stateEntity.SetModifiedProperty("autoconfirm"); db.SaveChanges(); } //db.Database.ExecuteSqlCommand("update dd_user set autoconfirm="+status+" where shopid="+ Properties.Settings.Default.shopkey); } catch (Exception e) { log.Error("setAutoConfrim error. msg=" + e.Message); throw; } }