public ActionResult AllUser()
{
string msg = Request["msg"];
using (var context = new AllUserModel())
{
var q = from t in context.UserTable
where t.name.Contains(msg) || t.phone.Contains(msg)
select t;
if (q.Count() != 0)
{
if (Request.IsAjaxRequest())
{
return(PartialView("testPage", q.ToList()));
}
else
{
return(View(q.ToList()));
}
}
else
{
return(PartialView("testPage", q.ToList()));
}
}
}
public ActionResult AddAdmin()
{
string phone = Request["phone"];
string password = Request["password"];
using (var context = new AllUserModel())
{
var q = from t1 in context.AdminTable
where t1.phone == phone
select t1;
if (q.Count() != 0)
{
Response.Write("<script>alert('手机号已经被注册');</script>");
return(View("Create"));
}
AdminTable myadmin = new AdminTable()
{
phone = phone,
password = password
};
try
{
context.AdminTable.Add(myadmin);
context.SaveChanges();
Response.Write("<script>alert('注册成功');</script>");
return(View("Create"));
}
catch (Exception e)
{
Response.Write("<script>alert('" + e.Message + "');</script>");
return(View("Create"));
}
}
}
public ActionResult AddUser()
{
string name = Request["userName"];
string phone = Request["userPhone"];
string password = Request["userPassword"];
using (var context = new AllUserModel())
{
var q = from t1 in context.UserTable
where t1.phone == phone
select t1;
if (q.Count() != 0)
{
Response.Write("<script>alert('手机号已经被注册');</script>");
return(View("Create"));
}
UserTable myUser = new UserTable()
{
name = name,
phone = phone,
password = password
};
try
{
context.UserTable.Add(myUser);
context.SaveChanges();
Response.Write("<script>alert('注册成功');</script>");
return(View("Create"));
}
catch (Exception e)
{
Response.Write("<script>alert('" + e.Message + "');</script>");
return(View("Create"));
}
}
// try
// {
// context.UserTable.Add(user);
// context.SaveChanges();
// ViewBag.registerMsg = "";
// Session["name"] = name;
// Session["phone"] = phone;
// Response.Write("<script>alert('注册成功');</script>");
// Session["login"] = "******";
// String url = Url.Action("Index", "Home", new { area = "" });
// return Redirect(url);
// }
// catch (Exception e)
// {
// ViewBag.registerMsg = e.Message;
// return View("register");
// }
//}
}
IList <AllUserModel> GetUser(string sql)
{
var userList = new List <AllUserModel>();
var dr = _dataHelper.ExecuteReader(sql);
if (dr.HasRecords)
{
while (dr.Read())
{
var usermodel = new AllUserModel
{
userId = dr.GetInt("userId"),
groupId = dr.GetInt("groupId"),
forumId = dr.GetInt("forumid"),
replyid = dr.GetInt("replyid"),
};
userList.Add(usermodel);
}
}
return(userList);
}
