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