/// <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(MethodActionType pMethodActionType, Table pTable)
{
StringBuilder wBuilder = new StringBuilder(FwkGeneratorHelper.TemplateDocument.GetTemplate("ParameterSummary").Content);
switch (pMethodActionType)
{
case MethodActionType.Insert:
case MethodActionType.Update:
case MethodActionType.GetByParam:
case MethodActionType.SearchByParam:
wBuilder.Replace("[MethodParameterName]", pTable.Name);
wBuilder.Replace("[ParameterName]", pTable.Name);
break;
case MethodActionType.Delete:
Column pPK = FwkGeneratorHelper.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 GenSPParameters_Batch(Table pTable, MethodActionType pMethodActionType)
{
StringBuilder wParams = new StringBuilder();
int i = 0;
bool appendProperty = true;
Column primaryKey = FwkGeneratorHelper.GetPrimaryKey(pTable);
foreach (Column c in pTable.Columns)
{
i++;
if (pMethodActionType == MethodActionType.Insert ||
pMethodActionType == MethodActionType.Update)
{
if (primaryKey != null)
{
appendProperty = !(primaryKey == c && pMethodActionType == 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>
/// Retorno del metodo
/// </summary>
/// <param name="pTable"></param>
/// <param name="pMethodActionType"></param>
/// <returns></returns>
static string GetSPName(Table pTable, MethodActionType pMethodActionType)
{
String sufix = string.Empty;
switch (pMethodActionType)
{
case MethodActionType.Insert:
sufix = "_i";
break;
case MethodActionType.GetByParam:
sufix = "_gp";
break;
case MethodActionType.Update:
sufix = "_u";
break;
case MethodActionType.Delete:
sufix = "_d";
break;
case MethodActionType.SearchByParam:
sufix = "_sp";
break;
case MethodActionType.Get:
sufix = "_g";
break;
}
return(string.Concat(pTable.Name, sufix));
}
/// <summary>
/// Genera código de parámetros de llamado a un método.
/// </summary>
/// <param name="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(MethodActionType pMethodActionType, Table pTable)
{
String wBuilder = string.Empty;
switch (pMethodActionType)
{
case MethodActionType.Insert:
case MethodActionType.Update:
case MethodActionType.GetByParam:
case MethodActionType.SearchByParam:
wBuilder = string.Concat(pTable.Name, " p", pTable.Name);
break;
case MethodActionType.Delete:
Column pPK = FwkGeneratorHelper.GetPrimaryKey(pTable);
if (pPK != null)
{
FwkGeneratorHelper.GetCSharpType(pPK);
wBuilder = String.Concat(FwkGeneratorHelper.GetCSharpType(pPK), " p", pPK.Name);
}
else
{
wBuilder = String.Concat("int pId");
}
break;
}
return(wBuilder);
}
private static string GenMethodReturn(Table pTable, MethodActionType t)
{
StringBuilder wBuilderReturn = null;
switch (t)
{
case MethodActionType.Insert:
{
Column pPK = FwkGeneratorHelper.GetPrimaryKey(pTable);
if (pPK != null)
{
wBuilderReturn = new StringBuilder(FwkGeneratorHelper.TemplateDocument.GetTemplate("InsertReturn").Content);
wBuilderReturn.Replace(CommonConstants.CONST_ENTITY_PROPERTY_NAME, pPK.Name);
wBuilderReturn.Replace(CommonConstants.CONST_TYPENAME, FwkGeneratorHelper.GetCSharpType(pPK));
return wBuilderReturn.ToString();
}
else
return " wDataBase.ExecuteNonQuery(wCmd);";
}
case MethodActionType.Update:
return " wDataBase.ExecuteNonQuery(wCmd);";
case MethodActionType.SearchByParam:
wBuilderReturn = new StringBuilder(FwkGeneratorHelper.TemplateDocument.GetTemplate("SearchReturn").Content);
return wBuilderReturn.ToString();
case MethodActionType.Delete:
return " wDataBase.ExecuteNonQuery(wCmd);";
}
return string.Empty;
}
static string GenBatchMethod(Table pTable, MethodActionType t)
{
StringBuilder wMethod = new StringBuilder(FwkGeneratorHelper.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();
}
static string GenBatchMethod(Table pTable, MethodActionType t)
{
StringBuilder wMethod = new StringBuilder(FwkGeneratorHelper.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(Table pTable, MethodActionType t)
{
switch (t)
{
case MethodActionType.GetByParam:
case MethodActionType.SearchByParam:
{
return(FwkGeneratorHelper.TemplateDocument.GetTemplate("EntityAnListDeclaration").Content);
}
}
return(string.Empty);
}
static string GenMethod(Table pTable, 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 GenMethod(Table pTable, 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());
}
private static string GenMethodReturn(Table pTable, MethodActionType t)
{
StringBuilder wBuilderReturn = null;
switch (t)
{
case MethodActionType.Insert:
{
Column pPK = FwkGeneratorHelper.GetPrimaryKey(pTable);
if (pPK != null)
{
wBuilderReturn = new StringBuilder(FwkGeneratorHelper.TemplateDocument.GetTemplate("InsertReturn").Content);
wBuilderReturn.Replace(CommonConstants.CONST_ENTITY_PROPERTY_NAME, pPK.Name);
wBuilderReturn.Replace(CommonConstants.CONST_TYPENAME, FwkGeneratorHelper.GetCSharpType(pPK));
return(wBuilderReturn.ToString());
}
else
{
return(" wDataBase.ExecuteNonQuery(wCmd);");
}
}
case MethodActionType.Update:
return(" wDataBase.ExecuteNonQuery(wCmd);");
case MethodActionType.SearchByParam:
wBuilderReturn = new StringBuilder(FwkGeneratorHelper.TemplateDocument.GetTemplate("SearchReturn").Content);
return(wBuilderReturn.ToString());
case MethodActionType.Delete:
return(" wDataBase.ExecuteNonQuery(wCmd);");
}
return(string.Empty);
}
/// <summary>
/// Retorno del metodo
/// </summary>
/// <param name="pTable"></param>
/// <param name="pMethodActionType"></param>
/// <returns></returns>
static string GetRetType(Table pTable, MethodActionType pMethodActionType)
{
String wBuilder = string.Empty;
Column c = FwkGeneratorHelper.GetPrimaryKey(pTable);
switch (pMethodActionType)
{
case MethodActionType.Insert:
case MethodActionType.Update:
case MethodActionType.Delete:
wBuilder = "void";
break;
case MethodActionType.SearchByParam:
wBuilder = string.Concat(pTable.Name, "List");
break;
case MethodActionType.GetByParam:
wBuilder = pTable.Name;
break;
}
return(wBuilder);
}
private static string GenDeclaration(Table pTable, MethodActionType t)
{
switch (t)
{
case MethodActionType.GetByParam:
case MethodActionType.SearchByParam:
{
return FwkGeneratorHelper.TemplateDocument.GetTemplate("EntityAnListDeclaration").Content;
}
}
return string.Empty;
}
static string GenSPParameters_Batch(Table pTable, MethodActionType pMethodActionType)
{
StringBuilder wParams = new StringBuilder();
int i = 0;
bool appendProperty = true;
Column primaryKey = FwkGeneratorHelper.GetPrimaryKey(pTable);
foreach (Column c in pTable.Columns)
{
i++;
if (pMethodActionType == MethodActionType.Insert ||
pMethodActionType == MethodActionType.Update)
{
if (primaryKey != null)
appendProperty = !(primaryKey == c && pMethodActionType == 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();
}
static string GenSPParameters(Table pTable, MethodActionType pMethodActionType)
{
StringBuilder wParams = new StringBuilder();
switch (pMethodActionType)
{
case MethodActionType.Insert:
foreach (Column c in pTable.Columns)
{
if (!FwkGeneratorHelper.NotSupportTypes_ToIncludeInBackEnd.Contains(c.DataType.SqlDataType.ToString().ToLower()))
{
if (c.InPrimaryKey)
{
wParams.Append(GetOutParameter(pTable, c));
}
else
{
wParams.Append(GetInParameter(pTable, c));
}
}
}
break;
case MethodActionType.Update:
foreach (Column c in pTable.Columns)
{
if (!FwkGeneratorHelper.NotSupportTypes_ToIncludeInBackEnd.Contains(c.DataType.SqlDataType.ToString().ToLower()))
{
wParams.Append(GetInParameter(pTable, c));
}
}
break;
case MethodActionType.Delete:
Column cPK = FwkGeneratorHelper.GetPrimaryKey(pTable);
if (cPK != null)
wParams.Append(GetInParameter(cPK.Name, FwkGeneratorHelper.GetDBType(cPK)));
else
wParams.Append(GetInParameter("Id", "System.Data.DbType.Int32"));
break;
case MethodActionType.SearchByParam:
foreach (Column c in pTable.Columns)
{
if (FwkGeneratorHelper.GeColumnFindeable(c))
wParams.Append(GetInParameter(pTable, c));
}
break;
case MethodActionType.Get:
wParams.Append(string.Empty);
break;
}
return wParams.ToString();
}
/// <summary>
/// Retorno del metodo
/// </summary>
/// <param name="pTable"></param>
/// <param name="pMethodActionType"></param>
/// <returns></returns>
static string GetSPName(Table pTable, MethodActionType pMethodActionType)
{
String sufix = string.Empty;
switch (pMethodActionType)
{
case MethodActionType.Insert:
sufix = "_i";
break;
case MethodActionType.GetByParam:
sufix = "_gp";
break;
case MethodActionType.Update:
sufix = "_u";
break;
case MethodActionType.Delete:
sufix = "_d";
break;
case MethodActionType.SearchByParam:
sufix = "_sp";
break;
case MethodActionType.Get:
sufix = "_g";
break;
}
return string.Concat(pTable.Name, sufix);
}
/// <summary>
/// Retorno del metodo
/// </summary>
/// <param name="pTable"></param>
/// <param name="pMethodActionType"></param>
/// <returns></returns>
static string GetRetType(Table pTable, MethodActionType pMethodActionType)
{
String wBuilder = string.Empty;
Column c = FwkGeneratorHelper.GetPrimaryKey(pTable);
switch (pMethodActionType)
{
case MethodActionType.Insert:
case MethodActionType.Update:
case MethodActionType.Delete:
wBuilder = "void";
break;
case MethodActionType.SearchByParam:
wBuilder = string.Concat(pTable.Name, "List");
break;
case MethodActionType.GetByParam:
wBuilder = pTable.Name;
break;
}
return wBuilder;
}
/// <summary>
/// Genera código de parámetros de llamado a un método.
/// </summary>
/// <param name="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(MethodActionType pMethodActionType, Table pTable)
{
String wBuilder = string.Empty;
switch (pMethodActionType)
{
case MethodActionType.Insert:
case MethodActionType.Update:
case MethodActionType.GetByParam:
case MethodActionType.SearchByParam:
wBuilder = string.Concat(pTable.Name, " p", pTable.Name);
break;
case MethodActionType.Delete:
Column pPK = FwkGeneratorHelper.GetPrimaryKey(pTable);
if (pPK != null)
{
FwkGeneratorHelper.GetCSharpType(pPK);
wBuilder = String.Concat(FwkGeneratorHelper.GetCSharpType(pPK), " p", pPK.Name);
}
else
{
wBuilder = String.Concat("int pId");
}
break;
}
return wBuilder;
}
/// <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(MethodActionType pMethodActionType, Table pTable)
{
StringBuilder wBuilder = new StringBuilder(FwkGeneratorHelper.TemplateDocument.GetTemplate("ParameterSummary").Content);
switch (pMethodActionType)
{
case MethodActionType.Insert:
case MethodActionType.Update:
case MethodActionType.GetByParam:
case MethodActionType.SearchByParam:
wBuilder.Replace("[MethodParameterName]", pTable.Name);
wBuilder.Replace("[ParameterName]", pTable.Name);
break;
case MethodActionType.Delete:
Column pPK = FwkGeneratorHelper.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 GenSPParameters(Table pTable, MethodActionType pMethodActionType)
{
StringBuilder wParams = new StringBuilder();
switch (pMethodActionType)
{
case MethodActionType.Insert:
foreach (Column c in pTable.Columns)
{
if (!FwkGeneratorHelper.NotSupportTypes_ToIncludeInBackEnd.Contains(c.DataType.SqlDataType.ToString().ToLower()))
{
if (c.InPrimaryKey)
{
wParams.Append(GetOutParameter(pTable, c));
}
else
{
wParams.Append(GetInParameter(pTable, c));
}
}
}
break;
case MethodActionType.Update:
foreach (Column c in pTable.Columns)
{
if (!FwkGeneratorHelper.NotSupportTypes_ToIncludeInBackEnd.Contains(c.DataType.SqlDataType.ToString().ToLower()))
{
wParams.Append(GetInParameter(pTable, c));
}
}
break;
case MethodActionType.Delete:
Column cPK = FwkGeneratorHelper.GetPrimaryKey(pTable);
if (cPK != null)
{
wParams.Append(GetInParameter(cPK.Name, FwkGeneratorHelper.GetDBType(cPK)));
}
else
{
wParams.Append(GetInParameter("Id", "System.Data.DbType.Int32"));
}
break;
case MethodActionType.SearchByParam:
foreach (Column c in pTable.Columns)
{
if (FwkGeneratorHelper.GeColumnFindeable(c))
{
wParams.Append(GetInParameter(pTable, c));
}
}
break;
case MethodActionType.Get:
wParams.Append(string.Empty);
break;
}
return(wParams.ToString());
}
