public int ExecuteNonQuery(string filepath, string query, string[] parameters, ExcelProperties properties) { filepath = getCannolizePath(filepath); //logger.Trace("ExecuteNonQuery(string filepath, string query, string[] parameters, ExcelProperties properties)"); if (string.IsNullOrEmpty(filepath)) { throw new Exception(ExcelResources.DataSourceEmpty); } if (string.IsNullOrEmpty(query)) { throw new Exception(ExcelResources.QueryEmpty); } OpenXmlClient con = new OpenXmlClient(); return(con.ExecuteNonQuery(query, parameters, filepath));; }
public DataTable GetOleDbSchemaTable(string filepath, Guid schema, string[] parameters, ExcelProperties properties) { filepath = getCannolizePath(filepath); if (string.IsNullOrEmpty(filepath)) { throw new Exception(ExcelResources.DataSourceEmpty); } if (schema == null || string.IsNullOrEmpty(schema.ToString())) { throw new Exception(ExcelResources.SchemaEmpty); } OpenXmlClient openxmlcon = new OpenXmlClient(); DataTable openxmltbl = openxmlcon.GetSchemaTable(filepath); return(openxmltbl); }
public int ExecuteMultipleQuery(string filepath, string[] query, ExcelProperties properties) { filepath = getCannolizePath(filepath); if (string.IsNullOrEmpty (filepath)) { throw new Exception(ExcelResources.DataSourceEmpty); } if (query.Length == 0) { throw new Exception(ExcelResources.QueryEmpty); } OpenXmlClient con = new OpenXmlClient(); con.ExecuteMultipleQuery(filepath, query); return(1); }