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