public DataTable GetEntityList()
{
using (Access3.RobotAccess dac = new Access3.RobotAccess())
{
return(dac.GetEntityList());
}
}
public DataTable GetDataTier(Int16 EntityId)
{
using (Access3.RobotAccess dac = new Access3.RobotAccess())
{
return(dac.GetDataTier(EntityId));
}
}
public DataTable GetWizardList(string searchTxt, string dbConnectionString, string dbPassword)
{
using (Access3.RobotAccess dac = new Access3.RobotAccess())
{
return(dac.GetWizardList(searchTxt, dbConnectionString, dbPassword));
}
}
private void ExecProgD(string ProcedureName, string ss, CurrPrj CPrj, CurrSrc CSrc, CurrTar CTar)
{
using (Access3.RobotAccess dac = new Access3.RobotAccess())
{
if (CPrj.SrcDesProviderCd == "S")
{
dac.ExecSql("SET QUOTED_IDENTIFIER ON SET ANSINULL ON IF EXISTS (SELECT 1 FROM dbo.sysobjects WHERE id = object_id('"
+ ProcedureName + "') AND type='P') DROP PROCEDURE " + ProcedureName
+ " EXEC('" + ss.Replace("'", "''") + "') SET QUOTED_IDENTIFIER OFF", CSrc.SrcConnectionString, CSrc.SrcDbPassword);
}
else
{
dac.ExecSql("SET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON IF EXISTS (SELECT 1 FROM dbo.sysobjects WHERE id = object_id('"
+ ProcedureName + "') AND type='P') DROP PROCEDURE " + ProcedureName
+ " EXEC('" + ss.Replace("'", "''") + "') SET QUOTED_IDENTIFIER OFF", CSrc.SrcConnectionString, CSrc.SrcDbPassword);
}
}
if (CTar.TarDbServer != CSrc.SrcDbServer && CPrj.SrcDesProviderCd == "M")
{
using (Access3.RobotAccess dac = new Access3.RobotAccess())
{
if (CPrj.TarDesProviderCd == "S")
{
dac.ExecSql("SET QUOTED_IDENTIFIER ON SET ANSINULL ON IF EXISTS (SELECT 1 FROM dbo.sysobjects WHERE id = object_id('"
+ ProcedureName + "') AND type='P') DROP PROCEDURE " + ProcedureName
+ " EXEC('" + ss.Replace("'", "''") + "') SET QUOTED_IDENTIFIER OFF", CTar.TarConnectionString, CTar.TarDbPassword);
}
else
{
dac.ExecSql("SET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON IF EXISTS (SELECT 1 FROM dbo.sysobjects WHERE id = object_id('"
+ ProcedureName + "') AND type='P') DROP PROCEDURE " + ProcedureName
+ " EXEC('" + ss.Replace("'", "''") + "') SET QUOTED_IDENTIFIER OFF", CTar.TarConnectionString, CTar.TarDbPassword);
}
}
}
}