public static DataSet GetDataTables(List <string> tableNames) { try { if (tableNames == null || tableNames.Count == 0) { return(null); } DbWebSvc.DbWebSvcSoapClient dbsc = new DbWebSvc.DbWebSvcSoapClient(); DataSet ds = dbsc.GetDataTables(tableNames.ToArray()); if (ds == null || ds.Tables.Count == 0) { return(null); } else { return(ds); } } catch (Exception ex) { MessageBox.Show(ex.Message); return(null); } }
public static void InsertWithParams(string tableName, DbParam[] dbParams) { try { DbWebSvc.DbWebSvcSoapClient dbsc = new DbWebSvc.DbWebSvcSoapClient(); dbsc.InsertWithParam(tableName, SerializeObject(dbParams)); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public static void ExecuteBatchSql(List <string> sqlList) { try { DbWebSvc.DbWebSvcSoapClient dbsc = new DbWebSvc.DbWebSvcSoapClient(); dbsc.ExecuteBatchSQL(sqlList.ToArray()); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public static void ExecuteSql(string strSql) { try { DbWebSvc.DbWebSvcSoapClient dbsc = new DbWebSvc.DbWebSvcSoapClient(); dbsc.ExecuteSql(strSql); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public static void ExecuteSP(string procName, DbParam[] dbParams) { try { //DbWebSvc.MySqlParameter[] ops = GetMySqlParameters(dbParams); DbWebSvc.DbWebSvcSoapClient dbsc = new DbWebSvc.DbWebSvcSoapClient(); dbsc.ExecuteStoredProcedure(procName, SerializeObject(dbParams)); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public static void UpdateWithParams_2(string tableName, DbParam[] dbParams, int keyNum) { try { //DbWebSvc.MySqlParameter[] ops = GetMySqlParameters(dbParams); DbWebSvc.DbWebSvcSoapClient dbsc = new DbWebSvc.DbWebSvcSoapClient(); dbsc.UpdateWithParam_2(tableName, SerializeObject(dbParams), keyNum); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public static DataTable GetDataTableFromSql(string strSql) { try { DbWebSvc.DbWebSvcSoapClient dbsc = new DbWebSvc.DbWebSvcSoapClient(); DataSet ds = dbsc.GetDataFromSql(strSql); if (ds == null || ds.Tables.Count == 0) { return(null); } else { return(ds.Tables[0]); } } catch (Exception ex) { MessageBox.Show(ex.Message); return(null); } }