public string ChangeState(string id) { FBProject _main = new FBProject(); string result = string.Empty; if (_main.ChangeState(id)) { result = @"{""success"":" + true + @",""msg"":""" + "成功!" + @"""}"; } else result = @"{""success"":" + false + @",""msg"":""" + "失败!" + @"""}"; return result; }
public string Add() { NameValueCollection Form = HttpContext.Current.Request.Form; FBProject _main = new FBProject(); _main = EntityExtension2.Load<FBProject>(new FBProject(), Form); //转换成实体 string result = string.Empty; if (_main.Add()) { result = @"{""success"":" + true + @",""msg"":""" + "成功!" + @"""}"; } else result = @"{""success"":" + false + @",""msg"":""" + "失败!" + @"""}"; return result; //String s = (new System.IO.StreamReader(HttpContext.Current.Request.InputStream)).ReadToEnd(); //FBProject fb = JsonConvert.DeserializeObject(s, typeof(FBProject)) as FBProject; }
public string GetProjectJson2(string sqlwhere) { string[] stringList; string username=string.Empty; string roid = string.Empty; ; string result = string.Empty; if (string.IsNullOrEmpty(sqlwhere)) { sqlwhere = " 1=1"; } HttpCookie cookie = HttpContext.Current.Request.Cookies["user"]; if (cookie != null) { stringList = cookie.Value.ToString().Split('|'); //截取帐号密码; username = Server.UrlDecode(stringList[0].ToString()); roid = stringList[2].ToString(); if (roid == "7") { // result = new FBProject().GetProjectJson2(sqlwhere); sqlwhere = sqlwhere.Replace("'", "''"); result = new FBProject().Filter("", sqlwhere); } else { sqlwhere = sqlwhere.Replace("'", "''"); result = new FBProject().Filter(username, sqlwhere); } } return result; }
public string GetUser(string q) { DataTable table = new FBProject().GetUser(q).Tables[0]; JsonArray jsonList = new JsonArray(); Jayrock.Json.JsonObject json; foreach (DataRow row in table.Rows) { json = new Jayrock.Json.JsonObject(); json.Accumulate("uname", row["username"]); //UserId jsonList.Add(json); } string str = jsonList.ToString(); return str; }