public UnitTypeCollection QueryUnitTypeList(ValidState vs)
{
UnitTypeCollection types = new UnitTypeCollection();
string sqlString = "";
sqlString = "select distinct UnitID,UnitName,IsValid from EPM_Res_Unit ";
switch (vs)
{
case ValidState.InValid:
sqlString = sqlString + " where IsValid = 0";
break;
case ValidState.Valid:
sqlString = sqlString + " where IsValid =1 ";
break;
}
using (DataTable table = publicDbOpClass.DataTableQuary(sqlString))
{
if (table.Rows.Count <= 0)
{
return(types);
}
int count = table.Rows.Count;
for (int i = 0; i < count; i++)
{
types.Add(this.GetUnitTypeFromDataRow(table.Rows[i]));
}
}
return(types);
}
private void GetUnitTypeList()
{
UnitTypeCollection = _posRepository.GetUnitType(SettingHelpers.CompanyConfigruationObject.CompanyId);
if (UnitTypeCollection.Any())
{
_addItem.cbUnitType.SelectedIndex = 0;
}
}
