/// <summary>
/// 得到所有产品类型
/// </summary>
public static List<ProductType> GetItems()
{
string sql = "select * from ProductType";
DataTable dt = DataMake.DataTableRead(sql);
ProductType productType = new ProductType();
List<ProductType> productTypeList = new List<ProductType>();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
productType.id = (int)dt.Rows[i]["Id"];
productType.productTypeName_zh = dt.Rows[i]["ProductTypeName_zh"].ToString();
productType.productTypeName_en = dt.Rows[i]["ProductTypeName_en"].ToString();
productType.productTypeRemark = dt.Rows[i]["ProductType_Remark"].ToString();
productTypeList.Add(productType);
}
}
return productTypeList;
}
/// <summary>
/// 获取某一个产品类型
/// </summary>
public static ProductType GetItem(string id)
{
string sql = "select * from ProductType where Id="+id;
DataTable dt = DataMake.DataTableRead(sql);
ProductType productType = new ProductType();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
productType.id = (int)dt.Rows[i]["Id"];
productType.productTypeName_zh = dt.Rows[i]["ProductTypeName_zh"].ToString();
productType.productTypeName_en = dt.Rows[i]["ProductTypeName_en"].ToString();
productType.productTypeRemark = dt.Rows[i]["ProductType_Remark"].ToString();
}
}
return productType;
}