public void GenerarChangeState()
{
int n_activo = (from c in _lstColumnaBE where c.Nombre == _CampoHabilitado select c).Count();
if (n_activo > 0)
{
string connection = GetTipoConnection();
string parameter = GetTipoParamenter();
string command = GetTipoCommand();
StreamWriter dalc = File.AppendText(_Ruta);
int n_key = (from c in _lstColumnaBE where c.Es_PK select c).Count();
dalc.WriteLine(" public void Change_State_" + ToolBC.StandarizarNombreClase(_objTablaBE.Nombre) + "(" + ToolBC.KeyParameters(_lstColumnaBE, _DataSource) + ")");
dalc.WriteLine(" {");
dalc.WriteLine(" String cadena;");
dalc.WriteLine(" String sql = \"" + ToolBC.StandarizarNombreClase(_objTablaBE.Nombre) + "_Change_State\";");
dalc.WriteLine(" " + parameter + "[] arrParameters = new " + parameter + "[" + n_key + "];");
dalc.WriteLine("");
dalc.WriteLine(" try");
dalc.WriteLine(" {");
dalc.WriteLine(" cadena = " + (_Tool ? ToolGenBC.GetNombreFuncion() : ToolGenBC.GetCadenaConexion(_Tag)));
dalc.WriteLine("");
dalc.WriteLine(" using(" + connection + " conn = new " + connection + "(cadena))");
dalc.WriteLine(" {");
dalc.WriteLine(" using(" + command + " cmd = conn.CreateCommand())");
dalc.WriteLine(" {");
dalc.WriteLine(" cmd.CommandText = sql;");
dalc.WriteLine(" cmd.CommandType = CommandType.StoredProcedure;");
dalc.WriteLine("");
KeyParameters(dalc);
dalc.WriteLine("");
dalc.WriteLine(" for (int i = 0; i < arrParameters.Length; i++)");
dalc.WriteLine(" cmd.Parameters.Add(arrParameters[i]);");
dalc.WriteLine("");
dalc.WriteLine(" cmd.Connection.Open();");
dalc.WriteLine(" cmd.ExecuteNonQuery();");
dalc.WriteLine(" }");
dalc.WriteLine(" }");
dalc.WriteLine(" }");
dalc.WriteLine(" catch(Exception)");
dalc.WriteLine(" {");
dalc.WriteLine(" throw;");
dalc.WriteLine(" }");
dalc.WriteLine(" }");
dalc.WriteLine("");
dalc.Close();
}
}
public void GenerarChangeState()
{
try
{
int n_activo = (from c in _lstColumnaBE where c.Nombre == _CampoHabilitado select c).Count();
if (n_activo > 0)
{
int n_habilitado = (from c in _lstColumnaBE where c.Nombre == _CampoHabilitado select c).Count();
StreamWriter bc = File.AppendText(_Ruta);
bc.WriteLine(" public void Change_State_" + ToolBC.StandarizarNombreClase(_objTablaBE.Nombre) + "(" + ToolBC.KeyParameters(_lstColumnaBE, _DataSource) + ")");
bc.WriteLine(" {");
bc.WriteLine(" try");
bc.WriteLine(" {");
bc.WriteLine(" obj" + ToolBC.StandarizarNombreClase(_objTablaBE.Nombre) + "DALC.Change_State_" + ToolBC.StandarizarNombreClase(_objTablaBE.Nombre) + "(" + ToolBC.KeyVariables(_lstColumnaBE) + ");");
bc.WriteLine(" }");
bc.WriteLine(" catch(Exception)");
bc.WriteLine(" {");
bc.WriteLine(" throw;");
bc.WriteLine(" }");
bc.WriteLine(" }");
bc.WriteLine("");
bc.Close();
}
}
catch (Exception)
{
throw;
}
}
public void GenerarGet()
{
string connection = GetTipoConnection();
string parameter = GetTipoParamenter();
string command = GetTipoCommand();
string datareader = GetTipoDataReader();
StreamWriter dalc = File.AppendText(_Ruta);
int n_key = (from c in _lstColumnaBE where c.Es_PK select c).Count();
dalc.WriteLine(" public " + ToolBC.StandarizarNombreClase(_objTablaBE.Nombre) + "BE Get_" + ToolBC.StandarizarNombreClase(_objTablaBE.Nombre) + "(" + ToolBC.KeyParameters(_lstColumnaBE, _DataSource) + ")");
dalc.WriteLine(" {");
dalc.WriteLine(" String cadena;");
dalc.WriteLine(" String sql = \"" + ToolBC.StandarizarNombreClase(_objTablaBE.Nombre) + "_Get\";");
dalc.WriteLine(" " + parameter + "[] arrParameters = new " + parameter + "[" + n_key + "];");
dalc.WriteLine(" " + ToolBC.StandarizarNombreClase(_objTablaBE.Nombre) + "BE obj" + ToolBC.StandarizarNombreClase(_objTablaBE.Nombre) + "BE = null;");
dalc.WriteLine("");
dalc.WriteLine(" try");
dalc.WriteLine(" {");
dalc.WriteLine(" cadena = " + (_Tool ? ToolGenBC.GetNombreFuncion() : ToolGenBC.GetCadenaConexion(_Tag)));
dalc.WriteLine("");
dalc.WriteLine(" using(" + connection + " conn = new " + connection + "(cadena))");
dalc.WriteLine(" {");
dalc.WriteLine(" using(" + command + " cmd = conn.CreateCommand())");
dalc.WriteLine(" {");
dalc.WriteLine(" cmd.CommandText = sql;");
dalc.WriteLine(" cmd.CommandType = CommandType.StoredProcedure;");
dalc.WriteLine("");
KeyParameters(dalc);
dalc.WriteLine("");
dalc.WriteLine(" for (int i = 0; i < arrParameters.Length; i++)");
dalc.WriteLine(" cmd.Parameters.Add(arrParameters[i]);");
dalc.WriteLine("");
dalc.WriteLine(" cmd.Connection.Open();");
dalc.WriteLine("");
dalc.WriteLine(" using(" + datareader + " dr = cmd.ExecuteReader())");
dalc.WriteLine(" {");
dalc.WriteLine(" while(dr.Read())");
dalc.WriteLine(" {");
dalc.WriteLine(" obj" + ToolBC.StandarizarNombreClase(_objTablaBE.Nombre) + "BE = new " + ToolBC.StandarizarNombreClase(_objTablaBE.Nombre) + "BE();");
ClassFromDR(dalc);
dalc.WriteLine(" }");
dalc.WriteLine(" }");
dalc.WriteLine(" }");
dalc.WriteLine(" }");
dalc.WriteLine(" return obj" + ToolBC.StandarizarNombreClase(_objTablaBE.Nombre) + "BE;");
dalc.WriteLine(" }");
dalc.WriteLine(" catch(Exception)");
dalc.WriteLine(" {");
dalc.WriteLine(" throw;");
dalc.WriteLine(" }");
dalc.WriteLine(" }");
dalc.WriteLine("");
dalc.Close();
}
public void GenerarGet()
{
StreamWriter bc = File.AppendText(_Ruta);
try
{
bc.WriteLine(" public " + ToolBC.StandarizarNombreClase(_objTablaBE.Nombre) + "BE Get_" + ToolBC.StandarizarNombreClase(_objTablaBE.Nombre) + "(" + ToolBC.KeyParameters(_lstColumnaBE, _DataSource) + ")");
bc.WriteLine(" {");
bc.WriteLine(" try");
bc.WriteLine(" {");
bc.WriteLine(" return obj" + ToolBC.StandarizarNombreClase(_objTablaBE.Nombre) + "DALC.Get_" + ToolBC.StandarizarNombreClase(_objTablaBE.Nombre) + "(" + ToolBC.KeyVariables(_lstColumnaBE) + ");");
bc.WriteLine(" }");
bc.WriteLine(" catch(Exception)");
bc.WriteLine(" {");
bc.WriteLine(" throw;");
bc.WriteLine(" }");
bc.WriteLine(" }");
bc.WriteLine("");
bc.Close();
}
catch (Exception)
{
throw;
}
}
