DamaiDataSet.ShipmentDetailDataTable CreateNewShipmentDetailDataTable(int id, int productClass)
{
DamaiDataSet.ShipmentDetailDataTable dt = new DamaiDataSet.ShipmentDetailDataTable();
foreach (DataRowView item in productBindingSource)
{
DataRow dr = item.Row as DataRow;
DamaiDataSet.ProductRow pr = dr as DamaiDataSet.ProductRow;
if (pr.Class != productClass)
{
continue;
}
DamaiDataSet.ShipmentDetailRow r = dt.NewRow() as DamaiDataSet.ShipmentDetailRow;
r.ProductID = pr.ProductID;
r.ShipmentID = id;
r.Volume = 0;
r.ID = Guid.NewGuid();
r.Cost = 0;
dt.AddShipmentDetailRow(r);
}
return(dt);
}
private void shipmentBindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
if (MyFunction.LockAll)
{
MessageBox.Show("鎖定中,不能存檔");
return;
}
if (!this.Validate())
{
MessageBox.Show("有資料錯誤, 請改好再存!");
return;
}
this.shipmentBindingSource.EndEdit();
this.shipmentDetailBindingSource.EndEdit();
//SQLVEDataSet.ShipmentDataTable table = (SQLVEDataSet.ShipmentDataTable)sQLVEDataSet.Shipment.GetChanges();
//SQLVEDataSet.ShipmentDetailDataTable detail = (SQLVEDataSet.ShipmentDetailDataTable)sQLVEDataSet.ShipmentDetail.GetChanges();
DamaiDataSet.ShipmentDataTable table = (DamaiDataSet.ShipmentDataTable)damaiDataSet.Shipment.GetChanges();
DamaiDataSet.ShipmentDetailDataTable detail = (DamaiDataSet.ShipmentDetailDataTable)damaiDataSet.ShipmentDetail.GetChanges();
if (table == null && detail == null)
{
MessageBox.Show("沒有改動任何資料! 不用存");
return;
}
if (table != null)
{
//foreach (SQLVEDataSet.ShipmentRow r in table)
foreach (DamaiDataSet.ShipmentRow r in table)
{
if (r.RowState != DataRowState.Deleted)
{
r.BeginEdit();
if (!ischecked)
{
r.KeyinID = MyFunction.OperatorID;
r.CheckedID = -1;
}
else
{
r.CheckedID = MyFunction.OperatorID;
}
r.LastUpdated = DateTime.Now;
r.EndEdit();
}
}
try
{
//sQLVEDataSet.Shipment.Merge(table);
//this.shipmentTableAdapter.Update(this.sQLVEDataSet.Shipment);
//sQLVEDataSet.Shipment.AcceptChanges();
damaiDataSet.Shipment.Merge(table);
this.shipmentTableAdapter1.Update(this.damaiDataSet.Shipment);
damaiDataSet.Shipment.AcceptChanges();
}
catch (Exception ex)
{
MessageBox.Show("存Shipment時,ex:" + ex.Message);
}
}
//if (checkMode) // 查核模式會更新會計科目
//{
// MyFunction.SetGlobalFlag(GlobalFlag.basicDataModified);
// // return;
//}
if (detail != null)
{
try
{
//sQLVEDataSet.ShipmentDetail.Merge(detail);
//shipmentDetailTableAdapter.Update(sQLVEDataSet.ShipmentDetail);
//sQLVEDataSet.ShipmentDetail.AcceptChanges();
damaiDataSet.ShipmentDetail.Merge(detail);
shipmentDetailTableAdapter1.Update(damaiDataSet.ShipmentDetail);
damaiDataSet.ShipmentDetail.AcceptChanges();
}
catch (Exception ex)
{
MessageBox.Show("存ShipmentDetail時,ex:" + ex.Message);
}
}
}
