public bool editUser(BaseUserInfo user)
{
string sql = string.Format("UPDATE BaseUserInfo SET uName='{0}',uAge={1},uAddress='{2}',uHeight='{3}',uBlood='{4}',uWeight='{5}',uEdu='{6}',uProfession='{7}',uMoney='{8}',uMarriage='{9}',uHouse='{10}',uSpeak='{11}',uFaceUrl='{12}',fAddress='{13}',fAge='{14}',fHeight='{15}',fEdu='{16}',fMoney='{17}',aRemark='{18}',uYear='{19}',uMonth='{20}',uDate='{21}',uHobby='{22}' where uId={23} ", user.uName, user.uAge, user.uAddress, user.uHeight, user.uBlood, user.uWeight, user.uEdu, user.uProfession, user.uMoney, user.uMarriage, user.uHouse, user.uSpeak, user.uFaceUrl, user.fAddress, user.fAge, user.fHeight, user.fEdu, user.fMoney, user.aRemark, user.uYear, user.uMonth, user.uDate,user.uHobby, user.uId);
int n = DBHelper.NonQuery(sql);
return n== 1;
}
public ActionResult Edit(BaseUserInfo user)
{
BaseUserInfoBLL userBLL = new BaseUserInfoBLL();
if (userBLL.editUser(user))
{
return RedirectToAction("List", "Admin");
}
else
{
return Content("修改失败");
}
}
public ActionResult Create(BaseUserInfo user)
{
BaseUserInfoBLL baseInfo = new BaseUserInfoBLL();
if ( baseInfo.createUser(user))
{
return RedirectToAction("List", "Admin");
}
else
{
return Content("创建失败");
}
}
public bool createUser(BaseUserInfo user)
{
string sql = string.Format("INSERT INTO BaseUserInfo (uName ,uAge ,uAddress ,uHeight ,uBlood ,uWeight, uEdu ,uProfession, uMoney, uMarriage ,uHouse, uSpeak, uFaceUrl ,fAddress ,fAge ,fHeight, fEdu, fMoney ,aRemark,uYear,uMonth,uDate,uHobby) VALUES ('{0}',{1},'{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}','{21}',{22})", user.uName, user.uAge, user.uAddress, user.uHeight, user.uBlood, user.uWeight, user.uEdu, user.uProfession, user.uMoney, user.uMarriage, user.uHouse, user.uSpeak, user.uFaceUrl, user.fAddress, user.fAge, user.fHeight, user.fEdu, user.fMoney, user.aRemark, user.uYear, user.uMonth, user.uDate,user.uHobby);
return DBHelper.NonQuery(sql)==1;
}