public int User_Rights_Insert_Barth(List <User_RightsInfo> _list)
{
try
{
using (SqlConnection conn = new SqlConnection(ConfigInfo.ConnectionString))
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
var bulkCopy = new SqlBulkCopy(conn);
bulkCopy.DestinationTableName = "user_rights";
bulkCopy.ColumnMappings.Add("User_Name", "User_Name");
bulkCopy.ColumnMappings.Add("funcid", "funcid");
bulkCopy.ColumnMappings.Add("authcode", "authcode");
using (var datareader = new ObjectDataReader <User_RightsInfo>(_list))
{
bulkCopy.WriteToServer(datareader);
}
}
return(0);
}
catch (Exception ex)
{
ErrorLog.log.Error(ex.ToString());
return(-1);
}
}
public int Function_Group_Insert_Batch(List <Function_GroupInfo> _list)
{
try
{
using (SqlConnection conn = new SqlConnection(ConfigInfo.ConnectionString))
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
var bulkCopy = new SqlBulkCopy(conn);
bulkCopy.DestinationTableName = "functions_group";
bulkCopy.ColumnMappings.Add("group_id", "group_id");
bulkCopy.ColumnMappings.Add("functionid", "functionid");
using (var datareader = new ObjectDataReader <Function_GroupInfo>(_list))
{
bulkCopy.WriteToServer(datareader);
}
}
return(0);
}
catch (Exception ex)
{
ErrorLog.log.Error(ex.ToString());
return(-1);
}
}