/// <summary>
/// GetSortForSql
/// </summary>
/// <returns></returns>
public string GetSortForSql()
{
string sort = "";
// process temp table
DataRow[] dataRowOrder = Data.Tables["WorkViewSortTemp"].Select("Deleted = 0", "Order_ ASC");
foreach (DataRow row in dataRowOrder)
{
if (!(((WorkViewTDS.WorkViewSortTempRow)row).Deleted))
{
int order_ = ((WorkViewTDS.WorkViewSortTempRow)row).Order_;
string workType = ((WorkViewTDS.WorkViewSortTempRow)row).WorkType;
int companyId = ((WorkViewTDS.WorkViewSortTempRow)row).COMPANY_ID;
int sortId = ((WorkViewTDS.WorkViewSortTempRow)row).SortID;
WorkTypeViewSort workTypeViewSort = new WorkTypeViewSort();
workTypeViewSort.LoadByWorkTypeSortId(workType, companyId, sortId);
WorkTypeViewSortGateway workTypeViewSortGateway = new WorkTypeViewSortGateway(workTypeViewSort.Data);
string tableName = workTypeViewSortGateway.GetTable_(workType, companyId, sortId);
if (tableName == "AM_ASSET_SEWER_SECTION") tableName = "AASS";
if (tableName == "LFS_WORK_FULLLENGTHLINING") tableName = "LWF";
if (tableName == "LFS_WORK") tableName = "LW";
if (tableName == "AM_ASSET_SEWER_LATERAL") tableName = "AASL";
if (tableName == "LFS_ASSET_SEWER_SECTION") tableName = "LASS";
if (tableName == "LFS_WORK_JUNCTIONLINING_SECTION") tableName = "LWJLS";
if (tableName == "LFS_WORK_JUNCTIONLINING_LATERAL") tableName = "LWJLL";
if (tableName == "LFS_WORK_REHABASSESSMENT") tableName = "LWR";
if (tableName == "LFS_WORK_MANHOLE_REHABILITATION") tableName = "LWMR";
if (tableName == "AM_ASSET_SEWER_MH") tableName = "AASMH";
sort = sort + tableName + "." + workTypeViewSortGateway.GetColumn_(workType, companyId, sortId) + ", ";
}
}
sort = sort.Substring(0, sort.Length - 2);
return sort;
}
/// <summary>
/// GetSortForSummary
/// </summary>
/// <returns></returns>
public string GetSortForSummary()
{
string sort = "";
DataRow[] dataRowOrder = Data.Tables["WorkViewSortTemp"].Select("Deleted = 0", "Order_ ASC");
foreach (DataRow row in dataRowOrder)
{
if (!(((WorkViewTDS.WorkViewSortTempRow)row).Deleted))
{
string workType = ((WorkViewTDS.WorkViewSortTempRow)row).WorkType;
int companyId = ((WorkViewTDS.WorkViewSortTempRow)row).COMPANY_ID;
int sortId = ((WorkViewTDS.WorkViewSortTempRow)row).SortID;
WorkTypeViewSort workTypeViewSort = new WorkTypeViewSort();
workTypeViewSort.LoadByWorkTypeSortId(workType, companyId, sortId);
WorkTypeViewSortGateway workTypeViewSortGateway = new WorkTypeViewSortGateway(workTypeViewSort.Data);
sort = sort + workTypeViewSortGateway.GetName(workType, companyId, sortId) + ", ";
}
}
if (sort.Length > 2)
{
sort = sort.Substring(0, sort.Length - 2);
}
return sort;
}
