/// <summary>
/// 更新一条数据
/// </summary>
public int Update(ADT.XingZhi.Models.S.LoginTimes model)
{
try
{
SqlParameter[] param =
{
new SqlParameter("@userName", SqlDbType.VarChar, 20),
new SqlParameter("@ip", SqlDbType.VarChar, 20),
new SqlParameter("@isAdmin", SqlDbType.Bit)
};
param[0].Value = model.UserName;
param[1].Value = model.IP;
param[2].Value = model.IsAdmin;
return(SqlHelper.ExecuteNonQuery(DefaultConnection.ConnectionStringByDefaultDB, CommandType.Text, "UPDATE [S_LOGINTIMES] SET LT_IP=@ip,LT_LOGINTIME=GETDATE(),LT_TIMES=LT_TIMES+1 WHERE U_NAME=@userName AND LT_ISADMIN=@isAdmin", param));
}
catch (ArgumentNullException ex)
{
logger.Error("调用方法Update(ADT.XingZhi.Models.S.LoginTimes model)发生ArgumentNullException", ex);
}
catch (SqlException ex)
{
logger.Error("调用方法Update(ADT.XingZhi.Models.S.LoginTimes model)发生SqlException", ex);
}
catch (Exception ex)
{
logger.Error("调用方法Update(ADT.XingZhi.Models.S.LoginTimes model)发生Exception", ex);
}
return(-1);
}
/// <summary>
/// 新增一条数据
/// </summary>
public int Add(ADT.XingZhi.Models.S.LoginTimes model)
{
try
{
SqlParameter[] param =
{
new SqlParameter("@userName", SqlDbType.VarChar, 20),
new SqlParameter("@ip", SqlDbType.VarChar, 20),
new SqlParameter("@isAdmin", SqlDbType.Bit)
};
param[0].Value = model.UserName;
param[1].Value = model.IP;
param[2].Value = model.IsAdmin;
return(SqlHelper.ExecuteNonQuery(DefaultConnection.ConnectionStringByDefaultDB, CommandType.Text, "INSERT INTO [S_LOGINTIMES](U_NAME,LT_IP,LT_LOGINTIME,LT_ISADMIN,LT_TIMES) VALUES(@userName,@ip,GETDATE(),@isAdmin,1)", param));
return(Convert.ToInt32(param[6].Value));
}
catch (ArgumentNullException ex)
{
logger.Error("调用方法Add(ADT.XingZhi.Models.S.LoginTimes model)发生ArgumentNullException", ex);
}
catch (SqlException ex)
{
logger.Error("调用方法Add(ADT.XingZhi.Models.S.LoginTimes model)发生SqlException", ex);
}
catch (Exception ex)
{
logger.Error("调用方法Add(ADT.XingZhi.Models.S.LoginTimes model)发生Exception", ex);
}
return(-1);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(ADT.XingZhi.Models.S.LoginTimes model)
{
return(dal.Update(model));
}
/// <summary>
/// 新增一条数据
/// </summary>
public int Add(ADT.XingZhi.Models.S.LoginTimes model)
{
return(dal.Add(model));
}
