//public static bool CheckImportTable(int iType, UserInfo user, ref string strError) //{ // switch (iType) // { // case 1: // Basic.Area.Area_DB areadb = new Basic.Area.Area_DB(); // return areadb.CheckImportTable(ref strError); // case 2: // Stock.Stock_DB stockdb = new Stock.Stock_DB(); // return stockdb.CheckImportTable(ref strError); // default: // strError = "找不到对应的导入类型"; // return false; // } //} public static bool UpLoadSql(List <string> lstSql, User.UserModel user, ref string strError) { if (lstSql == null || lstSql.Count <= 0) { strError = "上传数据不能为空"; return(false); } if (OracleDBHelper.ExecuteNonQueryList(lstSql, ref strError) >= 1) { return(true); } else { if (string.IsNullOrEmpty(strError)) { try { OracleDBHelper.ExecuteNonQuery2(CommandType.Text, lstSql[0], null); if (lstSql.Count >= 2) { OracleDBHelper.ExecuteNonQuery2(CommandType.Text, lstSql[1], null); } } catch (Exception ex) { strError = ex.Message; } } return(false); } }
public int GetExecuteNonQuery(string strSql) { try { return(OracleDBHelper.ExecuteNonQuery2(CommandType.Text, strSql).ToInt32()); } catch (Exception ex) { throw new Exception(ex.Message); } }