/// <summary>
/// Creates a new instance of the sol_Products class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_Product MakeSol_Product(SqlDataReader dataReader)
{
Sol_Product sol_Product = new Sol_Product();
sol_Product.ProductID = SqlClientUtility.GetInt32(dataReader, "ProductID", 0);
sol_Product.ProName = SqlClientUtility.GetString(dataReader, "ProName", String.Empty);
sol_Product.ProDescription = SqlClientUtility.GetString(dataReader, "ProDescription", String.Empty);
sol_Product.ProShortDescription = SqlClientUtility.GetString(dataReader, "ProShortDescription", String.Empty);
sol_Product.ProImage = SqlClientUtility.GetBytes(dataReader, "ProImage", new byte[0]);
sol_Product.AgencyID = SqlClientUtility.GetInt32(dataReader, "AgencyID", 0);
sol_Product.MenuOrder = SqlClientUtility.GetInt32(dataReader, "MenuOrder", 0);
sol_Product.IsActive = SqlClientUtility.GetBoolean(dataReader, "IsActive", false);
sol_Product.Price = SqlClientUtility.GetDecimal(dataReader, "Price", Decimal.Zero);
sol_Product.CategoryID = SqlClientUtility.GetInt32(dataReader, "CategoryID", 0);
sol_Product.RefundAmount = SqlClientUtility.GetDecimal(dataReader, "RefundAmount", Decimal.Zero);
sol_Product.HandlingCommissionAmount = SqlClientUtility.GetDecimal(dataReader, "HandlingCommissionAmount", Decimal.Zero);
sol_Product.CommissionUnit = SqlClientUtility.GetInt32(dataReader, "CommissionUnit", 0);
sol_Product.VafAmount = SqlClientUtility.GetDecimal(dataReader, "VafAmount", Decimal.Zero);
sol_Product.FeeUnit = SqlClientUtility.GetInt32(dataReader, "FeeUnit", 0);
sol_Product.ContainerID = SqlClientUtility.GetInt32(dataReader, "ContainerID", 0);
sol_Product.StandardDozenID = SqlClientUtility.GetInt32(dataReader, "StandardDozenID", 0);
sol_Product.UPC = SqlClientUtility.GetString(dataReader, "UPC", String.Empty);
sol_Product.ProductCode = SqlClientUtility.GetString(dataReader, "ProductCode", String.Empty);
sol_Product.TypeId = SqlClientUtility.GetByte(dataReader, "TypeId", 0x00);
sol_Product.Tax1Exempt = SqlClientUtility.GetBoolean(dataReader, "Tax1Exempt", false);
sol_Product.Tax2Exempt = SqlClientUtility.GetBoolean(dataReader, "Tax2Exempt", false);
sol_Product.MasterProductID = SqlClientUtility.GetInt32(dataReader, "MasterProductID", 0);
sol_Product.Weight = SqlClientUtility.GetDecimal(dataReader, "Weight", Decimal.Zero);
sol_Product.Volume = SqlClientUtility.GetDecimal(dataReader, "Volume", Decimal.Zero);
sol_Product.TargetQuantity = SqlClientUtility.GetInt32(dataReader, "TargetQuantity", 0);
return(sol_Product);
}
/// <summary>
/// Creates a new instance of the Sac_Log class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sac_Log MakeSac_Log(SqlDataReader dataReader)
{
Sac_Log sac_Log = new Sac_Log();
sac_Log.LogID = SqlClientUtility.GetInt32(dataReader, "LogID", 0);
sac_Log.EntryType = SqlClientUtility.GetInt32(dataReader, "EntryType", 0);
sac_Log.OrderNumber = SqlClientUtility.GetInt32(dataReader, "OrderNumber", 0);
sac_Log.OrderAmount = SqlClientUtility.GetDecimal(dataReader, "OrderAmount", Decimal.Zero);
sac_Log.Description = SqlClientUtility.GetString(dataReader, "Description", String.Empty);
sac_Log.Quantityof50 = SqlClientUtility.GetInt32(dataReader, "Quantityof50", 0);
sac_Log.Quantityof20 = SqlClientUtility.GetInt32(dataReader, "Quantityof20", 0);
sac_Log.Quantityof10 = SqlClientUtility.GetInt32(dataReader, "Quantityof10", 0);
sac_Log.Quantityof5 = SqlClientUtility.GetInt32(dataReader, "Quantityof5", 0);
sac_Log.QuantityofToonie = SqlClientUtility.GetInt32(dataReader, "QuantityofToonie", 0);
sac_Log.QuantityofLoonie = SqlClientUtility.GetInt32(dataReader, "QuantityofLoonie", 0);
sac_Log.QuantityofQuarter = SqlClientUtility.GetInt32(dataReader, "QuantityofQuarter", 0);
sac_Log.QuantityofDime = SqlClientUtility.GetInt32(dataReader, "QuantityofDime", 0);
sac_Log.QuantityofNickel = SqlClientUtility.GetInt32(dataReader, "QuantityofNickel", 0);
sac_Log.TotalValue = SqlClientUtility.GetDecimal(dataReader, "TotalValue", Decimal.Zero);
sac_Log.Remaining50 = SqlClientUtility.GetInt32(dataReader, "Remaining50", 0);
sac_Log.Remaining20 = SqlClientUtility.GetInt32(dataReader, "Remaining20", 0);
sac_Log.Remaining10 = SqlClientUtility.GetInt32(dataReader, "Remaining10", 0);
sac_Log.Remaining5 = SqlClientUtility.GetInt32(dataReader, "Remaining5", 0);
sac_Log.RemainingToonie = SqlClientUtility.GetInt32(dataReader, "RemainingToonie", 0);
sac_Log.RemainingLoonie = SqlClientUtility.GetInt32(dataReader, "RemainingLoonie", 0);
sac_Log.RemainingQuarter = SqlClientUtility.GetInt32(dataReader, "RemainingQuarter", 0);
sac_Log.RemainingDime = SqlClientUtility.GetInt32(dataReader, "RemainingDime", 0);
sac_Log.RemainingNickel = SqlClientUtility.GetInt32(dataReader, "RemainingNickel", 0);
sac_Log.TimeStamp = SqlClientUtility.GetDateTime(dataReader, "TimeStamp", new DateTime(0));
return(sac_Log);
}
/// <summary>
/// Creates a new instance of the sol_Shipment class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_Shipment MakeSol_Shipment(SqlDataReader dataReader)
{
Sol_Shipment sol_Shipment = new Sol_Shipment();
sol_Shipment.ShipmentID = SqlClientUtility.GetInt32(dataReader, "ShipmentID", 0);
sol_Shipment.UserID = SqlClientUtility.GetGuid(dataReader, "UserID", Guid.Empty);
sol_Shipment.UserName = SqlClientUtility.GetString(dataReader, "UserName", String.Empty);
sol_Shipment.RBillNumber = SqlClientUtility.GetString(dataReader, "RBillNumber", String.Empty);
sol_Shipment.Date = SqlClientUtility.GetDateTime(dataReader, "Date", new DateTime(0));
sol_Shipment.AgencyID = SqlClientUtility.GetInt32(dataReader, "AgencyID", 0);
sol_Shipment.AgencyName = SqlClientUtility.GetString(dataReader, "AgencyName", String.Empty);
sol_Shipment.AgencyAddress1 = SqlClientUtility.GetString(dataReader, "AgencyAddress1", String.Empty);
sol_Shipment.AgencyAddress2 = SqlClientUtility.GetString(dataReader, "AgencyAddress2", String.Empty);
sol_Shipment.AgencyCity = SqlClientUtility.GetString(dataReader, "AgencyCity", String.Empty);
sol_Shipment.AgencyProvince = SqlClientUtility.GetString(dataReader, "AgencyProvince", String.Empty);
sol_Shipment.AgencyCountry = SqlClientUtility.GetString(dataReader, "AgencyCountry", String.Empty);
sol_Shipment.AgencyPostalCode = SqlClientUtility.GetString(dataReader, "AgencyPostalCode", String.Empty);
sol_Shipment.Status = SqlClientUtility.GetString(dataReader, "Status", String.Empty);
sol_Shipment.CarrierID = SqlClientUtility.GetInt32(dataReader, "CarrierID", 0);
sol_Shipment.PlantID = SqlClientUtility.GetInt32(dataReader, "PlantID", 0);
sol_Shipment.TrailerNumber = SqlClientUtility.GetString(dataReader, "TrailerNumber", String.Empty);
sol_Shipment.ProBillNumber = SqlClientUtility.GetString(dataReader, "ProBillNumber", String.Empty);
sol_Shipment.ShippedDate = SqlClientUtility.GetDateTime(dataReader, "ShippedDate", new DateTime(0));
sol_Shipment.SealNumber = SqlClientUtility.GetString(dataReader, "SealNumber", String.Empty);
sol_Shipment.LoadReference = SqlClientUtility.GetString(dataReader, "LoadReference", String.Empty);
sol_Shipment.ERBillTransmitted = SqlClientUtility.GetBoolean(dataReader, "eRBillTransmitted", false);
return(sol_Shipment);
}
/// <summary>
/// Creates a new instance of the sol_CategoryButtons class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_CategoryButton MakeSol_CategoryButton(SqlDataReader dataReader)
{
Sol_CategoryButton sol_CategoryButton = new Sol_CategoryButton();
sol_CategoryButton.CategoryButtonID = SqlClientUtility.GetInt32(dataReader, "CategoryButtonID", 0);
sol_CategoryButton.WorkStationID = SqlClientUtility.GetInt32(dataReader, "WorkStationID", 0);
sol_CategoryButton.ControlType = SqlClientUtility.GetByte(dataReader, "ControlType", 0x00);
sol_CategoryButton.Description = SqlClientUtility.GetString(dataReader, "Description", String.Empty);
sol_CategoryButton.DefaultQuantity = SqlClientUtility.GetInt32(dataReader, "DefaultQuantity", 0);
sol_CategoryButton.CategoryID = SqlClientUtility.GetInt32(dataReader, "CategoryID", 0);
sol_CategoryButton.LocationX = SqlClientUtility.GetInt32(dataReader, "LocationX", 0);
sol_CategoryButton.LocationY = SqlClientUtility.GetInt32(dataReader, "LocationY", 0);
sol_CategoryButton.Width = SqlClientUtility.GetInt32(dataReader, "Width", 0);
sol_CategoryButton.Height = SqlClientUtility.GetInt32(dataReader, "Height", 0);
sol_CategoryButton.Font = SqlClientUtility.GetString(dataReader, "Font", String.Empty);
sol_CategoryButton.FontStyle = SqlClientUtility.GetString(dataReader, "FontStyle", String.Empty);
sol_CategoryButton.ForeColor = SqlClientUtility.GetString(dataReader, "ForeColor", String.Empty);
sol_CategoryButton.BackColor = SqlClientUtility.GetString(dataReader, "BackColor", String.Empty);
sol_CategoryButton.ImageIndex = SqlClientUtility.GetInt32(dataReader, "ImageIndex", 0);
sol_CategoryButton.ImagePath = SqlClientUtility.GetString(dataReader, "ImagePath", String.Empty);
sol_CategoryButton.SubContainerMaxCount = SqlClientUtility.GetInt32(dataReader, "SubContainerMaxCount", 0);
sol_CategoryButton.SubContainerCounter = SqlClientUtility.GetInt32(dataReader, "SubContainerCounter", 0);
sol_CategoryButton.ImageSize = SqlClientUtility.GetByte(dataReader, "ImageSize", 0x00);
sol_CategoryButton.SubContainerCountDown = SqlClientUtility.GetBoolean(dataReader, "SubContainerCountDown", false);
sol_CategoryButton.MaxCountPerLine = SqlClientUtility.GetInt32(dataReader, "MaxCountPerLine", 0);
try
{
sol_CategoryButton.ForeColorArgb = SqlClientUtility.GetInt32(dataReader, "ForeColorArgb", 0);
sol_CategoryButton.BackColorArgb = SqlClientUtility.GetInt32(dataReader, "BackColorArgb", 0);
}
catch { }
return(sol_CategoryButton);
}
protected virtual LocationRuleView MakeLocationRuleView(SqlDataReader dataReader)
{
LocationRuleView locationRule = new LocationRuleView();
// Table columns
locationRule.ID = SqlClientUtility.GetInt32(dataReader, "ID", 0);
locationRule.Code = SqlClientUtility.GetString(dataReader, "Code", String.Empty);
locationRule.LocationID = SqlClientUtility.GetInt32(dataReader, "LocationID", 0);
locationRule.RuleID = SqlClientUtility.GetInt32(dataReader, "RuleID", 0);
locationRule.IsActive = SqlClientUtility.GetBoolean(dataReader, "IsActive", false);
locationRule.Comments = SqlClientUtility.GetString(dataReader, "Comments", String.Empty);
locationRule.InternalComment = SqlClientUtility.GetString(dataReader, "InternalComment", String.Empty);
locationRule.CreatedBy = SqlClientUtility.GetString(dataReader, "CreatedBy", String.Empty);
locationRule.CreatedOn = SqlClientUtility.GetDateTime(dataReader, "CreatedOn", DateTime.Now);
locationRule.AuditActionBy = SqlClientUtility.GetString(dataReader, "AuditActionBy", String.Empty);
locationRule.AuditActionOn = SqlClientUtility.GetDateTime(dataReader, "AuditActionOn", DateTime.Now);
// Extended columns from view
locationRule.MapLatitude = SqlClientUtility.GetDecimal(dataReader, "MapLatitude", 0);
locationRule.MapLongitude = SqlClientUtility.GetDecimal(dataReader, "MapLongitude", 0);
locationRule.RadiusK = SqlClientUtility.GetDecimal(dataReader, "RadiusK", 0);
locationRule.WarnK = SqlClientUtility.GetDecimal(dataReader, "WarnK", 0);
locationRule.Direction = SqlClientUtility.GetInt32(dataReader, "Direction", 0);
locationRule.Message = SqlClientUtility.GetString(dataReader, "Message", String.Empty);
locationRule.LocationName = SqlClientUtility.GetString(dataReader, "LocationName", String.Empty);
locationRule.LocationType = SqlClientUtility.GetInt32(dataReader, "LocationType", 0);
locationRule.Polygon = SqlClientUtility.GetString(dataReader, "Polygon", String.Empty);
return(locationRule);
}
/// <summary>
/// Creates a new instance of the sol_Customers class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_Customer MakeSol_Customer(SqlDataReader dataReader)
{
Sol_Customer sol_Customer = new Sol_Customer();
sol_Customer.CustomerID = SqlClientUtility.GetInt32(dataReader, "CustomerID", 0);
sol_Customer.CustomerCode = SqlClientUtility.GetString(dataReader, "CustomerCode", String.Empty);
sol_Customer.Name = SqlClientUtility.GetString(dataReader, "Name", String.Empty);
sol_Customer.Contact = SqlClientUtility.GetString(dataReader, "Contact", String.Empty);
sol_Customer.Address1 = SqlClientUtility.GetString(dataReader, "Address1", String.Empty);
sol_Customer.Address2 = SqlClientUtility.GetString(dataReader, "Address2", String.Empty);
sol_Customer.City = SqlClientUtility.GetString(dataReader, "City", String.Empty);
sol_Customer.Province = SqlClientUtility.GetString(dataReader, "Province", String.Empty);
sol_Customer.Country = SqlClientUtility.GetString(dataReader, "Country", String.Empty);
sol_Customer.PostalCode = SqlClientUtility.GetString(dataReader, "PostalCode", String.Empty);
sol_Customer.Email = SqlClientUtility.GetString(dataReader, "Email", String.Empty);
sol_Customer.LoweredEmail = SqlClientUtility.GetString(dataReader, "LoweredEmail", String.Empty);
sol_Customer.IsActive = SqlClientUtility.GetBoolean(dataReader, "IsActive", false);
sol_Customer.PhoneNumber = SqlClientUtility.GetString(dataReader, "PhoneNumber", String.Empty);
sol_Customer.Notes = SqlClientUtility.GetString(dataReader, "Notes", String.Empty);
sol_Customer.Password = SqlClientUtility.GetString(dataReader, "Password", String.Empty);
sol_Customer.DepotID = SqlClientUtility.GetString(dataReader, "DepotID", String.Empty);
sol_Customer.CardNumber = SqlClientUtility.GetString(dataReader, "CardNumber", String.Empty);
sol_Customer.CardTypeID = SqlClientUtility.GetInt32(dataReader, "CardTypeID", 0);
sol_Customer.SolumCustomer = SqlClientUtility.GetBoolean(dataReader, "SolumCustomer", false);
sol_Customer.QuickDropCustomer = SqlClientUtility.GetBoolean(dataReader, "QuickDropCustomer", false);
//sol_Customer.IsNew = SqlClientUtility.GetBoolean(dataReader, "IsNew", false);
return(sol_Customer);
}
/// <summary>
/// Creates a new instance of the Qds_CardType class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Qds_CardType MakeQds_CardType(SqlDataReader dataReader)
{
Qds_CardType qds_CardType = new Qds_CardType();
qds_CardType.CardTypeID = SqlClientUtility.GetInt32(dataReader, "CardTypeID", 0);
qds_CardType.CardType = SqlClientUtility.GetString(dataReader, "CardType", String.Empty);
return(qds_CardType);
}
/// <summary>
/// Creates a new instance of the sol_StandardDozen class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_StandardDozen MakeSol_StandardDozen(SqlDataReader dataReader)
{
Sol_StandardDozen sol_StandardDozen = new Sol_StandardDozen();
sol_StandardDozen.StandardDozenID = SqlClientUtility.GetInt32(dataReader, "StandardDozenID", 0);
sol_StandardDozen.Quantity = SqlClientUtility.GetInt32(dataReader, "Quantity", 0);
return(sol_StandardDozen);
}
/// <summary>
/// Creates a new instance of the Sol_WS_Carriers class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_WS_Carrier MakeSol_WS_Carrier(SqlDataReader dataReader)
{
Sol_WS_Carrier sol_WS_Carrier = new Sol_WS_Carrier();
sol_WS_Carrier.CarrierID = SqlClientUtility.GetInt32(dataReader, "CarrierID", 0);
sol_WS_Carrier.Carrier = SqlClientUtility.GetString(dataReader, "Carrier", String.Empty);
return(sol_WS_Carrier);
}
/// <summary>
/// Creates a new instance of the Sol_WS_ItemTypes class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_WS_ItemType MakeSol_WS_ItemType(SqlDataReader dataReader)
{
Sol_WS_ItemType sol_WS_ItemType = new Sol_WS_ItemType();
sol_WS_ItemType.ItemTypeID = SqlClientUtility.GetInt32(dataReader, "ItemTypeID", 0);
sol_WS_ItemType.ItemType = SqlClientUtility.GetString(dataReader, "ItemType", String.Empty);
return(sol_WS_ItemType);
}
/// <summary>
/// Creates a new instance of the Sol_WS_Plants class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_WS_Plant MakeSol_WS_Plant(SqlDataReader dataReader)
{
Sol_WS_Plant sol_WS_Plant = new Sol_WS_Plant();
sol_WS_Plant.PlantID = SqlClientUtility.GetInt32(dataReader, "PlantID", 0);
sol_WS_Plant.Plant = SqlClientUtility.GetString(dataReader, "Plant", String.Empty);
return(sol_WS_Plant);
}
/// <summary>
/// Creates a new instance of the Qds_PaymentMethod class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Qds_PaymentMethod MakeQds_PaymentMethod(SqlDataReader dataReader)
{
Qds_PaymentMethod qds_PaymentMethod = new Qds_PaymentMethod();
qds_PaymentMethod.PaymentMethodID = SqlClientUtility.GetInt32(dataReader, "PaymentMethodID", 0);
qds_PaymentMethod.PaymentMethod = SqlClientUtility.GetString(dataReader, "PaymentMethod", String.Empty);
return(qds_PaymentMethod);
}
/// <summary>
/// Creates a new instance of the sol_ContainerTypes class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_ContainerType MakeSol_ContainerType(SqlDataReader dataReader)
{
Sol_ContainerType sol_ContainerType = new Sol_ContainerType();
sol_ContainerType.ContainerTypeID = SqlClientUtility.GetInt32(dataReader, "ContainerTypeID", 0);
sol_ContainerType.Description = SqlClientUtility.GetString(dataReader, "Description", String.Empty);
return(sol_ContainerType);
}
/// <summary>
/// Creates a new instance of the Sol_OrderCardLink class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_OrderCardLink MakeSol_OrderCardLink(SqlDataReader dataReader)
{
Sol_OrderCardLink sol_OrderCardLink = new Sol_OrderCardLink();
sol_OrderCardLink.CardNumber = SqlClientUtility.GetString(dataReader, "CardNumber", String.Empty);
sol_OrderCardLink.OrderID = SqlClientUtility.GetInt32(dataReader, "OrderID", 0);
return(sol_OrderCardLink);
}
/// <summary>
/// Creates a new instance of the Sac_LogType class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sac_LogType MakeSac_LogType(SqlDataReader dataReader)
{
Sac_LogType sac_LogType = new Sac_LogType();
sac_LogType.LogTypeID = SqlClientUtility.GetInt32(dataReader, "LogTypeID", 0);
sac_LogType.Description = SqlClientUtility.GetString(dataReader, "Description", String.Empty);
return(sac_LogType);
}
/// <summary>
/// Creates a new instance of the Sac_CharityType class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sac_CharityType MakeSac_CharityType(SqlDataReader dataReader)
{
Sac_CharityType sac_CharityType = new Sac_CharityType();
sac_CharityType.CharityTypeID = SqlClientUtility.GetInt32(dataReader, "CharityTypeID", 0);
sac_CharityType.CharityType = SqlClientUtility.GetString(dataReader, "CharityType", String.Empty);
return(sac_CharityType);
}
/// <summary>
/// Creates a new instance of the Vir_StagingMethod class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Vir_StagingMethod MakeVir_StagingMethod(SqlDataReader dataReader)
{
Vir_StagingMethod vir_StagingMethod = new Vir_StagingMethod();
vir_StagingMethod.StagingMethodID = SqlClientUtility.GetInt32(dataReader, "StagingMethodID", 0);
vir_StagingMethod.StagingMethodName = SqlClientUtility.GetString(dataReader, "StagingMethodName", String.Empty);
return(vir_StagingMethod);
}
/// <summary>
/// Creates a new instance of the Vir_Conveyor class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Vir_Conveyor MakeVir_Conveyor(SqlDataReader dataReader)
{
Vir_Conveyor vir_Conveyor = new Vir_Conveyor();
vir_Conveyor.ConveyorID = SqlClientUtility.GetInt32(dataReader, "ConveyorID", 0);
vir_Conveyor.ConveyorDescription = SqlClientUtility.GetString(dataReader, "ConveyorDescription", String.Empty);
return(vir_Conveyor);
}
/// <summary>
/// Creates a new instance of the LOAI_NHAN_VIEN class and populates it with data from the specified SqlDataReader.
/// </summary>
private LOAINHANVIEN_DTO MakeLOAINHANVIEN_DTO(SqlDataReader dataReader)
{
LOAINHANVIEN_DTO LoaiNhanVien = new LOAINHANVIEN_DTO();
LoaiNhanVien.Ma = SqlClientUtility.GetInt32(dataReader, "MA", 0);
LoaiNhanVien.TenLoaiNhanVien = SqlClientUtility.GetString(dataReader, "TEN_LOAI_NHAN_VIEN", String.Empty);
return(LoaiNhanVien);
}
/// <summary>
/// Creates a new instance of the HANG_SAN_XUAT class and populates it with data from the specified SqlDataReader.
/// </summary>
private HANGSANXUAT_DTO MakeHANGSANXUAT_DTO(SqlDataReader dataReader)
{
HANGSANXUAT_DTO HangSanXuat = new HANGSANXUAT_DTO();
HangSanXuat.Ma = SqlClientUtility.GetInt32(dataReader, "MA", 0);
HangSanXuat.TenHangXe = SqlClientUtility.GetString(dataReader, "TEN_HANG_XE", String.Empty);
return(HangSanXuat);
}
/// <summary>
/// Creates a new instance of the LOAI_XE class and populates it with data from the specified SqlDataReader.
/// </summary>
private LOAIXE_DTO MakeLOAIXE_DTO(SqlDataReader dataReader)
{
LOAIXE_DTO LoaiXe = new LOAIXE_DTO();
LoaiXe.Ma = SqlClientUtility.GetInt32(dataReader, "MA", 0);
LoaiXe.TenLoaiXe = SqlClientUtility.GetString(dataReader, "TEN_LOAI_XE", String.Empty);
LoaiXe.GhiChu = SqlClientUtility.GetString(dataReader, "GHI_CHU", String.Empty);
return(LoaiXe);
}
/// <summary>
/// Creates a new instance of the sol_Messages class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_Message MakeSol_Message(SqlDataReader dataReader)
{
Sol_Message sol_Message = new Sol_Message();
sol_Message.MessageID = SqlClientUtility.GetInt32(dataReader, "MessageID", 0);
sol_Message.Name = SqlClientUtility.GetString(dataReader, "Name", String.Empty);
sol_Message.Description = SqlClientUtility.GetString(dataReader, "Description", String.Empty);
return(sol_Message);
}
/// <summary>
/// Creates a new instance of the KIEU_XE class and populates it with data from the specified SqlDataReader.
/// </summary>
private KIEUXE_DTO MakeKIEUXE_DTO(SqlDataReader dataReader)
{
KIEUXE_DTO KieuXe = new KIEUXE_DTO();
KieuXe.Ma = SqlClientUtility.GetInt32(dataReader, "MA", 0);
KieuXe.MaLoaiXe = SqlClientUtility.GetInt32(dataReader, "MA_LOAI_XE", 0);
KieuXe.TenKieuXe = SqlClientUtility.GetString(dataReader, "TEN_KIEU_XE", String.Empty);
return(KieuXe);
}
/// <summary>
/// Creates a new instance of the Qds_PaymentMethodAvailableByDepot class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Qds_PaymentMethodAvailableByDepot MakeQds_PaymentMethodAvailableByDepot(SqlDataReader dataReader)
{
Qds_PaymentMethodAvailableByDepot qds_PaymentMethodAvailableByDepot = new Qds_PaymentMethodAvailableByDepot();
qds_PaymentMethodAvailableByDepot.DepotID = SqlClientUtility.GetString(dataReader, "DepotID", String.Empty);
qds_PaymentMethodAvailableByDepot.PaymentMethodID = SqlClientUtility.GetInt32(dataReader, "PaymentMethodID", 0);
qds_PaymentMethodAvailableByDepot.DepotDefault = SqlClientUtility.GetBoolean(dataReader, "DepotDefault", false);
return(qds_PaymentMethodAvailableByDepot);
}
/// <summary>
/// Creates a new instance of the Vir_ConveyorLink class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Vir_ConveyorLink MakeVir_ConveyorLink(SqlDataReader dataReader)
{
Vir_ConveyorLink vir_ConveyorLink = new Vir_ConveyorLink();
vir_ConveyorLink.ConveyorLinkID = SqlClientUtility.GetInt32(dataReader, "ConveyorLinkID", 0);
vir_ConveyorLink.BagPositionID = SqlClientUtility.GetInt32(dataReader, "BagPositionID", 0);
vir_ConveyorLink.ConveyorID = SqlClientUtility.GetInt32(dataReader, "ConveyorID", 0);
return(vir_ConveyorLink);
}
/// <summary>
/// Creates a new instance of the Sac_ClientNames class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sac_ClientName MakeSac_ClientName(SqlDataReader dataReader)
{
Sac_ClientName sac_ClientName = new Sac_ClientName();
sac_ClientName.ClientID = SqlClientUtility.GetString(dataReader, "ClientID", String.Empty);
sac_ClientName.CashTrayID = SqlClientUtility.GetInt32(dataReader, "CashTrayID", 0);
sac_ClientName.CoinAmountInventory = SqlClientUtility.GetDecimal(dataReader, "CoinAmountInventory", Decimal.Zero);
return(sac_ClientName);
}
/// <summary>
/// Creates a new instance of the Sol_BinCount class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_BinCount MakeSol_BinCount(SqlDataReader dataReader)
{
Sol_BinCount sol_BinCount = new Sol_BinCount();
sol_BinCount.ClientID = SqlClientUtility.GetString(dataReader, "ClientID", String.Empty);
sol_BinCount.CategoryButtonID = SqlClientUtility.GetInt32(dataReader, "CategoryButtonID", 0);
sol_BinCount.CurrentCount = SqlClientUtility.GetInt32(dataReader, "CurrentCount", 0);
return(sol_BinCount);
}
/// <summary>
/// Creates a new instance of the Sol_WS_ErrorCodes class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_WS_ErrorCode MakeSol_WS_ErrorCode(SqlDataReader dataReader)
{
Sol_WS_ErrorCode sol_WS_ErrorCode = new Sol_WS_ErrorCode();
sol_WS_ErrorCode.ErrorNumber = SqlClientUtility.GetInt32(dataReader, "ErrorNumber", 0);
sol_WS_ErrorCode.ErrorDescription = SqlClientUtility.GetString(dataReader, "ErrorDescription", String.Empty);
sol_WS_ErrorCode.MessageToClient = SqlClientUtility.GetBoolean(dataReader, "MessageToClient", false);
sol_WS_ErrorCode.Notes = SqlClientUtility.GetString(dataReader, "Notes", String.Empty);
return(sol_WS_ErrorCode);
}
/// <summary>
/// Creates a new instance of the CHI_TIET_PHIEU_XUAT_XE class and populates it with data from the specified SqlDataReader.
/// </summary>
private CHITIETPHIEUXUATXE_DTO MakeCHITIETPHIEUXUATXE_DTO(SqlDataReader dataReader)
{
CHITIETPHIEUXUATXE_DTO ChiTietPhieuXuatXe = new CHITIETPHIEUXUATXE_DTO();
ChiTietPhieuXuatXe.MaPhieuXuatXe = SqlClientUtility.GetInt32(dataReader, "MA_PHIEU_XUAT_XE", 0);
ChiTietPhieuXuatXe.MaXe = SqlClientUtility.GetInt32(dataReader, "MA_XE", 0);
ChiTietPhieuXuatXe.MaMau = SqlClientUtility.GetString(dataReader, "MA_MAU", String.Empty);
ChiTietPhieuXuatXe.SoLuong = SqlClientUtility.GetInt32(dataReader, "SO_LUONG", 0);
return(ChiTietPhieuXuatXe);
}
/// <summary>
/// Creates a new instance of the DON_DAT_HANG class and populates it with data from the specified SqlDataReader.
/// </summary>
private DONDATHANG_DTO MakeDONDATHANG_DTO(SqlDataReader dataReader)
{
DONDATHANG_DTO DonDatHang = new DONDATHANG_DTO();
DonDatHang.Ma = SqlClientUtility.GetInt32(dataReader, "MA", 0);
DonDatHang.NgayDat = SqlClientUtility.GetDateTime(dataReader, "NGAY_DAT", DateTime.Now);
DonDatHang.TongTien = SqlClientUtility.GetDecimal(dataReader, "TONG_TIEN", Decimal.Zero);
DonDatHang.TongSoLuong = SqlClientUtility.GetInt32(dataReader, "TONG_SO_LUONG", 0);
return(DonDatHang);
}