public string ExecuteData_string(string sProcName)
{
string dt_ = "";
DataTable dt = new DataTable();
try
{
Open();
global::MySql.Data.MySqlClient.MySqlDataAdapter da = new global::MySql.Data.MySqlClient.MySqlDataAdapter();
cmd.CommandText = sProcName;
da.SelectCommand = cmd;
da.Fill(dt);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw ex;
}
finally
{
Close();
}
dt_ = dt.Rows[0][0].ToString();
return(dt_);
}
public int Execute_int(string sProcName)
{
DataTable dt = new DataTable();
int dt_ = 0;
try
{
Open();
global::MySql.Data.MySqlClient.MySqlDataAdapter da = new global::MySql.Data.MySqlClient.MySqlDataAdapter();
cmd.CommandText = sProcName;
da.SelectCommand = cmd;
da.Fill(dt);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw ex;
}
finally
{
Close();
}
dt_ = dt.Rows.Count;
return(dt_);
}
public bool ExecuteData_bool(string sProcName)
{
DataTable dt = new DataTable();
try
{
Open();
global::MySql.Data.MySqlClient.MySqlDataAdapter da = new global::MySql.Data.MySqlClient.MySqlDataAdapter();
cmd.CommandText = sProcName;
da.SelectCommand = cmd;
da.Fill(dt);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw ex;
}
finally
{
Close();
}
return(true);
}
private void InitAdapter() {
this._adapter = new global::MySql.Data.MySqlClient.MySqlDataAdapter();
global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
tableMapping.SourceTable = "Table";
tableMapping.DataSetTable = "viewbilling";
tableMapping.ColumnMappings.Add("customer_id", "customer_id");
tableMapping.ColumnMappings.Add("com_order_date", "com_order_date");
tableMapping.ColumnMappings.Add("menu_name", "menu_name");
tableMapping.ColumnMappings.Add("price", "price");
this._adapter.TableMappings.Add(tableMapping);
}
private void InitAdapter() {
this._adapter = new global::MySql.Data.MySqlClient.MySqlDataAdapter();
global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
tableMapping.SourceTable = "Table";
tableMapping.DataSetTable = "ste_clijuridico";
tableMapping.ColumnMappings.Add("idclijuridico", "idclijuridico");
tableMapping.ColumnMappings.Add("jurrepresentante", "jurrepresentante");
tableMapping.ColumnMappings.Add("jurrazonsocial", "jurrazonsocial");
this._adapter.TableMappings.Add(tableMapping);
this._adapter.DeleteCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.DeleteCommand.Connection = this.Connection;
this._adapter.DeleteCommand.CommandText = @"DELETE FROM `ste_clijuridico` WHERE ((`idclijuridico` = @Original_idclijuridico) AND ((@IsNull_jurrepresentante = 1 AND `jurrepresentante` IS NULL) OR (`jurrepresentante` = @Original_jurrepresentante)) AND ((@IsNull_jurrazonsocial = 1 AND `jurrazonsocial` IS NULL) OR (`jurrazonsocial` = @Original_jurrazonsocial)))";
this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text;
global::MySql.Data.MySqlClient.MySqlParameter param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_idclijuridico";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "idclijuridico";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_jurrepresentante";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "jurrepresentante";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_jurrepresentante";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "jurrepresentante";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_jurrazonsocial";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "jurrazonsocial";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_jurrazonsocial";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "jurrazonsocial";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
this._adapter.InsertCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = "INSERT INTO `ste_clijuridico` (`idclijuridico`, `jurrepresentante`, `jurrazonsoci" +
"al`) VALUES (@idclijuridico, @jurrepresentante, @jurrazonsocial)";
this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@idclijuridico";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "idclijuridico";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@jurrepresentante";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "jurrepresentante";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@jurrazonsocial";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "jurrazonsocial";
this._adapter.InsertCommand.Parameters.Add(param);
this._adapter.UpdateCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.UpdateCommand.Connection = this.Connection;
this._adapter.UpdateCommand.CommandText = @"UPDATE `ste_clijuridico` SET `idclijuridico` = @idclijuridico, `jurrepresentante` = @jurrepresentante, `jurrazonsocial` = @jurrazonsocial WHERE ((`idclijuridico` = @Original_idclijuridico) AND ((@IsNull_jurrepresentante = 1 AND `jurrepresentante` IS NULL) OR (`jurrepresentante` = @Original_jurrepresentante)) AND ((@IsNull_jurrazonsocial = 1 AND `jurrazonsocial` IS NULL) OR (`jurrazonsocial` = @Original_jurrazonsocial)))";
this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@idclijuridico";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "idclijuridico";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@jurrepresentante";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "jurrepresentante";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@jurrazonsocial";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "jurrazonsocial";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_idclijuridico";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "idclijuridico";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_jurrepresentante";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "jurrepresentante";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_jurrepresentante";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "jurrepresentante";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_jurrazonsocial";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "jurrazonsocial";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_jurrazonsocial";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "jurrazonsocial";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
}
private void InitAdapter() {
this._adapter = new global::MySql.Data.MySqlClient.MySqlDataAdapter();
global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
tableMapping.SourceTable = "Table";
tableMapping.DataSetTable = "ste_cliente";
tableMapping.ColumnMappings.Add("idcliente", "idcliente");
tableMapping.ColumnMappings.Add("clitipo", "clitipo");
tableMapping.ColumnMappings.Add("cliruc", "cliruc");
this._adapter.TableMappings.Add(tableMapping);
this._adapter.DeleteCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.DeleteCommand.Connection = this.Connection;
this._adapter.DeleteCommand.CommandText = "DELETE FROM `ste_cliente` WHERE ((`idcliente` = @Original_idcliente) AND ((@IsNul" +
"l_clitipo = 1 AND `clitipo` IS NULL) OR (`clitipo` = @Original_clitipo)) AND ((@" +
"IsNull_cliruc = 1 AND `cliruc` IS NULL) OR (`cliruc` = @Original_cliruc)))";
this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text;
global::MySql.Data.MySqlClient.MySqlParameter param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_idcliente";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "idcliente";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_clitipo";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "clitipo";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_clitipo";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "clitipo";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_cliruc";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "cliruc";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_cliruc";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "cliruc";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
this._adapter.InsertCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = "INSERT INTO `ste_cliente` (`clitipo`, `cliruc`) VALUES (@clitipo, @cliruc)";
this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@clitipo";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "clitipo";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@cliruc";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "cliruc";
this._adapter.InsertCommand.Parameters.Add(param);
this._adapter.UpdateCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.UpdateCommand.Connection = this.Connection;
this._adapter.UpdateCommand.CommandText = @"UPDATE `ste_cliente` SET `clitipo` = @clitipo, `cliruc` = @cliruc WHERE ((`idcliente` = @Original_idcliente) AND ((@IsNull_clitipo = 1 AND `clitipo` IS NULL) OR (`clitipo` = @Original_clitipo)) AND ((@IsNull_cliruc = 1 AND `cliruc` IS NULL) OR (`cliruc` = @Original_cliruc)))";
this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@clitipo";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "clitipo";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@cliruc";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "cliruc";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_idcliente";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "idcliente";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_clitipo";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "clitipo";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_clitipo";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "clitipo";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_cliruc";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "cliruc";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_cliruc";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "cliruc";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
}
private void InitAdapter() {
this._adapter = new global::MySql.Data.MySqlClient.MySqlDataAdapter();
global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
tableMapping.SourceTable = "Table";
tableMapping.DataSetTable = "ste_detallecarga";
tableMapping.ColumnMappings.Add("iddetallecarga", "iddetallecarga");
tableMapping.ColumnMappings.Add("dcaiddetalleenvio", "dcaiddetalleenvio");
tableMapping.ColumnMappings.Add("dcacantidad", "dcacantidad");
tableMapping.ColumnMappings.Add("dcaidcarga", "dcaidcarga");
this._adapter.TableMappings.Add(tableMapping);
this._adapter.DeleteCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.DeleteCommand.Connection = this.Connection;
this._adapter.DeleteCommand.CommandText = @"DELETE FROM `ste_detallecarga` WHERE ((`iddetallecarga` = @Original_iddetallecarga) AND ((@IsNull_dcaiddetalleenvio = 1 AND `dcaiddetalleenvio` IS NULL) OR (`dcaiddetalleenvio` = @Original_dcaiddetalleenvio)) AND ((@IsNull_dcacantidad = 1 AND `dcacantidad` IS NULL) OR (`dcacantidad` = @Original_dcacantidad)) AND ((@IsNull_dcaidcarga = 1 AND `dcaidcarga` IS NULL) OR (`dcaidcarga` = @Original_dcaidcarga)))";
this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text;
global::MySql.Data.MySqlClient.MySqlParameter param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_iddetallecarga";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "iddetallecarga";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_dcaiddetalleenvio";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dcaiddetalleenvio";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_dcaiddetalleenvio";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dcaiddetalleenvio";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_dcacantidad";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dcacantidad";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_dcacantidad";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dcacantidad";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_dcaidcarga";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dcaidcarga";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_dcaidcarga";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dcaidcarga";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
this._adapter.InsertCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = "INSERT INTO `ste_detallecarga` (`dcaiddetalleenvio`, `dcacantidad`, `dcaidcarga`)" +
" VALUES (@dcaiddetalleenvio, @dcacantidad, @dcaidcarga)";
this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@dcaiddetalleenvio";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dcaiddetalleenvio";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@dcacantidad";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dcacantidad";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@dcaidcarga";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dcaidcarga";
this._adapter.InsertCommand.Parameters.Add(param);
this._adapter.UpdateCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.UpdateCommand.Connection = this.Connection;
this._adapter.UpdateCommand.CommandText = @"UPDATE `ste_detallecarga` SET `dcaiddetalleenvio` = @dcaiddetalleenvio, `dcacantidad` = @dcacantidad, `dcaidcarga` = @dcaidcarga WHERE ((`iddetallecarga` = @Original_iddetallecarga) AND ((@IsNull_dcaiddetalleenvio = 1 AND `dcaiddetalleenvio` IS NULL) OR (`dcaiddetalleenvio` = @Original_dcaiddetalleenvio)) AND ((@IsNull_dcacantidad = 1 AND `dcacantidad` IS NULL) OR (`dcacantidad` = @Original_dcacantidad)) AND ((@IsNull_dcaidcarga = 1 AND `dcaidcarga` IS NULL) OR (`dcaidcarga` = @Original_dcaidcarga)))";
this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@dcaiddetalleenvio";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dcaiddetalleenvio";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@dcacantidad";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dcacantidad";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@dcaidcarga";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dcaidcarga";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_iddetallecarga";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "iddetallecarga";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_dcaiddetalleenvio";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dcaiddetalleenvio";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_dcaiddetalleenvio";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dcaiddetalleenvio";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_dcacantidad";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dcacantidad";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_dcacantidad";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dcacantidad";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_dcaidcarga";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dcaidcarga";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_dcaidcarga";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dcaidcarga";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
}
private void InitAdapter() {
this._adapter = new global::MySql.Data.MySqlClient.MySqlDataAdapter();
global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
tableMapping.SourceTable = "Table";
tableMapping.DataSetTable = "viewdeliveryorderdetil";
tableMapping.ColumnMappings.Add("menu", "menu");
tableMapping.ColumnMappings.Add("price", "price");
tableMapping.ColumnMappings.Add("id", "id");
this._adapter.TableMappings.Add(tableMapping);
}
private void InitAdapter() {
this._adapter = new global::MySql.Data.MySqlClient.MySqlDataAdapter();
global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
tableMapping.SourceTable = "Table";
tableMapping.DataSetTable = "ste_usuario";
tableMapping.ColumnMappings.Add("idusuario", "idusuario");
tableMapping.ColumnMappings.Add("usuuser", "usuuser");
tableMapping.ColumnMappings.Add("usupassword", "usupassword");
tableMapping.ColumnMappings.Add("usunombres", "usunombres");
tableMapping.ColumnMappings.Add("usuapellidos", "usuapellidos");
tableMapping.ColumnMappings.Add("usudni", "usudni");
tableMapping.ColumnMappings.Add("usuestado", "usuestado");
tableMapping.ColumnMappings.Add("usutipo", "usutipo");
this._adapter.TableMappings.Add(tableMapping);
this._adapter.DeleteCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.DeleteCommand.Connection = this.Connection;
this._adapter.DeleteCommand.CommandText = @"DELETE FROM `ste_usuario` WHERE ((`idusuario` = @Original_idusuario) AND ((@IsNull_usuuser = 1 AND `usuuser` IS NULL) OR (`usuuser` = @Original_usuuser)) AND ((@IsNull_usupassword = 1 AND `usupassword` IS NULL) OR (`usupassword` = @Original_usupassword)) AND ((@IsNull_usunombres = 1 AND `usunombres` IS NULL) OR (`usunombres` = @Original_usunombres)) AND ((@IsNull_usuapellidos = 1 AND `usuapellidos` IS NULL) OR (`usuapellidos` = @Original_usuapellidos)) AND ((@IsNull_usudni = 1 AND `usudni` IS NULL) OR (`usudni` = @Original_usudni)) AND ((@IsNull_usuestado = 1 AND `usuestado` IS NULL) OR (`usuestado` = @Original_usuestado)) AND ((@IsNull_usutipo = 1 AND `usutipo` IS NULL) OR (`usutipo` = @Original_usutipo)))";
this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text;
global::MySql.Data.MySqlClient.MySqlParameter param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_idusuario";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "idusuario";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_usuuser";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "usuuser";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_usuuser";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "usuuser";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_usupassword";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "usupassword";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_usupassword";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "usupassword";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_usunombres";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "usunombres";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_usunombres";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "usunombres";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_usuapellidos";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "usuapellidos";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_usuapellidos";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "usuapellidos";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_usudni";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "usudni";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_usudni";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "usudni";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_usuestado";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "usuestado";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_usuestado";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "usuestado";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_usutipo";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "usutipo";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_usutipo";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "usutipo";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
this._adapter.InsertCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = "INSERT INTO `ste_usuario` (`usuuser`, `usupassword`, `usunombres`, `usuapellidos`" +
", `usudni`, `usuestado`, `usutipo`) VALUES (@usuuser, @usupassword, @usunombres," +
" @usuapellidos, @usudni, @usuestado, @usutipo)";
this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@usuuser";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "usuuser";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@usupassword";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "usupassword";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@usunombres";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "usunombres";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@usuapellidos";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "usuapellidos";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@usudni";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "usudni";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@usuestado";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "usuestado";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@usutipo";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "usutipo";
this._adapter.InsertCommand.Parameters.Add(param);
this._adapter.UpdateCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.UpdateCommand.Connection = this.Connection;
this._adapter.UpdateCommand.CommandText = @"UPDATE `ste_usuario` SET `usuuser` = @usuuser, `usupassword` = @usupassword, `usunombres` = @usunombres, `usuapellidos` = @usuapellidos, `usudni` = @usudni, `usuestado` = @usuestado, `usutipo` = @usutipo WHERE ((`idusuario` = @Original_idusuario) AND ((@IsNull_usuuser = 1 AND `usuuser` IS NULL) OR (`usuuser` = @Original_usuuser)) AND ((@IsNull_usupassword = 1 AND `usupassword` IS NULL) OR (`usupassword` = @Original_usupassword)) AND ((@IsNull_usunombres = 1 AND `usunombres` IS NULL) OR (`usunombres` = @Original_usunombres)) AND ((@IsNull_usuapellidos = 1 AND `usuapellidos` IS NULL) OR (`usuapellidos` = @Original_usuapellidos)) AND ((@IsNull_usudni = 1 AND `usudni` IS NULL) OR (`usudni` = @Original_usudni)) AND ((@IsNull_usuestado = 1 AND `usuestado` IS NULL) OR (`usuestado` = @Original_usuestado)) AND ((@IsNull_usutipo = 1 AND `usutipo` IS NULL) OR (`usutipo` = @Original_usutipo)))";
this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@usuuser";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "usuuser";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@usupassword";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "usupassword";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@usunombres";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "usunombres";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@usuapellidos";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "usuapellidos";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@usudni";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "usudni";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@usuestado";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "usuestado";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@usutipo";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "usutipo";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_idusuario";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "idusuario";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_usuuser";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "usuuser";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_usuuser";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "usuuser";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_usupassword";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "usupassword";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_usupassword";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "usupassword";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_usunombres";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "usunombres";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_usunombres";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "usunombres";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_usuapellidos";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "usuapellidos";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_usuapellidos";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "usuapellidos";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_usudni";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "usudni";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_usudni";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "usudni";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_usuestado";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "usuestado";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_usuestado";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "usuestado";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_usutipo";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "usutipo";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_usutipo";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "usutipo";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
}
private void InitAdapter() {
this._adapter = new global::MySql.Data.MySqlClient.MySqlDataAdapter();
global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
tableMapping.SourceTable = "Table";
tableMapping.DataSetTable = "incremento";
tableMapping.ColumnMappings.Add("idincremento", "idincremento");
tableMapping.ColumnMappings.Add("criterio", "criterio");
tableMapping.ColumnMappings.Add("valor", "valor");
this._adapter.TableMappings.Add(tableMapping);
this._adapter.DeleteCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.DeleteCommand.Connection = this.Connection;
this._adapter.DeleteCommand.CommandText = "DELETE FROM `incremento` WHERE ((`idincremento` = @Original_idincremento) AND ((@" +
"IsNull_criterio = 1 AND `criterio` IS NULL) OR (`criterio` = @Original_criterio)" +
") AND ((@IsNull_valor = 1 AND `valor` IS NULL) OR (`valor` = @Original_valor)))";
this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text;
global::MySql.Data.MySqlClient.MySqlParameter param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_idincremento";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "idincremento";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_criterio";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "criterio";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_criterio";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "criterio";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_valor";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "valor";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_valor";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "valor";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
this._adapter.InsertCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = "INSERT INTO `incremento` (`idincremento`, `criterio`, `valor`) VALUES (@idincreme" +
"nto, @criterio, @valor)";
this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@idincremento";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "idincremento";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@criterio";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "criterio";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@valor";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "valor";
this._adapter.InsertCommand.Parameters.Add(param);
this._adapter.UpdateCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.UpdateCommand.Connection = this.Connection;
this._adapter.UpdateCommand.CommandText = @"UPDATE `incremento` SET `idincremento` = @idincremento, `criterio` = @criterio, `valor` = @valor WHERE ((`idincremento` = @Original_idincremento) AND ((@IsNull_criterio = 1 AND `criterio` IS NULL) OR (`criterio` = @Original_criterio)) AND ((@IsNull_valor = 1 AND `valor` IS NULL) OR (`valor` = @Original_valor)))";
this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@idincremento";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "idincremento";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@criterio";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "criterio";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@valor";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "valor";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_idincremento";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "idincremento";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_criterio";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "criterio";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_criterio";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "criterio";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_valor";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "valor";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_valor";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "valor";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
}
private void InitAdapter() {
this._adapter = new global::MySql.Data.MySqlClient.MySqlDataAdapter();
global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
tableMapping.SourceTable = "Table";
tableMapping.DataSetTable = "ste_unidad";
tableMapping.ColumnMappings.Add("idunidad", "idunidad");
tableMapping.ColumnMappings.Add("uniplaca", "uniplaca");
tableMapping.ColumnMappings.Add("uniidcamionero", "uniidcamionero");
tableMapping.ColumnMappings.Add("unidelaempresa", "unidelaempresa");
this._adapter.TableMappings.Add(tableMapping);
this._adapter.DeleteCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.DeleteCommand.Connection = this.Connection;
this._adapter.DeleteCommand.CommandText = @"DELETE FROM `ste_unidad` WHERE ((`idunidad` = @Original_idunidad) AND ((@IsNull_uniplaca = 1 AND `uniplaca` IS NULL) OR (`uniplaca` = @Original_uniplaca)) AND ((@IsNull_uniidcamionero = 1 AND `uniidcamionero` IS NULL) OR (`uniidcamionero` = @Original_uniidcamionero)) AND ((@IsNull_unidelaempresa = 1 AND `unidelaempresa` IS NULL) OR (`unidelaempresa` = @Original_unidelaempresa)))";
this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text;
global::MySql.Data.MySqlClient.MySqlParameter param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_idunidad";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "idunidad";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_uniplaca";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "uniplaca";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_uniplaca";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "uniplaca";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_uniidcamionero";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "uniidcamionero";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_uniidcamionero";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "uniidcamionero";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_unidelaempresa";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "unidelaempresa";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_unidelaempresa";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "unidelaempresa";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
this._adapter.InsertCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = "INSERT INTO `ste_unidad` (`uniplaca`, `uniidcamionero`, `unidelaempresa`) VALUES " +
"(@uniplaca, @uniidcamionero, @unidelaempresa)";
this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@uniplaca";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "uniplaca";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@uniidcamionero";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "uniidcamionero";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@unidelaempresa";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "unidelaempresa";
this._adapter.InsertCommand.Parameters.Add(param);
this._adapter.UpdateCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.UpdateCommand.Connection = this.Connection;
this._adapter.UpdateCommand.CommandText = @"UPDATE `ste_unidad` SET `uniplaca` = @uniplaca, `uniidcamionero` = @uniidcamionero, `unidelaempresa` = @unidelaempresa WHERE ((`idunidad` = @Original_idunidad) AND ((@IsNull_uniplaca = 1 AND `uniplaca` IS NULL) OR (`uniplaca` = @Original_uniplaca)) AND ((@IsNull_uniidcamionero = 1 AND `uniidcamionero` IS NULL) OR (`uniidcamionero` = @Original_uniidcamionero)) AND ((@IsNull_unidelaempresa = 1 AND `unidelaempresa` IS NULL) OR (`unidelaempresa` = @Original_unidelaempresa)))";
this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@uniplaca";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "uniplaca";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@uniidcamionero";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "uniidcamionero";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@unidelaempresa";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "unidelaempresa";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_idunidad";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "idunidad";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_uniplaca";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "uniplaca";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_uniplaca";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "uniplaca";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_uniidcamionero";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "uniidcamionero";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_uniidcamionero";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "uniidcamionero";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_unidelaempresa";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "unidelaempresa";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_unidelaempresa";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "unidelaempresa";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
}
private void InitAdapter() {
this._adapter = new global::MySql.Data.MySqlClient.MySqlDataAdapter();
global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
tableMapping.SourceTable = "Table";
tableMapping.DataSetTable = "ste_session";
tableMapping.ColumnMappings.Add("idsession", "idsession");
tableMapping.ColumnMappings.Add("sesidpantalla", "sesidpantalla");
tableMapping.ColumnMappings.Add("sesfecha_hora", "sesfecha_hora");
tableMapping.ColumnMappings.Add("sesidusuario", "sesidusuario");
this._adapter.TableMappings.Add(tableMapping);
this._adapter.DeleteCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.DeleteCommand.Connection = this.Connection;
this._adapter.DeleteCommand.CommandText = @"DELETE FROM `ste_session` WHERE ((`idsession` = @Original_idsession) AND ((@IsNull_sesidpantalla = 1 AND `sesidpantalla` IS NULL) OR (`sesidpantalla` = @Original_sesidpantalla)) AND ((@IsNull_sesfecha_hora = 1 AND `sesfecha_hora` IS NULL) OR (`sesfecha_hora` = @Original_sesfecha_hora)) AND ((@IsNull_sesidusuario = 1 AND `sesidusuario` IS NULL) OR (`sesidusuario` = @Original_sesidusuario)))";
this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text;
global::MySql.Data.MySqlClient.MySqlParameter param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_idsession";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "idsession";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_sesidpantalla";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "sesidpantalla";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_sesidpantalla";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "sesidpantalla";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_sesfecha_hora";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "sesfecha_hora";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_sesfecha_hora";
param.DbType = global::System.Data.DbType.DateTime;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.DateTime;
param.IsNullable = true;
param.SourceColumn = "sesfecha_hora";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_sesidusuario";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "sesidusuario";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_sesidusuario";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "sesidusuario";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
this._adapter.InsertCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = "INSERT INTO `ste_session` (`sesidpantalla`, `sesfecha_hora`, `sesidusuario`) VALU" +
"ES (@sesidpantalla, @sesfecha_hora, @sesidusuario)";
this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@sesidpantalla";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "sesidpantalla";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@sesfecha_hora";
param.DbType = global::System.Data.DbType.DateTime;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.DateTime;
param.IsNullable = true;
param.SourceColumn = "sesfecha_hora";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@sesidusuario";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "sesidusuario";
this._adapter.InsertCommand.Parameters.Add(param);
this._adapter.UpdateCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.UpdateCommand.Connection = this.Connection;
this._adapter.UpdateCommand.CommandText = @"UPDATE `ste_session` SET `sesidpantalla` = @sesidpantalla, `sesfecha_hora` = @sesfecha_hora, `sesidusuario` = @sesidusuario WHERE ((`idsession` = @Original_idsession) AND ((@IsNull_sesidpantalla = 1 AND `sesidpantalla` IS NULL) OR (`sesidpantalla` = @Original_sesidpantalla)) AND ((@IsNull_sesfecha_hora = 1 AND `sesfecha_hora` IS NULL) OR (`sesfecha_hora` = @Original_sesfecha_hora)) AND ((@IsNull_sesidusuario = 1 AND `sesidusuario` IS NULL) OR (`sesidusuario` = @Original_sesidusuario)))";
this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@sesidpantalla";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "sesidpantalla";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@sesfecha_hora";
param.DbType = global::System.Data.DbType.DateTime;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.DateTime;
param.IsNullable = true;
param.SourceColumn = "sesfecha_hora";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@sesidusuario";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "sesidusuario";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_idsession";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "idsession";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_sesidpantalla";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "sesidpantalla";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_sesidpantalla";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "sesidpantalla";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_sesfecha_hora";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "sesfecha_hora";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_sesfecha_hora";
param.DbType = global::System.Data.DbType.DateTime;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.DateTime;
param.IsNullable = true;
param.SourceColumn = "sesfecha_hora";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_sesidusuario";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "sesidusuario";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_sesidusuario";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "sesidusuario";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
}
private void InitAdapter() {
this._adapter = new global::MySql.Data.MySqlClient.MySqlDataAdapter();
global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
tableMapping.SourceTable = "Table";
tableMapping.DataSetTable = "ste_serie";
tableMapping.ColumnMappings.Add("idserie", "idserie");
tableMapping.ColumnMappings.Add("sertipo", "sertipo");
tableMapping.ColumnMappings.Add("sernumero", "sernumero");
tableMapping.ColumnMappings.Add("servalmin", "servalmin");
tableMapping.ColumnMappings.Add("servalmax", "servalmax");
this._adapter.TableMappings.Add(tableMapping);
this._adapter.DeleteCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.DeleteCommand.Connection = this.Connection;
this._adapter.DeleteCommand.CommandText = @"DELETE FROM `ste_serie` WHERE ((`idserie` = @Original_idserie) AND ((@IsNull_sertipo = 1 AND `sertipo` IS NULL) OR (`sertipo` = @Original_sertipo)) AND ((@IsNull_sernumero = 1 AND `sernumero` IS NULL) OR (`sernumero` = @Original_sernumero)) AND ((@IsNull_servalmin = 1 AND `servalmin` IS NULL) OR (`servalmin` = @Original_servalmin)) AND ((@IsNull_servalmax = 1 AND `servalmax` IS NULL) OR (`servalmax` = @Original_servalmax)))";
this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text;
global::MySql.Data.MySqlClient.MySqlParameter param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_idserie";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "idserie";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_sertipo";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "sertipo";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_sertipo";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "sertipo";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_sernumero";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "sernumero";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_sernumero";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "sernumero";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_servalmin";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "servalmin";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_servalmin";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "servalmin";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_servalmax";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "servalmax";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_servalmax";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "servalmax";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
this._adapter.InsertCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = "INSERT INTO `ste_serie` (`sertipo`, `sernumero`, `servalmin`, `servalmax`) VALUES" +
" (@sertipo, @sernumero, @servalmin, @servalmax)";
this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@sertipo";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "sertipo";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@sernumero";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "sernumero";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@servalmin";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "servalmin";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@servalmax";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "servalmax";
this._adapter.InsertCommand.Parameters.Add(param);
this._adapter.UpdateCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.UpdateCommand.Connection = this.Connection;
this._adapter.UpdateCommand.CommandText = @"UPDATE `ste_serie` SET `sertipo` = @sertipo, `sernumero` = @sernumero, `servalmin` = @servalmin, `servalmax` = @servalmax WHERE ((`idserie` = @Original_idserie) AND ((@IsNull_sertipo = 1 AND `sertipo` IS NULL) OR (`sertipo` = @Original_sertipo)) AND ((@IsNull_sernumero = 1 AND `sernumero` IS NULL) OR (`sernumero` = @Original_sernumero)) AND ((@IsNull_servalmin = 1 AND `servalmin` IS NULL) OR (`servalmin` = @Original_servalmin)) AND ((@IsNull_servalmax = 1 AND `servalmax` IS NULL) OR (`servalmax` = @Original_servalmax)))";
this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@sertipo";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "sertipo";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@sernumero";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "sernumero";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@servalmin";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "servalmin";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@servalmax";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "servalmax";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_idserie";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "idserie";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_sertipo";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "sertipo";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_sertipo";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "sertipo";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_sernumero";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "sernumero";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_sernumero";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "sernumero";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_servalmin";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "servalmin";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_servalmin";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "servalmin";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_servalmax";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "servalmax";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_servalmax";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "servalmax";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
}
private void InitAdapter() {
this._adapter = new global::MySql.Data.MySqlClient.MySqlDataAdapter();
global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
tableMapping.SourceTable = "Table";
tableMapping.DataSetTable = "ste_envio";
tableMapping.ColumnMappings.Add("idenvio", "idenvio");
tableMapping.ColumnMappings.Add("envidcliente", "envidcliente");
tableMapping.ColumnMappings.Add("envfecha_registro", "envfecha_registro");
tableMapping.ColumnMappings.Add("envdireccion_origen", "envdireccion_origen");
tableMapping.ColumnMappings.Add("envdireccion_destino", "envdireccion_destino");
tableMapping.ColumnMappings.Add("envdestinatario", "envdestinatario");
tableMapping.ColumnMappings.Add("envrucdestinatario", "envrucdestinatario");
tableMapping.ColumnMappings.Add("envidserie", "envidserie");
tableMapping.ColumnMappings.Add("envnumcomprobante", "envnumcomprobante");
tableMapping.ColumnMappings.Add("envtipocomprobante", "envtipocomprobante");
this._adapter.TableMappings.Add(tableMapping);
this._adapter.DeleteCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.DeleteCommand.Connection = this.Connection;
this._adapter.DeleteCommand.CommandText = @"DELETE FROM `ste_envio` WHERE ((`idenvio` = @Original_idenvio) AND ((@IsNull_envidcliente = 1 AND `envidcliente` IS NULL) OR (`envidcliente` = @Original_envidcliente)) AND ((@IsNull_envfecha_registro = 1 AND `envfecha_registro` IS NULL) OR (`envfecha_registro` = @Original_envfecha_registro)) AND ((@IsNull_envdireccion_origen = 1 AND `envdireccion_origen` IS NULL) OR (`envdireccion_origen` = @Original_envdireccion_origen)) AND ((@IsNull_envdireccion_destino = 1 AND `envdireccion_destino` IS NULL) OR (`envdireccion_destino` = @Original_envdireccion_destino)) AND ((@IsNull_envdestinatario = 1 AND `envdestinatario` IS NULL) OR (`envdestinatario` = @Original_envdestinatario)) AND ((@IsNull_envrucdestinatario = 1 AND `envrucdestinatario` IS NULL) OR (`envrucdestinatario` = @Original_envrucdestinatario)) AND ((@IsNull_envidserie = 1 AND `envidserie` IS NULL) OR (`envidserie` = @Original_envidserie)) AND ((@IsNull_envnumcomprobante = 1 AND `envnumcomprobante` IS NULL) OR (`envnumcomprobante` = @Original_envnumcomprobante)) AND ((@IsNull_envtipocomprobante = 1 AND `envtipocomprobante` IS NULL) OR (`envtipocomprobante` = @Original_envtipocomprobante)))";
this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text;
global::MySql.Data.MySqlClient.MySqlParameter param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_idenvio";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "idenvio";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_envidcliente";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "envidcliente";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_envidcliente";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "envidcliente";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_envfecha_registro";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "envfecha_registro";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_envfecha_registro";
param.DbType = global::System.Data.DbType.DateTime;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.DateTime;
param.IsNullable = true;
param.SourceColumn = "envfecha_registro";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_envdireccion_origen";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "envdireccion_origen";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_envdireccion_origen";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "envdireccion_origen";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_envdireccion_destino";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "envdireccion_destino";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_envdireccion_destino";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "envdireccion_destino";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_envdestinatario";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "envdestinatario";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_envdestinatario";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "envdestinatario";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_envrucdestinatario";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "envrucdestinatario";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_envrucdestinatario";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "envrucdestinatario";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_envidserie";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "envidserie";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_envidserie";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "envidserie";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_envnumcomprobante";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "envnumcomprobante";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_envnumcomprobante";
param.DbType = global::System.Data.DbType.Int64;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int64;
param.IsNullable = true;
param.SourceColumn = "envnumcomprobante";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_envtipocomprobante";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "envtipocomprobante";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_envtipocomprobante";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "envtipocomprobante";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
this._adapter.InsertCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = @"INSERT INTO `ste_envio` (`envidcliente`, `envfecha_registro`, `envdireccion_origen`, `envdireccion_destino`, `envdestinatario`, `envrucdestinatario`, `envidserie`, `envnumcomprobante`, `envtipocomprobante`) VALUES (@envidcliente, @envfecha_registro, @envdireccion_origen, @envdireccion_destino, @envdestinatario, @envrucdestinatario, @envidserie, @envnumcomprobante, @envtipocomprobante)";
this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@envidcliente";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "envidcliente";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@envfecha_registro";
param.DbType = global::System.Data.DbType.DateTime;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.DateTime;
param.IsNullable = true;
param.SourceColumn = "envfecha_registro";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@envdireccion_origen";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "envdireccion_origen";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@envdireccion_destino";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "envdireccion_destino";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@envdestinatario";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "envdestinatario";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@envrucdestinatario";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "envrucdestinatario";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@envidserie";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "envidserie";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@envnumcomprobante";
param.DbType = global::System.Data.DbType.Int64;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int64;
param.IsNullable = true;
param.SourceColumn = "envnumcomprobante";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@envtipocomprobante";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "envtipocomprobante";
this._adapter.InsertCommand.Parameters.Add(param);
this._adapter.UpdateCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.UpdateCommand.Connection = this.Connection;
this._adapter.UpdateCommand.CommandText = "UPDATE `ste_envio` SET `envidcliente` = @envidcliente, `envfecha_registro` = @env" +
"fecha_registro, `envdireccion_origen` = @envdireccion_origen, `envdireccion_dest" +
"ino` = @envdireccion_destino, `envdestinatario` = @envdestinatario, `envrucdesti" +
"natario` = @envrucdestinatario, `envidserie` = @envidserie, `envnumcomprobante` " +
"= @envnumcomprobante, `envtipocomprobante` = @envtipocomprobante WHERE ((`idenvi" +
"o` = @Original_idenvio) AND ((@IsNull_envidcliente = 1 AND `envidcliente` IS NUL" +
"L) OR (`envidcliente` = @Original_envidcliente)) AND ((@IsNull_envfecha_registro" +
" = 1 AND `envfecha_registro` IS NULL) OR (`envfecha_registro` = @Original_envfec" +
"ha_registro)) AND ((@IsNull_envdireccion_origen = 1 AND `envdireccion_origen` IS" +
" NULL) OR (`envdireccion_origen` = @Original_envdireccion_origen)) AND ((@IsNull" +
"_envdireccion_destino = 1 AND `envdireccion_destino` IS NULL) OR (`envdireccion_" +
"destino` = @Original_envdireccion_destino)) AND ((@IsNull_envdestinatario = 1 AN" +
"D `envdestinatario` IS NULL) OR (`envdestinatario` = @Original_envdestinatario))" +
" AND ((@IsNull_envrucdestinatario = 1 AND `envrucdestinatario` IS NULL) OR (`env" +
"rucdestinatario` = @Original_envrucdestinatario)) AND ((@IsNull_envidserie = 1 A" +
"ND `envidserie` IS NULL) OR (`envidserie` = @Original_envidserie)) AND ((@IsNull" +
"_envnumcomprobante = 1 AND `envnumcomprobante` IS NULL) OR (`envnumcomprobante` " +
"= @Original_envnumcomprobante)) AND ((@IsNull_envtipocomprobante = 1 AND `envtip" +
"ocomprobante` IS NULL) OR (`envtipocomprobante` = @Original_envtipocomprobante))" +
")";
this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@envidcliente";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "envidcliente";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@envfecha_registro";
param.DbType = global::System.Data.DbType.DateTime;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.DateTime;
param.IsNullable = true;
param.SourceColumn = "envfecha_registro";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@envdireccion_origen";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "envdireccion_origen";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@envdireccion_destino";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "envdireccion_destino";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@envdestinatario";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "envdestinatario";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@envrucdestinatario";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "envrucdestinatario";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@envidserie";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "envidserie";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@envnumcomprobante";
param.DbType = global::System.Data.DbType.Int64;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int64;
param.IsNullable = true;
param.SourceColumn = "envnumcomprobante";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@envtipocomprobante";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "envtipocomprobante";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_idenvio";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "idenvio";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_envidcliente";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "envidcliente";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_envidcliente";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "envidcliente";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_envfecha_registro";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "envfecha_registro";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_envfecha_registro";
param.DbType = global::System.Data.DbType.DateTime;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.DateTime;
param.IsNullable = true;
param.SourceColumn = "envfecha_registro";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_envdireccion_origen";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "envdireccion_origen";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_envdireccion_origen";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "envdireccion_origen";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_envdireccion_destino";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "envdireccion_destino";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_envdireccion_destino";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "envdireccion_destino";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_envdestinatario";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "envdestinatario";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_envdestinatario";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "envdestinatario";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_envrucdestinatario";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "envrucdestinatario";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_envrucdestinatario";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "envrucdestinatario";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_envidserie";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "envidserie";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_envidserie";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "envidserie";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_envnumcomprobante";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "envnumcomprobante";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_envnumcomprobante";
param.DbType = global::System.Data.DbType.Int64;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int64;
param.IsNullable = true;
param.SourceColumn = "envnumcomprobante";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_envtipocomprobante";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "envtipocomprobante";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_envtipocomprobante";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "envtipocomprobante";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
}
private void InitAdapter() {
this._adapter = new global::MySql.Data.MySqlClient.MySqlDataAdapter();
global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
tableMapping.SourceTable = "Table";
tableMapping.DataSetTable = "ste_detalleenvio";
tableMapping.ColumnMappings.Add("iddetalleenvio", "iddetalleenvio");
tableMapping.ColumnMappings.Add("denidenvio", "denidenvio");
tableMapping.ColumnMappings.Add("dencodigo", "dencodigo");
tableMapping.ColumnMappings.Add("dendescripcion", "dendescripcion");
tableMapping.ColumnMappings.Add("dencantidad", "dencantidad");
tableMapping.ColumnMappings.Add("denpreciounitario", "denpreciounitario");
tableMapping.ColumnMappings.Add("dentipo", "dentipo");
tableMapping.ColumnMappings.Add("denresta", "denresta");
this._adapter.TableMappings.Add(tableMapping);
this._adapter.DeleteCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.DeleteCommand.Connection = this.Connection;
this._adapter.DeleteCommand.CommandText = @"DELETE FROM `ste_detalleenvio` WHERE ((`iddetalleenvio` = @Original_iddetalleenvio) AND ((@IsNull_denidenvio = 1 AND `denidenvio` IS NULL) OR (`denidenvio` = @Original_denidenvio)) AND ((@IsNull_dencodigo = 1 AND `dencodigo` IS NULL) OR (`dencodigo` = @Original_dencodigo)) AND ((@IsNull_dencantidad = 1 AND `dencantidad` IS NULL) OR (`dencantidad` = @Original_dencantidad)) AND ((@IsNull_denpreciounitario = 1 AND `denpreciounitario` IS NULL) OR (`denpreciounitario` = @Original_denpreciounitario)) AND ((@IsNull_dentipo = 1 AND `dentipo` IS NULL) OR (`dentipo` = @Original_dentipo)) AND ((@IsNull_denresta = 1 AND `denresta` IS NULL) OR (`denresta` = @Original_denresta)))";
this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text;
global::MySql.Data.MySqlClient.MySqlParameter param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_iddetalleenvio";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "iddetalleenvio";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_denidenvio";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "denidenvio";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_denidenvio";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "denidenvio";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_dencodigo";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dencodigo";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_dencodigo";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "dencodigo";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_dencantidad";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dencantidad";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_dencantidad";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dencantidad";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_denpreciounitario";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "denpreciounitario";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_denpreciounitario";
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.NewDecimal;
param.IsNullable = true;
param.SourceColumn = "denpreciounitario";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_dentipo";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dentipo";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_dentipo";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dentipo";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_denresta";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "denresta";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_denresta";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "denresta";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
this._adapter.InsertCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = "INSERT INTO `ste_detalleenvio` (`denidenvio`, `dencodigo`, `dendescripcion`, `den" +
"cantidad`, `denpreciounitario`, `dentipo`, `denresta`) VALUES (@denidenvio, @den" +
"codigo, @dendescripcion, @dencantidad, @denpreciounitario, @dentipo, @denresta)";
this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@denidenvio";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "denidenvio";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@dencodigo";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "dencodigo";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@dendescripcion";
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Text;
param.IsNullable = true;
param.SourceColumn = "dendescripcion";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@dencantidad";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dencantidad";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@denpreciounitario";
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.NewDecimal;
param.IsNullable = true;
param.SourceColumn = "denpreciounitario";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@dentipo";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dentipo";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@denresta";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "denresta";
this._adapter.InsertCommand.Parameters.Add(param);
this._adapter.UpdateCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.UpdateCommand.Connection = this.Connection;
this._adapter.UpdateCommand.CommandText = @"UPDATE `ste_detalleenvio` SET `denidenvio` = @denidenvio, `dencodigo` = @dencodigo, `dendescripcion` = @dendescripcion, `dencantidad` = @dencantidad, `denpreciounitario` = @denpreciounitario, `dentipo` = @dentipo, `denresta` = @denresta WHERE ((`iddetalleenvio` = @Original_iddetalleenvio) AND ((@IsNull_denidenvio = 1 AND `denidenvio` IS NULL) OR (`denidenvio` = @Original_denidenvio)) AND ((@IsNull_dencodigo = 1 AND `dencodigo` IS NULL) OR (`dencodigo` = @Original_dencodigo)) AND ((@IsNull_dencantidad = 1 AND `dencantidad` IS NULL) OR (`dencantidad` = @Original_dencantidad)) AND ((@IsNull_denpreciounitario = 1 AND `denpreciounitario` IS NULL) OR (`denpreciounitario` = @Original_denpreciounitario)) AND ((@IsNull_dentipo = 1 AND `dentipo` IS NULL) OR (`dentipo` = @Original_dentipo)) AND ((@IsNull_denresta = 1 AND `denresta` IS NULL) OR (`denresta` = @Original_denresta)))";
this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@denidenvio";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "denidenvio";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@dencodigo";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "dencodigo";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@dendescripcion";
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Text;
param.IsNullable = true;
param.SourceColumn = "dendescripcion";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@dencantidad";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dencantidad";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@denpreciounitario";
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.NewDecimal;
param.IsNullable = true;
param.SourceColumn = "denpreciounitario";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@dentipo";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dentipo";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@denresta";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "denresta";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_iddetalleenvio";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "iddetalleenvio";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_denidenvio";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "denidenvio";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_denidenvio";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "denidenvio";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_dencodigo";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dencodigo";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_dencodigo";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "dencodigo";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_dencantidad";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dencantidad";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_dencantidad";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dencantidad";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_denpreciounitario";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "denpreciounitario";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_denpreciounitario";
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.NewDecimal;
param.IsNullable = true;
param.SourceColumn = "denpreciounitario";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_dentipo";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dentipo";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_dentipo";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "dentipo";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_denresta";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "denresta";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_denresta";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "denresta";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
}
private void InitAdapter() {
this._adapter = new global::MySql.Data.MySqlClient.MySqlDataAdapter();
global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
tableMapping.SourceTable = "Table";
tableMapping.DataSetTable = "ste_camionero";
tableMapping.ColumnMappings.Add("idcamionero", "idcamionero");
tableMapping.ColumnMappings.Add("camnombres", "camnombres");
tableMapping.ColumnMappings.Add("camapellidos", "camapellidos");
tableMapping.ColumnMappings.Add("camdni", "camdni");
tableMapping.ColumnMappings.Add("camdireccion", "camdireccion");
tableMapping.ColumnMappings.Add("camlicencia", "camlicencia");
tableMapping.ColumnMappings.Add("camcategoria", "camcategoria");
this._adapter.TableMappings.Add(tableMapping);
this._adapter.DeleteCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.DeleteCommand.Connection = this.Connection;
this._adapter.DeleteCommand.CommandText = @"DELETE FROM `ste_camionero` WHERE ((`idcamionero` = @Original_idcamionero) AND ((@IsNull_camnombres = 1 AND `camnombres` IS NULL) OR (`camnombres` = @Original_camnombres)) AND ((@IsNull_camapellidos = 1 AND `camapellidos` IS NULL) OR (`camapellidos` = @Original_camapellidos)) AND ((@IsNull_camdni = 1 AND `camdni` IS NULL) OR (`camdni` = @Original_camdni)) AND ((@IsNull_camdireccion = 1 AND `camdireccion` IS NULL) OR (`camdireccion` = @Original_camdireccion)) AND ((@IsNull_camlicencia = 1 AND `camlicencia` IS NULL) OR (`camlicencia` = @Original_camlicencia)) AND ((@IsNull_camcategoria = 1 AND `camcategoria` IS NULL) OR (`camcategoria` = @Original_camcategoria)))";
this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text;
global::MySql.Data.MySqlClient.MySqlParameter param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_idcamionero";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "idcamionero";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_camnombres";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "camnombres";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_camnombres";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "camnombres";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_camapellidos";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "camapellidos";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_camapellidos";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "camapellidos";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_camdni";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "camdni";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_camdni";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "camdni";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_camdireccion";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "camdireccion";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_camdireccion";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "camdireccion";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_camlicencia";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "camlicencia";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_camlicencia";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "camlicencia";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_camcategoria";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "camcategoria";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_camcategoria";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "camcategoria";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
this._adapter.InsertCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = "INSERT INTO `ste_camionero` (`camnombres`, `camapellidos`, `camdni`, `camdireccio" +
"n`, `camlicencia`, `camcategoria`) VALUES (@camnombres, @camapellidos, @camdni, " +
"@camdireccion, @camlicencia, @camcategoria)";
this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@camnombres";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "camnombres";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@camapellidos";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "camapellidos";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@camdni";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "camdni";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@camdireccion";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "camdireccion";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@camlicencia";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "camlicencia";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@camcategoria";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "camcategoria";
this._adapter.InsertCommand.Parameters.Add(param);
this._adapter.UpdateCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.UpdateCommand.Connection = this.Connection;
this._adapter.UpdateCommand.CommandText = @"UPDATE `ste_camionero` SET `camnombres` = @camnombres, `camapellidos` = @camapellidos, `camdni` = @camdni, `camdireccion` = @camdireccion, `camlicencia` = @camlicencia, `camcategoria` = @camcategoria WHERE ((`idcamionero` = @Original_idcamionero) AND ((@IsNull_camnombres = 1 AND `camnombres` IS NULL) OR (`camnombres` = @Original_camnombres)) AND ((@IsNull_camapellidos = 1 AND `camapellidos` IS NULL) OR (`camapellidos` = @Original_camapellidos)) AND ((@IsNull_camdni = 1 AND `camdni` IS NULL) OR (`camdni` = @Original_camdni)) AND ((@IsNull_camdireccion = 1 AND `camdireccion` IS NULL) OR (`camdireccion` = @Original_camdireccion)) AND ((@IsNull_camlicencia = 1 AND `camlicencia` IS NULL) OR (`camlicencia` = @Original_camlicencia)) AND ((@IsNull_camcategoria = 1 AND `camcategoria` IS NULL) OR (`camcategoria` = @Original_camcategoria)))";
this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@camnombres";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "camnombres";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@camapellidos";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "camapellidos";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@camdni";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "camdni";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@camdireccion";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "camdireccion";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@camlicencia";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "camlicencia";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@camcategoria";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "camcategoria";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_idcamionero";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "idcamionero";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_camnombres";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "camnombres";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_camnombres";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "camnombres";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_camapellidos";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "camapellidos";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_camapellidos";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "camapellidos";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_camdni";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "camdni";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_camdni";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "camdni";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_camdireccion";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "camdireccion";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_camdireccion";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "camdireccion";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_camlicencia";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "camlicencia";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_camlicencia";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "camlicencia";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_camcategoria";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "camcategoria";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_camcategoria";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "camcategoria";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
}
private void InitAdapter() {
this._adapter = new global::MySql.Data.MySqlClient.MySqlDataAdapter();
global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
tableMapping.SourceTable = "Table";
tableMapping.DataSetTable = "customer_profile";
tableMapping.ColumnMappings.Add("CP_Name", "CP_Name");
tableMapping.ColumnMappings.Add("CP_Delivery_Address", "CP_Delivery_Address");
tableMapping.ColumnMappings.Add("CP_Mobile_Number", "CP_Mobile_Number");
tableMapping.ColumnMappings.Add("Customer_ID", "Customer_ID");
tableMapping.ColumnMappings.Add("Menu_Schedule_Customer_S", "Menu_Schedule_Customer_S");
this._adapter.TableMappings.Add(tableMapping);
}
private void InitAdapter() {
this._adapter = new global::MySql.Data.MySqlClient.MySqlDataAdapter();
global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
tableMapping.SourceTable = "Table";
tableMapping.DataSetTable = "ste_carga";
tableMapping.ColumnMappings.Add("idcarga", "idcarga");
tableMapping.ColumnMappings.Add("caridunidad", "caridunidad");
tableMapping.ColumnMappings.Add("carfechaasignacion", "carfechaasignacion");
tableMapping.ColumnMappings.Add("carfechasalida", "carfechasalida");
this._adapter.TableMappings.Add(tableMapping);
this._adapter.DeleteCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.DeleteCommand.Connection = this.Connection;
this._adapter.DeleteCommand.CommandText = @"DELETE FROM `ste_carga` WHERE ((`idcarga` = @Original_idcarga) AND ((@IsNull_caridunidad = 1 AND `caridunidad` IS NULL) OR (`caridunidad` = @Original_caridunidad)) AND ((@IsNull_carfechaasignacion = 1 AND `carfechaasignacion` IS NULL) OR (`carfechaasignacion` = @Original_carfechaasignacion)) AND ((@IsNull_carfechasalida = 1 AND `carfechasalida` IS NULL) OR (`carfechasalida` = @Original_carfechasalida)))";
this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text;
global::MySql.Data.MySqlClient.MySqlParameter param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_idcarga";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "idcarga";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_caridunidad";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "caridunidad";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_caridunidad";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "caridunidad";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_carfechaasignacion";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "carfechaasignacion";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_carfechaasignacion";
param.DbType = global::System.Data.DbType.DateTime;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.DateTime;
param.IsNullable = true;
param.SourceColumn = "carfechaasignacion";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_carfechasalida";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "carfechasalida";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_carfechasalida";
param.DbType = global::System.Data.DbType.DateTime;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.DateTime;
param.IsNullable = true;
param.SourceColumn = "carfechasalida";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
this._adapter.InsertCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = "INSERT INTO `ste_carga` (`caridunidad`, `carfechaasignacion`, `carfechasalida`) V" +
"ALUES (@caridunidad, @carfechaasignacion, @carfechasalida)";
this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@caridunidad";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "caridunidad";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@carfechaasignacion";
param.DbType = global::System.Data.DbType.DateTime;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.DateTime;
param.IsNullable = true;
param.SourceColumn = "carfechaasignacion";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@carfechasalida";
param.DbType = global::System.Data.DbType.DateTime;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.DateTime;
param.IsNullable = true;
param.SourceColumn = "carfechasalida";
this._adapter.InsertCommand.Parameters.Add(param);
this._adapter.UpdateCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.UpdateCommand.Connection = this.Connection;
this._adapter.UpdateCommand.CommandText = @"UPDATE `ste_carga` SET `caridunidad` = @caridunidad, `carfechaasignacion` = @carfechaasignacion, `carfechasalida` = @carfechasalida WHERE ((`idcarga` = @Original_idcarga) AND ((@IsNull_caridunidad = 1 AND `caridunidad` IS NULL) OR (`caridunidad` = @Original_caridunidad)) AND ((@IsNull_carfechaasignacion = 1 AND `carfechaasignacion` IS NULL) OR (`carfechaasignacion` = @Original_carfechaasignacion)) AND ((@IsNull_carfechasalida = 1 AND `carfechasalida` IS NULL) OR (`carfechasalida` = @Original_carfechasalida)))";
this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@caridunidad";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "caridunidad";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@carfechaasignacion";
param.DbType = global::System.Data.DbType.DateTime;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.DateTime;
param.IsNullable = true;
param.SourceColumn = "carfechaasignacion";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@carfechasalida";
param.DbType = global::System.Data.DbType.DateTime;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.DateTime;
param.IsNullable = true;
param.SourceColumn = "carfechasalida";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_idcarga";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "idcarga";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_caridunidad";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "caridunidad";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_caridunidad";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "caridunidad";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_carfechaasignacion";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "carfechaasignacion";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_carfechaasignacion";
param.DbType = global::System.Data.DbType.DateTime;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.DateTime;
param.IsNullable = true;
param.SourceColumn = "carfechaasignacion";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_carfechasalida";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "carfechasalida";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_carfechasalida";
param.DbType = global::System.Data.DbType.DateTime;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.DateTime;
param.IsNullable = true;
param.SourceColumn = "carfechasalida";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
}
private void InitAdapter() {
this._adapter = new global::MySql.Data.MySqlClient.MySqlDataAdapter();
global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
tableMapping.SourceTable = "Table";
tableMapping.DataSetTable = "Kanji";
tableMapping.ColumnMappings.Add("Id", "Id");
tableMapping.ColumnMappings.Add("Literal", "Literal");
tableMapping.ColumnMappings.Add("OnYomi", "OnYomi");
tableMapping.ColumnMappings.Add("KunYomi", "KunYomi");
tableMapping.ColumnMappings.Add("Meaning", "Meaning");
tableMapping.ColumnMappings.Add("JLPT", "JLPT");
tableMapping.ColumnMappings.Add("StrokeCount", "StrokeCount");
this._adapter.TableMappings.Add(tableMapping);
this._adapter.DeleteCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.DeleteCommand.Connection = this.Connection;
this._adapter.DeleteCommand.CommandText = @"DELETE FROM `Kanji` WHERE ((`Id` = @Original_Id) AND (`Literal` = @Original_Literal) AND (`OnYomi` = @Original_OnYomi) AND (`KunYomi` = @Original_KunYomi) AND (`Meaning` = @Original_Meaning) AND (`JLPT` = @Original_JLPT) AND (`StrokeCount` = @Original_StrokeCount))";
this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text;
global::MySql.Data.MySqlClient.MySqlParameter param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_Id";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Id";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_Literal";
param.DbType = global::System.Data.DbType.StringFixedLength;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.String;
param.IsNullable = true;
param.SourceColumn = "Literal";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_OnYomi";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "OnYomi";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_KunYomi";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "KunYomi";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_Meaning";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "Meaning";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_JLPT";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "JLPT";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_StrokeCount";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "StrokeCount";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
this._adapter.InsertCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = "INSERT INTO `Kanji` (`Literal`, `OnYomi`, `KunYomi`, `Meaning`, `JLPT`, `StrokeCo" +
"unt`) VALUES (@Literal, @OnYomi, @KunYomi, @Meaning, @JLPT, @StrokeCount)";
this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Literal";
param.DbType = global::System.Data.DbType.StringFixedLength;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.String;
param.IsNullable = true;
param.SourceColumn = "Literal";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@OnYomi";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "OnYomi";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@KunYomi";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "KunYomi";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Meaning";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "Meaning";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@JLPT";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "JLPT";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@StrokeCount";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "StrokeCount";
this._adapter.InsertCommand.Parameters.Add(param);
this._adapter.UpdateCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.UpdateCommand.Connection = this.Connection;
this._adapter.UpdateCommand.CommandText = @"UPDATE `Kanji` SET `Literal` = @Literal, `OnYomi` = @OnYomi, `KunYomi` = @KunYomi, `Meaning` = @Meaning, `JLPT` = @JLPT, `StrokeCount` = @StrokeCount WHERE ((`Id` = @Original_Id) AND (`Literal` = @Original_Literal) AND (`OnYomi` = @Original_OnYomi) AND (`KunYomi` = @Original_KunYomi) AND (`Meaning` = @Original_Meaning) AND (`JLPT` = @Original_JLPT) AND (`StrokeCount` = @Original_StrokeCount))";
this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Literal";
param.DbType = global::System.Data.DbType.StringFixedLength;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.String;
param.IsNullable = true;
param.SourceColumn = "Literal";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@OnYomi";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "OnYomi";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@KunYomi";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "KunYomi";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Meaning";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "Meaning";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@JLPT";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "JLPT";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@StrokeCount";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "StrokeCount";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_Id";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Id";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_Literal";
param.DbType = global::System.Data.DbType.StringFixedLength;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.String;
param.IsNullable = true;
param.SourceColumn = "Literal";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_OnYomi";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "OnYomi";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_KunYomi";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "KunYomi";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_Meaning";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "Meaning";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_JLPT";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "JLPT";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_StrokeCount";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "StrokeCount";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
}
private void InitAdapter() {
this._adapter = new global::MySql.Data.MySqlClient.MySqlDataAdapter();
global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
tableMapping.SourceTable = "Table";
tableMapping.DataSetTable = "ste_clinatural";
tableMapping.ColumnMappings.Add("idclinatural", "idclinatural");
tableMapping.ColumnMappings.Add("natnombres", "natnombres");
tableMapping.ColumnMappings.Add("natapellidos", "natapellidos");
tableMapping.ColumnMappings.Add("natdni", "natdni");
this._adapter.TableMappings.Add(tableMapping);
this._adapter.DeleteCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.DeleteCommand.Connection = this.Connection;
this._adapter.DeleteCommand.CommandText = @"DELETE FROM `ste_clinatural` WHERE ((`idclinatural` = @Original_idclinatural) AND ((@IsNull_natnombres = 1 AND `natnombres` IS NULL) OR (`natnombres` = @Original_natnombres)) AND ((@IsNull_natapellidos = 1 AND `natapellidos` IS NULL) OR (`natapellidos` = @Original_natapellidos)) AND ((@IsNull_natdni = 1 AND `natdni` IS NULL) OR (`natdni` = @Original_natdni)))";
this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text;
global::MySql.Data.MySqlClient.MySqlParameter param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_idclinatural";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "idclinatural";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_natnombres";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "natnombres";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_natnombres";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "natnombres";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_natapellidos";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "natapellidos";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_natapellidos";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "natapellidos";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_natdni";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "natdni";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_natdni";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "natdni";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
this._adapter.InsertCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = "INSERT INTO `ste_clinatural` (`idclinatural`, `natnombres`, `natapellidos`, `natd" +
"ni`) VALUES (@idclinatural, @natnombres, @natapellidos, @natdni)";
this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@idclinatural";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "idclinatural";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@natnombres";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "natnombres";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@natapellidos";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "natapellidos";
this._adapter.InsertCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@natdni";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "natdni";
this._adapter.InsertCommand.Parameters.Add(param);
this._adapter.UpdateCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
this._adapter.UpdateCommand.Connection = this.Connection;
this._adapter.UpdateCommand.CommandText = @"UPDATE `ste_clinatural` SET `idclinatural` = @idclinatural, `natnombres` = @natnombres, `natapellidos` = @natapellidos, `natdni` = @natdni WHERE ((`idclinatural` = @Original_idclinatural) AND ((@IsNull_natnombres = 1 AND `natnombres` IS NULL) OR (`natnombres` = @Original_natnombres)) AND ((@IsNull_natapellidos = 1 AND `natapellidos` IS NULL) OR (`natapellidos` = @Original_natapellidos)) AND ((@IsNull_natdni = 1 AND `natdni` IS NULL) OR (`natdni` = @Original_natdni)))";
this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@idclinatural";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "idclinatural";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@natnombres";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "natnombres";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@natapellidos";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "natapellidos";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@natdni";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "natdni";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_idclinatural";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "idclinatural";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_natnombres";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "natnombres";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_natnombres";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "natnombres";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_natapellidos";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "natapellidos";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_natapellidos";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "natapellidos";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@IsNull_natdni";
param.DbType = global::System.Data.DbType.Int32;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
param.IsNullable = true;
param.SourceColumn = "natdni";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new global::MySql.Data.MySqlClient.MySqlParameter();
param.ParameterName = "@Original_natdni";
param.DbType = global::System.Data.DbType.String;
param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
param.IsNullable = true;
param.SourceColumn = "natdni";
param.SourceVersion = global::System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
}
