private static string GerarSolectNode(SqlTable sqlTable, SqlReference sref, int seq)
{
StringBuilder builder = new StringBuilder();
StringBuilder builder2 = new StringBuilder();
SqlTable table = SqlTable.GetTable(sref.PkTable);
if (seq == 0)
{
sref = sqlTable.References[1];
}
else
{
sref = sqlTable.References[0];
}
if (seq == 0)
{
if (sqlTable.Colunas[1].SqlDataType != "text")
{
builder2.Append(sqlTable.Colunas[1].NetDataType + " " + sqlTable.Colunas[1].Name + "_, ");
}
}
else
{
if (sqlTable.Colunas[0].SqlDataType != "text")
{
builder2.Append(sqlTable.Colunas[0].NetDataType + " " + sqlTable.Colunas[0].Name + "_, ");
}
}
builder.AppendLine(string.Concat(new object[] { "\t\t/// <summary>\n\t\t/// Busca os " + table.ClassBusinessNome + " na base atrav\x00e9s do parametro\n\t\t/// </summary>\n\t\tpublic DbDataReader Get_", table.ClassBusinessNome, "(", builder2.Remove(builder2.Length - 2, 2), ")" }));
builder.AppendLine("\t\t{");
builder.AppendLine("\t\t\ttry");
builder.AppendLine("\t\t\t{");
builder.AppendLine("\t\t\t\tcmd = new SqlCommand();");
builder.AppendLine("\t\t\t\tcmd.CommandType = CommandType.StoredProcedure;");
builder.AppendLine("\t\t\t\tcmd.CommandText = \"usp_" + Program.sulfixSelect + sqlTable.ProcNome + "\";");
if (seq == 0)
{
if (sqlTable.Colunas[1].SqlDataType != "text")
{
builder.AppendLine("\t\t\t\tcmd.Parameters.AddWithValue(\"@" + sref.FkColumnName + "\", " + sqlTable.Colunas[1].Name + "_);");
}
}
else
{
if (sqlTable.Colunas[0].SqlDataType != "text")
{
builder.AppendLine("\t\t\t\tcmd.Parameters.AddWithValue(\"@" + sref.FkColumnName + "\", " + sqlTable.Colunas[0].Name + "_);");
}
}
builder.AppendLine();
builder.AppendLine(Tab(4) + "OpenConnection();");
builder.AppendLine("\t\t\t\treturn cmd.ExecuteReader(CommandBehavior.CloseConnection);");
builder.AppendLine("\t\t\t}");
builder.AppendLine("\t\t\tcatch (SqlException sex){ throw sex; }");
builder.AppendLine("\t\t\tcatch (Exception ex){ throw ex; }");
builder.AppendLine("\t\t}");
return(builder.ToString());
}
public void CreateEventLog(Enum_EVENTLOGTYPE eventLogType, string description, int clientCaseID, TransactionManager trans, SqlReference sqlRef)
{
var sqlRelationShips = new List <SqlRelationship>();
if (sqlRef != null)
{
sqlRelationShips.Add(new SqlRelationship("ClientCaseID", sqlRef.Guid));
}
trans.Insert(new MediFast.dbo.T_EVENTLOG()
{
ClientCaseID = clientCaseID,
CreatedBy = this.Config.UserInfo.ID,
EventLogType = eventLogType,
Description = description
}, sqlRelationShips.ToArray());
}
