public void InsertarPiezasRequeme(int iCodPlanta)
{
try
{
DataTable dt = this.ObtenerPiezasReQuemado(iCodPlanta);
if (dt != null & dt.Rows.Count > 0)
{
c00_CargaDatos cd = new c00_CargaDatos();
cd.InsertarInformacion(dt, "pieza");
cd.ActualizarInformacion(dt, "pieza");
}
}
catch (Exception e) { throw new Exception(this.sClassName + ", InsertarPiezasRequeme: " + e.Message); }
}
public static void ProbarCargaDatos()
{
List <DataSet> lds = new List <DataSet>();
DataSet ds = null;
DataTable dt = null;
DataRow dr = null;
ds = new DataSet();
dt = new DataTable("InsTabla01");
dt.Columns.Add("Columna01", Type.GetType("System.Int32"));
dt.Columns.Add("Columna02", Type.GetType("System.Int64"));
dt.Columns.Add("Columna03", Type.GetType("System.Double"));
dt.Columns.Add("Columna04", Type.GetType("System.String"));
dt.Columns.Add("Columna05", Type.GetType("System.DateTime"));
dt.Columns.Add("Columna06", Type.GetType("System.DateTime"));
for (int i = 0; i < 10; i++)
{
dr = dt.NewRow();
dr["Columna01"] = (int)(1 + i);
dr["Columna02"] = (long)(100 + i);
dr["Columna03"] = (double)(1.5 + i);
dr["Columna04"] = "valor" + (1 + i).ToString();
dr["Columna05"] = DateTime.Now;
dr["Columna06"] = DBNull.Value;
dt.Rows.Add(dr);
}
dt.AcceptChanges();
ds.Tables.Add(dt);
//
dt = new DataTable("UpdTabla01");
dt.Columns.Add("Columna00", Type.GetType("System.Int32"));
dt.Columns.Add("Columna01", Type.GetType("System.Int32"));
dt.Columns.Add("Columna02", Type.GetType("System.Int64"));
dt.Columns.Add("Columna03", Type.GetType("System.Double"));
dt.Columns.Add("Columna04", Type.GetType("System.String"));
dt.Columns.Add("Columna05", Type.GetType("System.DateTime"));
dt.Columns.Add("Columna06", Type.GetType("System.DateTime"));
for (int i = 0; i < 5; i++)
{
dr = dt.NewRow();
dr["Columna00"] = (int)(1);
dr["Columna01"] = (int)(1 + i);
dr["Columna02"] = (long)(200 + i);
dr["Columna03"] = (double)(3.5 + i);
dr["Columna04"] = "valor" + (2 + i).ToString();
dr["Columna05"] = DateTime.Now;
dr["Columna06"] = DBNull.Value;
dt.Rows.Add(dr);
}
dt.AcceptChanges();
ds.Tables.Add(dt);
//
dt = new DataTable("DelTabla01");
dt.Columns.Add("Columna01", Type.GetType("System.Int32"));
for (int i = 5; i < 8; i++)
{
dr = dt.NewRow();
dr["Columna01"] = (int)(1 + i);
dt.Rows.Add(dr);
}
dt.AcceptChanges();
ds.Tables.Add(dt);
lds.Add(ds);
c00_CargaDatos cObj = new c00_CargaDatos();
//cObj.(lds);
}