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