public List <int> GetTepmIdsByExecOrAppr(string userId)
{
if (string.IsNullOrEmpty(userId))
{
return(null);
}
List <int> ids = new List <int>();
List <int> stageTempIds = new List <int>();
List <int> stageTempIds1 = TaskStageTemplateLogic.GetInstance().GetTaskStageTemplatesByExecutor(userId);
List <int> stageTempIds2 = TaskStageTemplateLogic.GetInstance().GetTaskStageTemplatesByApprover(userId);
if (stageTempIds1.Count > 0)
{
stageTempIds.AddRange(stageTempIds1);
}
if (stageTempIds2.Count > 0)
{
stageTempIds.AddRange(stageTempIds2);
}
foreach (int id in stageTempIds)
{
string sql = "select ID from FlowTemplate where ','+Stages+',' like '%," + id + ",%'";
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ids.Add(Convert.ToInt32(dt.Rows[i]["ID"]));
}
}
}
return(ids);
}
public TaskStage GetTaskStage(int id)
{
string sql = "select * from TaskStage where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
TaskStageTemplate template = TaskStageTemplateLogic.GetInstance().GetTaskStageTemplate(Convert.ToInt32(dt.Rows[0]["TemplateID"]));
string ActualAppr = "";
if (dt.Rows[0]["ActualAppr"] != null && dt.Rows[0]["ActualAppr"] != DBNull.Value)
{
ActualAppr = dt.Rows[0]["ActualAppr"].ToString();
}
string ActualExec = "";
if (dt.Rows[0]["ActualExec"] != null && dt.Rows[0]["ActualExec"] != DBNull.Value)
{
ActualExec = dt.Rows[0]["ActualExec"].ToString();
}
DateTime ApprTime = DateTime.MinValue;
if (dt.Rows[0]["ApprTime"] != null && dt.Rows[0]["ApprTime"] != DBNull.Value)
{
ApprTime = Convert.ToDateTime(dt.Rows[0]["ApprTime"]);
}
DateTime ExecTime = DateTime.MinValue;
if (dt.Rows[0]["ExecTime"] != null && dt.Rows[0]["ExecTime"] != DBNull.Value)
{
ExecTime = Convert.ToDateTime(dt.Rows[0]["ExecTime"]);
}
TaskStage element = new TaskStage(Convert.ToInt32(dt.Rows[0]["ID"]), dt.Rows[0]["Name"].ToString(), template, TaskStage.GetTaskStatus(Convert.ToInt32(dt.Rows[0]["TaskStatus"])), ActualExec, ActualAppr, ExecTime, ApprTime, dt.Rows[0]["Remark"].ToString());
return(element);
}
return(null);
}
public List <FlowTemplate> GetAllFlowTemplates()
{
List <FlowTemplate> elements = new List <FlowTemplate>();
string sql = "select * from FlowTemplate";
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
TaskStageTemplateLogic tsl = TaskStageTemplateLogic.GetInstance();
for (int i = 0; i < dt.Rows.Count; i++)
{
List <TaskStageTemplate> stages = new List <TaskStageTemplate>();
string stageIds = dt.Rows[i]["Stages"].ToString();
List <string> idList = Flow.GetSatges(stageIds);
foreach (string id in idList)
{
TaskStageTemplate stage = tsl.GetTaskStageTemplate(Convert.ToInt32(id));
if (stage != null)
{
stages.Add(stage);
}
}
FlowTemplate element = new FlowTemplate(Convert.ToInt32(dt.Rows[i]["ID"]), dt.Rows[i]["Name"].ToString(), stages);
elements.Add(element);
}
}
return(elements);
}
public static TaskStageTemplateLogic GetInstance()
{
if (instance == null)
{
instance = new TaskStageTemplateLogic();
}
return(instance);
}
public List <TaskStage> GetAllTaskStages()
{
List <TaskStage> elements = new List <TaskStage>();
string sql = "select * from TaskStage";
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
TaskStageTemplateLogic tstl = TaskStageTemplateLogic.GetInstance();
for (int i = 0; i < dt.Rows.Count; i++)
{
TaskStageTemplate template = tstl.GetTaskStageTemplate(Convert.ToInt32(dt.Rows[i]["TemplateID"]));
string ActualAppr = "";
if (dt.Rows[i]["ActualAppr"] != null && dt.Rows[i]["ActualAppr"] != DBNull.Value)
{
ActualAppr = dt.Rows[0]["ActualAppr"].ToString();
}
string ActualExec = "";
if (dt.Rows[i]["ActualExec"] != null && dt.Rows[i]["ActualExec"] != DBNull.Value)
{
ActualExec = dt.Rows[0]["ActualExec"].ToString();
}
DateTime ApprTime = DateTime.MinValue;
if (dt.Rows[i]["ApprTime"] != null && dt.Rows[i]["ApprTime"] != DBNull.Value)
{
ApprTime = Convert.ToDateTime(dt.Rows[i]["ApprTime"]);
}
DateTime ExecTime = DateTime.MinValue;
if (dt.Rows[i]["ExecTime"] != null && dt.Rows[i]["ExecTime"] != DBNull.Value)
{
ExecTime = Convert.ToDateTime(dt.Rows[i]["ExecTime"]);
}
TaskStage element = new TaskStage(Convert.ToInt32(dt.Rows[i]["ID"]), dt.Rows[i]["Name"].ToString(), template, TaskStage.GetTaskStatus(Convert.ToInt32(dt.Rows[i]["TaskStatus"])), ActualExec, ActualAppr, ExecTime, ApprTime, dt.Rows[i]["Remark"].ToString());
elements.Add(element);
}
}
return(elements);
}
public List <FlowTemplate> GetFlowTemplates(string name, int stageCount)
{
List <FlowTemplate> elements = new List <FlowTemplate>();
string where = "where (1=1)";
if (!string.IsNullOrEmpty(name))
{
where += " and Name like '%" + name + "%'";
}
string sql = "select * from FlowTemplate " + where + " order by ID desc";
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
TaskStageTemplateLogic tsl = TaskStageTemplateLogic.GetInstance();
for (int i = 0; i < dt.Rows.Count; i++)
{
List <TaskStageTemplate> stages = new List <TaskStageTemplate>();
string stageIds = dt.Rows[i]["Stages"].ToString();
List <string> idList = Flow.GetSatges(stageIds);
if (idList.Count == stageCount)
{
foreach (string id in idList)
{
TaskStageTemplate stage = tsl.GetTaskStageTemplate(Convert.ToInt32(id));
if (stage != null)
{
stages.Add(stage);
}
}
FlowTemplate element = new FlowTemplate(Convert.ToInt32(dt.Rows[i]["ID"]), dt.Rows[i]["Name"].ToString(), stages);
elements.Add(element);
}
}
}
return(elements);
}
public FlowTemplate GetFlowTemplate(int id)
{
string sql = "select * from FlowTemplate where ID=" + id;
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
TaskStageTemplateLogic tsl = TaskStageTemplateLogic.GetInstance();
List <TaskStageTemplate> stages = new List <TaskStageTemplate>();
string stageIds = dt.Rows[0]["Stages"].ToString();
List <string> idList = Flow.GetSatges(stageIds);
foreach (string idStr in idList)
{
TaskStageTemplate stage = tsl.GetTaskStageTemplate(Convert.ToInt32(idStr));
if (stage != null)
{
stages.Add(stage);
}
}
FlowTemplate element = new FlowTemplate(Convert.ToInt32(dt.Rows[0]["ID"]), dt.Rows[0]["Name"].ToString(), stages);
return(element);
}
return(null);
}
public List <FlowTemplate> GetFlowTemplates(string where)
{
List <FlowTemplate> elements = new List <FlowTemplate>();
if (!string.IsNullOrEmpty(where))
{
string w = where.Trim().ToLower();
if (!w.StartsWith("where "))
{
w = "where " + w;
}
string sql = "select * from FlowTemplate " + w + " order by ID desc";
DataTable dt = sqlHelper.Query(sql);
if (dt != null && dt.Rows.Count > 0)
{
TaskStageTemplateLogic tsl = TaskStageTemplateLogic.GetInstance();
for (int i = 0; i < dt.Rows.Count; i++)
{
List <TaskStageTemplate> stages = new List <TaskStageTemplate>();
string stageIds = dt.Rows[i]["Stages"].ToString();
List <string> idList = Flow.GetSatges(stageIds);
foreach (string id in idList)
{
TaskStageTemplate stage = tsl.GetTaskStageTemplate(Convert.ToInt32(id));
if (stage != null)
{
stages.Add(stage);
}
}
FlowTemplate element = new FlowTemplate(Convert.ToInt32(dt.Rows[i]["ID"]), dt.Rows[i]["Name"].ToString(), stages);
elements.Add(element);
}
}
}
return(elements);
}