protected override DictPoco[] GetTaskStatusCount()
{
var gsql = "select f_status as status_,count(f_status) as count_ from t_wf_task with(nolock) where f_kind='Flow' and f_status in ('Running','Finished','Deleted','Aborted') GROUP BY f_status order by f_status desc";
DataSet ds = LiteDB.ExecuteDataSet(gsql);
if (ds != null)
{
List <DictPoco> dictList = new List <DictPoco>();
foreach (DataRow row in ds.Tables[0].Rows)
{
DictPoco dict = new DictPoco();
dict.Key = row["status_"].ToString();
dict.Value = row["count_"].ToString();
dictList.Add(dict);
}
return(dictList.ToArray());
}
else
{
return(null);
}
}
protected override DictPoco[] GetModuleUseCount()
{
var gsql = "SELECT f_module_fname as name_, COUNT(f_id) as count_ from t_wf_task with(nolock) GROUP BY f_module_fcode,f_module_fname order by count(f_id) desc";
DataSet ds = LiteDB.ExecuteDataSet(gsql);
if (ds != null)
{
List <DictPoco> dictList = new List <DictPoco>();
foreach (DataRow row in ds.Tables[0].Rows)
{
DictPoco dict = new DictPoco();
dict.Key = row["name_"].ToString();
dict.Value = row["count_"].ToString();
dictList.Add(dict);
}
return(dictList.ToArray());
}
else
{
return(null);
}
}
