public static string getSystemParaBuildinCode()
{
Jayrock.Json.JsonObject ja = new Jayrock.Json.JsonObject();
Jayrock.Json.JsonObject jo;
DatabaseAccess dbAccess = new DatabaseAccess();
string sql = "select * from SystemParaBuildin";
System.Data.DataTable dt;
dbAccess.open();
try
{
dt = dbAccess.select(sql);
foreach (System.Data.DataRow row in dt.Rows)
{
jo = new Jayrock.Json.JsonObject();
foreach (System.Data.DataColumn col in dt.Columns)
{
jo.Accumulate(col.ColumnName, row[col.ColumnName]);
}
ja.Accumulate(row["ID"].ToString(), jo);
}
}
catch
{
throw;
}
finally
{
dbAccess.close();
}
return(ja.ToString());
}
public Jayrock.Json.JsonArray getFileJsonArray()
{
DatabaseAccess dbAccess = new DatabaseAccess();
Jayrock.Json.JsonArray images = new Jayrock.Json.JsonArray();
Jayrock.Json.JsonObject image;
System.Data.DataTable dt;
string sql = string.Format(" select ID, Name FileName, Description from [File] where parentid = {0} order by ID ", ID.ToString());
dbAccess.open();
try
{
dt = dbAccess.select(sql);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbAccess.close();
}
foreach (System.Data.DataRow row in dt.Rows)
{
image = new Jayrock.Json.JsonObject();
foreach (System.Data.DataColumn col in dt.Columns)
{
image.Accumulate(col.ColumnName.ToLower(), row[col.ColumnName]);
}
images.Add(image);
}
return(images);
}
/**
* Processes a JSON request.
*
* @param request Original JSON request
* @return The JSON response.
*/
public JsonObject Process(JsonObject request)
{
JsonObject response = new JsonObject();
JsonObject requestContext = request.getJSONObject("context");
JsonArray requestedGadgets = request["gadgets"] as JsonArray;
// Process all JSON first so that we don't wind up with hanging threads if
// a JsonException is thrown.
List<IAsyncResult> gadgets = new List<IAsyncResult>(requestedGadgets.Length);
for (int i = 0, j = requestedGadgets.Length; i < j; ++i)
{
var context = new JsonRpcGadgetContext(requestContext, (JsonObject)requestedGadgets[i]);
PreloadProcessor proc = new PreloadProcessor(CallJob);
IAsyncResult result = proc.BeginInvoke(context, null, null);
gadgets.Add(result);
}
foreach (var entry in gadgets)
{
try
{
AsyncResult result = (AsyncResult)entry;
PreloadProcessor proc = (PreloadProcessor)result.AsyncDelegate;
JsonObject gadget = proc.EndInvoke(result);
response.Accumulate("gadgets", gadget);
}
catch (JsonException e)
{
throw new RpcException("Unable to write JSON", e);
}
catch (Exception ee)
{
if (!(ee is RpcException))
{
throw new RpcException("Processing interrupted", ee);
}
RpcException e = (RpcException)ee;
// Just one gadget failed; mark it as such.
try
{
GadgetContext context = e.Context;
JsonObject errorObj = new JsonObject();
errorObj.Put("url", context.getUrl())
.Put("moduleId", context.getModuleId());
errorObj.Accumulate("errors", e.Message);
response.Accumulate("gadgets", errorObj);
}
catch (JsonException je)
{
throw new RpcException("Unable to write JSON", je);
}
}
}
return response;
}
public Jayrock.Json.JsonArray getImageJsonArray()
{
DatabaseAccess dbAccess = new DatabaseAccess();
Jayrock.Json.JsonArray images = new Jayrock.Json.JsonArray();
Jayrock.Json.JsonObject image;
System.Data.DataTable dt;
string sql = "select ID, FileName, MIME from [Image] where Category = '"
+ GlobalSetting.ArticleCategory.Event
+ "' and ParentID = " + ID.ToString();
dbAccess.open();
try
{
dt = dbAccess.select(sql);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbAccess.close();
}
foreach (System.Data.DataRow row in dt.Rows)
{
image = new Jayrock.Json.JsonObject();
foreach (System.Data.DataColumn col in dt.Columns)
{
image.Accumulate(col.ColumnName.ToLower(), row[col.ColumnName]);
}
images.Add(image);
}
return(images);
}
private void UploadPic(HttpRequest Request, HttpResponse Response, string strFileUrl)
{
HttpPostedFile file = Request.Files["Filedata"];
if (file != null)
{
//文件夹是否存在
string pathStr = HttpContext.Current.Server.MapPath("/" + strFileUrl);
if (!Directory.Exists(pathStr))
{
//不存在则自动创建文件夹
Directory.CreateDirectory(pathStr);
}
string ext = Path.GetExtension(file.FileName).ToLower();
string fileName = Guid.NewGuid().ToString("N", System.Globalization.CultureInfo.InvariantCulture) + ext;
string savepath = pathStr + "/" + fileName;
JsonObject json = new JsonObject();
try
{
file.SaveAs(savepath);
json.Accumulate("Status", "OK");
json.Accumulate("SavePath", "/" + strFileUrl + "/" + fileName);
Response.Write(("1|" + json.ToString()));
}
catch (Exception)
{
json.Accumulate("Status", "Failed");
json.Accumulate("ErrorMessage", "系统忙，请稍后再试！");
Response.Write("0|" + json.ToString());
}
}
else
{
JsonObject json = new JsonObject();
json.Accumulate("Status", "Failed");
json.Accumulate("ErrorMessage", " 系统忙，请稍后再试！");
Response.Write("0|" + json.ToString());
}
}
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;
}
