/// <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; }
private void StepSortProcessGrid() { WorkViewTDS dataSet = new WorkViewTDS(); dataSet.LFS_WORK_TYPE_VIEW_SORT.Merge(workTypeViewSort, true); WorkTypeViewSort model = new WorkTypeViewSort(dataSet); // update rows if (Session["workTypeViewSortDummy"] == null) { foreach (GridViewRow row in grdSort.Rows) { int sortId = int.Parse(grdSort.DataKeys[row.RowIndex].Values["SortID"].ToString()); bool selected = ((CheckBox)row.FindControl("cbxSelected")).Checked; int order = 0; try { order = int.Parse(((DropDownList)row.FindControl("ddlOrder")).SelectedValue); } catch { order = 0; } model.Update(hdfWorkType.Value, int.Parse(hdfCompanyId.Value), sortId, order, selected); } model.Table.AcceptChanges(); workTypeViewSort = (WorkViewTDS.LFS_WORK_TYPE_VIEW_SORTDataTable)model.Table; Session["workTypeViewSort"] = workTypeViewSort; } }
private bool StepLogicNext() { Page.Validate("Logic"); if (Page.IsValid) { // Load WorkViewTDS dataSet = new WorkViewTDS(); dataSet.LFS_WORK_TYPE_VIEW_SORT.Merge(workTypeViewSort, true); WorkTypeViewSort model = new WorkTypeViewSort(dataSet); if (dataSet.LFS_WORK_TYPE_VIEW_SORT.Rows.Count <= 0) { model.LoadByWorkTypeInView(hdfWorkType.Value, int.Parse(hdfCompanyId.Value), true); } // Store tables workTypeViewSort = (WorkViewTDS.LFS_WORK_TYPE_VIEW_SORTDataTable)model.Table; Session["workTypeViewSort"] = workTypeViewSort; return true; } else { return false; } }
/// <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; }