/// <summary>
/// 门户任务类别下拉框
/// </summary>
public override void InitData()
{
this.Items.Clear();
this.SelectAllText = "全部类别";
this.SelectAllValue = string.Empty;
this.InsertSelectAllOption();
TaskCategoryCollection taskCategories = TaskCategoryAdapter.Instance.GetCategoriesByUserID(DeluxeIdentity.CurrentUser.ID);
foreach (TaskCategory category in taskCategories)
{
this.Items.Add(new ListItem(category.CategoryName, category.CategoryID));
}
this.Items.Add(new ListItem("未分类", "Others"));
/*
* this.Items.Add(new ListItem("通用流程", "Others"));
* this.Items.Add(new ListItem("连锁开发系统", "1"));
* this.Items.Add(new ListItem("门店管理系统", "2"));
*/
}
/// <summary>
/// 根据SQL获取category
/// </summary>
/// <param name="where"></param>
/// <param name="orderby"></param>
/// <param name="selector"></param>
/// <returns></returns>
public TaskCategoryCollection GetCategoriesByWhereCondition(string where, string orderby, List<string> selector)
{
string sql = string.Format("SELECT");
if (selector != null && selector.Count > 0)
{
foreach (string sel in selector)
{
sql += TSqlBuilder.Instance.CheckQuotationMark(sel, true);
}
}
else
sql += " * ";
WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder();
builder.AppendItem("USER_ID", DeluxeIdentity.CurrentUser.ID);
builder.AppendTenantCode(typeof(TaskCategory));
sql += string.Format("FROM WF.USER_TASK_CATEGORY WHERE {0}",
builder.ToSqlString(TSqlBuilder.Instance));
if (where != string.Empty && where != null)
sql += string.Format("AND ({0})", where);
if (orderby != string.Empty && orderby != null)
sql += string.Format("ORDER BY {0}", orderby);
DataView dv = DbHelper.RunSqlReturnDS(sql).Tables[0].DefaultView;
TaskCategoryCollection tcc = new TaskCategoryCollection();
tcc.LoadFromDataView(dv);
return tcc;
}
/// <summary>
/// 根据CategoryID获取Category集合
/// </summary>
/// <param name="categoryID"></param>
/// <returns></returns>
public TaskCategoryCollection GetCategoriesByCategoryIDs(params string[] categoryID)
{
string strSQL = string.Empty;
TaskCategoryCollection taskCategories = new TaskCategoryCollection();
if (categoryID.Length > 0)
{
InSqlClauseBuilder inSQL = new InSqlClauseBuilder("CATEGORY_GUID");
inSQL.AppendItem(categoryID);
strSQL = string.Format("SELECT * FROM WF.USER_TASK_CATEGORY WHERE {0} ORDER BY INNER_SORT_ID",
inSQL.AppendTenantCodeSqlClause(typeof(TaskCategory)).ToSqlString(TSqlBuilder.Instance));
DataView dv = DbHelper.RunSqlReturnDS(strSQL).Tables[0].DefaultView;
taskCategories.LoadFromDataView(dv);
}
return taskCategories;
}
