public bool UpdateLastTime(int userId)
{
var strSql = new StringBuilder();
strSql.Append("update T_Users set ");
strSql.Append("LastTime=NowTime,");
strSql.Append("NowTime=@NowTime");
strSql.Append(" where UserId=@UserId");
SqlParameter[] parameters =
{
new SqlParameter("@NowTime", SqlDbType.DateTime),
new SqlParameter("@UserId", SqlDbType.Int, 4)
};
parameters[0].Value = DateTime.Now;
parameters[1].Value = userId;
var rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool UpdateStatus(int userId, byte status)
{
var strSql = new StringBuilder();
strSql.Append("update T_Users set ");
strSql.Append("Status=@Status");
strSql.Append(" where UserId=@UserId");
SqlParameter[] parameters =
{
new SqlParameter("@Status", SqlDbType.TinyInt, 1),
new SqlParameter("@UserId", SqlDbType.Int, 4)
};
parameters[0].Value = status;
parameters[1].Value = userId;
var rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更改用户密码
/// </summary>
/// <param name="userId">用户ID</param>
/// <param name="pwd">新密码</param>
/// <returns></returns>
public bool ChangePassword(int userId, string pwd)
{
var strSql = new StringBuilder();
strSql.Append("update T_Users set ");
strSql.Append("Pwd=@Pwd");
strSql.Append(" where UserId=@UserId");
SqlParameter[] parameters =
{
new SqlParameter("@UserId", SqlDbType.Int, 4),
new SqlParameter("@Pwd", SqlDbType.NVarChar, 32)
};
parameters[0].Value = userId;
parameters[1].Value = pwd;
if (DbHelperSql.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.Users model)
{
var strSql = new StringBuilder();
strSql.Append("update T_Users set ");
strSql.Append("UserName=@UserName,");
strSql.Append("Pwd=@Pwd,");
strSql.Append("Mobile=@Mobile,");
strSql.Append("Email=@Email,");
strSql.Append("Status=@Status,");
strSql.Append("RegTime=@RegTime,");
strSql.Append("RoleId=@RoleId,");
strSql.Append("LastTime=@LastTime,");
strSql.Append("NowTime=@NowTime,");
strSql.Append("ReMark=@ReMark");
strSql.Append(" where UserId=@UserId");
SqlParameter[] parameters =
{
new SqlParameter("@UserName", SqlDbType.NVarChar, 50),
new SqlParameter("@Pwd", SqlDbType.NVarChar, 32),
new SqlParameter("@Mobile", SqlDbType.NVarChar, 20),
new SqlParameter("@Email", SqlDbType.NVarChar, 128),
new SqlParameter("@Status", SqlDbType.TinyInt, 1),
new SqlParameter("@RegTime", SqlDbType.DateTime),
new SqlParameter("@RoleId", SqlDbType.Int, 4),
new SqlParameter("@LastTime", SqlDbType.DateTime),
new SqlParameter("@NowTime", SqlDbType.DateTime),
new SqlParameter("@ReMark", SqlDbType.NVarChar, 50),
new SqlParameter("@UserId", SqlDbType.Int, 4)
};
parameters[0].Value = model.UserName;
parameters[1].Value = model.Pwd;
parameters[2].Value = model.Mobile;
parameters[3].Value = model.Email;
parameters[4].Value = model.Status;
parameters[5].Value = model.RegTime;
parameters[6].Value = model.RoleId;
parameters[7].Value = model.LastTime;
parameters[8].Value = model.NowTime;
parameters[9].Value = model.ReMark;
parameters[10].Value = model.UserId;
var rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 批量删除数据
/// </summary>
public bool DeleteList(string idlist)
{
var strSql = new StringBuilder();
strSql.Append("delete from T_ESHour ");
strSql.Append(" where Id in (" + idlist + ") ");
var rows = DbHelperSql.ExecuteSql(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(int userId)
{
var strSql = new StringBuilder();
strSql.Append("delete from T_Users ");
strSql.Append(" where UserId=@UserId");
SqlParameter[] parameters =
{
new SqlParameter("@UserId", SqlDbType.Int, 4)
};
parameters[0].Value = userId;
var rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}