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