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