public static T Convert <T>(System.Data.Common.DbDataReader reader, ref T obj)
{
try
{
var fields = typeof(T).GetFields(BindingFlags.Instance | BindingFlags.Public);
foreach (var f in fields)
{
var col = reader.GetOrdinal(f.Name);
if (col >= 0)
{
f.SetValue(obj, ChangeType(reader.GetValue(col), f.FieldType));
}
}
var props = typeof(T).GetProperties(BindingFlags.Instance | BindingFlags.Public);
foreach (var p in props)
{
var col = reader.GetOrdinal(p.Name);
if (col >= 0)
{
p.SetValue(obj, ChangeType(reader.GetValue(col), p.PropertyType), null);
}
}
}
catch (Exception ex) { TraceLogger.Instance.WriteException(ex); throw; }
return(obj);
}
public static MobileDeviceOther getMobileDeviceOther(System.Data.Common.DbDataReader reader)
{
MobileDeviceOther mobileDeviceOther = new MobileDeviceOther();
mobileDeviceOther.MD_ = reader.GetString(reader.GetOrdinal("MD#"));
mobileDeviceOther.Other = reader.GetString(reader.GetOrdinal("Other"));
return(mobileDeviceOther);
}
public static MobileDeviceMutimedia getMobileDeviceMutimedia(System.Data.Common.DbDataReader reader)
{
MobileDeviceMutimedia mobileDeviceMutimedia = new MobileDeviceMutimedia();
mobileDeviceMutimedia.MD_ = reader.GetString(reader.GetOrdinal("MD#"));
mobileDeviceMutimedia.Mutimedia = reader.GetString(reader.GetOrdinal("Mutimedia"));
return(mobileDeviceMutimedia);
}
public static MobileDeviceCC getMobileDeviceCC(System.Data.Common.DbDataReader reader)
{
MobileDeviceCC mobileDeviceCC = new MobileDeviceCC();
mobileDeviceCC.MD_ = reader.GetString(reader.GetOrdinal("MD#"));
mobileDeviceCC.CC = reader.GetString(reader.GetOrdinal("CC"));
return(mobileDeviceCC);
}
public static Manufacture getManufacture(System.Data.Common.DbDataReader reader)
{
Manufacture manufacture = new Manufacture();
manufacture.ManuName = reader.GetString(reader.GetOrdinal("ManuName"));
manufacture.ManuURL = reader.GetString(reader.GetOrdinal("ManuURL"));
return(manufacture);
}
public static SMD getSMD(System.Data.Common.DbDataReader reader)
{
SMD SMD = new SMD();
SMD.StoreName = reader.GetString(reader.GetOrdinal("StoreName"));
SMD.MD_ = reader.GetString(reader.GetOrdinal("MD#"));
SMD.SMDURL = reader.GetString(reader.GetOrdinal("SMDURL"));
SMD.SMDPrice = reader.GetInt32(reader.GetOrdinal("SMDPrice"));
return(SMD);
}
public static MobileDeviceReview getMobileDeviceReview(System.Data.Common.DbDataReader reader)
{
MobileDeviceReview mobileDeviceReview = new MobileDeviceReview();
mobileDeviceReview.MD_ = reader.GetString(reader.GetOrdinal("MD#"));
mobileDeviceReview.ReviewURL = reader.GetString(reader.GetOrdinal("ReviewURL"));
mobileDeviceReview.ReviewType = reader.GetString(reader.GetOrdinal("ReviewType"));
mobileDeviceReview.ReviewName = reader.GetString(reader.GetOrdinal("ReviewName"));
mobileDeviceReview.ReviewMainSite = reader.GetString(reader.GetOrdinal("ReviewMainSite"));
return(mobileDeviceReview);
}
private static void QueryEmployee(Oracle.DataAccess.Client.OracleConnection conn)
{
string sql = "Select Emp_Id, Emp_No, Emp_Name, Mng_Id from Employee";
// Tạo một đối tượng Command.
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand();
// Liên hợp Command với Connection.
cmd.Connection = conn;
cmd.CommandText = sql;
using (System.Data.Common.DbDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
// Chỉ số (index) của cột Emp_ID trong câu lệnh SQL.
int empIdIndex = reader.GetOrdinal("Emp_Id"); // 0
long empId = Convert.ToInt64(reader.GetValue(0));
// Chỉ số của cột Emp_No là 1.
string empNo = reader.GetString(1);
int empNameIndex = reader.GetOrdinal("Emp_Name");// 2
string empName = reader.GetString(empNameIndex);
int mngIdIndex = reader.GetOrdinal("Mng_Id");
long?mngId = null;
if (!reader.IsDBNull(mngIdIndex))
{
mngId = Convert.ToInt64(reader.GetValue(mngIdIndex));
}
Console.WriteLine("--------------------");
Console.WriteLine("empIdIndex:" + empIdIndex);
Console.WriteLine("EmpId:" + empId);
Console.WriteLine("EmpNo:" + empNo);
Console.WriteLine("EmpName:" + empName);
Console.WriteLine("MngId:" + mngId);
}
}
}
}
public static GPU getGPU(System.Data.Common.DbDataReader reader)
{
GPU GPU = new GPU();
GPU.GPU_ = reader.GetString(reader.GetOrdinal("GPU#"));
GPU.ManuName = reader.GetString(reader.GetOrdinal("ManuName"));
GPU.GPUName = reader.GetString(reader.GetOrdinal("GPUName"));
GPU.Cores = reader.GetString(reader.GetOrdinal("Cores"));
GPU.BaseClock = reader.GetString(reader.GetOrdinal("BaseClock"));
GPU.BoostClock = reader.GetString(reader.GetOrdinal("BoostClock"));
GPU.MemorySpeed = reader.GetString(reader.GetOrdinal("MemorySpeed"));
GPU.MemoryConfig = reader.GetString(reader.GetOrdinal("MemoryConfig"));
GPU.PowerDraw = reader.GetString(reader.GetOrdinal("PowerDraw"));
return(GPU);
}
public static LapTop getLapTop(System.Data.Common.DbDataReader reader)
{
LapTop laptop = new LapTop();
laptop.MD_ = reader.GetString(reader.GetOrdinal("MD#"));
laptop.CDPlayer = reader.GetString(reader.GetOrdinal("CDPlayer"));
laptop.Adapter = reader.GetString(reader.GetOrdinal("Adapter"));
laptop.Port = reader.GetString(reader.GetOrdinal("Port"));
laptop.Webcam = reader.GetString(reader.GetOrdinal("Webcam"));
laptop.CpuName = reader.GetString(reader.GetOrdinal("CpuName"));
laptop.CPUManuName = reader.GetString(reader.GetOrdinal("CPUManuName"));
laptop.InPort = reader.GetString(reader.GetOrdinal("InPort"));
return(laptop);
}
public static x86CPU getX86CPU(System.Data.Common.DbDataReader reader)
{
x86CPU x86CPU = new x86CPU();
x86CPU.CpuName = reader.GetString(reader.GetOrdinal("CpuName"));
x86CPU.ManuName = reader.GetString(reader.GetOrdinal("ManuName"));
x86CPU.CAndT = reader.GetString(reader.GetOrdinal("CAndT"));
x86CPU.BaseClock = reader.GetString(reader.GetOrdinal("BaseClock"));
x86CPU.TurboClock = reader.GetString(reader.GetOrdinal("TurboClock"));
x86CPU.TDP = reader.GetString(reader.GetOrdinal("TDP"));
x86CPU.Graphics = reader.GetString(reader.GetOrdinal("Graphics"));
x86CPU.Cache = reader.GetString(reader.GetOrdinal("Cache"));
return(x86CPU);
}
public static Screen getScreen(System.Data.Common.DbDataReader reader)
{
Screen screen = new Screen();
screen.Screen_ = reader.GetString(reader.GetOrdinal("Screen#"));
screen.Resulation = reader.GetString(reader.GetOrdinal("Resulation"));
screen.Reflash = reader.GetString(reader.GetOrdinal("Reflash"));
screen.SRGB = reader.GetString(reader.GetOrdinal("SRGB"));
screen.SType = reader.GetString(reader.GetOrdinal("SType"));
screen.Size = reader.GetString(reader.GetOrdinal("Size"));
screen.HDR = reader.GetString(reader.GetOrdinal("HDR"));
return(screen);
}
public static string GetReaderValueString(System.Data.Common.DbDataReader reader, string name)
{
var ordinal = reader.GetOrdinal(name);
if (reader.IsDBNull(ordinal))
{
return(null);
}
try
{
return(reader.GetString(ordinal));
}
catch (Exception ex)
{
throw ex;
}
return(null);
}
public static Storage getStorage(System.Data.Common.DbDataReader reader)
{
Storage storage = new Storage();
storage.Storage_ = reader.GetString(reader.GetOrdinal("Storage#"));
storage.StorageName = reader.GetString(reader.GetOrdinal("StorageName"));
storage.ManuName = reader.GetString(reader.GetOrdinal("ManuName"));
storage.StorageType = reader.GetString(reader.GetOrdinal("StorageType"));
storage.StoragePort = reader.GetString(reader.GetOrdinal("StoragePort"));
storage.StorageCapacity = reader.GetString(reader.GetOrdinal("StorageCapacity"));
return(storage);
}
/// <summary>
/// Gets a float column. Slower then GetOrdinal + GetFloat
/// </summary>
/// <param name="reader"></param>
/// <param name="name"></param>
/// <returns></returns>
public static float GetFloat(this System.Data.Common.DbDataReader reader, string name)
{
int ordinal = reader.GetOrdinal(name);
return(reader.GetFloat(ordinal));
}
/// <summary>
/// Gets a double column. Slower then GetOrdinal + GetDouble
/// </summary>
/// <param name="reader"></param>
/// <param name="name"></param>
/// <returns></returns>
public static double GetDouble(this System.Data.Common.DbDataReader reader, string name)
{
int ordinal = reader.GetOrdinal(name);
return(reader.GetDouble(ordinal));
}
/// <summary>
/// Gets a float column. Slower then GetOrdinal + GetFloat
/// </summary>
/// <param name="reader"></param>
/// <param name="name"></param>
/// <returns></returns>
public static float?GetNFloat(this System.Data.Common.DbDataReader reader, string name)
{
int ordinal = reader.GetOrdinal(name);
return(reader.IsDBNull(ordinal) ? (float?)null : reader.GetFloat(ordinal));
}
/// <summary>
/// Gets a bool column. Slower then GetOrdinal + GetBoolean
/// </summary>
/// <param name="reader"></param>
/// <param name="name"></param>
/// <returns></returns>
public static bool GetBoolean(this System.Data.Common.DbDataReader reader, string name)
{
int ordinal = reader.GetOrdinal(name);
return(reader.GetBoolean(ordinal));
}
/// <summary>
/// Gets a bool column. Slower then GetOrdinal + GetBool
/// </summary>
/// <param name="reader"></param>
/// <param name="name"></param>
/// <returns></returns>
public static bool?GetNBoolean(this System.Data.Common.DbDataReader reader, string name)
{
int ordinal = reader.GetOrdinal(name);
return(reader.IsDBNull(ordinal) ? (bool?)null : reader.GetBoolean(ordinal));
}
/// <summary>
/// Gets an int column. Slower then GetOrdinal + GetInt32
/// </summary>
/// <param name="reader"></param>
/// <param name="name"></param>
/// <returns></returns>
public static Int32 GetInt32(this System.Data.Common.DbDataReader reader, string name)
{
int ordinal = reader.GetOrdinal(name);
return(reader.GetInt32(ordinal));
}
private int GetInt(System.Data.Common.DbDataReader RS, String FiledName)
{
int FieldID = RS.GetOrdinal(FiledName);
return(RS.IsDBNull(FieldID) ? 0 : RS.GetInt32(FieldID));
}
private String GetString(System.Data.Common.DbDataReader RS, String FiledName)
{
return(RS.IsDBNull(RS.GetOrdinal(FiledName)) ? "" : RS[FiledName].ToString());
}
/// <summary>
/// Gets a decimal column. Slower then GetOrdinal + GetDecimal
/// </summary>
/// <param name="reader"></param>
/// <param name="name"></param>
/// <returns></returns>
public static decimal?GetNDecimal(this System.Data.Common.DbDataReader reader, string name)
{
int ordinal = reader.GetOrdinal(name);
return(reader.IsDBNull(ordinal) ? (decimal?)null : reader.GetDecimal(ordinal));
}
/// <summary>
/// Gets a datetime column. Slower then GetOrdinal + GetDateTime
/// </summary>
/// <param name="reader"></param>
/// <param name="name"></param>
/// <returns></returns>
public static DateTime?GetNDateTime(this System.Data.Common.DbDataReader reader, string name)
{
int ordinal = reader.GetOrdinal(name);
return(reader.IsDBNull(ordinal) ? (DateTime?)null : reader.GetDateTime(ordinal));
}
/// <summary>
/// Gets a byte array column.
/// Use this for small byte array only, such as timestamps
///
/// Slower then GetOrdinal + GetByteArray(ordinal)
/// </summary>
/// <param name="reader"></param>
/// <param name="name">The name of the column</param>
/// <returns></returns>
public static byte[]? GetByteArray(this System.Data.Common.DbDataReader reader, string name)
{
int ordinal = reader.GetOrdinal(name);
return(reader.IsDBNull(ordinal) ? null : (byte[])reader.GetValue(ordinal));
}
/// <summary>
/// Gets a string column. Slower then GetOrdinal + GetString
/// </summary>
/// <param name="reader"></param>
/// <param name="name"></param>
/// <returns></returns>
public static string?GetNString(this System.Data.Common.DbDataReader reader, string name)
{
int ordinal = reader.GetOrdinal(name);
return(reader.IsDBNull(ordinal) ? null : reader.GetString(ordinal));
}
/// <summary>
/// Gets an int column. Slower then GetOrdinal + GetInt32
/// </summary>
/// <param name="reader"></param>
/// <param name="name"></param>
/// <returns></returns>
public static Int32?GetNInt32(this System.Data.Common.DbDataReader reader, string name)
{
int ordinal = reader.GetOrdinal(name);
return(reader.IsDBNull(ordinal) ? (int?)null : reader.GetInt32(ordinal));
}
public static MobileDevice getMobileDevice(System.Data.Common.DbDataReader reader)
{
MobileDevice mobileDevice = new MobileDevice();
mobileDevice.MD_ = reader.GetString(reader.GetOrdinal("MD#"));
mobileDevice.MDName = reader.GetString(reader.GetOrdinal("MDName"));
mobileDevice.MDType = reader.GetString(reader.GetOrdinal("MDType"));
mobileDevice.OfficialWebsite = reader.GetString(reader.GetOrdinal("OfficialWebsite"));
mobileDevice.OS = reader.GetString(reader.GetOrdinal("OS"));
mobileDevice.Weight = reader.GetString(reader.GetOrdinal("Weight"));
mobileDevice.Size = reader.GetString(reader.GetOrdinal("Size"));
mobileDevice.Battery = reader.GetString(reader.GetOrdinal("Battery"));
mobileDevice.Warranty = reader.GetString(reader.GetOrdinal("Warranty"));
mobileDevice.Ram = reader.GetString(reader.GetOrdinal("Ram"));
mobileDevice.ImageURL = reader.GetString(reader.GetOrdinal("ImageURL"));
mobileDevice.Screen_ = reader.GetString(reader.GetOrdinal("Screen#"));
mobileDevice.ManuName = reader.GetString(reader.GetOrdinal("ManuName"));
mobileDevice.Series_ = reader.GetString(reader.GetOrdinal("Series#"));
return(mobileDevice);
}
