public int Insert(ProductClothesCirculationSKURecord info)
{
try
{
string commandText = string.Format("insert into ProductCirculationSKURecord(productSKUID, num, price, recordID) values('{0}', '{1}', '{2}', '{3}')",
info.ProductSKUID, info.Num, info.Price, info.RecordID);
return(DbHelperAccess.executeNonQuery(commandText));
}
catch (Exception ex)
{
throw ex;
}
}
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);
}
private bool getRecord(out ProductClothesCirculationRecord record)
{
record = new ProductClothesCirculationRecord();
record.SkuRecords = new List <ProductClothesCirculationSKURecord>();
int totalNum = 0;
for (int i = 0; i < this.dataGridView1.Rows.Count; i++)
{
for (int j = 1; j < this.dataGridView1.Rows[i].Cells.Count; j++)
{
int num = 0;
if (!ValidateUtility.getInt(this.dataGridView1[j, i], false, true, out num))
{
return(false);
}
if (num == 0)
{
continue;
}
ProductClothesCirculationSKURecord skuRecord = new ProductClothesCirculationSKURecord();
skuRecord.Num = num;
skuRecord.ProductSKU = ProductSKUDao.getInstance().FindByComposeID(productId, colorAttrs[i].CharactorValueId, sizeAttrs[j - 1].CharactorValueId);
skuRecord.ProductSKUID = skuRecord.ProductSKU.ID;
record.SkuRecords.Add(skuRecord);
totalNum += num;
}
}
record.ProductID = ProductId;
record.TotalNum = totalNum;
return(true);
}
