/// <summary>
/// 保存session，若存在则更新session
/// </summary>
/// <param name="model"></param>
public static void SaveSessionInfo(LoginSessionInfoModel model)
{
if (model.IsNull())
{
return;
}
StringBuilder builder = new StringBuilder();
builder.Append("update LoginSessinInfo set DeviceNo=@DeviceNo, LashRefresh = @LashRefresh,Status=1 where SessinId=@SessinId");
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter()
{
ParameterName = "@SessinId", Value = model.SessinId
},
new SqlParameter()
{
ParameterName = "@DeviceNo", Value = model.DeviceNo
},
new SqlParameter()
{
ParameterName = "@LashRefresh", Value = model.LashRefresh
}
};
int rowCount = helper.ExecuteNonQuery(builder.ToString(), parameters);
if (rowCount == 0)//影响行数
{
helper.AddSession(model);
}
}
internal void AddSession(LoginSessionInfoModel model)
{
if (model.IsNull())
{
return;
}
StringBuilder builder = new StringBuilder();
builder.Append("insert into LoginSessinInfo (SessinId,DeviceNo,LoginTime,LashRefresh,Expired,Status) values(@SessinId,@DeviceNo,@LoginTime,@LashRefresh,@Expired,@Status)");
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter()
{
ParameterName = "@SessinId", Value = model.SessinId
},
new SqlParameter()
{
ParameterName = "@DeviceNo", Value = model.DeviceNo
},
new SqlParameter()
{
ParameterName = "@LoginTime", Value = model.LoginTime
},
new SqlParameter()
{
ParameterName = "@LashRefresh", Value = model.LashRefresh
},
new SqlParameter()
{
ParameterName = "@Expired", Value = model.Expired
},
new SqlParameter()
{
ParameterName = "@Status", Value = model.Status
}
};
ExecuteNonQuery(builder.ToString(), parameters);
}
