public static bool InsertOutDate(OutDate model)
{
using (LazlwEntities entities = new LazlwEntities())
{
entities.OutDates.Add(model);
return entities.SaveChanges() > 0;
}
}
public static Person GetLoginPerson(string perUser, string perPwd)
{
using (LazlwEntities entities = new LazlwEntities())
{
var entity = entities.People.FirstOrDefault(t => t.PerUser == perUser && t.PerPwd == perPwd);
if(entity!=null){
entity.PerUTime=DateTime.Now;
entities.SaveChanges();
}
return entity;
}
}
public static void DelPersonAll(int perId)
{
using (LazlwEntities entities = new LazlwEntities())
{
var depEntity=entities.DepDates.Where(t => t.DepPerId == perId);
entities.DepDates.RemoveRange(depEntity);
var outEntity = entities.OutDates.Where(t => t.OutPerId == perId);
entities.OutDates.RemoveRange(outEntity);
var entity = entities.People.FirstOrDefault(t => t.PerId == perId);
if (entity != null)
{
entities.People.Remove(entity);
}
entities.SaveChanges();
}
}
public static bool UpdateSysAdminAdId(int adId, string adPwd,string newAdPwd,out string msg)
{
using (LazlwEntities entities = new LazlwEntities())
{
var model = entities.SysAdminZlwGls.FirstOrDefault(t => t.AdId == adId && t.AdPwd == adPwd);
if (model == null)
{
msg = "原密码有误请重试";
return false;
}
if (model.AdUser.Equals(newAdPwd.ToLower()))
{
msg = "用户名和新密码不能相同";
return false;
}
model.AdPwd = newAdPwd;
msg = "密码修改成功";
return entities.SaveChanges() > 0;
}
}
public static bool UpdatePersonAudit(int perId, byte perAudit)
{
using (LazlwEntities entities = new LazlwEntities())
{
var oldentity = entities.People.FirstOrDefault(t => t.PerId == perId);
if (oldentity == null)
{
return false;
}
oldentity.PerAudit = perAudit;
return entities.SaveChanges() > 0;
}
}
public static bool UpdatePerson(Person model)
{
using (LazlwEntities entities = new LazlwEntities())
{
var oldentity = entities.People.FirstOrDefault(t => t.PerId == model.PerId);
if (oldentity == null)
{
return false;
}
oldentity.PerComp=model.PerComp;
oldentity.PerType = model.PerType;
oldentity.PerName=model.PerName;
oldentity.PerTel=model.PerTel;
oldentity.PerMail=model.PerMail;
oldentity.PerAddr=model.PerAddr;
oldentity.PerLimit = model.PerLimit;
oldentity.PerGfdj = model.PerGfdj;
oldentity.PerLsmj = model.PerLsmj;
oldentity.PerXntd = model.PerXntd;
oldentity.PerZqc = model.PerZqc;
oldentity.PerCdc = model.PerCdc;
if (!string.IsNullOrEmpty(model.PerUser))
{
oldentity.PerUser = model.PerUser;
}
if (!string.IsNullOrEmpty(model.PerPwd))
{
oldentity.PerPwd = model.PerPwd;
}
return entities.SaveChanges() > 0;
}
}
public static bool UpdatePerPwd(string oldPerPwd, string newPerPwd, int perId,out string msg)
{
msg="修改密码成功";
var entities = new LazlwEntities();
var model= entities.People.FirstOrDefault(t => t.PerId == perId);
if (model == null)
{
msg = "修改密码失败";
return false;
}
if (model.PerPwd != oldPerPwd)
{
msg = "旧密码输入错误";
return false;
}
model.PerPwd = newPerPwd;
if (entities.SaveChanges() > 0)
{
return true;
}
return false;
}
public static bool InsertPerson(Person model,out string msg)
{
using (LazlwEntities entities = new LazlwEntities())
{
msg = "用户注册成功";
var entity = entities.People.FirstOrDefault(t => t.PerUser == model.PerUser);
if (entity != null)
{
msg="用户已经存在";
return false;
}
entities.People.Add(model);
return entities.SaveChanges() > 0;
}
}
public static bool UpdateOutDate(OutDate model, OutDate oldModel)
{
using (LazlwEntities entities = new LazlwEntities())
{
entities.OutDates.Attach(oldModel);
ClassValueCopier.Copy(oldModel, model);
return entities.SaveChanges() > 0;
}
}