public ActionResult Registration(User user)
{
bool Status = false;
string Message = "";
if (ModelState.IsValid)
{
MongoAjax _mongoAjax = new MongoAjax();
UserAjax userAjax = new UserAjax {
FistName = user.FistName, LastName = user.LastName, UserName = user.UserName, Password = user.Password
};
var respond = _mongoAjax.AddUser(userAjax);
if (respond.isSuccess)
{
Message = "you have registration successfully ";
}
else
{
Message = respond.Message;
}
Status = respond.isSuccess;
}
else
{
ViewBag.Message = "Invalid requrest";
}
ViewBag.Message = Message;
ViewBag.Status = Status;
return(View(user));
}
public HttpResponseMessage Lang([FromBody] UserAjax userajax)
{
Db db = new Db();
string sqlnp = "SELECT * FROM GDMS_USER order by USER_ID";
int limit1 = (userajax.page - 1) * userajax.limit + 1;
int limit2 = userajax.page * userajax.limit;
string sql = "SELECT * FROM(SELECT p1.*,ROWNUM rn FROM(" + sqlnp + ")p1)WHERE rn BETWEEN " + limit1 + " AND " + limit2;
var ds = db.QueryT(sql);
Response res = new Response();
ArrayList data = new ArrayList();
foreach (DataRow col in ds.Rows)
{
Dictionary <string, string> dict = new Dictionary <string, string>
{
{ "USER_ID", col["USER_ID"].ToString() },
{ "USER_NAME", col["USER_NAME"].ToString() },
{ "USER_TYPE", col["USER_TYPE"].ToString() },
{ "FAILED_LOGINS", col["FAILED_LOGINS"].ToString() },
{ "LAST_IP", col["LAST_IP"].ToString() },
{ "EMAIL", col["EMAIL"].ToString() },
{ "LAST_LOGIN", col["LAST_LOGIN"].ToString() },
{ "JOIN_DATE", col["JOIN_DATE"].ToString() },
};
data.Add(dict);
}
//获取用户数量
string sql2 = "select count(*) as count from GDMS_USER";
var ds2 = db.QueryT(sql2);
foreach (DataRow col in ds2.Rows)
{
res.count = col["count"].ToString();
}
res.code = 0;
res.msg = "";
res.data = data;
var resJsonStr = JsonConvert.SerializeObject(res);
HttpResponseMessage resJson = new HttpResponseMessage
{
Content = new StringContent(resJsonStr, Encoding.GetEncoding("UTF-8"), "application/json")
};
return(resJson);
}
public HttpResponseMessage userList([FromBody] UserAjax userajax)
{
Db db = new Db();
string sqlnp = "SELECT a.*,b.USER_NAME FROM GDMS_USER_SYSTEM a LEFT JOIN GDMS_USER b ON a.USER_ID = b.USER_ID WHERE a.SYSTEM_ID = " + userajax.systemId + " order by a.USER_ID";
int limit1 = (userajax.page - 1) * userajax.limit + 1;
int limit2 = userajax.page * userajax.limit;
string sql = "SELECT * FROM(SELECT p1.*,ROWNUM rn FROM(" + sqlnp + ")p1)WHERE rn BETWEEN " + limit1 + " AND " + limit2;
var ds = db.QueryT(sql);
Response res = new Response();
ArrayList data = new ArrayList();
foreach (DataRow col in ds.Rows)
{
Dictionary <string, string> dict = new Dictionary <string, string>
{
{ "USER_ID", col["USER_ID"].ToString() },
{ "USER_NAME", col["USER_NAME"].ToString() },
};
data.Add(dict);
}
//获取用户数量
string sql2 = "select count(*) as count from GDMS_USER_SYSTEM WHERE SYSTEM_ID = " + userajax.systemId;
var ds2 = db.QueryT(sql2);
foreach (DataRow col in ds2.Rows)
{
res.count = col["count"].ToString();
}
res.code = 0;
res.msg = "";
res.data = data;
var resJsonStr = JsonConvert.SerializeObject(res);
HttpResponseMessage resJson = new HttpResponseMessage
{
Content = new StringContent(resJsonStr, Encoding.GetEncoding("UTF-8"), "application/json")
};
return(resJson);
}
