/// <summary>
/// Retorna o double da coluna selecionada
/// </summary>
public static double?GetDouble(this System.Data.DataRow dr, String columnName, double?defaultValue = null)
{
try
{
return(dr.GetValue <Double>(columnName));
}
catch (Exception)
{
try
{
String value = dr.GetValue <String>(columnName);
if (String.IsNullOrEmpty(value))
{
return(defaultValue);
}
value = value.Replace(",", ".");
return(Convert.ToDouble(value));
}
catch (Exception)
{
try
{
return(Convert.ToDouble(dr.GetValue(columnName)));
}
catch (Exception)
{
return(defaultValue);
}
}
}
}
/// <summary>
/// Retorna o double da coluna selecionada
/// </summary>
public static Nullable <Decimal> GetDecimal(this System.Data.DataRow dr, String columnName, Nullable <Decimal> defaultValue = null)
{
try
{
return(dr.GetValue <Decimal>(columnName));
}
catch (Exception)
{
try
{
String value = dr.GetValue <String>(columnName);
if (String.IsNullOrEmpty(value))
{
return(defaultValue);
}
value = value.Replace(",", ".");
return(Convert.ToDecimal(value));
}
catch (Exception)
{
try
{
return(Convert.ToDecimal(dr.GetValue(columnName)));
}
catch (Exception)
{
return(defaultValue);
}
}
}
}
/// <summary>
/// Retorna o campo DateTime da coluna selecionada
/// </summary>
public static DateTime?GetDateTime(this System.Data.DataRow dr, String columnName, DateTime?defaultValue = null)
{
try
{
return(dr.GetValue <DateTime>(columnName));
}
catch (Exception)
{
try
{
DateTime?dt = dr.GetValue(columnName) as DateTime?;
if (dt == null)
{
return(Convert.ToDateTime(dr.GetValue <String>(columnName)));
}
else
{
return(dt);
}
}
catch (Exception)
{
return(defaultValue);
}
}
}
/// <summary>
/// Retorna o Integer da coluna selecionada
/// </summary>
public static Nullable <Int32> GetInteger(this System.Data.DataRow dr, String columnName, Nullable <Int32> defaultValue = null)
{
try
{
return(dr.GetValue <Int32>(columnName));
}
catch (Exception)
{
try
{
return(Convert.ToInt32(dr.GetValue <String>(columnName)));
}
catch (Exception)
{
try
{
return(Convert.ToInt32(dr.GetValue(columnName)));
}
catch (Exception)
{
return(defaultValue);
}
}
}
}
protected override void Parse(System.Data.DataRow row)
{
if (row == null)
{
return;
}
base.Parse(row);
ShuXing1 = row.GetValue("CP_ShuXing1");
ShuXing2 = row.GetValue("CP_ShuXing2");
}
protected override void Parse(System.Data.DataRow row)
{
if (row == null)
{
return;
}
base.Parse(row);
Weight = row.GetValue("Weight");
Color = row.GetValue("Color");
}
public static SkuProductModel CreateSkuProductModel(System.Data.DataRow row)
{
if (row == null)
{
return(null);
}
switch (row.GetValue("DefinitionName"))
{
case "Tires":
return(new TireProductModel(row));
case "Lungu":
return(new HubProductModel(row));
case "Wiper":
return(new WiperProductModel(row));
case "Brake":
return(new BrakeProductModel(row));
case "Battery":
return(new BatteryProductModel(row));
case "Filter":
return(new FilterProductModel(row));
case "AutoProd":
return(new AutoProductModel(row));
default:
switch (row.GetValue("Category"))
{
case "FilterElement":
return(new FilterElementProductModel(row));
case "CarWashing":
case "CarMaintenance":
return(new CarBeautyProductModel(row));
case "Oil":
return(new OilProductModel(row));
case "Membrane":
return(new MembraneProductModel(row));
default:
return(new DefaultProductModel(row));
}
}
}
protected override void Parse(System.Data.DataRow row)
{
if (row == null)
{
return;
}
base.Parse(row);
BriefAuto = row.GetValue("CP_Brief_Auto");
RefNo = row.GetValue("CP_Filter_RefNo");
Type = row.GetValue("CP_Filter_Type");
SpecialNote = row.GetValue("SpecialNote");
}
protected override void Parse(System.Data.DataRow row)
{
base.Parse(row);
this.VariantID = row.GetValue("VariantID");
var list = new List <string>();
list.Add(row.GetValue("Variant_Image_filename_1"));
list.Add(row.GetValue("Variant_Image_filename_2"));
list.Add(row.GetValue("Variant_Image_filename_3"));
Image.ImageUrls = list.Where(img => !string.IsNullOrWhiteSpace(img)).Union(Image.ImageUrls);
ProductStatistics = new ProductStatisticsModel(row);
}
/// <summary>
/// Retorna o Integer da coluna selecionada
/// </summary>
public static Int32 GetInteger(this System.Data.DataRow dr, String columnName)
{
try
{
return(dr.GetValue <Int32>(columnName));
}
catch (Exception)
{
try
{
return(Convert.ToInt32(dr.GetValue <String>(columnName)));
}
catch (Exception)
{
return(Convert.ToInt32(dr.GetValue(columnName)));
}
}
}
/// <summary>
/// Retorna o campo DateTime da coluna selecionada
/// </summary>
public static DateTime GetDateTime(this System.Data.DataRow dr, String columnName)
{
try
{
return(dr.GetValue <DateTime>(columnName));
}
catch (Exception)
{
try
{
return(Convert.ToDateTime(dr.GetValue <String>(columnName)));
}
catch (Exception)
{
return((DateTime)dr.GetValue(columnName));
}
}
}
/// <summary>
/// Retorna o texto da coluna selecionada
/// </summary>
public static String GetString(this System.Data.DataRow dr, String columnName, String defaultValue = null)
{
try
{
String value = dr.GetValue <String>(columnName);
if (string.IsNullOrEmpty(value))
{
return(defaultValue);
}
return(value.Trim());
}
catch (Exception)
{
object value = dr.GetValue(columnName);
if (value == null)
{
return(defaultValue);
}
return(value.ToString().Trim());
}
}
protected override void Parse(System.Data.DataRow row)
{
if (row == null)
{
return;
}
base.Parse(row);
Position = row.GetValue("CP_Brake_Position");
BrakeForce = row.GetValue("CP_Brake_SI_BrakeForce");
Comfortable = row.GetValue("CP_Brake_SI_Comfortable");
Life = row.GetValue("CP_Brake_SI_Life");
Noise = row.GetValue("CP_Brake_SI_Noise");
Pollute = row.GetValue("CP_Brake_SI_Pollute");
Type = row.GetValue("CP_Brake_Type");
BriefAuto = row.GetValue("CP_Brief_Auto");
}
protected override void Parse(System.Data.DataRow row)
{
if (row == null)
{
return;
}
base.Parse(row);
Infomation = row.GetValue("CP_Battery_Info");
Capacity = row.GetValue("CP_Battery_SI_Capacity");
ColdBoot = row.GetValue("CP_Battery_SI_ColdBoot");
Convenience = row.GetValue("CP_Battery_SI_Convenience");
Current = row.GetValue("CP_Battery_SI_Current");
Life = row.GetValue("CP_Battery_SI_Life");
Safety = row.GetValue("CP_Battery_SI_Safety");
Size = row.GetValue("CP_Battery_Size");
}
protected override void Parse(System.Data.DataRow row)
{
if (row == null)
{
return;
}
base.Parse(row);
Rim = row.GetValue("CP_Tire_Rim");
CB = row.GetValue("CP_Tire_CB");
ET = row.GetValue("CP_Tire_ET");
H = row.GetValue("CP_Hub_H");
PCD = row.GetValue("CP_Tire_PCD");
Stand = row.GetValue("CP_Hub_Stand");
Width = row.GetValue("CP_Hub_Width");
}
protected override void Parse(System.Data.DataRow row)
{
if (row == null)
{
return;
}
base.Parse(row);
Weight = row.GetValue("Weight");
ShuXing1 = row.GetValue("CP_ShuXing1");
ShuXing2 = row.GetValue("CP_ShuXing2");
ShuXing3 = row.GetValue("CP_ShuXing3");
ShuXing4 = row.GetValue("CP_ShuXing4");
Remark = row.GetValue("CP_Remark");
}
protected override void Parse(System.Data.DataRow row)
{
if (row == null)
{
return;
}
base.Parse(row);
if (row.HasValue("CP_Wiper_Baffler"))
{
Stand = row.GetValue("CP_Wiper_Baffler") == "1";
}
OriginalNo = row.GetValue("CP_Wiper_OriginalNo");
Series = row.GetValue("CP_Wiper_Series");
Joint = row.GetValue("CP_Wiper_SI_Joint");
Silent = row.GetValue("CP_Wiper_SI_Silent");
Wearable = row.GetValue("CP_Wiper_SI_Wearable");
Size = row.GetValue("CP_Wiper_Size");
if (row.HasValue("CP_Wiper_Stand"))
{
Stand = row.GetValue("CP_Wiper_Stand") == "1";
}
}
/// <summary>
/// Retorna o Boolean da coluna selecionada
/// </summary>
public static Nullable <Boolean> GetBoolean(this System.Data.DataRow dr, String columnName, Nullable <Boolean> defaultValue = null)
{
try
{
return(dr.GetValue <Boolean>(columnName));
}
catch (Exception)
{
try
{
return(Convert.ToBoolean(dr.GetValue(columnName)));
}
catch (Exception)
{
try
{
if (dr.GetValue <int>(columnName) == 1)
{
return(true);
}
if (dr.GetValue <int>(columnName) == 0)
{
return(false);
}
if (dr.GetValue <String>(columnName) == "1")
{
return(true);
}
if (dr.GetValue <String>(columnName) == "0")
{
return(false);
}
return(defaultValue);
}
catch (Exception)
{
return(defaultValue);
}
}
}
}
protected override void Parse(System.Data.DataRow row)
{
var value = 0;
if (row.HasValue("Image_height") && int.TryParse(row["Image_height"].ToString(), out value))
{
this.Height = value;
}
if (row.HasValue("Image_width") && int.TryParse(row["Image_width"].ToString(), out value))
{
this.Width = value;
}
var list = new List <string>();
list.Add(row.GetValue("Image_filename_Big"));
list.Add(row.GetValue("Image_filename"));
list.Add(row.GetValue("Image_filename_2"));
list.Add(row.GetValue("Image_filename_3"));
list.Add(row.GetValue("Image_filename_4"));
list.Add(row.GetValue("Image_filename_5"));
ImageUrls = list.Where(img => !string.IsNullOrWhiteSpace(img)).Distinct().ToArray();
}
protected override void Parse(System.Data.DataRow row)
{
if (row == null)
{
return;
}
if (row.HasValue("oid"))
{
Oid = Convert.ToInt32(row["oid"]);
}
ProductID = row.GetValue("ProductID");
Category = row.GetValue("Category");
DefinitionName = row.GetValue("DefinitionName");
DisplayName = row.GetValue("DisplayName");
Description = row.GetValue("Description");
int result;
if (int.TryParse(row.GetValue("isOE"), out result) && result > 0)
{
IsOE = true;
}
if (int.TryParse(row.GetValue("ProductRefer"), out result))
{
ProductRefer = result;
}
if (row.HasValue("invoice") && string.Compare(row["invoice"].ToString(), "Yes", true) == 0)
{
Invoice = true;
}
if (row.HasValue("cy_list_price"))
{
Price = Convert.ToDecimal(row["cy_list_price"]);
}
if (row.HasValue("cy_marketing_price"))
{
MarketingPrice = Convert.ToDecimal(row["cy_marketing_price"]);
}
Brand = row.GetValue("CP_Brand");
Unit = row.GetValue("CP_Unit");
Place = row.GetValue("CP_Place");
ProductCode = row.GetValue("ProductCode");
ProductColor = row.GetValue("ProductColor");
ProductSize = row.GetValue("ProductSize");
if (row.HasValue("Onsale"))
{
Onsale = Convert.ToBoolean(row.GetValue("Onsale"));
}
else
{
Onsale = true;
}
Onsale = Onsale && (Price.GetValueOrDefault() > 0);
if (row.HasValue("stockout"))
{
Stockout = Convert.ToBoolean(row.GetValue("stockout"));
}
Image = new ProductImageModel(row);
}
protected override void Parse(System.Data.DataRow row)
{
if (row == null)
{
return;
}
base.Parse(row);
Size = new TireSizeModel(row);
LoadIndex = row.GetValue("CP_Tire_LoadIndex");
SpeedRating = row.GetValue("CP_Tire_SpeedRating");
ROF = row.GetValue("CP_Tire_ROF") == "防爆";
Type = row.GetValue("CP_Tire_Type");
Pattern = row.GetValue("CP_Tire_Pattern");
TextColor = row.GetValue("CP_Tire_TextColor");
Remark = row.GetValue("CP_Tire_Remark");
int result;
if (int.TryParse(row.GetValue("ProductRefer"), out result))
{
ProductRefer = result;
}
if (row.HasValue("cy_marketing_price"))
{
MarketingPrice = Convert.ToDecimal(row["cy_marketing_price"]);
}
CorneringStability = row.GetValue("CP_Tire_SI_CorneringStability");
DeepSnowTraction = row.GetValue("CP_Tire_SI_DeepSnowTraction");
DryTraction = row.GetValue("CP_Tire_SI_DryTraction");
HydroplaningResistance = row.GetValue("CP_Tire_SI_HydroplaningResistance");
IceTraction = row.GetValue("CP_Tire_SI_IceTraction");
LightSnowTraction = row.GetValue("CP_Tire_SI_LightSnowTraction");
NoiseComfort = row.GetValue("CP_Tire_SI_NoiseComfort");
RideComfort = row.GetValue("CP_Tire_SI_RideComfort");
SteeringResponse = row.GetValue("CP_Tire_SI_SteeringResponse");
WetTraction = row.GetValue("CP_Tire_SI_WetTraction");
}
protected override void Parse(System.Data.DataRow row)
{
base.Parse(row);
if (row.HasValue("AdditionalProperties"))
{
try
{
AdditionalProperties = JsonConvert.DeserializeObject <IDictionary <string, string> >(row.GetValue("AdditionalProperties"));
}
catch { }
}
if (AdditionalProperties == null)
{
AdditionalProperties = new Dictionary <string, string>();
}
}
protected override void Parse(System.Data.DataRow row)
{
Width = row.GetValue("CP_Tire_Width");
AspectRatio = row.GetValue("CP_Tire_AspectRatio");
Rim = row.GetValue("CP_Tire_Rim");
}
