public int AddLoginLog()
{
using (var db = new BaseDBContent())
{
try
{
this.db2 = db;
SysLoginLogInfor sysLogin = new SysLoginLogInfor();
sysLogin.id = Guid.NewGuid().ToString("N");
sysLogin.userId = 100;
sysLogin.userName = "******";
sysLogin.loginIp = "192.168.1.25";
sysLogin.loginCity = "青岛";
sysLogin.loginTime = DateTime.Now;
sysLogin.delFlag = 0;
return(this.Add2 <SysLoginLogInfor>(sysLogin));
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("------------------------------------------------");
System.Diagnostics.Debug.WriteLine("登录日志插入错误：" + ex);
System.Diagnostics.Debug.WriteLine("------------------------------------------------");
return(0);
}
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Modify <T>(T model) where T : class, new()
{
using (var db = new BaseDBContent())
{
db.Entry(model).State = EntityState.Modified;
return(db.SaveChanges());
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Del <T>(T model) where T : class, new()
{
using (var db = new BaseDBContent())
{
db.Set <T>().Attach(model);
db.Set <T>().Remove(model);
return(db.SaveChanges());
}
}
/// <summary>
/// 增加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add <T>(T model) where T : class, new()
{
using (var db = new BaseDBContent())
{
DbSet <T> dst = db.Set <T>();
dst.Add(model);
return(db.SaveChanges());
}
}
public int ModiyLoginLog()
{
using (var db = new BaseDBContent())
{
db2 = db;
var data = this.Entities <SysLoginLogInfor>().ToList();
SysLoginLogInfor sysLogin = data.Where(u => u.id == "001").FirstOrDefault();
sysLogin.userName = "******";
return(this.Modify <SysLoginLogInfor>(sysLogin));
}
}
/**************************----泛型方法实现基础方法封装----*************************************/
#region 查询
public IQueryable <T> Entities <T>() where T : class, new()
{
var db = new BaseDBContent();
return(db.Set <T>());
}
