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