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