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;
}
