public MyProductType GetItem(string brandCode, string regionCode, string productType)
{
DataTable dt = JCBase.Utility.Util.InsertDsCachForLoad("JCHVRF_ProductType");
DataView dv = dt.DefaultView;
string sql = " BrandCode='" + brandCode + "' and RegionCode = '" + regionCode + "' and ProductType = '" + productType + "'";//FactoryCode='" + factoryCode + "' and
dv.RowFilter = sql;
dt = dv.ToTable();
if (dt != null && dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
MyProductType item = new MyProductType();
item.BrandCode = brandCode;
item.FactoryCode = dr["FactoryCode"].ToString();
item.RegionCode = regionCode;
item.ProductType = productType;
item.Series = (dr["Series"] is DBNull) ? "" : dr["Series"].ToString();
item.MinCoolingDB = (dr["MinCoolingDB"] is DBNull) ? 0 : Convert.ToInt32(dr["MinCoolingDB"].ToString());
item.MaxCoolingDB = (dr["MaxCoolingDB"] is DBNull) ? 0 : Convert.ToInt32(dr["MaxCoolingDB"].ToString());
item.MinHeatingWB = (dr["MinHeatingWB"] is DBNull) ? 0 : Convert.ToInt32(dr["MinHeatingWB"].ToString());
item.MaxHeatingWB = (dr["MaxHeatingWB"] is DBNull) ? 0 : Convert.ToInt32(dr["MaxHeatingWB"].ToString());
if (dt.Columns.Contains("L2SizeDownRule"))
{
item.L2SizeDownRule = Convert.ToString(dr["L2SizeDownRule"]);
}
return(item);
}
return(null);
}
/// <summary>
/// 获取新风机的productType
/// </summary>
/// <param name="brandCode"></param>
/// <param name="regionCode"></param>
/// <returns></returns>
public DataTable GetFreshAirProductTypeData(string brandCode, string regionCode)
{
List <MyProductType> strList = new List <MyProductType>();
// 此处GetStdTableName中的参数flag直接用“Indoor”，因为Indoor与FreshAir的数据放在同一张标准表中
string sTableName = GetStdTableName(IndoorType.Indoor, regionCode);
DataTable dt = new DataTable();
if (!string.IsNullOrEmpty(sTableName))
{
String sql = "select DISTINCT t1.productType,t1.series from JCHVRF_ProductType t1 " +
"left join " + sTableName + " t2 on t1.productType = t2.productType " +
" where t2.selectionType = 'FreshAir' and t2.deleteflag = 1 and t1.BrandCode='" + brandCode + "' and t1.FactoryCode<>'G' and t1.RegionCode = '" + regionCode + "'";
dt = _dao.GetDataTable(sql);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
MyProductType productType = new MyProductType();
productType.ProductType = dr["productType"].ToString();
productType.Series = dr["series"].ToString();
//strList.Add(productType);
}
}
//if (strList != null && strList.Count > 0)
// return strList;
}
if (dt != null && dt.Rows.Count > 0)
{
return(dt);
}
return(null);
}
