public void GeneraParametersCSharp(CSourceWriter sw) { foreach (var f in this.lFieldData) { if (f.IsNullable) { sw.Write("com.Parameters.AddWithValue(UtilBD.Param(\""); sw.Write(f.Name); sw.Write("\"), "); sw.Write(f.Name); sw.WriteLn(");"); } else { sw.Write("if ("); sw.Write(f.Name); sw.Write(" == null){"); sw.Write("com.Parameters.AddWithValue(UtilBD.Param(\""); sw.Write(f.Name); sw.Write("\"), "); sw.Write("DBNull.Value"); sw.WriteLn(");"); sw.WriteLn("} else {"); sw.Write("com.Parameters.AddWithValue(UtilBD.Param(\""); sw.Write(f.Name); sw.Write("\"), "); sw.Write(f.Name); sw.WriteLn(");"); sw.WriteLn("}"); } } }
internal void GenerateSql(CSourceWriter sw) { sw.WriteLn("create table dbo." + this.Name + "("); bool primero = true; sw.AddTab(); foreach (CFieldM f in this.lFieldAll) { f.GeneraSql(sw, ref primero); } if (this.lFieldPk.Count > 0) { sw.WriteLn(",CONSTRAINT PK_" + this.Name + " PRIMARY KEY ("); primero = true; sw.AddTab(); foreach (CFieldM f in this.lFieldPk) { sw.Write(""); sw.WriteComma(ref primero); sw.WriteLn(f.Name); } sw.DelTab(); sw.WriteLn(")"); } foreach (CUniqueConstraintM u in this.LUniqueConstraint) { u.GeneraSql(sw); } sw.DelTab(); sw.WriteLn(")"); sw.EndLine(); sw.WriteLn("GO"); //Genera las unique constraints }
public override void Generate(CSourceWriter sw) { CSharpProject.WriteVisibility(sw, this.Visibility); sw.Space(); if (this.Class == null) { throw new NullReferenceException("El constructor ha de tener una clase."); } sw.Write(this.Class.Name); sw.Write("("); bool Primero = true; foreach (CParam p in this.lParam) { sw.WriteComma(ref Primero); p.Generate(sw); } sw.Write(")"); sw.OpenBracesLn(); sw.AddTab(); foreach (CSentence sen in lSentence) { sen.Generate(sw); } sw.DelTab(); sw.CloseBracesLn(); }
public override void Generate(CSourceWriter sw) { CSharpProject.WriteVisibility(sw, this.Visibility); sw.Space(); if (this.IsStatic) { sw.Write("static"); sw.Space(); } if (this.IsOverride) { sw.Write("override"); sw.Space(); } this.Type.Generate(sw); sw.Space(); sw.Write(this.Name); sw.Write("("); bool Primero = true; foreach (CParam p in this.lParam) { sw.WriteComma(ref Primero); p.Generate(sw); } sw.Write(")"); sw.WriteLn("{"); sw.AddTab(); foreach (CSentence sen in lSentence) { sen.Generate(sw); } sw.DelTab(); sw.WriteLn("}"); }
public override void Generate(CSourceWriter sw) { CSharpProject.WriteVisibility(sw, this.CSharpVisibility); sw.Space(); if (this.IsStatic) { sw.Write("static"); sw.Space(); } if (this.IsPartial) { sw.Write("partial"); sw.Space(); } sw.Write("class"); sw.Space(); sw.Write(this.Name); if (!string.IsNullOrWhiteSpace(this.ParentClassName)) { sw.Write(" : "); sw.Write(this.ParentClassName); } //*** Interfaces sw.OpenBracesLn(); sw.AddTab(); foreach (CClassElement item in this.lElement) { item.Generate(sw); } sw.DelTab(); sw.CloseBracesLn(); }
private void GenerateNamespace(CSourceWriter sw) { sw.Write("namespace"); sw.Space(); sw.Write(this.Namespace); sw.OpenBracesLn(); sw.AddTab(); }
public string GeneraSelectByPk() { MemoryStream ms = new MemoryStream(); CSourceWriter sw = new CSourceWriter(ms); this.GeneraSelectByPk(sw); sw.Close(); return(Encoding.UTF8.GetString(ms.ToArray())); }
private void GeneraSelectAll(CSourceWriter sw) { sw.Write("select"); sw.Space(); this.CamposPorComas(sw); sw.Space(); sw.Write("from"); sw.Space(); sw.Write(this.Name); }
private void CamposPorComas(CSourceWriter sw) { bool Primero = true; foreach (CFieldM f in this.lFieldAll) { sw.WriteComma(ref Primero); sw.Write(f.Name); } }
private void ParametrosCamposNoClavePorComas(CSourceWriter sw) { bool Primero = true; foreach (CFieldM f in this.lFieldData) { sw.WriteComma(ref Primero); sw.Write(SUtilBD.Param(f.Name)); } }
public void GeneraInsert(CSourceWriter sw) { sw.Write("insert into "); sw.Write(this.Name); sw.Write("("); this.CamposNoIdPorComas(sw); sw.Write(")"); sw.Write("values"); sw.Write("("); this.ParametrosCamposNoIdPorComas(sw); sw.Write(")"); }
internal void GeneraSql(CSourceWriter sw) { sw.WriteLn(string.Format("alter table dbo.{0} add constraint {1} foreign key(", this.tableSource.Name, this.Name)); sw.AddTab(); sw.WriteCommaStringList(this.lFieldSource); sw.DelTab(); sw.WriteLn(") references dbo." + this.tableDestination + " ("); sw.AddTab(); sw.WriteCommaStringList(this.lFieldDestination); sw.DelTab(); sw.WriteLn(")"); sw.WriteLn("GO"); }
private void ParametrosCamposNoIdPorComas(CSourceWriter sw) { bool Primero = true; foreach (CFieldM f in this.lFieldAll) { if (!f.IsIdentity) { sw.WriteComma(ref Primero); sw.Write(SUtilBD.Param(f.Name)); } } }
internal void GeneraSql(CSourceWriter sw) { bool primero = true; //CONSTRAINT AK_TransactionID UNIQUE(TransactionID) sw.WriteLn(",constraint " + this.Nombre + " unique ("); sw.AddTab(); foreach (CFieldM f in this.LFields) { sw.WriteComma(ref primero); sw.WriteLn("" + f.Name); } sw.DelTab(); sw.WriteLn(")"); }
private void GeneraDelete(CSourceWriter sw) { sw.Write("delete from "); sw.Write(this.Name); sw.Write(" where "); bool Primero = true; foreach (CFieldM f in this.lFieldPk) { sw.WriteAnd(ref Primero); sw.Write(f.Name); sw.Write(" = "); sw.Write(SUtilBD.Param(f.Name)); } }
public override void Generate(TextWriter lMensaje) { CSourceWriter sw = new CSourceWriter(this.ParentDirectory.FullName, this.Name); try { GenerateUsings(sw); GenerateNamespace(sw); foreach (CSharpElement item in this.lElement) { item.Generate(sw); } GenerateEndNamespace(sw); } finally { sw.Close(); lMensaje.WriteLine("Generado: " + sw.FullFileName); } }
private void GeneraSelectByPk(CSourceWriter sw) { sw.Write("select"); sw.Space(); this.CamposPorComas(sw); sw.Space(); sw.Write("from"); sw.Space(); sw.Write(this.Name); bool Primero = true; var sb = new StringBuilder(); foreach (CFieldM f in this.lFieldPk) { SUtilBD.AddCondicion(ref Primero, sb, f.Name + " = @" + SUtilBD.ParamName(f.Name)); } sw.Space(); sw.Write(sb.ToString()); }
public override void Generate(CSourceWriter sw) { CSharpProject.WriteVisibility(sw, this.CSharpVisibility); sw.Space(); if (this.IsStatic) { sw.Write("static"); sw.Space(); } this.Type.Generate(sw); sw.Space(); sw.Write(this.Name); if (!string.IsNullOrWhiteSpace(this.InitialValue)) { sw.Write(" = "); sw.Write(this.InitialValue); } sw.SemicolonLn(); }
private void GenerateUsings(CSourceWriter sw) { bool escribioUsings = false; LUsing l = new LUsing(); foreach (var item in this.lElement) { l.AddLUsing(item.lUsing); } foreach (CUsing u in l) { u.Generate(sw); escribioUsings = true; } if (escribioUsings) { sw.EndLine(); } }
internal static void WriteVisibility(CSourceWriter sw, CSharpVisibility cSharpVisibility) { switch (cSharpVisibility) { case CSharpVisibility.cvPublic: sw.Write("public"); break; case CSharpVisibility.cvPrivate: sw.Write("private"); break; case CSharpVisibility.cvProtected: sw.Write("protected"); break; case CSharpVisibility.cvInternal: sw.Write("internal"); break; } }
public string GenerateSql(bool withDrops) { MemoryStream ms = new MemoryStream(); CSourceWriter sw = new CSourceWriter(ms); if (withDrops) { //Primero se borran todas las relaciones para evitar errores de eliminación de tablas con otras relacionadas.(Si existen) foreach (CTableM t in this.lTable) { foreach (CRelationM r in t.lRelation) { sw.WriteLn(string.Format("IF OBJECT_ID('dbo.{0}', 'F') IS NOT NULL ALTER TABLE dbo.{1} DROP CONSTRAINT {0};", r.Name, r.tableSource.Name)); sw.WriteLn("GO"); } } //Se elinan las tablas si existen foreach (CTableM t in this.lTable) { sw.WriteLn(string.Format("IF OBJECT_ID('dbo.{0}', 'U') IS NOT NULL DROP TABLE dbo.{0};", t.Name)); sw.WriteLn("GO"); } } foreach (CTableM t in this.lTable) { t.GenerateSql(sw); sw.EndLine(); } foreach (CTableM t in this.lTable) { foreach (CRelationM r in t.lRelation) { r.GeneraSql(sw); } } sw.Close(); return(Encoding.UTF8.GetString(ms.ToArray())); }
public void GeneraInsertMethod(CSourceWriter sw) { sw.Write("public static int Insert"); sw.Write(this.Name); sw.Write("("); bool primero = true; foreach (CFieldM f in this.lFieldAll) { if (!f.IsIdentity) { sw.WriteComma(ref primero); sw.Write(f.csDataTypeName()); sw.Write(" "); sw.Write(f.Name); } } sw.WriteComma(ref primero); sw.Write("SqlConnection con"); sw.Write(")"); sw.WriteLn("{"); }
public void GeneraSql(CSourceWriter sw, ref bool primero) { sw.WriteComma(ref primero); sw.Write(this.Name); sw.Write(" "); sw.Write(this.CadenaTDSqlServer); if ((this.Td == SqlDbType.VarChar) || (this.Td == SqlDbType.VarBinary)) { sw.Write("("); sw.Write(this.Lenght.ToString()); sw.Write(")"); } if (this.IsIdentity) { sw.Write(" identity "); } if (!this.IsNullable) { sw.Write(" not null "); } sw.EndLine(); }
private void GeneraUpdate(CSourceWriter sw) { sw.Write("update "); sw.Write(this.Name); sw.Write(" set "); bool Primero = true; foreach (CFieldM f in this.lFieldData) { sw.WriteComma(ref Primero); sw.Write(f.Name); sw.Write(" = "); sw.Write(SUtilBD.Param(f.Name)); } sw.Write(" where "); Primero = true; foreach (CFieldM f in this.lFieldPk) { sw.WriteComma(ref Primero); sw.Write(f.Name); sw.Write(" = "); sw.Write(SUtilBD.Param(f.Name)); } }
public override void Generate(CSourceWriter sw) { sw.Write("bool?"); }
public override void Generate(CSourceWriter sw) { sw.Write("float?"); }
public override void Generate(CSourceWriter sw) { sw.Write("double?"); }
public override void Generate(CSourceWriter sw) { sw.Write("DateTime ?"); }
public override void Generate(CSourceWriter sw) { sw.Write("string"); }
public override void Generate(CSourceWriter sw) { sw.Write("byte[]"); }