本文整理汇总了C#中APB.Mercury.DataObjects.SCPWeb.ConnectionInfo类的典型用法代码示例。如果您正苦于以下问题：C# ConnectionInfo类的具体用法？C# ConnectionInfo怎么用？C# ConnectionInfo使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
ConnectionInfo类属于APB.Mercury.DataObjects.SCPWeb命名空间，在下文中一共展示了ConnectionInfo类的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的C#代码示例。
示例1: GetAllEscalaMesAtuacao
public static DataTable GetAllEscalaMesAtuacao(
ConnectionInfo pInfo,
String pESC_DIA,
decimal pATUA_ID
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = EscalaQD.qEscalaAtividadeList;
lQuery += " WHERE ESC_STATUS NOT IN ('I','E') ";
lQuery += " AND A.ATDEF_ID = B.ATDEF_ID ";
lQuery += string.Format(" AND A.{0} = >>{0} ", EscalaQD._ATUA_ID.Name);
lQuery += string.Format(" AND to_char(A.{0}, 'mm') = to_char(>>{0}, 'mm')", EscalaQD._ESC_DIA.Name);
lQuery += string.Format(" AND to_char(A.{0}, 'yyyy') = to_char(>>{0}, 'yyyy')", EscalaQD._ESC_DIA.Name);
lQuery += "Order By ESC_DIA ";
SelectCommand lSelect = new SelectCommand(lQuery);
lSelect.Fields.Add(EscalaQD._ATUA_ID.Name, pATUA_ID, (ItemType)EscalaQD._ATUA_ID.DBType);
lSelect.Fields.Add(EscalaQD._ESC_DIA.Name, pESC_DIA, (ItemType)EscalaQD._ESC_DIA.DBType);
lSelect.Fields.Add(EscalaQD._ESC_DIA.Name, pESC_DIA, (ItemType)EscalaQD._ESC_DIA.DBType);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
开发者ID:andreibaptista，项目名称:DEF_PUB_CALC，代码行数:27，代码来源:EscalaDo.cs
示例2: GetDeterminacaoSecretariaByNUC_ID
public static DataTable GetDeterminacaoSecretariaByNUC_ID(
decimal pNUC_ID,
decimal pPESF_ID,
decimal pDTMSEC_SITUACAO,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = DeterminacaoSecretariaQD.qDeterminacaoSecretariaList;
lQuery += string.Format(" WHERE DTMSEC_STATUS='A' AND {0} = >>{0}", DeterminacaoSecretariaQD._NUC_ID.Name);
if (pPESF_ID != 0)
lQuery += string.Format(" AND DTMSEC_PESF_PEDIDO = {0}", pPESF_ID);
if (pDTMSEC_SITUACAO != 0)
lQuery += string.Format(" AND DTMSEC_SITUACAO = {0}", pDTMSEC_SITUACAO);
lQuery += " ORDER BY DTMSEC_ID";
SelectCommand lSelect = new SelectCommand(lQuery);
lSelect.Fields.Add(DeterminacaoSecretariaQD._NUC_ID.Name, pNUC_ID, (ItemType)DeterminacaoSecretariaQD._NUC_ID.DBType);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
开发者ID:andreibaptista，项目名称:DEF_PUB_CALC，代码行数:29，代码来源:DeterminacaoSecretariaDo.cs
示例3: VerifyLogin
public static LoginUserDo VerifyLogin(string pEUSR, string pEusr_Password, string pEusr_Type, ConnectionInfo pConnectionInfo)
{
bool lReturn;
string lQuery;
DataTable lTable;
lQuery = UsersQD.qUsersList;
lTable = new DataTable();
if (pEusr_Type == "1")//Portal Garagem
{
lQuery += String.Format(" WHERE {0} = >>{0} AND {1} = >>{1} ", UsersQD._USR_LOGIN.Name, UsersQD._USR_PASSWORD.Name);
lQuery += " AND USR_STATUS='A' ";
SelectCommand lSelect = new SelectCommand(lQuery);
pEusr_Password = APB.Framework.Encryption.Crypto.Encode(pEusr_Password);
lSelect.Fields.Add(UsersQD._USR_LOGIN.Name, pEUSR, (ItemType)UsersQD._USR_LOGIN.DBType);
lSelect.Fields.Add(UsersQD._USR_PASSWORD.Name, pEusr_Password, (ItemType)UsersQD._USR_PASSWORD.DBType);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pConnectionInfo));
}
lReturn = (lTable.Rows.Count > 0) ? true : false;
// User Accept, Check TP_ID
if (lReturn)
{
return new LoginUserDo((decimal)lTable.Rows[0]["USR_ID"], (string)lTable.Rows[0]["USR_LOGIN"]);
}
return null;
}
开发者ID:andreibaptista，项目名称:DEF_PUB_CALC，代码行数:34，代码来源:UsersDo.cs
示例4: AutenticacaoNpj
public static DataTable AutenticacaoNpj(ConnectionInfo pConnectionInfo, string pSusr_Login, string pSusr_Senha)
{
DataTable lTable = new DataTable();
string lQuery = "";
pSusr_Senha = APB.Framework.Encryption.Crypto.Encode(pSusr_Senha);
lQuery = SystemUserQD.qAutenticacaoNpj;
lQuery += String.Format(" WHERE {0} = >>{0} AND {1} = >>{1} ", SystemUserQD._SUSR_LOGIN.Name, SystemUserQD._SUSR_PASSWORD.Name);
lQuery += " AND A.PES_ID = B.PES_ID ";
lQuery += " AND B.PES_ID = C.PES_ID ";
lQuery += " AND C.PESF_STATUS = 'A' ";
lQuery += " AND A.SUSR_STATUS = 'A' ";
lQuery += " AND C.SET_ID = D.SET_ID ";
lQuery += " AND N.NUC_ID = D.NUC_ID ";
lQuery += " AND N.NUC_ID = SN.NUC_ID ";
lQuery += " AND A.SUSR_ID = SN.SUSR_ID ";
lQuery += " AND C.FUNC_ID = E.FUNC_ID ";
SelectCommand lSelect = new SelectCommand(lQuery);
lSelect.Fields.Add(SystemUserQD._SUSR_LOGIN.Name, pSusr_Login, (ItemType)SystemUserQD._SUSR_LOGIN.DBType);
lSelect.Fields.Add(SystemUserQD._SUSR_PASSWORD.Name, pSusr_Senha, (ItemType)SystemUserQD._SUSR_PASSWORD.DBType);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pConnectionInfo));
return lTable;
}
开发者ID:andreibaptista，项目名称:DEF_PUB_CALC，代码行数:28，代码来源:SystemUserDo.cs
示例5: GetCountProcessoTamitacaoPedente
public static DataTable GetCountProcessoTamitacaoPedente(
decimal pCategoria,
string pLoginName,
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
if (pCategoria == (decimal)Categoria.Tramitação)
lQuery = DocumentoTramitacaoQD.qCountTramitacaoProcesso;
else if (pCategoria == (decimal)Categoria.TramitaçãoPetição)
lQuery = DocumentoTramitacaoQD.qCountTramitacaoPeticao;
else if (pCategoria == (decimal)Categoria.TramitaçãoProcessoExterno)
lQuery = DocumentoTramitacaoQD.qCountTramitacaoProcessoExterno;
else if (pCategoria == (decimal)Categoria.TramitaçãoOfício)
lQuery = DocumentoTramitacaoQD.qCountTramitacaoOficio;
lQuery += " AND DOC.DOC_REGUSER = '" + pLoginName + "' ";
lQuery += " AND DOCTRAM.nuc_dest_id is null ";
//SelectCommand lSelect = new SelectCommand(lQuery);
//lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
OracleDo lOra = new OracleDo();
lTable = lOra.Consulta(lQuery, pInfo.ConnectionString);
return lTable;
}
开发者ID:andreibaptista，项目名称:DEF_PUB_CALC，代码行数:31，代码来源:DocumentoTramitacaoDo.cs
示例6: GetAllTipoPessoa
public static DataTable GetAllTipoPessoa(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = PessoaQD.qTipoPessoa;
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
开发者ID:andreibaptista，项目名称:DEF_PUB_CALC，代码行数:14，代码来源:PessoaDo.cs
示例7: GetAllNucleoxLocalidade
public static DataTable GetAllNucleoxLocalidade(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = NucleoxLocalidadeQD.qNucleoxLocalidadeList;
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
开发者ID:andreibaptista，项目名称:DEF_PUB_CALC，代码行数:14，代码来源:NucleoxLocalidadeDo.cs
示例8: GetAllSector
public static DataTable GetAllSector(ConnectionInfo pInfo)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = sectorQD.qsectorList;
lQuery += " WHERE SECT_STATUS = 'A'";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
开发者ID:andreibaptista，项目名称:DEF_PUB_CALC，代码行数:14，代码来源:sectorDo.cs
示例9: GetAllTable
public static DataTable GetAllTable(ConnectionInfo pInfo)
{
string lQuery = "";
DataTable lTable;
lQuery = InformationSchemaQd.qAllTables;
lQuery += " ORDER BY TABLE_NAME";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
开发者ID:andreibaptista，项目名称:DEF_PUB_CALC，代码行数:14，代码来源:InformationSchemaDo.cs
示例10: GetAllColumn
public static DataTable GetAllColumn(string pTABLE_NAME, ConnectionInfo pInfo)
{
string lQuery = "";
DataTable lTable;
lQuery = string.Format(InformationSchemaQd.qAllColumn, pTABLE_NAME);
lQuery += " ORDER BY COLUMN_NAME";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
开发者ID:andreibaptista，项目名称:DEF_PUB_CALC，代码行数:14，代码来源:InformationSchemaDo.cs
示例11: GetAllRelatorioAtualizacao
public static DataTable GetAllRelatorioAtualizacao(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = RelatorioAtualizacaoQD.qRelatorioAtualizacaoList;
lQuery += " WHERE RLT_STATUS='A'";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
开发者ID:andreibaptista，项目名称:DEF_PUB_CALC，代码行数:15，代码来源:RelatorioAtualizacaoDo.cs
示例12: GetAllDocumentoxAssuntoPsicossocial
public static DataTable GetAllDocumentoxAssuntoPsicossocial(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = DocumentoxAssuntoPsicossocialQD.qDocumentoxAssuntoPsicossocialList;
lQuery += " WHERE DOCASSPS_STATUS='A'";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
开发者ID:andreibaptista，项目名称:DEF_PUB_CALC，代码行数:15，代码来源:DocumentoxAssuntoPsicossocialDo.cs
示例13: GetUsuariosAlunoNpj
public static DataTable GetUsuariosAlunoNpj(ConnectionInfo pInfo, string pNucleo)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = ALUNOXATENDIMENTONPJQD.qUsuariosNpj;
lQuery += " WHERE UG.GRP_ID = 1";
lQuery += " ORDER BY PES.PES_NOME ";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
开发者ID:andreibaptista，项目名称:DEF_PUB_CALC，代码行数:15，代码来源:ALUNOXATENDIMENTONPJDo.cs
示例14: GetAllDocumentosApresentados
public static DataTable GetAllDocumentosApresentados(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = DocumentosApresentadosQD.qDocumentosApresentadosList;
lQuery += " WHERE DOCAP_STATUS NOT IN ('I','E') ";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
开发者ID:andreibaptista，项目名称:DEF_PUB_CALC，代码行数:15，代码来源:DocumentosApresentadosDo.cs
示例15: GetAllVisitasSocioEducativas
public static DataTable GetAllVisitasSocioEducativas(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = VisitasSocioEducativasQD.qVisitasSocioEducativasList;
lQuery += " WHERE VTSCE_STATUS='A'";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
开发者ID:andreibaptista，项目名称:DEF_PUB_CALC，代码行数:15，代码来源:VisitasSocioEducativasDo.cs
示例16: GetAllEEProcedimento
public static DataTable GetAllEEProcedimento(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = EEProcedimentoQD.qEEProcedimentoList;
lQuery += " WHERE EEPCD_STATUS='A' ORDER BY EEPCD_DESCRICAO";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
开发者ID:andreibaptista，项目名称:DEF_PUB_CALC，代码行数:15，代码来源:EEProcedimentoDo.cs
示例17: GetAllDocumentoxEEDestino
public static DataTable GetAllDocumentoxEEDestino(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = DocumentoxEEDestinoQD.qDocumentoxEEDestinoList;
lQuery += " WHERE DOCEEDST_STATUS='A'";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
开发者ID:andreibaptista，项目名称:DEF_PUB_CALC，代码行数:15，代码来源:DocumentoxEEDestinoDo.cs
示例18: GetAllCalendarioJuridico
public static DataTable GetAllCalendarioJuridico(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = CalendarioJuridicoQD.qCalendarioJuridicoList;
lQuery += " WHERE CLDJ_STATUS='A' ORDER BY CLDJ_DIA";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
开发者ID:andreibaptista，项目名称:DEF_PUB_CALC，代码行数:15，代码来源:CalendarioJuridicoDo.cs
示例19: GetAllPessoa
public static DataTable GetAllPessoa(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = PessoaQD.qPessoaList;
lQuery += " WHERE PES_STATUS NOT IN ('I','E')";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
开发者ID:andreibaptista，项目名称:DEF_PUB_CALC，代码行数:15，代码来源:PessoaDo.cs
示例20: GetAllTipoInteressado
public static DataTable GetAllTipoInteressado(
ConnectionInfo pInfo
)
{
string lQuery = "";
DataTable lTable = new DataTable();
lQuery = TipoInteressadoQD.qTipoInteressadoList;
lQuery += " WHERE TINT_STATUS='A' ORDER BY TINT_ID";
SelectCommand lSelect = new SelectCommand(lQuery);
lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));
return lTable;
}
开发者ID:andreibaptista，项目名称:DEF_PUB_CALC，代码行数:15，代码来源:TipoInteressadoDo.cs
注：本文中的APB.Mercury.DataObjects.SCPWeb.ConnectionInfo类示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。 |
客服电话
APP下载
官方微信
请发表评论