public static SalesOrderDetailList Searchzz(string pcompany, out double mappingTiem, out double sqlCallTie)
{
Database wDataBase = null;
DbCommand wCmd = null;
SalesOrderDetailList list;
SalesOrderDetail sales;
Stopwatch watch = new Stopwatch();
try
{
wDataBase = DatabaseFactory.CreateDatabase(pcompany);
wCmd = wDataBase.GetStoredProcCommand("SalesOrderDetail_s");
watch.Start();
IDataReader reader = wDataBase.ExecuteReader(wCmd);
watch.Stop();
sqlCallTie = watch.Elapsed.TotalMilliseconds;
watch.Reset();
watch.Start();
list = new SalesOrderDetailList();
while (reader.Read())
{
sales = new SalesOrderDetail();
sales.CarrierTrackingNumber = reader["CarrierTrackingNumber"].ToString();
sales.LineTotal = Convert.ToInt32(reader["LineTotal"]);
sales.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]);
sales.ProductID = Convert.ToInt32(reader.GetOrdinal("ProductID"));
sales.OrderQty = Convert.ToInt32(reader["OrderQty"]);
sales.rowguid = (Guid)reader["rowguid"];
sales.SalesOrderDetailID = Convert.ToInt32(reader["SalesOrderDetailID"]);
sales.SalesOrderID = Convert.ToInt32(reader["SalesOrderID"]);
sales.SpecialOfferID = Convert.ToInt32(reader["SpecialOfferID"]);
sales.UnitPrice = Convert.ToDouble(reader["UnitPrice"]);
sales.UnitPriceDiscount = Convert.ToDouble(reader["UnitPriceDiscount"]);
list.Add(sales);
}
reader.Close();
reader.Dispose();
watch.Stop();
mappingTiem = watch.Elapsed.TotalMilliseconds;
return(list);
}
catch (Exception ex)
{
throw Fwk.Exceptions.ExceptionHelper.ProcessException(ex);
}
}
public static SalesOrderDetailList Searchzz(string pcompany, out double mappingTiem, out double sqlCallTie)
{
Database wDataBase = null;
DbCommand wCmd = null;
SalesOrderDetailList list;
SalesOrderDetail sales;
Stopwatch watch = new Stopwatch();
try
{
wDataBase = DatabaseFactory.CreateDatabase(pcompany);
wCmd = wDataBase.GetStoredProcCommand("SalesOrderDetail_s");
watch.Start();
IDataReader reader = wDataBase.ExecuteReader(wCmd);
watch.Stop();
sqlCallTie = watch.Elapsed.TotalMilliseconds;
watch.Reset();
watch.Start();
list = new SalesOrderDetailList();
while (reader.Read())
{
sales = new SalesOrderDetail();
sales.CarrierTrackingNumber = reader["CarrierTrackingNumber"].ToString();
sales.LineTotal = Convert.ToInt32(reader["LineTotal"]);
sales.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]);
sales.ProductID = Convert.ToInt32(reader.GetOrdinal("ProductID"));
sales.OrderQty = Convert.ToInt32(reader["OrderQty"]);
sales.rowguid = (Guid)reader["rowguid"];
sales.SalesOrderDetailID = Convert.ToInt32(reader["SalesOrderDetailID"]);
sales.SalesOrderID = Convert.ToInt32(reader["SalesOrderID"]);
sales.SpecialOfferID = Convert.ToInt32(reader["SpecialOfferID"]);
sales.UnitPrice = Convert.ToDouble(reader["UnitPrice"]);
sales.UnitPriceDiscount = Convert.ToDouble(reader["UnitPriceDiscount"]);
list.Add(sales);
}
reader.Close();
reader.Dispose();
watch.Stop();
mappingTiem = watch.Elapsed.TotalMilliseconds;
return list;
}
catch (Exception ex)
{
throw Fwk.Exceptions.ExceptionHelper.ProcessException(ex);
}
}
public static SalesOrderDetailList Search(string pcompany, out double mappingTiem, out double sqlCallTie, out Hashtable pRetrieveStatistics)
{
SqlConnection conn = new SqlConnection(GetCnnstring_App(pcompany));
conn.StatisticsEnabled = true;
SqlCommand cmd = new SqlCommand("SalesOrderDetail_s", conn);
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Connection = conn;
//cmd.CommandText = "SalesOrderDetail_s";
SalesOrderDetailList list;
SalesOrderDetail sales;
Stopwatch watch = new Stopwatch();
try
{
conn.Open();
watch.Start();
IDataReader reader = cmd.ExecuteReader();
watch.Stop();
sqlCallTie = watch.Elapsed.TotalMilliseconds;
watch.Reset();
watch.Start();
#region DATA Mapping
list = new SalesOrderDetailList();
while (reader.Read())
{
sales = new SalesOrderDetail();
sales.CarrierTrackingNumber = reader["CarrierTrackingNumber"].ToString();
sales.LineTotal = Convert.ToInt32(reader["LineTotal"]);
sales.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]);
sales.ProductID = Convert.ToInt32(reader.GetOrdinal("ProductID"));
sales.OrderQty = Convert.ToInt32(reader["OrderQty"]);
sales.rowguid = (Guid)reader["rowguid"];
sales.SalesOrderDetailID = Convert.ToInt32(reader["SalesOrderDetailID"]);
sales.SalesOrderID = Convert.ToInt32(reader["SalesOrderID"]);
sales.SpecialOfferID = Convert.ToInt32(reader["SpecialOfferID"]);
sales.UnitPrice = Convert.ToDouble(reader["UnitPrice"]);
sales.UnitPriceDiscount = Convert.ToDouble(reader["UnitPriceDiscount"]);
list.Add(sales);
}
reader.Close();
reader.Dispose();
#endregion
watch.Stop();
mappingTiem = watch.Elapsed.TotalMilliseconds;
//Recojo las estadísticas
pRetrieveStatistics = (Hashtable)conn.RetrieveStatistics();
return list;
}
catch (Exception ex)
{
throw Fwk.Exceptions.ExceptionHelper.ProcessException(ex);
}
}
public static SalesOrderDetailList Search(string pcompany, out double mappingTiem, out double sqlCallTie, out Hashtable pRetrieveStatistics)
{
SqlConnection conn = new SqlConnection(GetCnnstring_App(pcompany));
conn.StatisticsEnabled = true;
SqlCommand cmd = new SqlCommand("SalesOrderDetail_s", conn);
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Connection = conn;
//cmd.CommandText = "SalesOrderDetail_s";
SalesOrderDetailList list;
SalesOrderDetail sales;
Stopwatch watch = new Stopwatch();
try
{
conn.Open();
watch.Start();
IDataReader reader = cmd.ExecuteReader();
watch.Stop();
sqlCallTie = watch.Elapsed.TotalMilliseconds;
watch.Reset();
watch.Start();
#region DATA Mapping
list = new SalesOrderDetailList();
while (reader.Read())
{
sales = new SalesOrderDetail();
sales.CarrierTrackingNumber = reader["CarrierTrackingNumber"].ToString();
sales.LineTotal = Convert.ToInt32(reader["LineTotal"]);
sales.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]);
sales.ProductID = Convert.ToInt32(reader.GetOrdinal("ProductID"));
sales.OrderQty = Convert.ToInt32(reader["OrderQty"]);
sales.rowguid = (Guid)reader["rowguid"];
sales.SalesOrderDetailID = Convert.ToInt32(reader["SalesOrderDetailID"]);
sales.SalesOrderID = Convert.ToInt32(reader["SalesOrderID"]);
sales.SpecialOfferID = Convert.ToInt32(reader["SpecialOfferID"]);
sales.UnitPrice = Convert.ToDouble(reader["UnitPrice"]);
sales.UnitPriceDiscount = Convert.ToDouble(reader["UnitPriceDiscount"]);
list.Add(sales);
}
reader.Close();
reader.Dispose();
#endregion
watch.Stop();
mappingTiem = watch.Elapsed.TotalMilliseconds;
//Recojo las estadísticas
pRetrieveStatistics = (Hashtable)conn.RetrieveStatistics();
return(list);
}
catch (Exception ex)
{
throw Fwk.Exceptions.ExceptionHelper.ProcessException(ex);
}
}
