/// <summary>
/// 批量执行插入Sql
/// </summary>
/// <param name="str_msg"></param>
/// <param name="arr2_values"></param>
/// <param name="str_DbName"></param>
/// <param name="arr_conditionName"></param>
/// <returns></returns>
private bool InsertBseDir(out string str_msg, List <string[]> arr2_values, string str_DbName, List <string> arr_conditionName)
{
try
{
List <string> arr_strSql = new List <string>();
foreach (string[] arr_Tmp in arr2_values)
{
InsertClass _insertValues = new InsertClass();
_insertValues.DbName = str_DbName;
_insertValues.arr_conditions = arr_conditionName;
_insertValues.arr_values = arr_Tmp.ToList();
if (_insertValues.InsertOpr(out str_msg))
{
arr_strSql.Add(str_msg);
}
else
{
return(false);
}
}
return(ExecOpr(out str_msg, arr_strSql));
}
catch (Exception ex)
{
str_msg = ex.Message;
return(false);
}
}
private bool InsertBseDir(out string str_msg, List <string[]> arr2_values, string str_DbName, List <string> arr_conditionName, ref List <string> str_keyid)
{
try
{
foreach (string[] arr_Tmp in arr2_values)
{
InsertClass _insertValues = new InsertClass();
_insertValues.DbName = str_DbName;
_insertValues.arr_conditions = arr_conditionName;
_insertValues.arr_values = arr_Tmp.ToList();
if (_insertValues.InsertOpr(out str_msg))
{
try
{
_OraCon.Open();
DataSet _DataTmp = new DataSet();
string str_cmd = str_msg + ";";
str_cmd += "SELECT Seq from SQLITE_SEQUENCE where name = '" + str_DbName + "';";
OracleDataAdapter _adp = new OracleDataAdapter(str_cmd, _OraCon);
str_msg = _adp.Fill(_DataTmp).ToString();
if (_DataTmp != null && _DataTmp.Tables.Count > 0)
{
str_keyid.Add(_DataTmp.Tables[0].Rows[0][0] + "");
}
str_cmd = null;
}
catch (Exception ex)
{
str_msg = ex.Message;
return(false);
}
finally
{
_OraCon.Close();
}
}
else
{
return(false);
}
}
str_msg = str_keyid.Count().ToString();
return(true);
}
catch (Exception ex)
{
str_msg = ex.Message;
return(false);
}
}