public static ProductSKUDao getInstance()
{
if (dao == null)
{
dao = new ProductSKUDao();
}
return(dao);
}
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());
}
