public ActionResult Index(FormCollection collection)
{
RoadFlow.Platform.WorkFlowComment workFlowComment = new RoadFlow.Platform.WorkFlowComment();
RoadFlow.Platform.Organize organize = new RoadFlow.Platform.Organize();
IEnumerable <RoadFlow.Data.Model.WorkFlowComment> source = workFlowComment.GetAll();
if ("1" == base.Request.QueryString["isoneself"])
{
source = from p in source
where p.MemberID == "u_" + RoadFlow.Platform.Users.CurrentUserID.ToString()
select p;
}
JsonData jsonData = new JsonData();
foreach (RoadFlow.Data.Model.WorkFlowComment item in from p in source
orderby p.Type, p.Sort
select p)
{
JsonData jsonData2 = new JsonData();
jsonData2["id"] = item.ID.ToString();
jsonData2["Comment"] = item.Comment;
jsonData2["MemberID"] = (item.MemberID.IsNullOrEmpty() ? "所有人员" : organize.GetNames(item.MemberID));
jsonData2["Type"] = ((item.Type == 0) ? "管理员" : "个人");
jsonData2["Sort"] = item.Sort;
jsonData2["Opation"] = "<a class=\"editlink\" href=\"javascript:edit('" + item.ID.ToString() + "');\">编辑</a>";
jsonData.Add(jsonData2);
}
base.ViewBag.list = jsonData.ToJson();
return(View());
}
public string Query()
{
RoadFlow.Platform.HomeItems homeItems = new RoadFlow.Platform.HomeItems();
RoadFlow.Platform.Organize organize = new RoadFlow.Platform.Organize();
new List <RoadFlow.Data.Model.HomeItems>();
string name = base.Request.Form["Name1"];
string title = base.Request.Form["Title1"];
string type = base.Request.Form["Type"];
string text = base.Request.Form["sidx"];
string text2 = base.Request.Form["sord"];
int pageSize = Tools.GetPageSize();
int pageNumber = Tools.GetPageNumber();
string order = (text.IsNullOrEmpty() ? "Type" : text) + " " + (text2.IsNullOrEmpty() ? "asc" : text2);
long count;
List <RoadFlow.Data.Model.HomeItems> list = homeItems.GetList(out count, pageSize, pageNumber, name, title, type, order);
JsonData jsonData = new JsonData();
foreach (RoadFlow.Data.Model.HomeItems item in list)
{
StringBuilder stringBuilder = new StringBuilder();
if (!item.Ico.IsNullOrEmpty())
{
if (item.Ico.IsFontIco())
{
stringBuilder.Append("<i class='fa " + item.Ico + "' style='font-size:14px;vertical-align:middle;margin-right:3px;'></i>");
}
else
{
stringBuilder.Append("<img src='" + base.Url.Content("~" + item.Ico) + "' style='vertical-align:middle;margin-right:3px;'/>");
}
}
stringBuilder.Append(item.Title);
JsonData jsonData2 = new JsonData();
jsonData2["id"] = item.ID.ToString();
jsonData2["Name"] = item.Name;
jsonData2["Title"] = stringBuilder.ToString();
jsonData2["Type"] = homeItems.GetTypeTitle(item.Type);
jsonData2["DataSourceType"] = homeItems.GetDataSourceTitle(item.DataSourceType);
jsonData2["UseOrganizes"] = organize.GetNames(item.UseOrganizes);
jsonData2["Note"] = item.Note;
jsonData2["Opation"] = "<a class=\"editlink\" href=\"javascript:void(0);\" onclick=\"edit('" + item.ID + "');return false;\">编辑</a>";
jsonData.Add(jsonData2);
}
return("{\"userdata\":{\"total\":" + count + ",\"pagesize\":" + pageSize + ",\"pagenumber\":" + pageNumber + "},\"rows\":" + jsonData.ToJson() + "}");
}
public bool HasUse(Guid menuID, Guid userID, List <RoadFlow.Data.Model.MenuUser> menuusers, out string source, out string params1, bool showSource = false)
{
source = string.Empty;
params1 = string.Empty;
List <RoadFlow.Data.Model.MenuUser> list = menuusers.FindAll(delegate(RoadFlow.Data.Model.MenuUser p)
{
if (p.MenuID == menuID && p.SubPageID == Guid.Empty)
{
return(p.Users.Contains(userID.ToString(), StringComparison.CurrentCultureIgnoreCase));
}
return(false);
});
if (list.Count > 0)
{
StringBuilder stringBuilder = new StringBuilder();
foreach (RoadFlow.Data.Model.MenuUser item in list)
{
stringBuilder.Append(item.Organizes);
stringBuilder.Append(",");
if (!item.Params.IsNullOrEmpty())
{
params1 = item.Params;
}
}
Organize organize = new Organize();
source = organize.GetNames(stringBuilder.ToString().TrimEnd(','));
StringBuilder stringBuilder2 = new StringBuilder();
foreach (IGrouping <string, RoadFlow.Data.Model.MenuUser> item2 in from p in list.FindAll((RoadFlow.Data.Model.MenuUser p) => !p.Params.IsNullOrEmpty())
group p by p.Params)
{
stringBuilder2.Append(item2.Key.Trim1());
stringBuilder2.Append("&");
}
params1 = stringBuilder2.ToString().TrimEnd('&');
return(true);
}
return(false);
}
public DataTable GetExportDataTable(Guid programID, out string template, out string headerText, out string fileName)
{
template = "";
headerText = "";
fileName = "";
ProgramBuilderCache set = this.GetSet(programID);
if (set == null)
{
return(new DataTable());
}
template = Files.FilePath + set.Program.ExportTemplate.DesDecrypt();
headerText = set.Program.ExportHeaderText;
fileName = set.Program.ExportFileName;
string querySql;
List <IDbDataParameter> parList;
DataTable dataTable1 = new DBConnection().GetDataTable(this.GetExportCache(programID, out querySql, out parList), querySql, (IDataParameter[])parList.ToArray());
List <RoadFlow.Data.Model.ProgramBuilderExport> export = set.Export;
DataTable dataTable2 = new DataTable();
foreach (RoadFlow.Data.Model.ProgramBuilderExport programBuilderExport in export)
{
string showTitle = programBuilderExport.ShowTitle;
int? nullable = programBuilderExport.DataType;
int type;
if (!nullable.HasValue)
{
type = 0;
}
else
{
nullable = programBuilderExport.DataType;
type = nullable.Value;
}
Type exportColumnsType = this.GetExportColumnsType(type);
DataColumn column = new DataColumn(showTitle, exportColumnsType);
DataColumn dataColumn = column;
nullable = programBuilderExport.Width;
string str = nullable.ToString();
dataColumn.Caption = str;
dataTable2.Columns.Add(column);
}
int num = 1;
Dictionary dictionary = new Dictionary();
Organize organize = new Organize();
foreach (DataRow row1 in (InternalDataCollectionBase)dataTable1.Rows)
{
DataRow row2 = dataTable2.NewRow();
foreach (RoadFlow.Data.Model.ProgramBuilderExport programBuilderExport in export)
{
object empty = (object)string.Empty;
object obj1 = programBuilderExport.Field.IsNullOrEmpty() ? (object)"" : row1[programBuilderExport.Field];
int? showType = programBuilderExport.ShowType;
object obj2;
if (showType.HasValue)
{
switch (showType.GetValueOrDefault())
{
case 0:
obj2 = obj1;
goto label_24;
case 1:
obj2 = (object)num.ToString();
goto label_24;
case 2:
obj2 = (object)obj1.ToString().ToDateTime().ToString(programBuilderExport.ShowFormat);
goto label_24;
case 3:
obj2 = (object)obj1.ToString().ToDecimal().ToString(programBuilderExport.ShowFormat);
goto label_24;
case 4:
obj2 = (object)dictionary.GetTitle(obj1.ToString().ToGuid());
goto label_24;
case 5:
obj2 = (object)organize.GetNames(obj1.ToString(), ",");
goto label_24;
case 6:
obj2 = (object)programBuilderExport.CustomString;
goto label_24;
}
}
obj2 = obj1;
label_24:
row2[programBuilderExport.ShowTitle] = obj2;
}
++num;
dataTable2.Rows.Add(row2);
}
return(dataTable2);
}
public DataTable GetExportDataTable(Guid programID, out string template, out string headerText, out string fileName)
{
template = "";
headerText = "";
fileName = "";
ProgramBuilderCache set = GetSet(programID);
if (set == null)
{
return(new DataTable());
}
template = Files.FilePath + set.Program.ExportTemplate.DesDecrypt();
headerText = set.Program.ExportHeaderText;
fileName = set.Program.ExportFileName;
string querySql;
List <IDbDataParameter> parList;
Guid exportCache = GetExportCache(programID, out querySql, out parList);
DBConnection dBConnection = new DBConnection();
Guid connID = exportCache;
string sql = querySql;
IDataParameter[] param = parList.ToArray();
DataTable dataTable = dBConnection.GetDataTable(connID, sql, param);
List <RoadFlow.Data.Model.ProgramBuilderExport> export = set.Export;
DataTable dataTable2 = new DataTable();
foreach (RoadFlow.Data.Model.ProgramBuilderExport item in export)
{
DataColumn dataColumn = new DataColumn(item.ShowTitle, GetExportColumnsType(item.DataType.HasValue ? item.DataType.Value : 0));
dataColumn.Caption = item.Width.ToString();
dataTable2.Columns.Add(dataColumn);
}
int num = 1;
Dictionary dictionary = new Dictionary();
Organize organize = new Organize();
foreach (DataRow row in dataTable.Rows)
{
DataRow dataRow2 = dataTable2.NewRow();
foreach (RoadFlow.Data.Model.ProgramBuilderExport item2 in export)
{
object empty = string.Empty;
object obj = item2.Field.IsNullOrEmpty() ? "" : row[item2.Field];
switch (item2.ShowType)
{
case 0:
empty = obj;
break;
case 1:
empty = num.ToString();
break;
case 2:
empty = obj.ToString().ToDateTime().ToString(item2.ShowFormat);
break;
case 3:
empty = obj.ToString().ToDecimal().ToString(item2.ShowFormat);
break;
case 4:
empty = dictionary.GetTitle(obj.ToString().ToGuid());
break;
case 5:
empty = organize.GetNames(obj.ToString());
break;
case 6:
empty = item2.CustomString;
break;
default:
empty = obj;
break;
}
dataRow2[item2.ShowTitle] = empty;
}
num++;
dataTable2.Rows.Add(dataRow2);
}
return(dataTable2);
}
