public static bool File_Batch_FolderID(List <File> filelist)
{
try
{
using (var conn = DbHelper.ResourceService())
{
var recordparam = new List <SqlDataRecord>();
var recordcolumn = new[]
{
new SqlMetaData("id", SqlDbType.Int)
};
foreach (var r in filelist)
{
var record = new SqlDataRecord(recordcolumn);
record.SetInt32(0, r.FileID);
recordparam.Add(record);
}
var ids = new TableValueParameter("@ids", "IDList", recordparam);
conn.Execute("File_Batch_FolderID", ids, commandType: CommandType.StoredProcedure);
return(true);
}
}
catch (Exception e)
{
return(false);
}
}
public virtual Task <IEnumerable <TAny> > QueryAsync <TAny>(string query, TableValueParameter tableValueParameter, CommandType commandType) where TAny : class
{
return(Task.FromResult(Query <TAny>(query, tableValueParameter, commandType)));
}
public virtual Task <int> ExecuteAsync(string query, TableValueParameter tableValueParameter, CommandType commandType)
{
return(Task.FromResult(Execute(query, tableValueParameter, commandType)));
}
public abstract int Execute(string query, TableValueParameter tableValueParameter, CommandType commandType);
public abstract IEnumerable <TAny> Query <TAny>(string query, TableValueParameter tableValueParameter, CommandType commandType) where TAny : class;
public override Task <int> ExecuteAsync(string query, TableValueParameter tableValueParameter, CommandType commandType)
{
return(Connection.ExecuteAsync(query, tableValueParameter, ActiveTransaction, commandType: commandType));
}
public override Task <IEnumerable <TAny> > QueryAsync <TAny>(string query, TableValueParameter tableValueParameter, CommandType commandType)
{
return(Connection.QueryAsync <TAny>(query, tableValueParameter, ActiveTransaction, commandType: commandType));
}
