public int UpdateUser(Users_model usermodel)
{
string sql = "update users set loginpwd=@pwd,NickName=@nick,sex=@sex,age=@age,faceid=@face,FriendShipPolicyId=@friend,Name=@name,StarId=@star,BloodTypeId=@blood where id=@id";
SqlParameter[] pars =
{
new SqlParameter("@pwd", SqlDbType.VarChar, 20),
new SqlParameter("@nick", SqlDbType.VarChar, 20),
new SqlParameter("@sex", SqlDbType.Char, 2),
new SqlParameter("@age", SqlDbType.Int),
new SqlParameter("@face", SqlDbType.Int),
new SqlParameter("@friend", SqlDbType.Int),
new SqlParameter("@name", SqlDbType.VarChar, 20),
new SqlParameter("@star", SqlDbType.Int),
new SqlParameter("@blood", SqlDbType.Int),
new SqlParameter("@id", SqlDbType.Int)
};
pars[0].Value = usermodel.LoginPwd;
pars[1].Value = usermodel.NickName;
pars[2].Value = usermodel.Sex;
pars[3].Value = usermodel.Age;
pars[4].Value = usermodel.FaceId;
pars[5].Value = usermodel.Friend;
pars[6].Value = usermodel.Name;
pars[7].Value = usermodel.StarId;
pars[8].Value = usermodel.BloodId;
pars[9].Value = usermodel.Id;
return(DbHelperSql.ExecuteNonQuery(sql, CommandType.Text, pars));
}
public int AddUser(Users_model usermodel)
{
string sql = "insert into users values(@pwd,@nick,@sex,@age,@face,@friend,@name,@star,@blood)";
SqlParameter[] pars =
{
new SqlParameter("@pwd", SqlDbType.VarChar, 20),
new SqlParameter("@nick", SqlDbType.VarChar, 20),
new SqlParameter("@sex", SqlDbType.Char, 2),
new SqlParameter("@age", SqlDbType.Int),
new SqlParameter("@face", SqlDbType.Int),
new SqlParameter("@friend", SqlDbType.Int),
new SqlParameter("@name", SqlDbType.VarChar, 20),
new SqlParameter("@star", SqlDbType.Int),
new SqlParameter("@blood", SqlDbType.Int)
};
pars[0].Value = usermodel.LoginPwd;
pars[1].Value = usermodel.NickName;
pars[2].Value = usermodel.Sex;
pars[3].Value = usermodel.Age;
pars[4].Value = usermodel.FaceId;
pars[5].Value = usermodel.Friend;
pars[6].Value = usermodel.Name;
pars[7].Value = usermodel.StarId;
pars[8].Value = usermodel.BloodId;
return(DbHelperSql.ExecuteNonQuery(sql, CommandType.Text, pars));
}
public ActionResult DeleteConfirmed(int id)
{
Users_model users_model = db.Users_Models.Find(id);
db.Users_Models.Remove(users_model);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "UsersId,UserName,PassWord,rules,status")] Users_model users_model)
{
if (ModelState.IsValid)
{
db.Entry(users_model).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(users_model));
}
public ActionResult Create([Bind(Include = "UsersId,UserName,PassWord,rules,status")] Users_model users_model)
{
if (ModelState.IsValid)
{
db.Users_Models.Add(users_model);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(users_model));
}
public Users_model GetUserById(int id)
{
string sql = "select * from Users where id=@id";
Users_model usermodel = new Users_model();
DataTable da = DbHelperSql.GetTable(sql, CommandType.Text, new SqlParameter("@id", id));
if (da.Rows.Count > 0)
{
usermodel = new Users_model();
LoadEntity(da.Rows[0], usermodel);
}
return(usermodel);
}
private void LoadEntity(DataRow row, Users_model usermodel)
{
usermodel.Id = Convert.ToInt32(row["Id"]);
usermodel.LoginPwd = row["LoginPwd"] != DBNull.Value ? row["LoginPwd"].ToString() : string.Empty;
usermodel.NickName = row["NickName"] != DBNull.Value ? row["NickName"].ToString() : string.Empty;
usermodel.Sex = row["Sex"] != DBNull.Value ? row["Sex"].ToString() : string.Empty;
usermodel.Age = Convert.ToInt32(row["Age"]);
usermodel.FaceId = Convert.ToInt32(row["FaceId"]);
usermodel.Friend = Convert.ToInt32(row["FriendShipPolicyId"]);
usermodel.Name = row["Name"] != DBNull.Value ? row["Name"].ToString() : string.Empty;
usermodel.StarId = Convert.ToInt32(row["StarId"]);
usermodel.BloodId = Convert.ToInt32(row["BloodTypeId"]);
}
// GET: Users_model/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Users_model users_model = db.Users_Models.Find(id);
if (users_model == null)
{
return(HttpNotFound());
}
return(View(users_model));
}
public List <Users_model> GetList()
{
string sql = "select * from users";
DataTable da = DbHelperSql.GetTable(sql, CommandType.Text);
List <Users_model> list = null;
if (da.Rows.Count > 0)
{
list = new List <Users_model>();
Users_model usermodel = null;
foreach (DataRow row in da.Rows)
{
usermodel = new Users_model();
LoadEntity(row, usermodel);
list.Add(usermodel);
}
}
return(list);
}
public bool UserIsNull(Users_model usermodel)
{
if (usermodel.LoginPwd == null)
{
return(false);
}
else
{
return(true);
}
if (usermodel.NickName == null)
{
return(false);
}
else
{
return(true);
}
if (usermodel.Sex == null)
{
return(false);
}
else
{
return(true);
}
if (usermodel.Age == null)
{
return(false);
}
else
{
return(true);
}
if (usermodel.FaceId == null)
{
return(false);
}
else
{
return(true);
}
if (usermodel.Friend == null)
{
return(false);
}
else
{
return(true);
}
if (usermodel.Name == null)
{
return(false);
}
else
{
return(true);
}
if (usermodel.StarId == null)
{
return(false);
}
else
{
return(true);
}
if (usermodel.BloodId == null)
{
return(false);
}
else
{
return(true);
}
}
public bool AddUser(Users_model usermodel)
{
return(userdao.AddUser(usermodel) > 0);
}
public bool UpdateUser(Users_model usermodel)
{
return(userdao.UpdateUser(usermodel) > 0);
}
