public List <FormObject> GetFormObjectsByUser(User user) { List <FormObject> elements = new List <FormObject>(); string sql = "select * from TF_FormObject where Owner=" + user.ID; DataTable dt = sqlHelper.Query(sql); if (dt != null && dt.Rows.Count > 0) { FormTypeLogic ftl = FormTypeLogic.GetInstance(); FormItemLogic fil = FormItemLogic.GetInstance(); UserLogic ul = UserLogic.GetInstance(); for (int i = 0; i < dt.Rows.Count; i++) { FormObject element = new FormObject(); element.ID = Convert.ToInt32(dt.Rows[i]["ID"]); element.FormName = dt.Rows[i]["FormName"].ToString(); element.FormType = ftl.GetFormType(Convert.ToInt32(dt.Rows[i]["FormType"])); element.FormItems = fil.GetFormItemsByIds(dt.Rows[i]["FormItems"].ToString()); element.Owner = ul.GetUser(Convert.ToInt32(dt.Rows[i]["Owner"])); element.Remark = dt.Rows[i]["Remark"].ToString(); elements.Add(element); } } return(elements); }
public List <DocObject> GetDocObjectsByTemplateId(List <int> flowTemplateIds) { List <DocObject> elements = new List <DocObject>(); if (flowTemplateIds != null && flowTemplateIds.Count > 0) { string sql = "select TF_DocObject.* from TF_DocObject,TaskInfo,Flow,FlowTemplate where TF_DocObject.ID=TaskInfo.EntityId and TaskInfo.FlowID=Flow.ID and Flow.TemplateID in (" + flowTemplateIds + ")"; DataTable dt = sqlHelper.Query(sql); if (dt != null && dt.Rows.Count > 0) { FormObjectLogic fol = FormObjectLogic.GetInstance(); FormItemLogic fil = FormItemLogic.GetInstance(); UserLogic ul = UserLogic.GetInstance(); for (int i = 0; i < dt.Rows.Count; i++) { DocObject element = new DocObject(); element.ID = Convert.ToInt32(dt.Rows[i]["ID"]); element.Name = dt.Rows[i]["Name"].ToString(); element.Form = fol.GetFormObject(Convert.ToInt32(dt.Rows[i]["FormID"])); element.DocItems = fil.GetFormItemsByIds(dt.Rows[i]["DocItems"].ToString()); element.Owner = ul.GetUser(Convert.ToInt32(dt.Rows[i]["Owner"])); element.Remark = dt.Rows[i]["Remark"].ToString(); element.Flag = Convert.ToInt32(dt.Rows[i]["Flag"]); elements.Add(element); } } } return(elements); }
public List <DocObject> GetAllDocObjects() { List <DocObject> elements = new List <DocObject>(); string sql = "select * from TF_DocObject"; DataTable dt = sqlHelper.Query(sql); if (dt != null && dt.Rows.Count > 0) { FormObjectLogic fol = FormObjectLogic.GetInstance(); FormItemLogic fil = FormItemLogic.GetInstance(); UserLogic ul = UserLogic.GetInstance(); for (int i = 0; i < dt.Rows.Count; i++) { DocObject element = new DocObject(); element.ID = Convert.ToInt32(dt.Rows[i]["ID"]); element.Name = dt.Rows[i]["Name"].ToString(); element.Form = fol.GetFormObject(Convert.ToInt32(dt.Rows[i]["FormID"])); element.DocItems = fil.GetFormItemsByIds(dt.Rows[i]["DocItems"].ToString()); element.Owner = ul.GetUser(Convert.ToInt32(dt.Rows[i]["Owner"])); element.Remark = dt.Rows[i]["Remark"].ToString(); element.Flag = Convert.ToInt32(dt.Rows[i]["Flag"]); elements.Add(element); } } return(elements); }
private List <User> GetUsers(List <string> list) { List <User> users = new List <User>(); UserLogic ul = UserLogic.GetInstance(); foreach (string id in list) { users.Add(ul.GetUser(Convert.ToInt32(id))); } return(users); }