private void lLenarDesdeUnSpOTablaToolStripMenuItem_Click(object sender, EventArgs e)
{
Formularios.FormBuscarTabla dlg = new FormBuscarTabla(DB, Visor_sql_2015.Controladores_DB.TIPOOBJETO.STOREPROCERURE);
if (dlg.ShowDialog() == DialogResult.Cancel)
{
return;
}
Objetos.CSysObject obj = dlg.DameObjeto();
int j, k;
System.Data.SqlClient.SqlCommand SqlCommand1;
SqlCommand1 = new System.Data.SqlClient.SqlCommand();
SqlCommand1.CommandText = obj.Nombre;
SqlCommand1.CommandType = System.Data.CommandType.StoredProcedure;
SqlCommand1.Connection = new System.Data.SqlClient.SqlConnection(DB.ConnectionString);
SqlCommand1.Connection.Open();
System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand1);
System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;
sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter();
sqlDataAdapter1.SelectCommand = SqlCommand1;
DataSet ds = new DataSet("aaa");
try
{
sqlDataAdapter1.GetFillParameters();
sqlDataAdapter1.FillSchema(ds, SchemaType.Source, "aaa");
k = ds.Tables.Count;
for (j = 0; j < k; j++)
{
System.Data.DataTable t = ds.Tables[j];
int i, n;
n = t.Columns.Count;
Objetos.CConvertidor cv = new Objetos.CConvertidor();
for (i = 0; i < n; i++)
{
System.Data.DataColumn c = t.Columns[i];
Objetos.CParametro parametro = new Objetos.CParametro();
parametro.tipo = c.Caption;
parametro.nombre = c.Caption;
parametro.Logitud = c.MaxLength;
this.Campos.Add(parametro);
ListaCampos.Items.Add(parametro.tipo);
//string TipoNet = cv.DameTipo(c.DataType.ToString());
//OnDatoManual(c.Caption, TipoNet);
}
}
}
catch (Exception ex)
{
SqlCommand1.Connection.Close();
throw new Exception(ex.Message);
}
SqlCommand1.Connection.Close();
MuestraDataGrid();
}
private void MuestraCampos()
{
int j, k;
System.Data.SqlClient.SqlCommand SqlCommand1;
SqlCommand1 = new System.Data.SqlClient.SqlCommand();
SqlCommand1.CommandText = Nombre;
SqlCommand1.CommandType = System.Data.CommandType.StoredProcedure;
SqlCommand1.Connection = new System.Data.SqlClient.SqlConnection(DB.ConnectionString);
SqlCommand1.Connection.Open();
System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand1);
System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;
sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter();
sqlDataAdapter1.SelectCommand = SqlCommand1;
DataSet ds = new DataSet("aaa");
try
{
sqlDataAdapter1.GetFillParameters();
sqlDataAdapter1.FillSchema(ds, SchemaType.Source, "aaa");
k = ds.Tables.Count;
for (j = 0; j < k; j++)
{
System.Data.DataTable t = ds.Tables[j];
int i, n;
n = t.Columns.Count;
Objetos.CConvertidor cv = new Objetos.CConvertidor();
for (i = 0; i < n; i++)
{
System.Data.DataColumn c = t.Columns[i];
string TipoNet = cv.DameTipo(c.DataType.ToString());
OnDatoManual(c.Caption, TipoNet);
}
}
}
catch (Exception ex)
{
SqlCommand1.Connection.Close();
throw new Exception(ex.Message);
}
SqlCommand1.Connection.Close();
}
public void CreaCodigoTabla(string clase, System.Collections.Generic.List <Objetos.CParametro> parametros)
{
TCodigo.Text = "";
string s;
s = "using System;\r\n";
s = s + "namespace //namespace\r\n";
s = s + "{\r\n";
s = s + "\t/// <summary>\r\n";
s = s + "\t/// Summary description for " + clase + ".\r\n";
s = s + "\t/// </summary>\r\n";
s = s + "\tpublic class " + clase + "\r\n";
s = s + "\t{\r\n";
s = s + "\t\tpublic " + clase + "()\r\n";
s = s + "\t\t{\r\n";
s = s + "\t\t//\r\n";
s = s + "\t\t// TODO: Add constructor logic here\r\n";
s = s + "\t\t//\r\n";
s = s + "\t\t}\r\n";
Objetos.CConvertidor conv = new Objetos.CConvertidor();
int i, n;
n = parametros.Count;
for (i = 0; i < n; i++)
{
Objetos.CParametro par = parametros[i];
s = s + "\t\tpublic " + par.TipoNet + " " + par.nombre + "\r\n";
s = s + "\t\t{\r\n";
s = s + "\t\t\tget;\r\n";
s = s + "\t\t\tset;\r\n";
s = s + "\t\t}\r\n";
}
s = s + "\t}\r\n";
s = s + "}\r\n";
TCodigo.Text = s;
cTextColor1.AnalizaTexto();
}
