public List <ProductClothesCirculationSKURecord> FindList(int recordID) { List <ProductClothesCirculationSKURecord> records = new List <ProductClothesCirculationSKURecord>(); string commandText = string.Format("select * from ProductCirculationSKURecord where recordID = {0}", recordID); DataTable dt = DbHelperAccess.executeQuery(commandText); foreach (DataRow dr in dt.Rows) { ProductClothesCirculationSKURecord record = new ProductClothesCirculationSKURecord(); record.RecordID = recordID; record.ID = (int)dr["ID"]; record.Num = (int)dr["num"]; record.ProductSKUID = (int)dr["productSKUID"]; record.ProductSKU = ProductSKUDao.getInstance().FindByID(record.ProductSKUID); records.Add(record); } return(records); }
//commented by stone public string getNumString(int productId) { List <ProductAttribute> colorAttrs = findAttributes(productId, 1); List <ProductAttribute> sizeAttrs = findAttributes(productId, 2); StringBuilder sb = new StringBuilder(); string line = ""; foreach (ProductAttribute color in colorAttrs) { line = ""; foreach (ProductAttribute size in sizeAttrs) { line += string.Format(" {0}/{1}:{2,-5}", color.CharactorValue.Name, size.CharactorValue.Name, ProductSKUDao.getInstance().FindNumByComposeID(productId, color.CharactorValueId, size.CharactorValueId)); } sb.AppendLine(line); } return(sb.ToString()); }