public string TreeRefresh()
{
int showType = Request.Querys("showtype").ToString().ToInt(0);
bool showUser = !"0".Equals(Request.Querys("shouser"));
string refreshId = Request.Querys("refreshid");
Business.Organize organize = new Business.Organize();
Newtonsoft.Json.Linq.JArray jArray = new Newtonsoft.Json.Linq.JArray();
#region 显示工作组
if (1 == showType)
{
return("");
}
#endregion
if (refreshId.IsGuid(out Guid guid))
{
var childs = organize.GetChilds(guid);
foreach (var child in childs)
{
Newtonsoft.Json.Linq.JObject jObject = new Newtonsoft.Json.Linq.JObject()
{
{ "id", child.Id },
{ "parentID", child.ParentId },
{ "title", child.Name },
{ "ico", "" },
{ "link", "" },
{ "type", child.Type },
{ "hasChilds", organize.HasChilds(child.Id) ? 1 : showUser?organize.HasUsers(child.Id) ? 1 : 0 : 0 }
};
jArray.Add(jObject);
}
if (showUser)
{
var users = organize.GetUsers(guid);
var organizeUsers = new Business.OrganizeUser().GetListByOrganizeId(guid);
foreach (var userModel in users)
{
var organizeUserModel1 = organizeUsers.Find(p => p.UserId == userModel.Id);
bool isPartTime = organizeUserModel1.IsMain != 1;//是否是兼职
Newtonsoft.Json.Linq.JObject jObject = new Newtonsoft.Json.Linq.JObject()
{
{ "id", isPartTime ? organizeUserModel1.Id : userModel.Id },
{ "parentID", guid },
{ "title", userModel.Name + (isPartTime ? "<span style='color:#666;'>[兼任]</span>" : "") },
{ "ico", "fa-user" },
{ "link", "" },
{ "userID", userModel.Id },
{ "type", isPartTime ? 6 : 4 },
{ "hasChilds", 0 }
};
jArray.Add(jObject);
}
}
}
return(jArray.ToString());
}
//Creating JArray
public Newtonsoft.Json.Linq.JArray GetJArray2()
{
Newtonsoft.Json.Linq.JArray array = new Newtonsoft.Json.Linq.JArray();
Newtonsoft.Json.Linq.JValue text = new Newtonsoft.Json.Linq.JValue("Manual text");
Newtonsoft.Json.Linq.JValue date = new Newtonsoft.Json.Linq.JValue(new DateTime(2000, 5, 23));
//add to JArray
array.Add(text);
array.Add(date);
return(array);
}
public string QueryDeleteList()
{
string form_name = Request.Forms("form_name");
string typeid = Request.Querys("typeid");
string sidx = Request.Forms("sidx");
string sord = Request.Forms("sord");
int size = Tools.GetPageSize();
int number = Tools.GetPageNumber();
string order = (sidx.IsNullOrEmpty() ? "CreateDate" : sidx) + " " + (sord.IsNullOrEmpty() ? "DESC" : sord);
Business.Form form = new Business.Form();
var forms = form.GetPagerList(out int count, size, number, Current.UserId, form_name, "", order, 2);
Newtonsoft.Json.Linq.JArray jArray = new Newtonsoft.Json.Linq.JArray();
Business.User user = new Business.User();
foreach (System.Data.DataRow dr in forms.Rows)
{
Newtonsoft.Json.Linq.JObject jObject = new Newtonsoft.Json.Linq.JObject
{
{ "id", dr["Id"].ToString() },
{ "Name", dr["Name"].ToString() },
{ "CreateUserName", dr["CreateUserName"].ToString() },
{ "CreateTime", dr["CreateDate"].ToString().ToDateTime().ToDateTimeString() },
{ "LastModifyTime", dr["EditDate"].ToString().ToDateTime().ToDateTimeString() },
{ "Edit", "<a class=\"list\" href=\"javascript:void(0);\" onclick=\"reply('" + dr["Id"].ToString() + "', '" + dr["Name"].ToString() + "');return false;\"><i class=\"fa fa-reply\"></i>还原</a>" }
};
jArray.Add(jObject);
}
return("{\"userdata\":{\"total\":" + count + ",\"pagesize\":" + size + ",\"pagenumber\":" + number + "},\"rows\":" + jArray.ToString() + "}");
}
/// <summary>
/// 得到一个流程所有的表和字段
/// </summary>
/// <returns></returns>
public string GetTableJSON()
{
string dbs = Request.Forms("dbs");
if (dbs.IsNullOrWhiteSpace())
{
return("[]");
}
Newtonsoft.Json.Linq.JArray jArray = null;
try
{
jArray = Newtonsoft.Json.Linq.JArray.Parse(dbs);
}
catch
{
return("[]");
}
if (null == jArray)
{
return("[]");
}
Business.DbConnection dbConnection = new Business.DbConnection();
Newtonsoft.Json.Linq.JArray jArray1 = new Newtonsoft.Json.Linq.JArray();
foreach (Newtonsoft.Json.Linq.JObject jObject in jArray)
{
string table = jObject.Value <string>("table");
string connId = jObject.Value <string>("link");
int type = 0;
if (!connId.IsGuid(out Guid cid))
{
continue;
}
var dbConnModel = dbConnection.Get(cid);
if (null == dbConnModel)
{
continue;
}
Newtonsoft.Json.Linq.JObject jObject1 = new Newtonsoft.Json.Linq.JObject
{
{ "table", table },
{ "connId", connId },
{ "type", type },
{ "connName", dbConnModel.Name + "(" + dbConnModel.ConnType + ")" }
};
var fields = dbConnection.GetTableFields(cid, table);
Newtonsoft.Json.Linq.JArray fieldArray = new Newtonsoft.Json.Linq.JArray();
foreach (var field in fields)
{
Newtonsoft.Json.Linq.JObject jObject2 = new Newtonsoft.Json.Linq.JObject
{
{ "name", field.FieldName },
{ "comment", field.Comment }
};
fieldArray.Add(jObject2);
}
jObject1.Add("fields", fieldArray);
jArray1.Add(jObject1);
}
return(jArray1.ToString());
}
public Newtonsoft.Json.Linq.JArray GetEXP(string sql, out string outStr)
{
outStr = "";
Newtonsoft.Json.Linq.JArray data = new Newtonsoft.Json.Linq.JArray();
var dt = AppUtility.Engine.EngineConfig.CommandFactory.CreateCommand().ExecuteDataTable(sql);
if (dt.Rows.Count > 0)
{
//提取公式内{}内容获取规则明细名称
string exp = dt.Rows[0]["EXPRESSION"] + string.Empty;
exp.Replace('×', '*');
exp.Replace('÷', '/');
outStr = exp;
MatchCollection mc = Regex.Matches(exp, @"{([^}]+)}");
foreach (var item in mc)
{
string s = item.ToString();
string s0 = s.Substring(1, s.Length - 2);
string Namesql = string.Format("select DETAILENAME from C_RULEDETAILS where objectid='{0}' ", s0);
var name = AppUtility.Engine.EngineConfig.CommandFactory.CreateCommand().ExecuteScalar(Namesql) + string.Empty;
string s1 = "<button style='margin:1px' value='" + s0 + "'>" + name + "</button>";
exp = exp.Replace(s, s1);
}
Newtonsoft.Json.Linq.JObject ret = new Newtonsoft.Json.Linq.JObject();
ret.Add("exp", exp);
data.Add(ret);
}
return(data);
}
public string TreeRefresh()
{
string refreshId = Request.Querys("refreshid");
if (!refreshId.IsGuid(out Guid rid))
{
return("[]");
}
Business.Dictionary dictionary = new Business.Dictionary();
var childs = dictionary.GetChilds(rid);
Newtonsoft.Json.Linq.JArray jArray = new Newtonsoft.Json.Linq.JArray();
foreach (var child in childs)
{
Newtonsoft.Json.Linq.JObject jObject = new Newtonsoft.Json.Linq.JObject
{
{ "id", child.Id },
{ "parentID", child.ParentId },
{ "title", child.Status == 1 ? "<span style='color:#999'>" + child.Title + "[作废]</span>" : child.Title },
{ "type", "2" },
{ "ico", "" },
{ "hasChilds", dictionary.HasChilds(child.Id) ? 1 :0 }
};
jArray.Add(jObject);
}
return(jArray.ToString());
}
public IActionResult Index()
{
bool isoneself = "1".Equals(Request.Querys("isoneself"));
Guid userId = Current.UserId;
var all = new Business.FlowComment().GetAll();
Newtonsoft.Json.Linq.JArray jArray = new Newtonsoft.Json.Linq.JArray();
Business.User user = new Business.User();
foreach (var comment in all)
{
if (isoneself && comment.UserId != userId)
{
continue;
}
Newtonsoft.Json.Linq.JObject jObject = new Newtonsoft.Json.Linq.JObject
{
{ "id", comment.Id },
{ "Comments", comment.Comments },
{ "UserId", !comment.UserId.IsEmptyGuid() ? user.GetName(comment.UserId) : "全部人员" },
{ "AddType", comment.AddType == 0 ? "用户添加" : "管理员添加" },
{ "Sort", comment.Sort },
{ "Opation", "<a class=\"list\" href=\"javascript:void(0);\" onclick=\"edit('" + comment.Id + "');return false;\"><i class=\"fa fa-edit (alias)\"></i>编辑</a>" }
};
jArray.Add(jObject);
}
ViewData["json"] = jArray.ToString();
ViewData["appId"] = Request.Querys("appid");
ViewData["tabId"] = Request.Querys("tabid");
ViewData["isoneself"] = Request.Querys("isoneself");
return(View());
}
public IActionResult InstanceManage()
{
string groupId = Request.Querys("groupid");
Business.FlowTask flowTask = new Business.FlowTask();
var groupTasks = flowTask.GetListByGroupId(groupId.ToGuid());
Newtonsoft.Json.Linq.JArray jArray = new Newtonsoft.Json.Linq.JArray();
foreach (var groupTask in groupTasks)
{
Newtonsoft.Json.Linq.JObject jObject = new Newtonsoft.Json.Linq.JObject();
string opation = "<a class=\"list\" href=\"javascript:void(0);\" onclick=\"cngStatus('" + groupTask.Id.ToString() + "');\"><i class=\"fa fa-exclamation\"></i>状态</a>";
if (groupTask.ExecuteType.In(0, 1) && 5 != groupTask.TaskType)
{
opation += "<a class=\"list\" href=\"javascript:void(0);\" onclick=\"designate('" + groupTask.Id.ToString() + "');\"><i class=\"fa fa-hand-o-right\"></i>指派</a>"
+ "<a class=\"list\" href=\"javascript:void(0);\" onclick=\"goTo('" + groupTask.Id.ToString() + "');\"><i class=\"fa fa-level-up\"></i>跳转</a>";
}
jObject.Add("id", groupTask.Id);
jObject.Add("StepID", groupTask.StepName);
jObject.Add("SenderName", groupTask.SenderName);
jObject.Add("ReceiveTime", groupTask.ReceiveTime.ToDateTimeString());
jObject.Add("ReceiveName", groupTask.ReceiveName);
jObject.Add("CompletedTime1", groupTask.CompletedTime1.HasValue ? groupTask.CompletedTime1.Value.ToDateTimeString() : "");
jObject.Add("Status", flowTask.GetExecuteTypeTitle(groupTask.ExecuteType));
jObject.Add("Comment", groupTask.Comments);
jObject.Add("Note", groupTask.Note);
jObject.Add("Opation", opation);
jArray.Add(jObject);
}
ViewData["json"] = jArray.ToString();
ViewData["appid"] = Request.Querys("appid");
ViewData["iframeid"] = Request.Querys("iframeid");
return(View());
}
public void AddBook(Book book)
{
Newtonsoft.Json.Linq.JArray books = connector.GetInfo();
books.Add(Newtonsoft.Json.Linq.JToken.FromObject(book));
connector.WriteInfo(books);
}
public static List <T> GetList <T>(DbDataReader dataReader)
{
// 列名
var cols = new List <string>();
for (int index = 0; index < dataReader.FieldCount; index++)
{
cols.Add(dataReader.GetName(index));
}
// 赋值
Newtonsoft.Json.Linq.JArray jArray = new Newtonsoft.Json.Linq.JArray();
while (dataReader.Read() == true)
{
var toAdd_JObject = new Newtonsoft.Json.Linq.JObject();
foreach (string col in cols)
{
if (dataReader[col] != DBNull.Value)
{
toAdd_JObject.Add(col, dataReader[col].ToString());
}
else
{
toAdd_JObject.Add(col, null);
}
}
jArray.Add(toAdd_JObject);
}
return(jArray.ToObject <List <T> >());
}
public string QueryDelete()
{
string flow_name = Request.Forms("flow_name");
string typeid = Request.Forms("typeid");
string sidx = Request.Forms("sidx");
string sord = Request.Forms("sord");
int size = Tools.GetPageSize();
int number = Tools.GetPageNumber();
string order = (sidx.IsNullOrEmpty() ? "CreateDate" : sidx) + " " + (sord.IsNullOrEmpty() ? "DESC" : sord);
Business.Flow flow = new Business.Flow();
var flows = flow.GetPagerList(out int count, size, number, flow.GetManageFlowIds(Current.UserId), flow_name, "", order, 3);
Newtonsoft.Json.Linq.JArray jArray = new Newtonsoft.Json.Linq.JArray();
Business.User user = new Business.User();
foreach (System.Data.DataRow dr in flows.Rows)
{
Newtonsoft.Json.Linq.JObject jObject = new Newtonsoft.Json.Linq.JObject
{
{ "id", dr["Id"].ToString() },
{ "Name", dr["Name"].ToString() },
{ "CreateDate", dr["CreateDate"].ToString().ToDateTime().ToDateTimeString() },
{ "CreateUser", user.GetName(dr["CreateUser"].ToString().ToGuid()) },
{ "Status", flow.GetStatusTitle(dr["Status"].ToString().ToInt()) },
{ "Note", dr["Note"].ToString() },
{ "Opation", "<a class=\"list\" href=\"javascript:void(0);\" onclick=\"reply('" + dr["Id"].ToString() + "', '" + dr["Name"].ToString() + "');return false;\"><i class=\"fa fa-reply\"></i>还原</a>" }
};
jArray.Add(jObject);
}
return("{\"userdata\":{\"total\":" + count + ",\"pagesize\":" + size + ",\"pagenumber\":" + number + "},\"rows\":" + jArray.ToString() + "}");
}
public static void AddNonNullItem(ref Newtonsoft.Json.Linq.JArray array, Newtonsoft.Json.Linq.JToken json)
{
if (json != null)
{
array.Add(json);
}
}
public Newtonsoft.Json.Linq.JArray GetJson(string page, string size, out int total)
{
total = 0;
Newtonsoft.Json.Linq.JArray data = new Newtonsoft.Json.Linq.JArray();
if (!string.IsNullOrWhiteSpace(page) && !string.IsNullOrWhiteSpace(size))
{
string query = "";
if (!string.IsNullOrWhiteSpace(DEALERNAME))
{
query += (query == "" ? " WHERE" : " AND") + " DEALERNAME LIKE '%" + DEALERNAME + "%'";
}
//if (!string.IsNullOrWhiteSpace(NWWW))
//{
// query += (query == "" ? " WHERE" : " AND") + " NWWW LIKE '%" + NWWW + "%'";
//}
//if (!string.IsNullOrWhiteSpace(KIND))
//{
// query += (query == "" ? " WHERE" : " AND") + " KIND LIKE '%" + KIND + "%'";
//}
//if (!string.IsNullOrWhiteSpace(JXS_LEVEL))
//{
// query += (query == "" ? " WHERE" : " AND") + " JXS_LEVEL LIKE '%" + JXS_LEVEL + "%'";
//}
int _size = int.Parse(size);
int start = int.Parse(page) * _size;
System.Data.DataTable products = AppUtility.Engine.EngineConfig.CommandFactory.CreateCommand().ExecuteDataTable("select * from DZ_V_H3_BUSINESSDATACOLLECT " + query + " ORDER BY DEALERNAME ASC");
foreach (DataRow row in products.Rows)
{
if (total >= start && this.products.Count < _size)
{
this.products.Add(new MortgageList()
{
DEALERNAME = ReadCell(row, "DEALERNAME"),
RISK = ReadCell(row, "RISK"),
TOW = ReadCell(row, "TOW"),
PUNISH = ReadCell(row, "PUNISH"),
ARCHIVING = ReadCell(row, "ARCHIVING"),
COMPLAIN = ReadCell(row, "COMPLAIN"),
UPDATETIME = ReadCell(row, "UPDATETIME"),
ObjectID = ReadCell(row, "ObjectID"),
DealerId = ReadCell(row, "DealerId"),
CRMDEALERID = ReadCell(row, "CRMDEALERID")
});
}
total++;
}
this.products.Sort();
foreach (MortgageList p in this.products)
{
data.Add(p.GetJson(++start));
}
}
else
{
}
return(data);
}
private string GetResult(NeoArrayContainer container)
{
var array = new Newtonsoft.Json.Linq.JArray();
foreach (var x in container.GetVariables())
{
array.Add(GetResult(x));
}
return(array.ToString(Newtonsoft.Json.Formatting.Indented));
}
public string QueryCompleted()
{
string appid = Request.Querys("appid");
string tabid = Request.Querys("tabid");
string flowid = Request.Forms("flowid");
string title = Request.Forms("title");
string date1 = Request.Forms("date1");
string date2 = Request.Forms("date2");
string sidx = Request.Forms("sidx");
string sord = Request.Forms("sord");
string order = (sidx.IsNullOrEmpty() ? "CompletedTime1" : sidx) + " " + (sord.IsNullOrEmpty() ? "ASC" : sord);
int size = Tools.GetPageSize();
int number = Tools.GetPageNumber();
Business.FlowTask flowTask = new Business.FlowTask();
DataTable dataTable = flowTask.GetCompletedTask(size, number, Current.UserId, flowid, title, date1, date2, order, out int count);
Newtonsoft.Json.Linq.JArray jArray = new Newtonsoft.Json.Linq.JArray();
foreach (DataRow dr in dataTable.Rows)
{
int openModel = 0, width = 0, height = 0;
StringBuilder opation = new StringBuilder(
"<a href=\"javascript:void(0);\" class=\"list\" onclick=\"openTask('" + Url.Content("~/RoadFlowCore/FlowRun/Index") + "?" + string.Format("flowid={0}&stepid={1}&instanceid={2}&taskid={3}&groupid={4}&appid={5}&display=1",
dr["FlowId"], dr["StepId"], dr["InstanceId"], dr["Id"], dr["GroupId"], appid
) + "','" + dr["Title"].ToString().RemoveHTML().UrlEncode() + "','" + dr["Id"] + "'," + openModel + "," + width + "," + height + ");return false;\"><i class=\"fa fa-file-text-o\"></i>表单</a>" +
"<a class=\"list\" href=\"javascript:void(0);\" onclick=\"detail('" + dr["FlowId"] + "','" + dr["GroupId"] + "','" + dr["Id"] + "');return false;\"><i class=\"fa fa-navicon\"></i>过程</a>");
bool isHasten = flowTask.IsHasten(dr["Id"].ToString().ToGuid(), out bool isWithdraw);
if (isWithdraw)
{
opation.Append("<a class=\"list\" href=\"javascript:void(0);\" onclick=\"withdraw('" + dr["Id"] + "','" + dr["GroupId"] + "');return false;\"><i class=\"fa fa-mail-reply\"></i>收回</a>");
}
if (isHasten)
{
opation.Append("<a class=\"list\" href=\"javascript:void(0);\" onclick=\"hasten('" + dr["Id"] + "','" + dr["GroupId"] + "');return false;\"><i class=\"fa fa-bullhorn\"></i>催办</a>");
}
string taskTitle = "<a href=\"javascript:void(0);\" class=\"list\" onclick=\"openTask('" + Url.Content("~/RoadFlowCore/FlowRun/Index") + "?" + string.Format("flowid={0}&stepid={1}&instanceid={2}&taskid={3}&groupid={4}&appid={5}&display=1",
dr["FlowId"], dr["StepId"], dr["InstanceId"], dr["Id"], dr["GroupId"], appid
) + "','" + dr["Title"].ToString().RemoveHTML().UrlEncode() + "','" + dr["Id"] + "'," + openModel + "," + width + "," + height + ");return false;\">" + dr["Title"] + "</a>";
string note = dr["Note"].ToString();
Newtonsoft.Json.Linq.JObject jObject = new Newtonsoft.Json.Linq.JObject
{
{ "id", dr["Id"].ToString() },
{ "Title", taskTitle },
{ "FlowName", dr["FlowName"].ToString() },
{ "StepName", dr["StepName"].ToString() },
{ "SenderName", dr["SenderName"].ToString() },
{ "ReceiveTime", dr["ReceiveTime"].ToString().ToDateTime().ToDateTimeString() },
{ "CompletedTime", dr["CompletedTime1"].ToString().ToDateTime().ToDateTimeString() },
{ "Note", note },
{ "Opation", opation.ToString() }
};
jArray.Add(jObject);
}
return("{\"userdata\":{\"total\":" + count + ",\"pagesize\":" + size + ",\"pagenumber\":" + number + "},\"rows\":" + jArray.ToString() + "}");
}
public static string GetAllRequestJSON(string search_text, string RequestID)
{
//Security Check
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "read"))
{
throw new Exception("No Access.");
}
//Get current user info
SYS_UserView current_user = Controller_User.GetUser(RequestID, RequestID);
LINQ_MeetingDataContext dc = new LINQ_MeetingDataContext();
//Security Check For AllDepartment
string departmentID = "";
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "allDepartment"))
{
departmentID = current_user.DepartmentID;
}
List <MET_RequestView> the_requestlist = (from c in dc.MET_RequestViews
where c.Active == true && (departmentID == "" || (departmentID != "" && c.DepartmentID == departmentID)) &&
((search_text == "") ||
(search_text != "" && (
c.RequestNo.Contains(search_text) ||
c.RequestStatus.Contains(search_text) ||
c.RequestTitle.Contains(search_text) ||
c.RequestType.Contains(search_text) ||
c.Description.Contains(search_text) ||
c.Remark.Contains(search_text) ||
c.DepartmentName.Contains(search_text))))
orderby c.CreatedOn descending
select c
).ToList();
var lists = new Newtonsoft.Json.Linq.JArray() as dynamic;
foreach (var row in the_requestlist)
{
dynamic request = new Newtonsoft.Json.Linq.JObject();
request.RequestID = row.RequestID;
request.DepartmentID = row.DepartmentID;
request.RequestType = row.RequestType;
request.RequestNo = row.RequestNo;
request.RequestUserName = row.RequestUserName;
request.RequestTitle = row.RequestTitle;
request.RequestStatus = row.RequestStatus;
request.RequestOn = row.RequestOn;
request.DepartmentName = row.DepartmentName;
request.ApprovalStatus = row.ApprovalStatus;
lists.Add(request);
}
return(lists.ToString());
}
/// <summary>
/// 得到所有按钮JSON
/// </summary>
/// <returns></returns>
public Newtonsoft.Json.Linq.JArray GetAllJson()
{
var buttons = GetAll();
Newtonsoft.Json.Linq.JArray jArray = new Newtonsoft.Json.Linq.JArray();
foreach (var button in buttons)
{
jArray.Add(Newtonsoft.Json.Linq.JObject.Parse(button.ToString()));
}
return(jArray);
}
/// <summary>
/// get all bills filtered by both subject and start dates.
/// The start dates of the sessions helps keep us from making quite so many
/// bill queries.
/// </summary>
/// <param name="state"></param>
/// <param name="startdate"></param>
/// <param name="subjects">each space delimited token is searched for and all bill subjects that contain any token are returned</param>
/// <param name="cursor"></param>
/// <param name="f">action for each bill. null means no action.</param>
public async Task <Newtonsoft.Json.Linq.JArray> GetBillsFilteredAsync(string state, DateTime startdate, DateTime enddate, string subjects, string cursor, ExtraActionPerBill f)
{
OpenStateClientLib.OpenStateClient cli;
cli = new OpenStateClientLib.OpenStateClient();
Newtonsoft.Json.Linq.JArray AllBills = new Newtonsoft.Json.Linq.JArray();
var results = await cli.GetStateLegesAsync(state);
var aaa = results.Data;
List <string> SessionNames;
List <string> SessionIds;
List <DateTime> SessionStarts;
bool Ok = ExtractSessionNames(results, out SessionNames, out SessionIds, out SessionStarts);
if (SessionNames != null && SessionIds != null)
{
int nn = SessionNames.Count;
for (int ii = 0; ii < nn; ii++)
{
string SessionI = SessionNames[ii];
string SessionIdI = SessionIds[ii];
if (startdate <= SessionStarts[ii])
{
Newtonsoft.Json.Linq.JArray Bills = await cli.GetBillsAllAsync(state, SessionIdI, "", null);
if (Bills != null)
{
int n = Bills.Count;
for (int i = 0; i < n; i++)
{
Newtonsoft.Json.Linq.JToken OneBill = Bills[i]["node"];
Newtonsoft.Json.Linq.JArray SubjectsFound = OneBill["subject"] as Newtonsoft.Json.Linq.JArray;
string updatedAt = OneBill["updatedAt"].ToString();
System.DateTime updatedAtDate;
bool OkUpdatedAtDate = System.DateTime.TryParse(updatedAt, out updatedAtDate);
if (OkUpdatedAtDate && updatedAtDate >= startdate &&
updatedAtDate <= enddate &&
OpenStateClientLib.OpenStateClient.IsBillSubjectFound(subjects, SubjectsFound))
{
f?.Invoke(OneBill);
AllBills.Add(OneBill);
}
}
}
}
}
}
return(AllBills);
}
private void SaveSeans(List <FilmEntry> newData)
{
Newtonsoft.Json.Linq.JArray res = new Newtonsoft.Json.Linq.JArray();
Newtonsoft.Json.Linq.JObject data = new Newtonsoft.Json.Linq.JObject();
foreach (var c in newData)
{
var temp = Newtonsoft.Json.Linq.JObject.Parse(JsonConvert.SerializeObject(c));
res.Add(temp);
}
data["data"] = res;
File.WriteAllText("filmList.json", data.ToString());
}
/// <summary>
/// Lists the holidays for the company and its permanent establishments for the specified year( and country).
/// </summary>
/// <param name="year"></param>
/// <returns>A collection of holiday objects in JSON format, sorted by country codes and categorized into
/// general holidays(for the whole country), state holidays(for specific regions or states) and
/// permanent establishment holidays(that only affect certain permanent establishments of the company).</returns>
public async System.Threading.Tasks.Task <HRworksConnector.Models.GeneralActions.HolidaysResponse> GetHolidaysAsync(int year)
{
const string Target = @"GetHolidays";
Newtonsoft.Json.Linq.JObject json = new Newtonsoft.Json.Linq.JObject();
json["year"] = year;
Newtonsoft.Json.Linq.JArray countryCodesAsJson = new Newtonsoft.Json.Linq.JArray();
countryCodesAsJson.Add("DEU");
json["countryCodes"] = countryCodesAsJson;
return(await PostAsync <HRworksConnector.Models.GeneralActions.HolidaysResponse>(Target, json));
}
static void SQLADONETQuery(SQLQuery q, SQLResult result, ConnectionParams cp, bool rollbackOnly)
{
using (SqlConnection t = new SqlConnection(cp.getConnectionString())) //{ t.Open();
using (SqlCommand sqlCommand = new SqlCommand {
Connection = t
}) {
sqlCommand.Connection.Open();
if (!string.IsNullOrEmpty(q.userQuery))
{
if (!string.IsNullOrEmpty(q.SQL))
{
throw new Exception("SQL must be empty for a user query request");
}
q.SQL = getUserQuerySQL(t, q, cp);
checkRollbackOnlyConditions(result.rollbackOnly, q.SQL);
}
result.SQL = q.SQL;
result.userQuery = !string.IsNullOrEmpty(q.userQuery) ? q.uqCategory + "." + q.userQuery : null;
result.extendedUQ = q.uqCategory != null && q.uqCategory.EndsWith(UQCATEGORY_EXTENSION);
sqlCommand.CommandText = q.SQL;
using (SqlDataReader rs = sqlCommand.ExecuteReader(System.Data.CommandBehavior.Default)) {
result.statusCode = System.Net.HttpStatusCode.OK;
var data = new Newtonsoft.Json.Linq.JArray();
do
{
while (rs.Read())
{
var row = new Newtonsoft.Json.Linq.JObject();
for (int i = 0; i < rs.FieldCount; i++)
{
row.Add(rs.GetName(i), rs.GetValue(i).ToString());
}
data.Add(row);
}
result.data = data;
if (q.columnInfo)
{
int cc = rs.FieldCount;
for (int i = 0; i < cc; i++)
{
SQLResult.Column column = new SQLResult.Column();
column.name = rs.GetName(i);
column.dataType = rs.GetDataTypeName(i);
//column.subType = ;//Hmm, What to give here?
result.columns.Add(column);
}
}
} while (rs.NextResult());
}
}
}
/// <summary>
/// 得到导出的JSON字符串
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public string GetExportString(string id)
{
if (!id.IsGuid(out Guid dictId))
{
return(string.Empty);
}
var dicts = GetAllChilds(dictId, true);
Newtonsoft.Json.Linq.JArray jArray = new Newtonsoft.Json.Linq.JArray();
foreach (var dict in dicts)
{
jArray.Add(Newtonsoft.Json.Linq.JObject.FromObject(dict));
}
return(jArray.ToString());
}
internal void DeleteMux(Mux mux)
{
var wr = NewWebRequest("api/idnode/delete");
wr.Method = "POST";
var param = "uuid=";
var obj = new Newtonsoft.Json.Linq.JArray();
obj.Add(mux.UUID);
var byteArray = Encoding.UTF8.GetBytes(param + System.Web.HttpUtility.UrlEncode(obj.ToString()));
SetRequestStream(wr, byteArray);
wr.GetResponse();
}
public async Task CreateDeepnetFromRemoteSource()
{
// Prepare connection
Client c = new Client(userName, apiKey);
// Create source
Source.Arguments args = new Source.Arguments();
args.Add("remote", "http://static.bigml.com/csv/iris.csv");
Source s = await c.CreateSource(args);
s = await c.Wait <Source>(s.Resource);
Assert.AreEqual(s.StatusMessage.StatusCode, Code.Finished);
// Create dataset
DataSet.Arguments argsDS = new DataSet.Arguments();
argsDS.Add("source", s.Resource);
DataSet ds = await c.CreateDataset(argsDS);
ds = await c.Wait <DataSet>(ds.Resource);
Assert.AreEqual(ds.StatusMessage.StatusCode, Code.Finished);
// Create deepnet
Deepnet.Arguments argsDn = new Deepnet.Arguments();
argsDn.Add("dataset", ds.Resource);
Deepnet dn = await c.CreateDeepnet(argsDn);
dn = await c.Wait <Deepnet>(dn.Resource);
Assert.AreEqual(dn.StatusMessage.StatusCode, Code.Finished);
// test UPDATE method
Newtonsoft.Json.Linq.JObject changes = new Newtonsoft.Json.Linq.JObject();
Newtonsoft.Json.Linq.JArray tags = new Newtonsoft.Json.Linq.JArray();
tags.Add("Bindings C# test");
changes.Add("tags", tags);
dn = await c.Update <Deepnet>(dn.Resource, changes);
Assert.AreEqual(dn.Code, System.Net.HttpStatusCode.Accepted);
// test DELETE method
await c.Delete(s);
await c.Delete(ds);
await c.Delete(dn);
}
public static string GetAllAgendaJSON(string search_text, string RequestID)
{
//Security Check
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "read"))
{
throw new Exception("No Access.");
}
//Get current user info
SYS_UserView current_user = Controller_User.GetUser(RequestID, RequestID);
LINQ_MeetingDataContext dc = new LINQ_MeetingDataContext();
//Security Check For AllDepartment
string departmentID = "";
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "allDepartment"))
{
departmentID = current_user.DepartmentID;
}
List <MET_AgendaView> the_agendalist = (from c in dc.MET_AgendaViews
where c.Active == true && (departmentID == "" || (departmentID != "" && c.DepartmentID == departmentID)) &&
((search_text == "") ||
(search_text != "" && (
c.AgendaNo.Contains(search_text) ||
c.AgendaRemark.Contains(search_text) ||
c.AgendaStatus.Contains(search_text) ||
c.CUserCode.Contains(search_text) ||
c.MUserCode.Contains(search_text)
)))
orderby c.CreatedOn descending
select c
).ToList();
var lists = new Newtonsoft.Json.Linq.JArray() as dynamic;
foreach (var row in the_agendalist)
{
dynamic agenda = new Newtonsoft.Json.Linq.JObject();
agenda.AgendaID = row.AgendaID;
agenda.AgendaNo = row.AgendaNo;
agenda.AgendaDate = row.AgendaDate.ToString();
agenda.AgendaRemark = row.AgendaRemark;
agenda.AgendaStatus = row.AgendaStatus;
lists.Add(agenda);
}
return(lists.ToString());
}
public Newtonsoft.Json.Linq.JArray GetPerproty(string id)
{
Newtonsoft.Json.Linq.JArray data = new Newtonsoft.Json.Linq.JArray();
DataTable dt = new DataTable();
string sql = "SELECT ENUMVALUE from OT_EnumerableMetadata t where CATEGORY='" + id + "'";
dt = AppUtility.Engine.EngineConfig.CommandFactory.CreateCommand().ExecuteDataTable(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
Newtonsoft.Json.Linq.JObject ret = new Newtonsoft.Json.Linq.JObject();
ret.Add("ENUMVALUE", dt.Rows[i]["ENUMVALUE"].ToString());
data.Add(ret);
}
return(data);
}
public void Index()
{
var context = HttpContext;
Dictionary <int, int> baseProducts = new Dictionary <int, int>();
string Dealer = UserValidatorFactory.CurrentUser.UserCode;
System.Data.DataTable allProducts = this.ExecuteDataTableSql("CAPDB", @"SELECT distinct FD.FINANCIAL_PRODUCT_ID ProductID,FP.FINANCIAL_PRODUCT_NME ProductName
FROM
FP_DEALER@to_cms FD
JOIN FINANCIAL_PRODUCT@to_cms FP ON FD.FINANCIAL_PRODUCT_ID=FP.FINANCIAL_PRODUCT_ID
JOIN
(SELECT BSU.WORKFLOW_LOGIN_NME , BM2.BUSINESS_PARTNER_ID ,BM2.BUSINESS_PARTNER_NME
FROM BP_SYS_USER@to_cms BSU
JOIN BP_MAIN@to_cms BM ON BSU.BP_SECONDARY_ID=BM.BUSINESS_PARTNER_ID
JOIN BP_RELATIONSHIP@to_cms BRE ON BRE.BP_SECONDARY_ID=BM.BUSINESS_PARTNER_ID AND BRE.RELATIONSHIP_CDE='00112'
JOIN BP_MAIN@to_cms BM2 ON BM2.BUSINESS_PARTNER_ID=BRE.BP_PRIMARY_ID
WHERE BSU.WORKFLOWLOGIN_ACTIVE_IND='T' )
WORKFLOW_LOGIN ON
WORKFLOW_LOGIN.BUSINESS_PARTNER_ID=FD.BUSINESS_PARTNER_ID
WHERE to_char(FP.VALID_FROM_DTE,'yyyymmdd')< to_char(sysdate,'yyyymmdd') and to_char(FP.VALID_TO_DTE,'yyyymmdd')>to_char(sysdate,'yyyymmdd')"
+ " and WORKFLOW_LOGIN.WORKFLOW_LOGIN_NME='" + Dealer + "'"
+ " ORDER BY FD.FINANCIAL_PRODUCT_ID ASC");
Newtonsoft.Json.Linq.JArray ret = new Newtonsoft.Json.Linq.JArray();
if (allProducts != null)
{
for (int i = 0; i < allProducts.Rows.Count; i++)
{
Newtonsoft.Json.Linq.JObject token = new Newtonsoft.Json.Linq.JObject();
token.Add("ProductID", int.Parse(ReadCell(allProducts.Rows[i], "ProductID")));
token.Add("ProductName", ReadCell(allProducts.Rows[i], "ProductName"));
token.Add("ProductDescription", "暂无描述");
ret.Add(token);
baseProducts.Add(int.Parse(ReadCell(allProducts.Rows[i], "ProductID")), i);
}
}
System.Data.DataTable products = AppUtility.Engine.EngineConfig.CommandFactory.CreateCommand().ExecuteDataTable("SELECT p.* FROM C_PRODUCTS p LEFT JOIN OT_USER u ON p.dealer=u.appellation WHERE u.Code='" + UserValidatorFactory.CurrentUser.UserCode + "' ORDER BY ProductId ASC");
foreach (DataRow row in products.Rows)
{
if (baseProducts.ContainsKey(int.Parse(ReadCell(row, "ProductID"))))
{
ret[baseProducts[int.Parse(ReadCell(row, "ProductID"))]]["ProductName"] = ReadCell(row, "ProductAlias");
ret[baseProducts[int.Parse(ReadCell(row, "ProductID"))]]["ProductDescription"] = ReadCell(row, "ProductDescription");
}
}
context.Response.Write(ret);
}
public Newtonsoft.Json.Linq.JArray GetDealer()
{
Newtonsoft.Json.Linq.JArray data = new Newtonsoft.Json.Linq.JArray();
DataTable dt = new DataTable();
string sql = "Select DISTINCT * FROM (SELECT \"DealerName\" as \"经销商编号\",\"DealerName\" as \"经销商名称\" FROM DEALERACCEDE UNION ALL SELECT cast(\"经销商名称\" as nvarchar2(1000)) as 经销商编号, cast(\"经销商名称\" as nvarchar2(1000)) as 经销商名称 FROM in_cms.MV_H3_DEALER_OD_INFO_CN)";
dt = AppUtility.Engine.EngineConfig.CommandFactory.CreateCommand().ExecuteDataTable(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
Newtonsoft.Json.Linq.JObject ret = new Newtonsoft.Json.Linq.JObject();
ret.Add("key", dt.Rows[i]["经销商编号"].ToString());
ret.Add("value", dt.Rows[i]["经销商名称"].ToString());
data.Add(ret);
}
return(data);
}
public static string RandomSampleJson(
string json,
int?seed = null,
int maxNumberOfItems = 10)
{
Newtonsoft.Json.Linq.JToken root = (Newtonsoft.Json.Linq.JToken)Newtonsoft.Json.JsonConvert.DeserializeObject(json);
Random random = seed.HasValue ? new Random(seed.Value) : new Random();
string sampledJson;
if (root.Type == Newtonsoft.Json.Linq.JTokenType.Array)
{
Newtonsoft.Json.Linq.JArray array = (Newtonsoft.Json.Linq.JArray)root;
IEnumerable <Newtonsoft.Json.Linq.JToken> tokens = array
.OrderBy(x => random.Next())
.Take(random.Next(maxNumberOfItems));
Newtonsoft.Json.Linq.JArray newArray = new Newtonsoft.Json.Linq.JArray();
foreach (Newtonsoft.Json.Linq.JToken token in tokens)
{
newArray.Add(token);
}
sampledJson = newArray.ToString();
}
else if (root.Type == Newtonsoft.Json.Linq.JTokenType.Object)
{
Newtonsoft.Json.Linq.JObject jobject = (Newtonsoft.Json.Linq.JObject)root;
IEnumerable <Newtonsoft.Json.Linq.JProperty> properties = jobject
.Properties()
.OrderBy(x => random.Next())
.Take(maxNumberOfItems);
Newtonsoft.Json.Linq.JObject newObject = new Newtonsoft.Json.Linq.JObject();
foreach (Newtonsoft.Json.Linq.JProperty property in properties)
{
newObject.Add(property);
}
sampledJson = newObject.ToString();
}
else
{
sampledJson = json;
}
return(sampledJson);
}
public async Task CreateLogisticRegressionFromRemoteSource()
{
Client c = new Client(userName, apiKey);
Source.Arguments args = new Source.Arguments();
args.Add("remote", "https://static.bigml.com/csv/iris.csv");
args.Add("name", "C# tests - Iris");
Source s = await c.CreateSource(args);
s = await c.Wait <Source>(s.Resource);
Assert.AreEqual(s.StatusMessage.StatusCode, Code.Finished);
DataSet.Arguments argsDS = new DataSet.Arguments();
argsDS.Add("source", s.Resource);
DataSet ds = await c.CreateDataset(argsDS);
ds = await c.Wait <DataSet>(ds.Resource);
Assert.AreEqual(ds.StatusMessage.StatusCode, Code.Finished);
LogisticRegression.Arguments argsTM = new LogisticRegression.Arguments();
argsTM.Add("dataset", ds.Resource);
LogisticRegression lr = await c.CreateLogisticRegression(argsTM);
lr = await c.Wait <LogisticRegression>(lr.Resource);
// test it is finished
Assert.AreEqual(lr.StatusMessage.StatusCode, Code.Finished);
// test update method
Newtonsoft.Json.Linq.JObject changes = new Newtonsoft.Json.Linq.JObject();
Newtonsoft.Json.Linq.JArray tags = new Newtonsoft.Json.Linq.JArray();
tags.Add("Bindings C# test");
changes.Add("tags", tags);
lr = await c.Update <LogisticRegression>(lr.Resource, changes);
Assert.AreEqual(lr.Code, System.Net.HttpStatusCode.Accepted);
await c.Delete(s);
await c.Delete(ds);
await c.Delete(lr);
}
private void readJson(int month) /* 读取动画详细信息json */
{
Newtonsoft.Json.Linq.JArray jsonList1;
string url = "";
int t_month = month >= 10 ? 10 : month >= 7 ? 7 : month >= 4 ? 4 : month >= 1 ? 1 : 1;
int t_year = comboBox3.SelectedIndex == -1 ? year : Int32.Parse(comboBox3.Items[comboBox3.SelectedIndex].ToString());
foreach (archive a in archiveList)
{
if (a.year == t_year + "")
{
foreach (months m in a.months)
{
if (m.month == t_month + "")
{
url = bgmlist + m.json;
}
}
}
}
int adasd = "http://bgmlist.com/json/".Length;
jsonName = url.Substring(adasd, url.Length - adasd);
/* ** 本地json没有创建的话 */
if (System.IO.File.Exists(Path.Combine(appdataFAPI, @jsonName)))
{
readLocalJson(Path.Combine(appdataFAPI, @jsonName));
}
else
{
try
{
var pt = ProxyDetails.ProxyType;
ProxyDetails.ProxyType = (ProxyType)System.Enum.Parse(typeof(ProxyType), "None");
MyWebClient webClient = new MyWebClient();
byte[] b = webClient.DownloadData(url);
string jsonText = Encoding.UTF8.GetString(b, 0, b.Length);
Newtonsoft.Json.Linq.JObject aaaa = (Newtonsoft.Json.Linq.JObject)JsonConvert.DeserializeObject(jsonText);
jsonList1=new Newtonsoft.Json.Linq.JArray();
foreach (var item in aaaa)
{
jsonList1.Add(item.Value);
//Console.WriteLine(item.Key + item.Value);
}
//jsonList1 = (Newtonsoft.Json.Linq.JArray)JsonConvert.DeserializeObject(jsonText);
foreach (Newtonsoft.Json.Linq.JObject a in jsonList1)
{
a.Add("isOrderRabbit", "0"); /* 是否订阅 */
a.Add("episode", "01"); /* 集数 默认01 */
a.Add("searchKeyword", a["titleCN"].ToString().Replace("-", " ")); /* 搜索用关键字 默认用json提供的 */
a.Add("fansub", " "); /* 字幕组 */
a.Add("longepisode", "0"); /* 长期连载 */
a.Add("lastDate", ""); /* 上一次完成时间 */
}
useDmhyKeyword(jsonList1);
writeLocalJson(jsonList1, jsonName);
readLocalJson(Path.Combine(appdataFAPI, @jsonName));
checkBox1.Checked = false;
ProxyDetails.ProxyType = pt;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
dataGridView1.DataSource = (from a in jsonList
where Convert.ToInt32(a.weekDayCN) == day
select a).ToList(); ;
}
private Newtonsoft.Json.Linq.JToken parseField(OEIShared.IO.GFF.GFFField gffField)
{
Newtonsoft.Json.Linq.JToken j = null;
switch (gffField.Type)
{
case OEIShared.IO.GFF.GFFFieldType.Byte:
j = gffField.ValueByte;
break;
case OEIShared.IO.GFF.GFFFieldType.CExoLocString:
j = gffField.ValueCExoLocString.StringRef;
break;
case OEIShared.IO.GFF.GFFFieldType.CExoString:
j = gffField.ValueCExoString.Value;
break;
case OEIShared.IO.GFF.GFFFieldType.Char:
j = gffField.ValueChar;
break;
case OEIShared.IO.GFF.GFFFieldType.CResRef:
j = gffField.ValueCResRef.Value;
break;
case OEIShared.IO.GFF.GFFFieldType.Double:
j = gffField.ValueDouble;
break;
case OEIShared.IO.GFF.GFFFieldType.Dword:
j = gffField.ValueDword;
break;
case OEIShared.IO.GFF.GFFFieldType.Dword64:
j = gffField.ValueDword64;
break;
case OEIShared.IO.GFF.GFFFieldType.Float:
j = gffField.ValueFloat;
break;
case OEIShared.IO.GFF.GFFFieldType.GFFList:
//j = gffField.ValueList;
var a = new Newtonsoft.Json.Linq.JArray();
foreach (OEIShared.IO.GFF.GFFStruct gffStruct in gffField.ValueList.StructList)
a.Add(parseStruct(gffStruct));
j = a;
break;
case OEIShared.IO.GFF.GFFFieldType.GFFStruct:
j = parseStruct(gffField.ValueStruct);
break;
case OEIShared.IO.GFF.GFFFieldType.Int:
j = gffField.ValueInt;
break;
case OEIShared.IO.GFF.GFFFieldType.Int64:
j = gffField.ValueInt64;
break;
case OEIShared.IO.GFF.GFFFieldType.Short:
j = gffField.ValueShort;
break;
case OEIShared.IO.GFF.GFFFieldType.VoidData:
j = gffField.ValueVoidData;
break;
case OEIShared.IO.GFF.GFFFieldType.Word:
j = gffField.ValueWord;
break;
}
return j;
}
public void Deploy()
{
Console.WriteLine("");
Console.WriteLine("Deploying JSON");
Console.WriteLine("Loading Module directory " + sModulePath + "...");
DirectoryResourceRepository directoryResourceRepository = new DirectoryResourceRepository(sModulePath);
ContentManager contentManager = new ContentManager(sClientPath, sServerPath);
NWN2ResourceManager manager = new NWN2ResourceManager();
contentManager.ServerContentItemScanning += (name, status, bBegin) =>
{
if (!bBegin)
Console.Write(" -> Staging (" + status.ToString() + ")");
else
Console.Write("\nScanning: " + name);
};
contentManager.InitializeModule(directoryResourceRepository);
contentManager.ResetAllResourcesToDefaultServer();
contentManager.ResetScanResults();
checked
{
manager.AddRepository(directoryResourceRepository);
string sModuleName = Path.GetFileNameWithoutExtension(sModulePath);
string sTlkPath = "";
foreach (DownloadableResource d in contentManager.GetDownloadableResources())
{
switch (d.Type)
{
case DownloadableResource.FileType.Hak:
string hakPath = sHomePath + "\\hak\\" + d.Name;
Console.WriteLine("Adding Hak: " + d.Name);
if (File.Exists(hakPath))
manager.AddRepository(new ERFResourceRepository(hakPath));
else
Console.WriteLine("ERROR - Hak file not found in " + hakPath);
break;
case DownloadableResource.FileType.Tlk:
sTlkPath = sHomePath + "\\tlk\\" + d.Name;
if (File.Exists(sTlkPath))
Console.WriteLine("Found TLK: " + d.Name);
else
Console.WriteLine("ERROR - Tlk not found in " + sTlkPath);
break;
}
}
KeyValuePair<String, ushort>[] resourceTypes = { new KeyValuePair<String, ushort>("creature", ResUTC),
new KeyValuePair<String, ushort>("door", ResUTD),
new KeyValuePair<String, ushort>("encounter", ResUTE),
new KeyValuePair<String, ushort>("item", ResUTI),
new KeyValuePair<String, ushort>("store", ResUTM),
new KeyValuePair<String, ushort>("placeable", ResUTP),
new KeyValuePair<String, ushort>("tree", ResUTR),
new KeyValuePair<String, ushort>("sound", ResUTS),
new KeyValuePair<String, ushort>("trigger", ResUTT),
new KeyValuePair<String, ushort>("waypoint", ResUTW),
new KeyValuePair<String, ushort>("light", ResULT),
new KeyValuePair<String, ushort>("prefab", ResPFB) };
//ushort[] resourceTypes = { ResUTC, ResUTD, ResUTE, ResUTI, ResUTM, ResUTP, ResUTR, ResUTS, ResUTT, ResUTW, ResULT, ResPFB };
var json = new Newtonsoft.Json.Linq.JObject();
foreach (KeyValuePair<String, ushort> rType in resourceTypes)
{
var jsonArray = new Newtonsoft.Json.Linq.JArray();
foreach (IResourceEntry resource in manager.FindEntriesByType(rType.Value))
{
Console.WriteLine(rType.Key + ": " + resource.FullName);
var gff = new OEIShared.IO.GFF.GFFFile(resource.GetStream(false));
if (gff != null)
{
Newtonsoft.Json.Linq.JObject jsonData = null;
jsonData = new Newtonsoft.Json.Linq.JObject(parseGFF(gff));
//Console.WriteLine(jsonData);
/*
switch (rType.Value)
{
case ResUTC:
var creature = new NWN2Toolset.NWN2.Data.Blueprints.NWN2CreatureBlueprint(gff.TopLevelStruct);
jsonData = new Newtonsoft.Json.Linq.JObject(creature);
break;
case ResUTD:
var door = new NWN2Toolset.NWN2.Data.Blueprints.NWN2DoorBlueprint(gff.TopLevelStruct);
jsonData = new Newtonsoft.Json.Linq.JObject(door);
break;
case ResUTE:
var encounter = new NWN2Toolset.NWN2.Data.Blueprints.NWN2EncounterBlueprint(gff.TopLevelStruct);
jsonData = new Newtonsoft.Json.Linq.JObject(encounter);
break;
case ResUTI:
var item = new NWN2Toolset.NWN2.Data.Blueprints.NWN2ItemBlueprint(gff.TopLevelStruct);
jsonData = new Newtonsoft.Json.Linq.JObject(item);
break;
case ResUTM:
var store = new NWN2Toolset.NWN2.Data.Blueprints.NWN2StoreBlueprint(gff.TopLevelStruct);
jsonData = new Newtonsoft.Json.Linq.JObject(store);
break;
case ResUTP:
var placeable = new NWN2Toolset.NWN2.Data.Blueprints.NWN2PlaceableBlueprint(gff.TopLevelStruct);
jsonData = new Newtonsoft.Json.Linq.JObject(placeable);
break;
case ResUTR:
var tree = new NWN2Toolset.NWN2.Data.Blueprints.NWN2TreeBlueprint(gff.TopLevelStruct);
jsonData = new Newtonsoft.Json.Linq.JObject(tree);
break;
case ResUTS:
var sound = new NWN2Toolset.NWN2.Data.Blueprints.NWN2SoundBlueprint(gff.TopLevelStruct);
jsonData = new Newtonsoft.Json.Linq.JObject(sound);
break;
case ResUTT:
var trigger = new NWN2Toolset.NWN2.Data.Blueprints.NWN2TriggerBlueprint(gff.TopLevelStruct);
jsonData = new Newtonsoft.Json.Linq.JObject(trigger);
break;
case ResUTW:
var waypoint = new NWN2Toolset.NWN2.Data.Blueprints.NWN2WaypointBlueprint(gff.TopLevelStruct);
jsonData = new Newtonsoft.Json.Linq.JObject(waypoint);
break;
case ResULT:
var light = new NWN2Toolset.NWN2.Data.Blueprints.NWN2LightBlueprint(gff.TopLevelStruct);
jsonData = new Newtonsoft.Json.Linq.JObject(light);
break;
case ResPFB:
//blueprint = new NWN2Toolset.NWN2.Data.Blueprints.NWN2BlueprintSet(gff.TopLevelStruct);
break;
default:
break;
}
*/
if (jsonData != null) jsonArray.Add(jsonData);
}
}
if (jsonArray.Count > 0) json.Add(rType.Key,jsonArray);
}
Console.WriteLine("");
Console.WriteLine("Staging JSON Complete.");
Console.WriteLine("");
Console.WriteLine(json);
System.IO.File.WriteAllText(@".\nwn2.json", json.ToString());
}
}
public static void SendTemplate( string template_name, Dictionary<string, object> data, TemplateOverrides overrides = null )
{
var template_path = System.Web.HttpContext.Current.Server.MapPath(Config.Manager.Framework.Email.Template.Path);
var base_path = Path.Combine( template_path, template_name );
if( !File.Exists( Path.Combine(base_path,"config.json") ) )
throw new FileNotFoundException( "Could not find the specified config file." );
var sr_config = new StreamReader( Path.Combine(base_path,"config.json") );
var config = Newtonsoft.Json.Linq.JObject.Parse( sr_config.ReadToEnd() );
sr_config.Close();
if( !File.Exists(Path.Combine( base_path, (string)config["file"] )) )
throw new FileNotFoundException( "The file [" + (string)config["file"] + "] referenced in the template config can not be found in [" + base_path + "]." );
if( overrides != null )
{
if( !string.IsNullOrEmpty( overrides.Subject ) )
config["subject"] = overrides.Subject;
if( overrides.To != null )
{
var arr = new Newtonsoft.Json.Linq.JArray();
foreach( var to in overrides.To )
{
arr.Add(new Newtonsoft.Json.Linq.JObject(new Newtonsoft.Json.Linq.JProperty("name", to.DisplayName), new Newtonsoft.Json.Linq.JProperty("email", to.Address)));
}
config["to"] = arr;
}
if( overrides.From != null )
{
config["from"] = new Newtonsoft.Json.Linq.JObject( new Newtonsoft.Json.Linq.JProperty( "name", overrides.From.DisplayName ), new Newtonsoft.Json.Linq.JProperty( "email", overrides.From.Address ) );
}
}
if( config["vars"] != null )
{
foreach( Newtonsoft.Json.Linq.JObject o in config["vars"] )
{
string name = (string)o["name"];
string file = (string)o["file"];
string loop_over = (string)o["loop_over"];
string condition = (string)o["condition"];
if( !File.Exists( Path.Combine( base_path, file ) ) )
throw new FileNotFoundException( "The file ["+file+"] referenced in the template config can not be found in ["+base_path+"]." );
var sr_inner = new StreamReader( Path.Combine( base_path, file ) );
string inner_content = sr_inner.ReadToEnd();
sr_inner.Close();
data[name] = "";
if( !string.IsNullOrEmpty( condition ) )
{
// test condition, if true allow execution to continue, else continue
}
if( !string.IsNullOrEmpty( loop_over ) )
{
if( !data.ContainsKey( loop_over ) )
throw new ArgumentException( "The data dictionary is missing a required value called ["+loop_over+"].", "data" );
var list = data[loop_over] as IEnumerable;
if( list == null )
throw new ArgumentException( "The value called [" + loop_over + "] in the data dictionary must be castable to an IEnumerable.", "data" );
var regex_inner = new System.Text.RegularExpressions.Regex( @"\{\{([a-zA-Z0-9_\-\.]+)\}\}", System.Text.RegularExpressions.RegexOptions.IgnoreCase | System.Text.RegularExpressions.RegexOptions.Multiline | System.Text.RegularExpressions.RegexOptions.CultureInvariant );
var matches_inner = regex_inner.Matches( inner_content );
var builder = new StringBuilder();
foreach( var item in list )
{
string t_content = inner_content;
foreach( System.Text.RegularExpressions.Match m in matches_inner )
{
var orig_match = m.Value;
var group = m.Groups[1];
var parts = group.Value.Split( '.' );
if( parts[0] == "Item" )
t_content = t_content.Replace( orig_match, GetValue( item, parts, orig_match, 1 ) );
else
t_content = t_content.Replace( orig_match, GetValue( data[parts[0]], parts, orig_match, 1 ) );
}
builder.AppendLine( t_content );
}
inner_content = builder.ToString();
}
data[name] = inner_content;
}
}
var sr = new StreamReader( Path.Combine( base_path, (string)config["file"] ) );
string content = sr.ReadToEnd();
sr.Close();
var regex = new System.Text.RegularExpressions.Regex( @"\{\{([a-zA-Z0-9_\-\.]+)\}\}", System.Text.RegularExpressions.RegexOptions.IgnoreCase | System.Text.RegularExpressions.RegexOptions.Multiline | System.Text.RegularExpressions.RegexOptions.CultureInvariant );
var matches = regex.Matches( content );
foreach( System.Text.RegularExpressions.Match m in matches )
{
var orig_match = m.Value;
var group = m.Groups[1];
var parts = group.Value.Split( '.' );
content = content.Replace( orig_match, GetValue(data[parts[0]], parts, orig_match, 1) );
}
// MJL 2014-01-13 - If you use the "To" field in the overrides, then the config["to"] is an array
// the original code seems to assume it's not a collection. I've added a simple check to see
// if the object is a collection, of so, loop.
if(!(config["to"] is ICollection))
SendEmail((string)(config["to"]["email"]), (string)(config["subject"]), content, (string)(config["from"]["email"]), (string)(config["from"]["name"]));
else
foreach(var item in config["to"])
SendEmail((string)(item["email"]), (string)(config["subject"]), content, (string)(config["from"]["email"]), (string)(config["from"]["name"]));
}
public static TradeRecordsCommand createTradeRecordsCommand(LinkedList<long?> orders, bool prettyPrint)
{
JSONObject args = new JSONObject();
JSONArray arr = new JSONArray();
foreach (long? order in orders)
{
arr.Add(order);
}
args.Add("orders", arr);
return new TradeRecordsCommand(args, prettyPrint);
}
public static TradingHoursCommand createTradingHoursCommand(LinkedList<string> symbols, bool prettyPrint)
{
JSONObject args = new JSONObject();
JSONArray arr = new JSONArray();
foreach (string symbol in symbols)
{
arr.Add(symbol);
}
args.Add("symbols", arr);
return new TradingHoursCommand(args, prettyPrint);
}
public ActionResult Create()
{
int contactId = -1;
ViewModels.Tasks.CreateTaskViewModel viewModel;
Common.Models.Matters.Matter matter;
List<ViewModels.Account.UsersViewModel> userList;
List<ViewModels.Contacts.ContactViewModel> employeeContactList;
Newtonsoft.Json.Linq.JArray taskTemplates;
userList = new List<ViewModels.Account.UsersViewModel>();
employeeContactList = new List<ViewModels.Contacts.ContactViewModel>();
dynamic profile = ProfileBase.Create(Membership.GetUser().UserName);
if (profile.ContactId != null && !string.IsNullOrEmpty(profile.ContactId))
contactId = int.Parse(profile.ContactId);
using (IDbConnection conn = Data.Database.Instance.GetConnection())
{
Data.Account.Users.List(conn, false).ForEach(x =>
{
userList.Add(Mapper.Map<ViewModels.Account.UsersViewModel>(x));
});
Data.Contacts.Contact.ListEmployeesOnly(conn, false).ForEach(x =>
{
employeeContactList.Add(Mapper.Map<ViewModels.Contacts.ContactViewModel>(x));
});
viewModel = new ViewModels.Tasks.CreateTaskViewModel();
viewModel.TaskTemplates = new List<ViewModels.Tasks.TaskTemplateViewModel>();
taskTemplates = new Newtonsoft.Json.Linq.JArray();
Data.Tasks.TaskTemplate.List(conn, false).ForEach(x =>
{
viewModel.TaskTemplates.Add(Mapper.Map<ViewModels.Tasks.TaskTemplateViewModel>(x));
Newtonsoft.Json.Linq.JObject template = new Newtonsoft.Json.Linq.JObject();
template.Add(new Newtonsoft.Json.Linq.JProperty("Id", x.Id.Value));
template.Add(new Newtonsoft.Json.Linq.JProperty("TaskTemplateTitle", x.TaskTemplateTitle));
template.Add(new Newtonsoft.Json.Linq.JProperty("Title", x.Title));
template.Add(new Newtonsoft.Json.Linq.JProperty("Description", x.Description));
template.Add(new Newtonsoft.Json.Linq.JProperty("ProjectedStart", DTProp(x.ProjectedStart)));
template.Add(new Newtonsoft.Json.Linq.JProperty("DueDate", DTProp(x.DueDate)));
template.Add(new Newtonsoft.Json.Linq.JProperty("ProjectedEnd", DTProp(x.ProjectedEnd)));
template.Add(new Newtonsoft.Json.Linq.JProperty("ActualEnd", DTProp(x.ActualEnd)));
template.Add(new Newtonsoft.Json.Linq.JProperty("Active", x.Active));
taskTemplates.Add(template);
});
if (contactId > 0)
{
viewModel.TaskContact = new ViewModels.Tasks.TaskAssignedContactViewModel()
{
Contact = new ViewModels.Contacts.ContactViewModel()
{
Id = contactId
}
};
}
matter = Data.Matters.Matter.Get(Guid.Parse(Request["MatterId"]), conn, false);
}
ViewBag.Matter = matter;
ViewBag.UserList = userList;
ViewBag.EmployeeContactList = employeeContactList;
ViewBag.TemplateJson = taskTemplates.ToString();
return View(new ViewModels.Tasks.CreateTaskViewModel()
{
TaskTemplates = viewModel.TaskTemplates,
TaskContact = new ViewModels.Tasks.TaskAssignedContactViewModel()
{
AssignmentType = ViewModels.AssignmentTypeViewModel.Direct,
Contact = viewModel.TaskContact.Contact
}
});
}
public static TickPricesCommand createTickPricesCommand(LinkedList<string> symbols, long? timestamp, bool prettyPrint)
{
JSONObject args = new JSONObject();
JSONArray arr = new JSONArray();
foreach (string symbol in symbols)
{
arr.Add(symbol);
}
args.Add("symbols", arr);
args.Add("timestamp", timestamp);
return new TickPricesCommand(args, prettyPrint);
}
