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); } }