/// <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; }