private void button_save_Click(object sender, EventArgs e)
{
ProductClothesCirculationRecord record = null;
if (this.getRecord(out record))
{
LookupArg arg = new LookupArg(record, record.getTxt());
this.invokeLookupCallback(arg);
this.Close();
}
}
public int Insert(ProductClothesCirculationRecord info)
{
try
{
string commandText = string.Format("insert into ProductCirculationRecord(productID, totalNum, price, circulationID) values('{0}', '{1}', '{2}', '{3}')",
info.ProductID, info.TotalNum, info.Price, info.CirculationID);
DbHelperAccess.executeNonQuery(commandText);
int recordID = DbHelperAccess.executeMax("ID", "ProductCirculationRecord");
List <ProductClothesCirculationSKURecord> skuRecords = info.SkuRecords;
ProductClothesCirculationSKURecordDao dao = new ProductClothesCirculationSKURecordDao();
foreach (ProductClothesCirculationSKURecord record in skuRecords)
{
record.RecordID = recordID;
dao.Insert(record);
}
return(recordID);
}
catch (Exception ex)
{
throw ex;
}
}
public override void showDialog(object value)
{
this.initDataGridView();
string type = value.GetType().Name;
if (type.Equals("ProductCirculationRecord"))
{
try
{
ProductClothesCirculationRecord record = value as ProductClothesCirculationRecord;
List <ProductClothesCirculationSKURecord> records = record.SkuRecords;
foreach (ProductClothesCirculationSKURecord skuRecord in records)
{
int i = 0, j = 0;
for (; i < colorAttrs.Count; i++)
{
if (colorAttrs[i].CharactorValueId == skuRecord.ProductSKU.Color.Id)
{
break;
}
}
for (; j < sizeAttrs.Count; j++)
{
if (sizeAttrs[j].CharactorValueId == skuRecord.ProductSKU.Size.Id)
{
break;
}
}
this.dataGridView1.Rows.Count.ToString();
this.dataGridView1.ColumnCount.ToString();
this.dataGridView1[j + 1, i].Value = skuRecord.Num;
}
}
catch { }
}
this.ShowDialog();
}
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);
}
