static string GenSPParameters_Batch(TableViewBase pTable, CodeGeneratorCommon.MethodActionType pMethodActionType)
{
StringBuilder wParams = new StringBuilder();
int i = 0;
bool appendProperty = true;
Column primaryKey = FwkGenerator.GetPrimaryKey(pTable);
foreach (Column c in pTable.Columns)
{
i++;
if (pMethodActionType == CodeGeneratorCommon.MethodActionType.Insert ||
pMethodActionType == CodeGeneratorCommon.MethodActionType.Update)
{
if (primaryKey != null)
{
appendProperty = !(primaryKey == c && pMethodActionType == CodeGeneratorCommon.MethodActionType.Insert);
}
if (appendProperty)
{
//i == pTable.Columns.Count --> Fin de la coleccion
wParams.Append(Get_Property_Batch(c, (i == pTable.Columns.Count)));
}
}
}
return(wParams.ToString());
}
/// <summary>
/// Genera código de parámetros de llamado a un método.
/// </summary>
/// <param name="CodeGeneratorCommon.MethodActionType">información sobre el método a generar.</param>
/// <param name="pTable">tabla.</param>
/// <returns>Código que representa los parámetros para ejecutar el método.</returns>
/// <author>Marcelo Oviedo</author>
static string GenMethodParameters(CodeGeneratorCommon.MethodActionType pMethodActionType, TableViewBase pTable)
{
String wBuilder = string.Empty;
switch (pMethodActionType)
{
case CodeGeneratorCommon.MethodActionType.Insert:
case CodeGeneratorCommon.MethodActionType.Update:
case CodeGeneratorCommon.MethodActionType.GetByParam:
case CodeGeneratorCommon.MethodActionType.SearchByParam:
wBuilder = string.Concat(pTable.Name, " p", pTable.Name);
break;
case CodeGeneratorCommon.MethodActionType.Delete:
Column pPK = FwkGenerator.GetPrimaryKey(pTable);
if (pPK != null)
{
FwkGenerator.GetCSharpType(pPK);
wBuilder = String.Concat(FwkGenerator.GetCSharpType(pPK), " p", pPK.Name);
}
else
{
wBuilder = String.Concat("int pId");
}
break;
}
return(wBuilder);
}
static void GenCodeInsert(TableViewBase pTable, string pSpBody, CodeGeneratorCommon.MethodActionType action, List <GeneratedCode> pProceduresCode)
{
StringBuilder wBuilder = null;
GeneratedCode wCode = null;
String wIntermediateCode = String.Empty;
try
{
wBuilder = new StringBuilder();
wBuilder = GenCodeCommon(pTable, pSpBody);
wIntermediateCode = "(" + GenCodeInsertParameters(pTable, action) + ")";
wBuilder.Replace("[Parameters]", wIntermediateCode);
wBuilder.Replace("[Fields]", GenCodeInsertFields(pTable, action));
wBuilder.Replace("[Values]", GenCodeInsertValues(pTable, action));
wBuilder.Replace("[ReturnAutogenerated]", GenCodeInsertReturnAutogenerated(pTable, action));
wBuilder.Replace(CodeGeneratorCommon.CommonConstants.CONST_STOREDPROCEDURE_NAME, GetStoredProcedureName(pTable.Name, pTable.Schema, action));
//wCode = GetEntityGeneratedCode(pMethodInfo.Entity, pProceduresCode);
wCode = new GeneratedCode();
wCode.Id = pTable.Name;
wCode.Code.Append(wBuilder.ToString());
wCode.MethodActionType = action;
pProceduresCode.Add(wCode);
}
finally
{
wBuilder = null;
wCode = null;
}
}
///TODO: Ver si se utiliza esto
static string GenCodeInsertReturnAutogenerated(TableViewBase pTable, CodeGeneratorCommon.MethodActionType action)
{
StringBuilder wBuilder = new StringBuilder();
string wText = string.Empty;
foreach (Column wColumn in pTable.Columns)
{
if (wColumn.Identity)
{
wBuilder.Append("@");
wBuilder.Append(wColumn.Name);
//wText = Properties.Settings.Default.GetReturnAutogeneratedPattern.Replace("[Name]", wBuilder.ToString());
break;
}
}
string wOutputIdentitySet = FwkGeneratorHelper.TemplateDocument.GetTemplate("SP_OutputIdentitySet").Content;
if (wBuilder.Length == 0)
{
return(String.Empty);
}
else
{
return(wOutputIdentitySet.Replace("[OutputVariable]", wBuilder.ToString()));
}
}
/// <summary>
/// Retorno del metodo
/// </summary>
/// <param name="pTable"></param>
/// <param name="pMethodActionType"></param>
/// <returns></returns>
static string GetSPName(TableViewBase pTable, CodeGeneratorCommon.MethodActionType pMethodActionType)
{
String sufix = string.Empty;
switch (pMethodActionType)
{
case CodeGeneratorCommon.MethodActionType.Insert:
sufix = "_i";
break;
case CodeGeneratorCommon.MethodActionType.GetByParam:
sufix = "_gp";
break;
case CodeGeneratorCommon.MethodActionType.Update:
sufix = "_u";
break;
case CodeGeneratorCommon.MethodActionType.Delete:
sufix = "_d";
break;
case CodeGeneratorCommon.MethodActionType.SearchByParam:
sufix = "_sp";
break;
case CodeGeneratorCommon.MethodActionType.Get:
sufix = "_g";
break;
}
return(string.Concat(pTable.Name, sufix));
}
/// <summary>
/// Genera código de parámetros de un procedimiento almacenado de Búsqueda por clave primaria.
/// </summary>
/// <param name="pMethodInfo">información del método para generar stored procedure.</param>
/// <returns>Código fuente generado.</returns>
/// <date>2007-5-25T00:00:00</date>
/// <author>Marcelo Oviedo</author>
protected string GenCodeParameters(TableViewBase pTable, CodeGeneratorCommon.MethodActionType action)
{
StringBuilder wBuilder = new StringBuilder();
//if (action == MethodActionType.Get)
//{
foreach (Column wColumn in pTable.Columns)
{
//if (wColumn.KeyField)// && wColumn.Selected)
//{
StringBuilder wParamBuilder = BuildParameter(wColumn, action, false, false);
wBuilder.Append(wParamBuilder.ToString());
//}
}
//}
//else
//{
// foreach (ParameterInfo wParameterInfo in pMethodInfo.Parameters)
// {
// StringBuilder wParamBuilder = base.BuildParameter(wParameterInfo);
// wBuilder.Append(wParamBuilder.ToString());
// }
//}
RemoveChars(wBuilder, 3);
return(wBuilder.ToString());
}
/// <summary>
/// Retorna Nombre del SP segun toipo de accion del SP
/// </summary>
/// <param name="pTableName">Nombre de tabla</param>
/// <param name="pActionType">Puede ser get insert update delente etc</param>
/// <returns>StoredProcedureName</returns>
static String GetStoredProcedureName(String pTableName, String pSchema, CodeGeneratorCommon.MethodActionType pActionType)
{
String pSpName = String.Empty;
switch (pActionType)
{
case CodeGeneratorCommon.MethodActionType.Insert:
{
pSpName = string.Concat(pSchema, ".", pTableName, "_i");
break;
}
case CodeGeneratorCommon.MethodActionType.Update:
{
pSpName = string.Concat(pSchema, ".", pTableName, "_u");
break;
}
case CodeGeneratorCommon.MethodActionType.Delete:
{
pSpName = string.Concat(pSchema, ".", pTableName, "_d");
break;
}
case CodeGeneratorCommon.MethodActionType.SearchByParam:
{
pSpName = string.Concat(pSchema, ".", pTableName, "_s");
break;
}
}
return(pSpName);
}
/// <summary>
/// Genera comentarios sobre los parámetros de un método.
/// </summary>
/// <param name="pMethodInfo">información sobre el método a generar.</param>
/// <returns>Comentarios sobre los parámetros.</returns>
/// <author>Marcelo Oviedo</author>
static string GenParametersSummary(CodeGeneratorCommon.MethodActionType pMethodActionType, TableViewBase pTable)
{
StringBuilder wBuilder = new StringBuilder(FwkGenerator.TemplateDocument.GetTemplate("ParameterSummary").Content);
switch (pMethodActionType)
{
case CodeGeneratorCommon.MethodActionType.Insert:
case CodeGeneratorCommon.MethodActionType.Update:
case CodeGeneratorCommon.MethodActionType.GetByParam:
case CodeGeneratorCommon.MethodActionType.SearchByParam:
wBuilder.Replace("[MethodParameterName]", pTable.Name);
wBuilder.Replace("[ParameterName]", pTable.Name);
break;
case CodeGeneratorCommon.MethodActionType.Delete:
Column pPK = FwkGenerator.GetPrimaryKey(pTable);
if (pPK != null)
{
wBuilder.Replace("[MethodParameterName]", pPK.Name);
}
else
{
wBuilder.Replace("[MethodParameterName]", "pId");
}
wBuilder.Replace("[ParameterName]", string.Concat("Id por el cual realizar la busqueda de registros a eliminar de tabla ", pTable.Name));
break;
}
return(wBuilder.ToString());
}
static string GenBatchMethod(TableViewBase pTable, CodeGeneratorCommon.MethodActionType t)
{
StringBuilder wMethod = new StringBuilder(FwkGenerator.TemplateDocument.GetTemplate("MethodBatch").Content);
wMethod.Replace("[SummaryParams]", GenParametersSummary(t, pTable));
wMethod.Replace("[ParamArgs]", GenMethodParameters(t, pTable));
wMethod.Replace("[MethodName]", t.ToString());
wMethod.Replace("[StoredProcedureName]", GetSPName(pTable, t));
wMethod.Replace("[Parameters]", GenSPParameters_Batch(pTable, t));
return(wMethod.ToString());
}
private static string GenDeclaration(TableViewBase pTable, CodeGeneratorCommon.MethodActionType t)
{
switch (t)
{
case CodeGeneratorCommon.MethodActionType.GetByParam:
case CodeGeneratorCommon.MethodActionType.SearchByParam:
{
return(FwkGenerator.TemplateDocument.GetTemplate("EntityAnListDeclaration").Content);
}
}
return(string.Empty);
}
static string GenMethod(TableViewBase pTable, CodeGeneratorCommon.MethodActionType t)
{
StringBuilder wMethod = new StringBuilder(_Method_tt);
wMethod.Replace("[SummaryParams]", GenParametersSummary(t, pTable));
wMethod.Replace("[ParamArgs]", GenMethodParameters(t, pTable));
wMethod.Replace("[MethodName]", t.ToString());
wMethod.Replace("[RetType]", GetRetType(pTable, t));
wMethod.Replace("[StoredProcedureName]", GetSPName(pTable, t));
wMethod.Replace("[Parameters]", GenSPParameters(pTable, t));
wMethod.Replace("[Declarations]", GenDeclaration(pTable, t));
wMethod.Replace("[Return]", GenMethodReturn(pTable, t));
return(wMethod.ToString());
}
static string GenCodeInsertParameters(TableViewBase pTable, CodeGeneratorCommon.MethodActionType action)
{
StringBuilder wBuilder = new StringBuilder();
StringBuilder wParamBuilder;
foreach (Column c in pTable.Columns)
{
if (IsColumnValidToInsert(c))
{
wParamBuilder = BuildParameter(c, action, true, true);
wBuilder.Append(wParamBuilder.ToString());
}
}
RemoveChars(wBuilder, 3);
return(wBuilder.ToString());
}
/// <summary>
///
/// </summary>
/// <param name="pMethodInfo"></param>
/// <returns></returns>
/// <author>Marcelo Oviedo</author>
static string GenCodeInsertValues(TableViewBase pTable, CodeGeneratorCommon.MethodActionType action)
{
StringBuilder wBuilder = new StringBuilder();
foreach (Column wColumn in pTable.Columns)
{
//wColumn.Selected
if (IsColumnValidToInsert(wColumn))
{
wBuilder.AppendLine(string.Concat("@", wColumn.Name, ","));
}
}
RemoveChars(wBuilder, 3);
return(wBuilder.ToString());
}
/// <summary>
/// Genera código de parámetros de un procedimiento almacenado de borrado.
/// </summary>
/// <param name="pMethodInfo">información del método para generar stored procedure.</param>
/// <returns>Código fuente generado.</returns>
/// <date>2007-5-25T00:00:00</date>
/// <author>Marcelo Oviedo</author>
static string GenCodeDeleteParameters(TableViewBase pTable, CodeGeneratorCommon.MethodActionType action)
{
StringBuilder wBuilder = new StringBuilder();
foreach (Column wColumn in pTable.Columns)
{
if (wColumn.InPrimaryKey) //&& wColumn.Selected)
{
StringBuilder wParamBuilder = BuildParameter(wColumn, action, false, false);
wBuilder.Append(wParamBuilder.ToString());
}
}
RemoveChars(wBuilder, 3);
return(wBuilder.ToString());
}
/// <summary>
///
/// </summary>
/// <param name="pMethodInfo"></param>
/// <returns></returns>
/// <author>Marcelo Oviedo</author>
static string GenCodeInsertFields(TableViewBase pTable, CodeGeneratorCommon.MethodActionType action)
{
StringBuilder wBuilder = new StringBuilder();
foreach (Column wColumn in pTable.Columns)
{
//!wColumn.Autogenerated && wColumn.Selected &&
if (IsColumnValidToInsert(wColumn))
{
wBuilder.AppendLine(wColumn.Name);
wBuilder.Append(",");
}
}
RemoveChars(wBuilder, 2);
return(wBuilder.ToString());
}
static void GenCodeGetByParam(TableViewBase pTable, string pSpBody, CodeGeneratorCommon.MethodActionType action, List <GeneratedCode> pProceduresCode)
{
GeneratedCode wCode = null;
try
{
String wSPCode = GenerateStoreSearchByParam(pTable);
wCode = new GeneratedCode();
wCode.Code.Append(wSPCode);
wCode.MethodActionType = action;
wCode.Id = pTable.Name;
pProceduresCode.Add(wCode);
}
finally
{
wCode = null;
}
}
/// <summary>
/// Genera el listado de campos para el update
/// </summary>
/// <param name="pMethodInfo"></param>
/// <returns>string</returns>
/// <author>Marcelo Oviedo</author>
static string GenCodeUpdateSetStatements(TableViewBase pTable, CodeGeneratorCommon.MethodActionType action)
{
StringBuilder wBuilder = new StringBuilder();
foreach (Column wColumn in pTable.Columns)
{
if (!wColumn.Identity)//&& wColumn.Selected)
{
wBuilder.Append(wColumn.Name);
wBuilder.Append(" = @");
wBuilder.Append(wColumn.Name);
wBuilder.Append(",\r\n");
}
}
RemoveChars(wBuilder, 3);
return(wBuilder.ToString());
}
private static string GenMethodReturn(TableViewBase pTable, CodeGeneratorCommon.MethodActionType t)
{
StringBuilder wBuilderReturn = null;
switch (t)
{
case CodeGeneratorCommon.MethodActionType.Insert:
{
Column pPK = FwkGeneratorHelper.GetPrimaryKey(pTable);
if (pPK != null)
{
wBuilderReturn = new StringBuilder(" cmd.ExecuteNonQuery();");
wBuilderReturn.AppendLine(FwkGeneratorHelper.TemplateDocument.GetTemplate("InsertReturn").Content);
wBuilderReturn.Replace(CodeGeneratorCommon.CommonConstants.CONST_ENTITY_PROPERTY_NAME, pPK.Name);
wBuilderReturn.Replace(CodeGeneratorCommon.CommonConstants.CONST_TYPENAME, FwkGeneratorHelper.GetCSharpType(pPK));
return(wBuilderReturn.ToString());
}
else
{
return(" cmd.ExecuteNonQuery();");
}
}
case CodeGeneratorCommon.MethodActionType.Update:
return(" cmd.ExecuteNonQuery();");
case CodeGeneratorCommon.MethodActionType.SearchByParam:
wBuilderReturn = new StringBuilder(FwkGeneratorHelper.TemplateDocument.GetTemplate("SearchReturn").Content);
return(wBuilderReturn.ToString());
case CodeGeneratorCommon.MethodActionType.Delete:
return(" cmd.ExecuteNonQuery();");
}
return(string.Empty);
}
/// <summary>
/// Retorno del metodo
/// </summary>
/// <param name="pTable"></param>
/// <param name="pMethodActionType"></param>
/// <returns></returns>
static string GetRetType(TableViewBase pTable, CodeGeneratorCommon.MethodActionType pMethodActionType)
{
String wBuilder = string.Empty;
Column c = FwkGenerator.GetPrimaryKey(pTable);
switch (pMethodActionType)
{
case CodeGeneratorCommon.MethodActionType.Insert:
case CodeGeneratorCommon.MethodActionType.Update:
case CodeGeneratorCommon.MethodActionType.Delete:
wBuilder = "void";
break;
case CodeGeneratorCommon.MethodActionType.SearchByParam:
wBuilder = string.Concat(pTable.Name, "List");
break;
case CodeGeneratorCommon.MethodActionType.GetByParam:
wBuilder = pTable.Name;
break;
}
return(wBuilder);
}
/// <summary>
/// Constructor por defecto.
/// </summary>
/// <author>Marcelo Oviedo</author>
public GeneratedCode()
{
_Id = string.Empty;
_Code = new StringBuilder();
_MethodActionType = new CodeGeneratorCommon.MethodActionType();
}
/// <summary>
/// Genera código fuente de un parámetro del procedimiento almacenado a partir de un campo de la tabla.
/// </summary>
/// <param name="pTableFieldInfo">información sobre el parámetro a generar.</param>
/// <param name="pActionType">Tipo de Acción a realizar por el procedimiento almacenado.</param>
/// <param name="pSetDirection">Dirección del parámetro.</param>
/// <param name="pSetDefaultNull">Indica si se pasa NULL como valor por defecto.</param>
/// <returns>Código fuente del parámetro.</returns>
/// <date>2007-5-25T00:00:00</date>
/// <author>Marcelo Oviedo</author>
static StringBuilder BuildParameter(Column pColumn,
CodeGeneratorCommon.MethodActionType pActionType, bool pSetDirection, bool pSetDefaultNull)
{
string wDirection = string.Empty;
StringBuilder wBuilder = new StringBuilder();
wBuilder.Append("\t");
wBuilder.Append(FwkGeneratorHelper.GetParameterPattern(pColumn));
//@Nombre
wBuilder.Replace("[Name]", "@" + pColumn.Name);
if (pColumn.DataType.ToString().ToLower().Contains("image"))
{
wBuilder.Replace("[Type]", "varbinary");
}
else
{
wBuilder.Replace("[Type]", pColumn.DataType.ToString());
}
if (pColumn.DataType.MaximumLength != -1 && pColumn.DataType.MaximumLength != 0)
{
wBuilder.Replace("[Length]", pColumn.DataType.MaximumLength.ToString());
}
else
{
wBuilder.Replace("[Length]", "max");
}
wBuilder.Replace("[Precision]", pColumn.DataType.NumericPrecision.ToString());
wBuilder.Replace("[Scale]", pColumn.DataType.NumericScale.ToString());
if (pSetDirection)
{
ParameterDirection wParamDirection = ((pColumn.InPrimaryKey) && (pActionType == CodeGeneratorCommon.MethodActionType.Insert)) ? ParameterDirection.Output : ParameterDirection.Input;
switch (wParamDirection)
{
case System.Data.ParameterDirection.Input:
{
wDirection = String.Empty;
break;
}
case System.Data.ParameterDirection.Output:
{
wDirection = "OUTPUT";
break;
}
case System.Data.ParameterDirection.InputOutput:
{
wDirection = String.Empty;
break;
}
default:
{
wDirection = string.Empty;
break;
}
}
}
wBuilder.Replace("[Direction]", wDirection);
if (pSetDefaultNull && pColumn.Nullable)
{
wBuilder.Append(" = NULL");
}
wBuilder.Append(",\r\n");
return(wBuilder);
}
/// <summary>
/// Constructor por defecto.
/// </summary>
/// <author>Marcelo Oviedo</author>
public GeneratedCode()
{
_Id = string.Empty;
_Code = new StringBuilder();
_MethodActionType = new CodeGeneratorCommon.MethodActionType();
}
static string GenSPParameters(TableViewBase pTable, CodeGeneratorCommon.MethodActionType pMethodActionType)
{
StringBuilder wParams = new StringBuilder();
switch (pMethodActionType)
{
case CodeGeneratorCommon.MethodActionType.Insert:
foreach (Column c in pTable.Columns)
{
if (!FwkGenerator.NotSupportTypes_ToIncludeInBackEnd.Contains(c.DataType.SqlDataType.ToString().ToLower()))
{
if (c.InPrimaryKey)
{
wParams.Append(GetOutParameter(pTable, c));
}
else
{
wParams.Append(GetInParameter(pTable, c));
}
}
}
break;
case CodeGeneratorCommon.MethodActionType.Update:
foreach (Column c in pTable.Columns)
{
if (!FwkGenerator.NotSupportTypes_ToIncludeInBackEnd.Contains(c.DataType.SqlDataType.ToString().ToLower()))
{
wParams.Append(GetInParameter(pTable, c));
}
}
break;
case CodeGeneratorCommon.MethodActionType.Delete:
Column cPK = FwkGenerator.GetPrimaryKey(pTable);
if (cPK != null)
{
wParams.Append(GetInParameter(cPK.Name, FwkGenerator.GetDbType(cPK)));
}
else
{
wParams.Append(GetInParameter("Id", "System.Data.DbType.Int32"));
}
break;
case CodeGeneratorCommon.MethodActionType.SearchByParam:
foreach (Column c in pTable.Columns)
{
if (FwkGenerator.GeColumnFindeable(c))
{
wParams.Append(GetInParameter(pTable, c));
}
}
break;
case CodeGeneratorCommon.MethodActionType.Get:
wParams.Append(string.Empty);
break;
}
return(wParams.ToString());
}
