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