protected override object ExcecuteDataWithMultiple(SqlGenerator sqlGenerator)
{
var list = new List <DepartmentVM>();
var list2 = new List <DepartmentVM>();
var list3 = new List <DepartmentVM>();
DbExceute.Exceute(sqlGenerator, ((command) =>
{
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
list = reader.GenerateList <DepartmentVM>();// Mapper.Map<System.Data.IDataReader, List<DepartmentVM>>(reader); // for 1st result
}
reader.NextResult();
if (reader.HasRows)
{
list2 = reader.GenerateList <DepartmentVM>();// Mapper.Map<System.Data.IDataReader, List<DepartmentVM>>(reader); // for 2nd result
}
reader.NextResult();
if (reader.HasRows)
{
list3 = reader.GenerateList <DepartmentVM>();
}
; // Mapper.Map<System.Data.IDataReader, List<DepartmentVM>>(reader); // for 3rd result
}
}));
return(list);
}
protected virtual List <TVm> ExcecuteData(SqlGenerator sqlGenerator)
{
var list = new List <TVm>();
DbExceute.Exceute(sqlGenerator, ((command) =>
{
using (var reader = command.ExecuteReader())
if (reader.HasRows)
{
list = reader.GenerateList <TVm>();
}
}));
return(list);
}
protected virtual int Excecute(BaseForm form, SqlGenerator sqlGenerator)
{
var id = 0;
DbExceute.Exceute(sqlGenerator, ((command) =>
{
if (sqlGenerator.OperationType == SqlOperationType.Insert)
{
id = Convert.ToInt32((decimal)command.ExecuteScalar());
}
else
{
command.ExecuteNonQuery();
id = form.Id;
}
}));
return(id);
}
