public void FillGrid() { PTSProject.clsUniform UniformCL = Container.Resolve <clsUniform>(); int iType = 0; int iStation = 0; string sName = ""; string sOrder = ""; string sStyle = ""; string sColor = ""; string sLength = ""; string sSleeve = ""; string sDate = ""; string sChstWaist = ""; ViewModel.sHeadingFilter = "List Filtered by: "; int CurrRow = 0; ViewModel.sprList.MaxRows = 5000; //UPGRADE_ISSUE: (2064) FPSpreadADO.fpSpread method sprList.ClearRange was not upgraded. More Information: http://www.vbtonet.com/ewis/ewi2064.aspx ViewModel.sprList.ClearRange(1, 1, ViewModel.sprList.MaxCols, ViewModel.sprList.MaxRows, false); if (ViewModel.cboType.SelectedIndex != -1) { iType = ViewModel.cboType.GetItemData(ViewModel.cboType.SelectedIndex); ViewModel.sHeadingFilter = ViewModel.sHeadingFilter + modGlobal.Clean(ViewModel.cboType.Text) + "; "; } if (modGlobal.Clean(ViewModel.cboStation.Text) != "") { //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx iStation = Convert.ToInt32(modGlobal.GetVal(ViewModel.cboStation.Text)); ViewModel.sHeadingFilter = ViewModel.sHeadingFilter + "Station = " + modGlobal.Clean(ViewModel.cboStation.Text) + "; "; } sName = modGlobal.Clean(Strings.Replace(ViewModel.txtNameSearch.Text, "'", "''", 1, -1, CompareMethod.Binary)); if (sName != "") { ViewModel.sHeadingFilter = ViewModel.sHeadingFilter + "Name like " + sName + "; "; } sChstWaist = modGlobal.Clean(ViewModel.cboChstWaist.Text); if (sChstWaist != "") { ViewModel.sHeadingFilter = ViewModel.sHeadingFilter + "Chst/Waist = " + sChstWaist + "; "; } sLength = modGlobal.Clean(ViewModel.cboLength.Text); if (sLength != "") { ViewModel.sHeadingFilter = ViewModel.sHeadingFilter + "Length = " + sLength + "; "; } sSleeve = modGlobal.Clean(ViewModel.cboSleeve.Text); if (sSleeve != "") { ViewModel.sHeadingFilter = ViewModel.sHeadingFilter + "Sleeve Length = " + sSleeve + "; "; } sDate = modGlobal.Clean(ViewModel.cboManufDate.Text); if (sDate != "") { ViewModel.sHeadingFilter = ViewModel.sHeadingFilter + "Manuf Date = " + sDate + "; "; } sColor = modGlobal.Clean(ViewModel.cboColor.Text); if (sColor != "") { ViewModel.sHeadingFilter = ViewModel.sHeadingFilter + "Color = " + sColor + "; "; } sOrder = modGlobal.Clean(ViewModel.cboOrder.Text); if (sOrder != "") { ViewModel.sHeadingFilter = ViewModel.sHeadingFilter + "Order # = " + sOrder + "; "; } sStyle = modGlobal.Clean(ViewModel.cboStyle.Text); if (sStyle != "") { ViewModel.sHeadingFilter = ViewModel.sHeadingFilter + "Style # = " + sStyle + "; "; } if (~UniformCL.GetUniformGlobeList(iType, iStation, sName, sOrder, sStyle, sColor, sLength, sSleeve, sDate, sChstWaist) != 0) { ViewManager.ShowMessage("There is no Globe Uniforms returned. Clear Filters and try again.", "Get Globe Uniform Data", UpgradeHelpers.Helpers.BoxButtons.OK); return; } while (!UniformCL.Uniform.EOF) { CurrRow++; ViewModel.sprList.Row = CurrRow; ViewModel.sprList.Col = 1; ViewModel.sprList.Text = modGlobal.Clean(UniformCL.Uniform["co"]); ViewModel.sprList.Col = 2; ViewModel.sprList.Text = modGlobal.Clean(UniformCL.Uniform["description"]); ViewModel.sprList.Col = 3; ViewModel.sprList.Text = modGlobal.Clean(UniformCL.Uniform["serial_number"]); ViewModel.sprList.Col = 4; ViewModel.sprList.Text = modGlobal.Clean(UniformCL.Uniform["order_number"]); ViewModel.sprList.Col = 5; ViewModel.sprList.Text = modGlobal.Clean(UniformCL.Uniform["color"]); ViewModel.sprList.Col = 6; ViewModel.sprList.Text = modGlobal.Clean(UniformCL.Uniform["chst_waist_size"]); ViewModel.sprList.Col = 7; ViewModel.sprList.Text = modGlobal.Clean(UniformCL.Uniform["length"]); ViewModel.sprList.Col = 8; ViewModel.sprList.Text = modGlobal.Clean(UniformCL.Uniform["sleeve_length"]); ViewModel.sprList.Col = 9; ViewModel.sprList.Text = Convert.ToDateTime(UniformCL.Uniform["manufactured_date"]).ToString("M/d/yyyy"); ViewModel.sprList.Col = 10; ViewModel.sprList.Text = modGlobal.Clean(UniformCL.Uniform["style_number"]); if (modGlobal.Clean(UniformCL.Uniform["style_description"]) != "") { ViewModel.sprList.TextTip = FarPoint.ViewModels.TextTipPolicy.Floating; ViewModel.sprList.CellNoteIndicator = true; //UPGRADE_ISSUE: (2064) FPSpreadADO.fpSpread property sprList.CellNote was not upgraded. More Information: http://www.vbtonet.com/ewis/ewi2064.aspx ViewModel.sprList.CellNote = modGlobal.Clean(UniformCL.Uniform["style_description"]); } ViewModel.sprList.Col = 11; if (modGlobal.Clean(UniformCL.Uniform["name_full"]) == "") { if (modGlobal.Clean(UniformCL.Uniform["station"]) == "") { ViewModel.sprList.Text = "???"; } else { ViewModel.sprList.Text = "Station " + modGlobal.Clean(UniformCL.Uniform["station"]); } } else { ViewModel.sprList.Text = modGlobal.Clean(UniformCL.Uniform["name_full"]); } ViewModel.sprList.Col = 12; if (modGlobal.Clean(UniformCL.Uniform["retired_date"]) == "") { if (modGlobal.Clean(UniformCL.Uniform["issued_date"]) == "") { ViewModel.sprList.Text = ""; } else { ViewModel.sprList.Text = Convert.ToDateTime(UniformCL.Uniform["issued_date"]).ToString("M/d/yyyy"); ViewModel.sprList.TextTip = FarPoint.ViewModels.TextTipPolicy.Floating; ViewModel.sprList.CellNoteIndicator = true; //UPGRADE_ISSUE: (2064) FPSpreadADO.fpSpread property sprList.CellNote was not upgraded. More Information: http://www.vbtonet.com/ewis/ewi2064.aspx ViewModel.sprList.CellNote = "Issued"; } } else { ViewModel.sprList.Text = Convert.ToDateTime(UniformCL.Uniform["retired_date"]).ToString("M/d/yyyy"); ViewModel.sprList.TextTip = FarPoint.ViewModels.TextTipPolicy.Floating; ViewModel.sprList.CellNoteIndicator = true; //UPGRADE_ISSUE: (2064) FPSpreadADO.fpSpread property sprList.CellNote was not upgraded. More Information: http://www.vbtonet.com/ewis/ewi2064.aspx ViewModel.sprList.CellNote = "Retired"; } UniformCL.Uniform.MoveNext(); } ; ViewModel.lbCount.Text = "Total Count: " + ViewModel.sprList.DataRowCnt.ToString(); ViewModel.sprList.MaxRows = ViewModel.sprList.DataRowCnt; }