public List<EquipmentDTO> GetCustomerEquipments(String customerCardCode)
{
List<EquipmentDTO> equipmentList = new List<EquipmentDTO>();
String query = "SELECT InsID, ManufSN, InternalSN, ItemCode, ItemName, AddrType, Street, StreetNo, Building, Zip, Block, City, State, County, Country FROM OINS WHERE Customer = '" + customerCardCode + "' AND status = 'A' ORDER BY ManufSN";
SqlCommand command = new SqlCommand(query, sqlServerConnection);
SqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
EquipmentDTO equipment = new EquipmentDTO();
equipment.id = (int) dataReader["InsID"];
equipment.ManufSN = GetStringValue(dataReader, "ManufSN");
equipment.InternalSN = GetStringValue(dataReader, "InternalSN");
equipment.ItemCode = GetStringValue(dataReader, "ItemCode");
equipment.ItemName = GetStringValue(dataReader, "ItemName");
equipment.AddrType = GetStringValue(dataReader, "AddrType");
equipment.Street = GetStringValue(dataReader, "Street");
equipment.StreetNo = GetStringValue(dataReader, "StreetNo");
equipment.Block = GetStringValue(dataReader, "Block");
equipment.Building = GetStringValue(dataReader, "Building");
equipment.Zip = GetStringValue(dataReader, "Zip");
equipment.City = GetStringValue(dataReader, "City");
equipment.State = GetStringValue(dataReader, "State");
equipment.County = GetStringValue(dataReader, "County");
equipment.Country = GetStringValue(dataReader, "Country");
equipmentList.Add(equipment);
}
dataReader.Close();
return equipmentList;
}
// Recebe como parâmetro os ids separados por vírgula
public List<EquipmentDTO> GetEquipments(String equipmentIds)
{
List<EquipmentDTO> equipmentList = new List<EquipmentDTO>();
if (String.IsNullOrEmpty(equipmentIds)) equipmentIds = "0";
String query = "SELECT ManufSN, InternalSN, ItemCode, ItemName, Customer FROM OINS WHERE InsID IN (" + equipmentIds + ") AND status = 'A' ORDER BY ManufSN";
SqlCommand command = new SqlCommand(query, sqlServerConnection);
SqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
EquipmentDTO equipment = new EquipmentDTO();
equipment.ManufSN = GetStringValue(dataReader, "ManufSN");
equipment.InternalSN = GetStringValue(dataReader, "InternalSN");
equipment.ItemCode = GetStringValue(dataReader, "ItemCode");
equipment.ItemName = GetStringValue(dataReader, "ItemName");
equipment.Customer = GetStringValue(dataReader, "Customer");
equipmentList.Add(equipment);
}
dataReader.Close();
return equipmentList;
}
