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