/// <summary>
/// 修改用户名称
/// </summary>
/// <returns></returns>
public bool UpdatePassWord(TF.RunSafty.Entry.Users model)
{
string strSql = @"update Tab_User set passWord=@passWord where Id=@id";
SqlParameter[] sqlParameter =
{
new SqlParameter("id", model.id),
new SqlParameter("@passWord", model.passWord)
};
return(SqlHelps.ExecuteNonQuery(ConnectionString, CommandType.Text, strSql, sqlParameter) > 0);
}
/// <summary>
/// 修改用户名称
/// </summary>
/// <returns></returns>
public bool Update(TF.RunSafty.Entry.Users model)
{
string strSql = @"update Tab_User set userNumber=@userNumber,userName=@userName,roseId=@roseId where Id=@id";
SqlParameter[] sqlParameter =
{
new SqlParameter("id", model.id),
new SqlParameter("@userNumber", model.userNumber),
new SqlParameter("@userName", model.userName),
new SqlParameter("@roseId", model.roseId)
};
return(SqlHelps.ExecuteNonQuery(ConnectionString, CommandType.Text, strSql, sqlParameter) > 0);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TF.RunSafty.Entry.Users DataRowToModel(DataRow row)
{
TF.RunSafty.Entry.Users model = new TF.RunSafty.Entry.Users();
if (row != null)
{
model.id = int.Parse(row["id"].ToString());
model.userNumber = row["userNumber"].ToString();
model.userName = row["userName"].ToString();
model.passWord = row["passWord"].ToString();
model.roseId = int.Parse(row["roseId"].ToString());
}
return(model);
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public int Add(TF.RunSafty.Entry.Users model)
{
string strSql = @"insert into Tab_User (userNumber,userName,passWord,roseId) values
(@userNumber,@userName,@passWord,@roseId)";
SqlParameter[] sqlParameter =
{
new SqlParameter("@userNumber", model.userNumber),
new SqlParameter("@userName", model.userName),
new SqlParameter("@passWord", model.passWord),
new SqlParameter("@roseId", model.roseId)
};
object obj = SqlHelps.ExecuteNonQuery(ConnectionString, CommandType.Text, strSql, sqlParameter);
if (DBNull.Value.Equals(obj))
{
return(0);
}
return(Convert.ToInt32(obj));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(TF.RunSafty.Entry.Users model)
{
return(DBUr.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(TF.RunSafty.Entry.Users model)
{
return(DBUr.Add(model));
}
