public List <DocObject> GetDocObjectsByOwner(User user) { List <DocObject> elements = new List <DocObject>(); string sql = "select * from TF_DocObject where Owner=" + user.ID; 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> 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); }