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;
}
