/// <summary>
/// Get WorkList
/// </summary>
/// <returns></returns>
public DataSet GetWorkList(string pagenum, string pagesize, string procFullName, string actionerName, string folio, string StartDate, string endDate, string procstate, string originator, string paraEmpression)
{
try
{
string sql = "SProc_GetMyWorklist_Test";
SqlParameter[] paras =
{
new SqlParameter("@pagenum", pagenum),
new SqlParameter("@pagesize", pagesize),
new SqlParameter("@ProcFullName", procFullName),
new SqlParameter("@ActionerName", actionerName),
new SqlParameter("@Folio", folio),
new SqlParameter("@StartDate", StartDate),
new SqlParameter("@endDate", endDate),
new SqlParameter("@procstate", procstate),
new SqlParameter("@originator", originator),
new SqlParameter("@ParaEmpression", paraEmpression)
};
DataSet ds = SqlHelper.ExecuteDataSet(SqlHelper.WorkSpaceConnectionStringLocalTransaction, CommandType.StoredProcedure, sql, paras);
DataTable dtGroup = ds.Tables[1];
dtGroup.Columns.Add("AliasName");
foreach (DataRow r in dtGroup.Rows)
{
string name = r["ProcName"].ToString();
r["AliasName"] = Settings.GetConfigurationValue(name);
int procSetId = Common.SafeInt(r["ProcSetId"].ToString(), 0);
ProcessSettingsEntity entity = Settings.GetProcessSettings(procSetId);
if (entity != null)
{
if (!string.IsNullOrEmpty(entity.Description))
{
r["AliasName"] = entity.Description;
}
}
else
{
//r.Delete();
}
}
DataTable dt = ds.Tables[0];
dt.Columns.Add("FormURL");
foreach (DataRow r in dt.Rows)
{
string urlLink = "<a href=\"../{0}\" id=\"HL_{3}\">{1}</a>";
string actName = r["ActivityName"].ToString();
r["ActivityName"] = Common.FormatBrackets(actName);
int procSetId = Common.SafeInt(r["ProcSetId"].ToString(), 0);
int procId = Common.SafeInt(r["ProcInstID"].ToString(), 0);
if (procSetId > 0 && procId > 0)
{
r["FormURL"] = string.Format(urlLink, r["data"].ToString(), r["Folio"].ToString(), "MyApp" + r["ProcInstID"], procId.ToString());
}
}
return(ds);
}
catch (Exception ex)
{
DBManager.RecoreErrorProfile(ex, "WorkListDAL.GetWorkList", DBManager.GetCurrentUserAD());
return(null);
}
}
public DataSet GetMyWorklist(string user, string pagenum, string pagesize, string procName, string folio, string group, string Submitor, string StartTime, string EndTime, string FlowStatus, string Employee)
{
try
{
string sql = "SProc_GetMyWorklist";
SqlParameter[] paras =
{
new SqlParameter("@ActionerName", user),
new SqlParameter("@Folio", folio),
new SqlParameter("@ProcSetName", procName),
new SqlParameter("@StartTime", StartTime),
new SqlParameter("@EndTime", EndTime),
new SqlParameter("@PageNum", pagenum),
new SqlParameter("@PageSize", pagesize),
new SqlParameter("@Group", group),
new SqlParameter("@Submitor", Submitor),
new SqlParameter("@FlowStatus", FlowStatus),
new SqlParameter("@Employee", Employee)
};
DataSet ds = SqlHelper.ExecuteDataSet(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, sql, paras);
if (ds == null || ds.Tables.Count == 0)
{
return(null);
}
DataTable dtGroup = ds.Tables[1];
dtGroup.Columns.Add("AliasName");
foreach (DataRow r in dtGroup.Rows)
{
string name = r["ProcName"].ToString();
r["AliasName"] = Settings.GetConfigurationValue(name);
int procSetId = Common.SafeInt(r["ProcSetId"].ToString(), 0);
ProcessSettingsEntity entity = Settings.GetProcessSettings(procSetId);
if (entity != null)
{
if (!string.IsNullOrEmpty(entity.Description))
{
r["AliasName"] = entity.Description;
}
}
}
DataTable dt = ds.Tables[0];
dt.Columns.Add("FormURL");
foreach (DataRow r in dt.Rows)
{
string urlLink = "<a href=\"../{0}\" id=\"HL_{3}\">{1}</a>";
string actName = r["ActivityName"].ToString();
r["ActivityName"] = Common.FormatBrackets(actName);
int procSetId = Common.SafeInt(r["ProcSetId"].ToString(), 0);
int procId = Common.SafeInt(r["ProcInstID"].ToString(), 0);
if (procSetId > 0 && procId > 0)
{
r["FormURL"] = string.Format(urlLink, r["data"].ToString(), r["Folio"].ToString(), "MyApp" + r["ProcInstID"], procId.ToString());
}
}
return(ds);
}
catch (Exception ex)
{
DBManager.RecoreErrorProfile(ex, "WorkListDAL.GetMyWorklist", DBManager.GetCurrentUserAD());
return(null);
}
}
