public static bool UpdateScanAudit(ScanAuditDS scans)
{
//
bool ret = false;
if (scans.HasChanges())
{
ScanAuditDS _scans = (ScanAuditDS)scans.GetChanges(DataRowState.Modified);
for (int i = 0; i < _scans.ScanAuditTable.Rows.Count; i++)
{
ScanAuditDS.ScanAuditTableRow scan = _scans.ScanAuditTable[i];
bool changed = UpdateScanAudit(scan);
}
scans.AcceptChanges();
}
ret = true;
return(ret);
}
public static bool UpdateScanAudit(ScanAuditDS.ScanAuditTableRow scan)
{
//
bool ret = false;
ret = App.Mediator.ExecuteNonQuery(USP_SCANAUDIT_UPDATE, new object[] {
scan.RecordID,
(!scan.IsArriveNull()?scan.Arrive:null),
(!scan.IsBellNull()?scan.Bell:null),
(!scan.IsDelStartNull()?scan.DelStart:null),
(!scan.IsDelEndNull()?scan.DelEnd:null),
(!scan.IsDepartNull()?scan.Depart:null),
(!scan.IsTimeEntryByNull()?scan.TimeEntryBy:null),
(!scan.IsOnTimeIssueNull()?scan.OnTimeIssue:null),
(!scan.IsAdditCommentsNull()?scan.AdditComments:null)
});
ret = true;
return(ret);
}
