|
|
using System;
|
|
|
using System.Data;
|
|
|
using BP.DA;
|
|
|
using BP.En;
|
|
|
using System.Text.RegularExpressions;
|
|
|
using BP.CCFast.Portal.WindowExt;
|
|
|
|
|
|
namespace BP.CCFast.Portal
|
|
|
{
|
|
|
/// <summary>
|
|
|
/// 信息块
|
|
|
/// </summary>
|
|
|
public class WindowTemplateAttr : EntityNoNameAttr
|
|
|
{
|
|
|
/// <summary>
|
|
|
/// 信息块类型
|
|
|
/// </summary>
|
|
|
public const string Icon = "Icon";
|
|
|
/// <summary>
|
|
|
/// 顺序
|
|
|
/// </summary>
|
|
|
public const string Idx = "Idx";
|
|
|
/// <summary>
|
|
|
/// 标题
|
|
|
/// </summary>
|
|
|
public const string Docs = "Docs";
|
|
|
/// <summary>
|
|
|
/// 要弃用了
|
|
|
/// </summary>
|
|
|
public const string WinDocType = "WinDocType";
|
|
|
/// <summary>
|
|
|
/// 模式
|
|
|
/// </summary>
|
|
|
public const string WinDocModel = "WinDocModel";
|
|
|
/// <summary>
|
|
|
/// tag1
|
|
|
/// </summary>
|
|
|
public const string ColSpan = "ColSpan";
|
|
|
/// <summary>
|
|
|
/// Tag2
|
|
|
/// </summary>
|
|
|
public const string MoreLinkModel = "MoreLinkModel";
|
|
|
/// <summary>
|
|
|
/// PopW
|
|
|
/// </summary>
|
|
|
public const string PopW = "PopW";
|
|
|
public const string PopH = "PopH";
|
|
|
/// <summary>
|
|
|
/// 风格，比如Tab风格, table风格等.
|
|
|
/// </summary>
|
|
|
public const string Style = "Style";
|
|
|
/// <summary>
|
|
|
/// 是否可删除
|
|
|
/// </summary>
|
|
|
public const string IsDel = "IsDel";
|
|
|
/// <summary>
|
|
|
/// 控制方式
|
|
|
/// </summary>
|
|
|
public const string CtrlWay = "CtrlWay";
|
|
|
/// <summary>
|
|
|
/// 打开方式
|
|
|
/// </summary>
|
|
|
public const string OpenWay = "OpenWay";
|
|
|
/// <summary>
|
|
|
/// 更多标签
|
|
|
/// </summary>
|
|
|
public const string MoreLab = "MoreLab";
|
|
|
/// <summary>
|
|
|
/// MoreUrl
|
|
|
/// </summary>
|
|
|
public const string MoreUrl = "MoreUrl";
|
|
|
/// <summary>
|
|
|
/// 产生时间
|
|
|
/// </summary>
|
|
|
public const string DocGenerRDT = "DocGenerRDT";
|
|
|
/// <summary>
|
|
|
/// 是否独占一行
|
|
|
/// </summary>
|
|
|
public const string IsEnable = "IsEnable";
|
|
|
/// <summary>
|
|
|
/// 组织编号
|
|
|
/// </summary>
|
|
|
public const string OrgNo = "OrgNo";
|
|
|
/// <summary>
|
|
|
/// 页面ID.
|
|
|
/// </summary>
|
|
|
public const string PageID = "PageID";
|
|
|
|
|
|
public const string DefaultChart = "DefaultChart";
|
|
|
|
|
|
public const string C1Ens = "C1Ens";
|
|
|
public const string C2Ens = "C2Ens";
|
|
|
public const string C3Ens = "C3Ens";
|
|
|
|
|
|
|
|
|
#region 数据源
|
|
|
public const string DBType = "DBType";
|
|
|
public const string DBSrc = "DBSrc";
|
|
|
public const string DBExp0 = "DBExp0";
|
|
|
public const string DBExp1 = "DBExp1";
|
|
|
public const string DBExp2 = "DBExp2";
|
|
|
|
|
|
/// <summary>
|
|
|
/// 显示类型
|
|
|
/// </summary>
|
|
|
public const string WindowsShowType = "WindowsShowType";
|
|
|
#endregion 数据源
|
|
|
|
|
|
#region 百分比扇形图
|
|
|
public const string LabOfFZ = "LabOfFZ";
|
|
|
public const string SQLOfFZ = "SQLOfFZ";
|
|
|
public const string LabOfFM = "LabOfFM";
|
|
|
public const string SQLOfFM = "SQLOfFM";
|
|
|
public const string LabOfRate = "LabOfRate";
|
|
|
#endregion 百分比扇形图
|
|
|
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 信息块
|
|
|
/// </summary>
|
|
|
public class WindowTemplate : EntityNoName
|
|
|
{
|
|
|
#region 权限控制.
|
|
|
/// <summary>
|
|
|
/// 控制权限
|
|
|
/// </summary>
|
|
|
public override UAC HisUAC
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
UAC uac = new UAC();
|
|
|
if (BP.Web.WebUser.IsAdmin == true)
|
|
|
uac.OpenAll();
|
|
|
else
|
|
|
uac.IsView = false;
|
|
|
return uac;
|
|
|
}
|
|
|
}
|
|
|
#endregion 权限控制.
|
|
|
|
|
|
#region 属性
|
|
|
/// <summary>
|
|
|
/// 窗口模式
|
|
|
/// </summary>
|
|
|
public string WinDocModel
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValStringByKey(WindowTemplateAttr.WinDocModel);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(WindowTemplateAttr.WinDocModel, value);
|
|
|
}
|
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
|
/// 更多的URL
|
|
|
/// </summary>
|
|
|
public string MoreUrl
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValStrByKey(WindowTemplateAttr.MoreUrl);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(WindowTemplateAttr.MoreUrl, value);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 更多标签
|
|
|
/// </summary>
|
|
|
public string MoreLab
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValStrByKey(WindowTemplateAttr.MoreLab);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(WindowTemplateAttr.MoreLab, value);
|
|
|
}
|
|
|
}
|
|
|
public int PopW
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValIntByKey(WindowTemplateAttr.PopW);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(WindowTemplateAttr.PopW, value);
|
|
|
}
|
|
|
}
|
|
|
public int PopH
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValIntByKey(WindowTemplateAttr.PopH);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(WindowTemplateAttr.PopH, value);
|
|
|
}
|
|
|
}
|
|
|
public int ColSpan
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValIntByKey(WindowTemplateAttr.ColSpan);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(WindowTemplateAttr.ColSpan, value);
|
|
|
}
|
|
|
}
|
|
|
public int MoreLinkModel
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValIntByKey(WindowTemplateAttr.MoreLinkModel);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(WindowTemplateAttr.MoreLinkModel, value);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 标题
|
|
|
/// </summary>
|
|
|
|
|
|
/// <summary>
|
|
|
/// 用户是否可以删除
|
|
|
/// </summary>
|
|
|
public bool ItIsDel
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValBooleanByKey(WindowTemplateAttr.IsDel);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(WindowTemplateAttr.IsDel, value);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 是否禁用?
|
|
|
/// </summary>
|
|
|
public bool ItIsEnable
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValBooleanByKey(WindowTemplateAttr.IsEnable);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(WindowTemplateAttr.IsEnable, value);
|
|
|
}
|
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
|
/// 打开方式
|
|
|
/// </summary>
|
|
|
public int OpenWay
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValIntByKey(WindowTemplateAttr.OpenWay);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(WindowTemplateAttr.OpenWay, value);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 顺序号
|
|
|
/// </summary>
|
|
|
public int Idx
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValIntByKey(WindowTemplateAttr.Idx);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(WindowTemplateAttr.Idx, value);
|
|
|
}
|
|
|
}
|
|
|
public string DocGenerRDT
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValStrByKey(WindowTemplateAttr.DocGenerRDT);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(WindowTemplateAttr.DocGenerRDT, value);
|
|
|
}
|
|
|
}
|
|
|
public string PageID
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValStrByKey(WindowTemplateAttr.PageID);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(WindowTemplateAttr.PageID, value);
|
|
|
}
|
|
|
}
|
|
|
public string Docs
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValStrByKey(WindowTemplateAttr.Docs);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(WindowTemplateAttr.Docs, value);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 获取参数化的字符串
|
|
|
/// </summary>
|
|
|
/// <param name="stringInput"></param>
|
|
|
/// <param name="dr"></param>
|
|
|
/// <returns></returns>
|
|
|
private string GetParameteredString(string stringInput, DataRow dr)
|
|
|
{
|
|
|
String regE = "@[a-zA-Z]([\\w-]*[a-zA-Z0-9])?"; //字母开始，字母+数字结尾，字母+数字+下划线+中划线中间
|
|
|
//String regE = "@[\\w-]+"; //字母+数字+下划线+中划线
|
|
|
MatchCollection mc = Regex.Matches(stringInput, regE, RegexOptions.IgnoreCase);
|
|
|
foreach (Match m in mc)
|
|
|
{
|
|
|
string v = m.Value;
|
|
|
string f = m.Value.Substring(1);
|
|
|
stringInput = stringInput.Replace(v, String.Format("{0}", dr[f]));
|
|
|
}
|
|
|
return stringInput;
|
|
|
}
|
|
|
#endregion
|
|
|
|
|
|
#region 构造方法
|
|
|
/// <summary>
|
|
|
/// 信息块
|
|
|
/// </summary>
|
|
|
public WindowTemplate()
|
|
|
{
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 信息块
|
|
|
/// </summary>
|
|
|
/// <param name="no"></param>
|
|
|
public WindowTemplate(string no)
|
|
|
{
|
|
|
this.No = no;
|
|
|
this.Retrieve();
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// EnMap
|
|
|
/// </summary>
|
|
|
public override Map EnMap
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
if (this._enMap != null)
|
|
|
return this._enMap;
|
|
|
|
|
|
Map map = new Map("GPM_WindowTemplate", "信息块");
|
|
|
map.setEnType(EnType.Sys);
|
|
|
|
|
|
#region 基本信息.
|
|
|
map.AddTBStringPK(WindowTemplateAttr.No, null, "编号", true, true, 1, 40, 100);
|
|
|
map.AddTBString(WindowTemplateAttr.Name, null, "标题", true, false, 0, 300, 20, true);
|
|
|
|
|
|
map.AddTBInt(WindowTemplateAttr.ColSpan, 1, "占的列数", true, false);
|
|
|
map.SetHelperAlert(WindowTemplateAttr.ColSpan, "画布按照4列划分布局，输入的输在在1=4之间.");
|
|
|
|
|
|
map.AddTBString(WindowTemplateAttr.WinDocModel, null, "内容类型", true, false, 0, 300, 20, true);
|
|
|
map.AddTBString(WindowTemplateAttr.Icon, null, "Icon", true, false, 0, 100, 20, true);
|
|
|
map.AddTBString(WindowTemplateAttr.PageID, null, "页面ID", true, true, 0, 40, 20, false);
|
|
|
#endregion 基本信息.
|
|
|
|
|
|
// map.AddDDLSysEnum(WindowTemplateAttr.ColSpan, 1, "占的列数", true, true, WindowTemplateAttr.ColSpan,
|
|
|
// "@1=1列@2=2列@3=覆盖新窗口");
|
|
|
|
|
|
#region 更多的信息定义.
|
|
|
map.AddTBString(WindowTemplateAttr.MoreLab, null, "更多标签", false, false, 0, 300, 20, true);
|
|
|
map.AddTBString(WindowTemplateAttr.MoreUrl, null, "更多链接", false, false, 0, 300, 20, true);
|
|
|
map.AddDDLSysEnum(WindowTemplateAttr.MoreLinkModel, 0, "打开方式", false, false, WindowTemplateAttr.MoreLinkModel,
|
|
|
"@0=新窗口@1=本窗口@2=覆盖新窗口");
|
|
|
map.AddTBInt(WindowTemplateAttr.PopW, 500, "Pop宽度", false, true);
|
|
|
map.AddTBInt(WindowTemplateAttr.PopH, 400, "Pop高度", false, true);
|
|
|
#endregion 更多的信息定义.
|
|
|
|
|
|
#region 内容定义.
|
|
|
map.AddTBString(WindowTemplateAttr.MoreUrl, null, "更多链接", false, false, 0, 300, 20, true);
|
|
|
map.AddTBStringDoc(WindowTemplateAttr.Docs, null, "内容表达式", true, false);
|
|
|
#endregion 内容定义.
|
|
|
|
|
|
#region 权限定义.
|
|
|
// 0=Html , 1=SQL列表
|
|
|
// map.AddTBInt(WindowTemplateAttr.WinDocModel, 0, "内容类型", false, true);
|
|
|
// map.AddTBString(WindowTemplateAttr.Docs, null, "内容", true, false, 0, 4000, 20);
|
|
|
#endregion 权限定义.
|
|
|
|
|
|
#region 其他
|
|
|
map.AddTBInt(WindowTemplateAttr.Idx, 0, "默认的排序", false, false);
|
|
|
map.AddBoolean(WindowTemplateAttr.IsDel, true, "用户是否可删除", false, false);
|
|
|
map.AddBoolean(WindowTemplateAttr.IsEnable, false, "是否禁用?", false, false);
|
|
|
map.AddTBString(WindowTemplateAttr.OrgNo, null, "OrgNo", false, false, 0, 50, 20);
|
|
|
#endregion 其他
|
|
|
|
|
|
#region 扇形图
|
|
|
|
|
|
map.AddTBString(WindowTemplateAttr.LabOfFZ, null, "分子标签", true, false, 0, 100, 20);
|
|
|
map.AddTBStringDoc(WindowTemplateAttr.SQLOfFZ, null, "分子表达式", true, false, true);
|
|
|
|
|
|
map.AddTBString(WindowTemplateAttr.LabOfFM, null, "分母标签", true, false, 0, 100, 20);
|
|
|
map.AddTBStringDoc(WindowTemplateAttr.SQLOfFM, null, "分子表达式", true, false, true);
|
|
|
map.AddTBString(WindowTemplateAttr.LabOfRate, null, "率标签", true, false, 0, 100, 20);
|
|
|
#endregion 扇形图
|
|
|
|
|
|
|
|
|
#region 多图形展示.
|
|
|
|
|
|
map.AddBoolean("IsPie", false, "饼图?", true, true);
|
|
|
map.AddBoolean("IsLine", false, "折线图?", true, true);
|
|
|
map.AddBoolean("IsZZT", false, "柱状图?", true, true);
|
|
|
map.AddBoolean("IsRing", false, "显示环形图?", true, true);
|
|
|
map.AddBoolean("IsRate", false, "百分比扇形图?", true, true);
|
|
|
|
|
|
map.AddDDLSysEnum(WindowTemplateAttr.DefaultChart, 0, "默认显示图形", true, true, WindowTemplateAttr.DefaultChart,
|
|
|
"@0=饼图@1=折线图@2=柱状图@3=显示环形图");
|
|
|
|
|
|
#endregion 多图形展示.
|
|
|
|
|
|
|
|
|
|
|
|
this._enMap = map;
|
|
|
return this._enMap;
|
|
|
}
|
|
|
}
|
|
|
#endregion
|
|
|
|
|
|
protected override bool beforeInsert()
|
|
|
{
|
|
|
this.No = DBAccess.GenerGUID();
|
|
|
if (DataType.IsNullOrEmpty(this.PageID) == true)
|
|
|
this.PageID = "Home";
|
|
|
return base.beforeInsert();
|
|
|
}
|
|
|
|
|
|
protected override void afterDelete()
|
|
|
{
|
|
|
//删除它的实例.
|
|
|
Windows ens = new Windows();
|
|
|
ens.Delete(WindowAttr.WindowTemplateNo, this.No);
|
|
|
|
|
|
base.afterDelete();
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 信息块s
|
|
|
/// </summary>
|
|
|
public class WindowTemplates : EntitiesNoName
|
|
|
{
|
|
|
#region 构造
|
|
|
/// <summary>
|
|
|
/// 信息块s
|
|
|
/// </summary>
|
|
|
public WindowTemplates()
|
|
|
{
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 得到它的 Entity
|
|
|
/// </summary>
|
|
|
public override Entity GetNewEntity
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return new WindowTemplate();
|
|
|
}
|
|
|
}
|
|
|
#endregion
|
|
|
|
|
|
#region 为了适应自动翻译成java的需要,把实体转换成List.
|
|
|
/// <summary>
|
|
|
/// 转化成 java list,C#不能调用.
|
|
|
/// </summary>
|
|
|
/// <returns>List</returns>
|
|
|
public System.Collections.Generic.IList<WindowTemplate> ToJavaList()
|
|
|
{
|
|
|
return (System.Collections.Generic.IList<WindowTemplate>)this;
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 转化成list
|
|
|
/// </summary>
|
|
|
/// <returns>List</returns>
|
|
|
public System.Collections.Generic.List<WindowTemplate> Tolist()
|
|
|
{
|
|
|
System.Collections.Generic.List<WindowTemplate> list = new System.Collections.Generic.List<WindowTemplate>();
|
|
|
for (int i = 0; i < this.Count; i++)
|
|
|
{
|
|
|
list.Add((WindowTemplate)this[i]);
|
|
|
}
|
|
|
return list;
|
|
|
}
|
|
|
#endregion 为了适应自动翻译成java的需要,把实体转换成List.
|
|
|
|
|
|
public void InitDocs()
|
|
|
{
|
|
|
//处理内容.
|
|
|
foreach (WindowTemplate item in this)
|
|
|
{
|
|
|
//文本的, 不用转化.
|
|
|
if (item.WinDocModel.Equals(WinDocModel.Html))
|
|
|
continue;
|
|
|
|
|
|
//内置的.
|
|
|
if (item.WinDocModel.Equals(WinDocModel.System))
|
|
|
{
|
|
|
string exp = item.Docs;
|
|
|
exp = BP.WF.Glo.DealExp(exp, null);
|
|
|
item.Docs = exp;
|
|
|
continue;
|
|
|
}
|
|
|
|
|
|
//HtmlVar 变量字段.
|
|
|
if (item.WinDocModel.Equals(WinDocModel.HtmlVar))
|
|
|
{
|
|
|
HtmlVarDtls dtls = new HtmlVarDtls();
|
|
|
dtls.Retrieve(DtlAttr.RefPK, item.No);
|
|
|
|
|
|
foreach (HtmlVarDtl dtl in dtls)
|
|
|
{
|
|
|
string sql = dtl.Exp0;
|
|
|
sql = sql.Replace("~", "'");
|
|
|
sql = BP.WF.Glo.DealExp(sql, null);
|
|
|
try
|
|
|
{
|
|
|
dtl.Exp0 = DBAccess.RunSQLReturnStringIsNull(sql, "0");
|
|
|
}
|
|
|
catch (Exception ex)
|
|
|
{
|
|
|
dtl.Exp0 = "err@" + ex.Message;
|
|
|
}
|
|
|
}
|
|
|
item.Docs = dtls.ToJson();
|
|
|
continue;
|
|
|
}
|
|
|
|
|
|
//tab 标签页.
|
|
|
if (item.WinDocModel.Equals(WinDocModel.Tab))
|
|
|
{
|
|
|
TabDtls dtls = new TabDtls();
|
|
|
dtls.Retrieve(DtlAttr.RefPK, item.No);
|
|
|
|
|
|
foreach (TabDtl dtl in dtls)
|
|
|
{
|
|
|
string sql = dtl.Exp0;
|
|
|
sql = sql.Replace("~", "'");
|
|
|
sql = BP.WF.Glo.DealExp(sql, null);
|
|
|
try
|
|
|
{
|
|
|
DataTable dt = DBAccess.RunSQLReturnTable(sql);
|
|
|
dtl.Exp0 = BP.Tools.Json.ToJson(dt); // DBAccess.RunSQLReturnStringIsNull(sql, "0");
|
|
|
}
|
|
|
catch (Exception ex)
|
|
|
{
|
|
|
dtl.Exp0 = "err@" + ex.Message;
|
|
|
}
|
|
|
}
|
|
|
item.Docs = dtls.ToJson();
|
|
|
continue;
|
|
|
}
|
|
|
|
|
|
|
|
|
#region 扇形百分比.
|
|
|
if (item.WinDocModel.Equals(WinDocModel.ChartRate)) //sql列表.
|
|
|
{
|
|
|
try
|
|
|
{
|
|
|
//分子.
|
|
|
string sql = item.GetValStringByKey(WindowTemplateAttr.SQLOfFZ);
|
|
|
sql = sql.Replace("~", "'");
|
|
|
sql = BP.WF.Glo.DealExp(sql, null);
|
|
|
string val = DBAccess.RunSQLReturnString(sql);
|
|
|
item.SetValByKey(WindowTemplateAttr.SQLOfFZ, val);
|
|
|
|
|
|
//分母.
|
|
|
sql = item.GetValStringByKey(WindowTemplateAttr.SQLOfFM);
|
|
|
sql = sql.Replace("~", "'");
|
|
|
sql = BP.WF.Glo.DealExp(sql, null);
|
|
|
val = DBAccess.RunSQLReturnString(sql);
|
|
|
item.SetValByKey(WindowTemplateAttr.SQLOfFM, val);
|
|
|
}
|
|
|
catch (Exception ex)
|
|
|
{
|
|
|
item.WinDocModel = WinDocModel.Html;
|
|
|
item.Docs = "err@" + ex.Message + " SQL=" + item.Docs;
|
|
|
}
|
|
|
}
|
|
|
#endregion 扇形百分比.
|
|
|
|
|
|
|
|
|
//SQL列表.
|
|
|
if (item.WinDocModel.Equals(WinDocModel.Table) //sql列表.
|
|
|
|| item.WinDocModel.Equals(WinDocModel.ChartLine) //sql柱状图
|
|
|
|| item.WinDocModel.Equals(WinDocModel.ChartChina) //折线图.
|
|
|
|| item.WinDocModel.Equals(WinDocModel.ChartRing) //环形图.
|
|
|
|| item.WinDocModel.Equals(WinDocModel.ChartPie)) //饼图.
|
|
|
{
|
|
|
try
|
|
|
{
|
|
|
string sql = item.Docs;
|
|
|
sql = sql.Replace("~", "'");
|
|
|
sql = BP.WF.Glo.DealExp(sql, null);
|
|
|
DataTable dt = DBAccess.RunSQLReturnTable(sql);
|
|
|
item.Docs = BP.Tools.Json.ToJson(dt);
|
|
|
}
|
|
|
catch (Exception ex)
|
|
|
{
|
|
|
BP.DA.Log.DebugWriteError(ex.Message);
|
|
|
item.WinDocModel = WinDocModel.Html;
|
|
|
item.Docs = "err@" + ex.Message + " SQL=" + item.Docs;
|
|
|
}
|
|
|
}
|
|
|
}
|
|
|
}
|
|
|
public override int RetrieveAll()
|
|
|
{
|
|
|
int i = this.RetrieveAllFromDBSource("Idx");
|
|
|
if (i >= 1)
|
|
|
{
|
|
|
InitHomePageData();
|
|
|
return i;
|
|
|
}
|
|
|
|
|
|
//初始化模板数据.
|
|
|
InitHomePageData();
|
|
|
|
|
|
//查询模数据.
|
|
|
i = this.RetrieveAllFromDBSource("Idx");
|
|
|
InitDocs();
|
|
|
return i;
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 初始化 Home 数据
|
|
|
/// </summary>
|
|
|
public string InitHomePageData()
|
|
|
{
|
|
|
|
|
|
WindowTemplate en = new WindowTemplate();
|
|
|
|
|
|
#region 关于我们.
|
|
|
en.No = "001";
|
|
|
en.WinDocModel = WinDocModel.Html;
|
|
|
en.PageID = "Home";
|
|
|
en.Name = "关于我们";
|
|
|
string html = "";
|
|
|
html += "<ul>";
|
|
|
html += " <li>ccbpm是一个100%的开源软件,包含工作流程引擎、表单引擎、组织结构管理、菜单管理等敏捷开发的基础模块。</li>";
|
|
|
html += " <li>该开源软件由驰骋公司从2003年开始研发到至今，经过多个版本迭代，并历经数千个项目于用户需求场景完成。</li>";
|
|
|
html += " <li>设计严谨、考究抽象程度高、覆盖大部分客户应用需求，属于一款不可多得的应用国产的敏捷开发工具。</li>";
|
|
|
html += " <li>源代码都发布在giee上，采用GPL开源协议进行开源，遵守GPL开源协议使用ccbpm合法有效。</li>";
|
|
|
html += " <li>驰骋公司对外提供现场培训、技术支持、协助集成、协助项目落地服务，对小微企业，小企业，中等企业，大企业收费8,12,18,23三个等级的付费。</li>";
|
|
|
html += "</ul>";
|
|
|
en.Docs = html;
|
|
|
en.MoreLinkModel = 1;
|
|
|
en.ColSpan = 2;
|
|
|
en.ItIsDel = true;
|
|
|
en.Insert();
|
|
|
#endregion 关于我们.
|
|
|
|
|
|
#region 登录信息.
|
|
|
en = new WindowTemplate();
|
|
|
en.PageID = "Home";
|
|
|
en.No = "002";
|
|
|
en.Name = "登录信息";
|
|
|
en.WinDocModel = WinDocModel.System; //系统内置的.
|
|
|
|
|
|
html = "<table>";
|
|
|
html += "<tr>";
|
|
|
html += " <td>帐号</td>";
|
|
|
html += " <td>@WebUser.No</td>";
|
|
|
html += "</tr>";
|
|
|
|
|
|
html += "<tr>";
|
|
|
html += " <td>姓名</td>";
|
|
|
html += " <td>@WebUser.Name</td>";
|
|
|
html += "</tr>";
|
|
|
|
|
|
html += "<tr>";
|
|
|
html += " <td>部门</td>";
|
|
|
html += " <td>@WebUser.FK_DeptName</td>";
|
|
|
html += "</tr>";
|
|
|
en.Docs = html;
|
|
|
en.ColSpan = 1;
|
|
|
en.Insert();
|
|
|
#endregion 登录信息.
|
|
|
|
|
|
#region 我的待办.
|
|
|
en = new WindowTemplate();
|
|
|
en.PageID = "Home";
|
|
|
en.No = "003";
|
|
|
en.Name = "我的待办";
|
|
|
en.WinDocModel = WinDocModel.ChartLine; //柱状图.
|
|
|
|
|
|
html = "SELECT NodeName AS '流程名', COUNT(WorkID) as '数量' ";
|
|
|
html += " FROM WF_GenerWorkerlist WHERE FK_Emp = '@WebUser.No' AND IsPass=0 GROUP BY NodeName ";
|
|
|
en.Docs = html;
|
|
|
en.MoreLinkModel = 1;
|
|
|
en.ColSpan = 4;
|
|
|
en.Insert();
|
|
|
#endregion 我的待办分布.
|
|
|
|
|
|
#region 全部流程.
|
|
|
en = new WindowTemplate();
|
|
|
en.PageID = "Home";
|
|
|
en.No = "004";
|
|
|
en.Name = "全部流程";
|
|
|
en.WinDocModel = WinDocModel.ChartLine; //柱状图.
|
|
|
|
|
|
if (BP.Difference.SystemConfig.CCBPMRunModel == BP.Sys.CCBPMRunModel.Single)
|
|
|
en.Docs = "SELECT FlowName AS '流程名', COUNT(WorkID) AS '数量' FROM WF_GenerWorkFlow WHERE WFState !=0 GROUP BY FlowName";
|
|
|
else
|
|
|
en.Docs = "SELECT FlowName AS '流程名', COUNT(WorkID) AS '数量' FROM WF_GenerWorkFlow WHERE WFState !=0 AND OrgNo='@WebUser.OrgNo' GROUP BY FlowName";
|
|
|
|
|
|
en.MoreLinkModel = 1;
|
|
|
en.ColSpan = 2;
|
|
|
|
|
|
en.Insert();
|
|
|
#endregion 我的待办分布.
|
|
|
|
|
|
#region 我的未完成.
|
|
|
en = new WindowTemplate();
|
|
|
en.PageID = "Home";
|
|
|
en.WinDocModel = WinDocModel.ChartLine; //.
|
|
|
en.No = "005";
|
|
|
en.Name = "未完成";
|
|
|
html = "SELECT FlowName AS '流程名', COUNT(WorkID) AS '数量' FROM WF_GenerWorkFlow WHERE WFState = 2 ";
|
|
|
html += "and Emps like '%@WebUser.No%' GROUP BY FlowName";
|
|
|
en.Docs = html;
|
|
|
en.MoreLinkModel = 1;
|
|
|
en.ColSpan = 4;
|
|
|
|
|
|
en.Insert();
|
|
|
#endregion 我的未完成.
|
|
|
|
|
|
#region 我的发起.
|
|
|
en = new WindowTemplate();
|
|
|
en.PageID = "Home";
|
|
|
en.No = "006";
|
|
|
en.Name = "我的发起";
|
|
|
en.WinDocModel = WinDocModel.ChartPie; //柱状图.
|
|
|
|
|
|
if (BP.Difference.SystemConfig.CCBPMRunModel == BP.Sys.CCBPMRunModel.Single)
|
|
|
en.Docs = "SELECT FlowName AS '流程名', COUNT(WorkID) AS '数量' FROM WF_GenerWorkFlow WHERE WFState !=0 AND Starter='@WebUser.No' GROUP BY FlowName";
|
|
|
else
|
|
|
en.Docs = "SELECT FlowName AS '流程名', COUNT(WorkID) AS '数量' FROM WF_GenerWorkFlow WHERE WFState !=0 AND Starter='@WebUser.No' AND OrgNo='@WebUser.OrgNo' GROUP BY FlowName";
|
|
|
|
|
|
en.MoreLinkModel = 1;
|
|
|
en.ColSpan = 1;
|
|
|
en.Insert();
|
|
|
#endregion 我的发起.
|
|
|
|
|
|
#region 我参与的.
|
|
|
en = new WindowTemplate();
|
|
|
en.PageID = "Home";
|
|
|
en.No = "007";
|
|
|
en.Name = "我参与的";
|
|
|
en.WinDocModel = WinDocModel.ChartChina; //柱状图.
|
|
|
|
|
|
if (BP.Difference.SystemConfig.CCBPMRunModel == BP.Sys.CCBPMRunModel.Single)
|
|
|
en.Docs = "SELECT FlowName AS '流程名', COUNT(WorkID) AS '数量' FROM WF_GenerWorkFlow WHERE WFState !=0 AND Emps LIKE '%@WebUser.No,%' GROUP BY FlowName";
|
|
|
else
|
|
|
en.Docs = "SELECT FlowName AS '流程名', COUNT(WorkID) AS '数量' FROM WF_GenerWorkFlow WHERE WFState !=0 AND Emps LIKE '%@WebUser.No,%' AND OrgNo='@WebUser.OrgNo' GROUP BY FlowName";
|
|
|
|
|
|
en.MoreLinkModel = 1;
|
|
|
en.ColSpan = 4;
|
|
|
|
|
|
en.Insert();
|
|
|
#endregion 我的发起.
|
|
|
|
|
|
#region 流程实例月份柱状图.
|
|
|
en = new WindowTemplate();
|
|
|
en.PageID = "Home";
|
|
|
en.No = "008";
|
|
|
en.Name = "月统计发起";
|
|
|
en.WinDocModel = WinDocModel.ChartLine;
|
|
|
html = "SELECT FK_NY AS '月份', COUNT(WorkID) AS '数量' FROM WF_GenerWorkFlow WHERE WFState !=0 GROUP BY FK_NY";
|
|
|
en.Docs = html;
|
|
|
en.MoreLinkModel = 1;
|
|
|
en.ColSpan = 4;
|
|
|
en.Insert();
|
|
|
#endregion 流程实例月份柱状图.
|
|
|
|
|
|
return "执行成功.";
|
|
|
|
|
|
|
|
|
}
|
|
|
}
|
|
|
}
|