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