public void ActualizaDatos(String tabla, DataTable datos)
{
if (_Conexion == null || datos == null)
{
return;
}
DataSet tablaDataSet = new DataSet();
String qry = "select * from " + tabla + " where 1 = 0 ";
_DataAdapter = new iDB2DataAdapter();
_DataAdapter.SelectCommand = new iDB2Command(qry, _Conexion);
_DataAdapter.Fill(tablaDataSet);
iDB2CommandBuilder Cmb = new iDB2CommandBuilder(_DataAdapter);
_DataAdapter.InsertCommand = Cmb.GetInsertCommand();
foreach (DataRow fila in datos.Rows)
{
fila.SetAdded();
}
_DataAdapter.Update(datos);
}
private void btnInsert_Click(object sender, EventArgs e)
{
try
{
DataRow newRow = deathstarDataSet.WORKORDER.NewRow();
newRow["orderID"] = txtWrkOrdID.Text;
newRow["planeNo"] = cbxPlaneNo.Text;
newRow["taskID"] = cbxTaskID.Text;
newRow["strDat"] = dteStart.Text;
newRow["endDat"] = dteEnd.Text;
newRow["woStat"] = txtStatus.Text;
newRow["partsLbr"] = numCost.Text;
newRow["lbrHours"] = numLabor.Text;
deathstarDataSet.WORKORDER.AddWORKORDERRow((DeathstarDataSet.WORKORDERRow)newRow);
deathstarDataSet.WORKORDER.AcceptChanges();
iDB2DataAdapter dataAdapter = new iDB2DataAdapter();
dataAdapter.Update(deathstarDataSet.WORKORDER);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void GetAepmMaster()
{
var dt = new DataTable();
var dset = new DataSet();
//retrieve any records needing updating
try
{
using (var conn = new iDB2Connection(ConfigurationManager.AppSettings["AS400ConnectionString"]))
{
// string sql = @"SELECT G_GUID, G_ITEM, G_RETRN FROM CGJLEGAC.GETMSTRL1 WHERE G_RETRN != 'R' and G_RETRN != 'S'";
string sql = GetUnprocessMasterRecsString();
var objDataAdapter = new iDB2DataAdapter();
var cmd = new iDB2Command(sql, conn);
objDataAdapter.SelectCommand = cmd;
objDataAdapter.SelectCommand.CommandTimeout = 0;
dt.Clear();
dset.Clear();
objDataAdapter.Fill(dt);
objDataAdapter.Fill(dset, "currentSelections");
var cb = new iDB2CommandBuilder(objDataAdapter);
AddParameters(cb);
//update records to 'S' for submitted
for (int i = 0; i < dset.Tables["currentSelections"].Rows.Count; i++)
{
dset.Tables["currentSelections"].Rows[i]["G_RETRN"] = 'S';
}
objDataAdapter.Update(dset, "currentSelections");
var taskList = new Task[dt.Rows.Count];
//submit records asynch
for (int i = 0; i < dt.Rows.Count; i++)
{
taskList[i] = TestAsync(dt, i);
}
Task.WaitAll(taskList);
}
}
catch (Exception ex)
{
WriteToEventLog(ex);
}
}