/// <summary>
/// 取得sql
/// </summary>
/// <param name="sqlCode"></param>
/// <param name="para"></param>
/// <returns></returns>
public static string getSql(string sqlCode, DataTable para, int rowNo)
{
//取得sql文
string sql = "";
//数据库类型 access db2
string dbType = ConfigurationSettings.AppSettings["dbType"];
//access
if (DBTYPE.access.ToString().Equals(dbType) == true)
{
sql = XmlRW.GetSqlFormXML(getConfigPath("UserSqlConfig.xml"), sqlCode + "_A");
sql = FormatSql_A(sql.ToLower(), para, rowNo);
}
else if (DBTYPE.db2.ToString().Equals(dbType) == true)
{
sql = XmlRW.GetSqlFormXML(getConfigPath("UserSqlConfig.xml"), sqlCode + "_D");
sql = FormatSql_D(sql.ToLower(), para, rowNo);
}
else if (DBTYPE.oracle.ToString().Equals(dbType) == true)
{
sql = XmlRW.GetSqlFormXML(getConfigPath("UserSqlConfig.xml"), sqlCode + "_O");
sql = FormatSql_O(sql.ToLower(), para, rowNo);
}
return(sql);
}
//public
/// <summary>
/// 取得sql
/// </summary>
/// <param name="sqlCode"></param>
/// <param name="para"></param>
/// <returns></returns>
public static string getSql(string sqlCode, string para)
{
//取得sql文
string sql = "";
//数据库类型 1：access 2：db2 3:oracle
string dbType = ConfigurationSettings.AppSettings["dbType"];
//access
if (DBTYPE.access.ToString().Equals(dbType) == true)
{
sql = XmlRW.GetSqlFormXML(getConfigPath("UserSqlConfig.xml"), sqlCode + "_A");
sql = FormatSql_A(sql, para);
}
else if (DBTYPE.db2.ToString().Equals(dbType) == true)
{
sql = XmlRW.GetSqlFormXML(getConfigPath("UserSqlConfig.xml"), sqlCode + "_D");
sql = FormatSql_D(sql, para);
}
else if (DBTYPE.oracle.ToString().Equals(dbType) == true)
{
sql = XmlRW.GetSqlFormXML(getConfigPath("UserSqlConfig.xml"), sqlCode + "_O");
sql = FormatSql_O(sql, para);
}
return(sql);
}
