public List <TaskStageTemplate> GetTaskStageTemplatesByApprover(User user)
{
List <TaskStageTemplate> elements = new List <TaskStageTemplate>();
string sql = "select * from TaskStageTemplate where ','+Approvers+',' like '%," + user.ID + ",%'";
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
TaskStageTemplate element = new TaskStageTemplate(Convert.ToInt32(dt.Rows[i]["ID"]), dt.Rows[i]["Name"].ToString(), TaskStage.GetUsers(dt.Rows[i]["Executors"].ToString()), TaskStage.GetUsers(dt.Rows[i]["Approvers"].ToString()));
elements.Add(element);
}
}
return(elements);
}
public TaskStageTemplate GetTaskStageTemplate(int id)
{
string sql = "select * from TaskStageTemplate where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
TaskStageTemplate element = new TaskStageTemplate(Convert.ToInt32(dt.Rows[0]["ID"]), dt.Rows[0]["Name"].ToString(), TaskStage.GetUsers(dt.Rows[0]["Executors"].ToString()), TaskStage.GetUsers(dt.Rows[0]["Approvers"].ToString()));
return(element);
}
return(null);
}
