/// <summary>
/// 大批量数据插入
/// </summary>
/// <param name="tableNamelist">表名数组</param>
/// <param name="dtlist">数据表数组</param>
/// <param name="isPkIdentitylist">是否保留标志源</param>
public static List <OrganizationExecuteResult> BatchCopyInsert(List <string> tableNameList, List <DataTable> dtList, List <bool> isPkIdentitylist)
{
List <OrganizationExecuteResult> result = new List <OrganizationExecuteResult>();
var organizationEntitys = new ConnectionHelper().GetOrganizationEntitys();
foreach (var organizationEntity in organizationEntitys)
{
OrganizationExecuteResult organizationExecuteResult = new OrganizationExecuteResult();
organizationExecuteResult.Code = organizationEntity.Code;
organizationExecuteResult.Name = organizationEntity.Name;
var sqlHelper = new SqlHelper();
organizationExecuteResult.Data = sqlHelper.BatchCopyInsert(tableNameList, dtList, isPkIdentitylist);
result.Add(organizationExecuteResult);
}
return(result);
}
/// <summary>
/// 获取数据
/// </summary>
/// <param name="cmdType"></param>
/// <param name="cmdText"></param>
/// <param name="spr"></param>
/// <returns></returns>
public static List <OrganizationExecuteResult> GetDataSet(CommandType cmdType, string cmdText, List <SqlParameter> spr)
{
List <OrganizationExecuteResult> result = new List <OrganizationExecuteResult>();
var organizationEntitys = new ConnectionHelper().GetOrganizationEntitys();
foreach (var organizationEntity in organizationEntitys)
{
OrganizationExecuteResult organizationExecuteResult = new OrganizationExecuteResult();
organizationExecuteResult.Code = organizationEntity.Code;
organizationExecuteResult.Name = organizationEntity.Name;
ISqlHelper sqlHelper = SqlConvertHelper.GetInstallSqlHelper(organizationEntity.Connectionstring);
organizationExecuteResult.Data = sqlHelper.GetDataSet(cmdType, cmdText, spr);
result.Add(organizationExecuteResult);
}
return(result);
}
