public ReportEditManagement(string azureConnectionString)
{
_dp = new DapperDataAccess();
this.azureConnectionString = azureConnectionString;
var builder = new ConfigurationBuilder();
IConfiguration configuration = builder.Build();
_fileStorage = new AzureFileStorageServiceCommon(configuration);
_fileStorage.SetConnectionString(azureConnectionString);
_dp = new DapperDataAccess();
_indexData = new IndexDBAccess(_dp);
}
public Predictions(string azureConnectionString)
{
_azureConnectionString = azureConnectionString;
var builder = new ConfigurationBuilder();
IConfiguration configuration = builder.Build();
_fileStorage = new AzureFileStorageServiceCommon(configuration);
_fileStorage.SetConnectionString(azureConnectionString);
_dbConn = new DbUtilities();
_dp = new DapperDataAccess();
_indexData = new IndexDBAccess(_dp);
}
public bool CadastraLike(int Codigo)
{
var parceria = RetornaParceria(Codigo);
if (parceria.Count() > 0)
{
var dbArgs = new DynamicParameters(Codigo);
dbArgs.Add("Operacao", Operacao.Insert);
DapperDataAccess.ExecuteWhitoutReturn("spParceria", dbArgs);
return(true);
}
return(false);
}
// PARTE 3 inicio
public IEnumerable <ParceriaModel> RetornaLista()
{
StringBuilder sb = new StringBuilder();
sb.Append(" SELECT ");
sb.Append(" Titulo ");
sb.Append(" , ISNULL(URLPagina,'') URLPagina ");
sb.Append(" , Empresa ");
sb.Append(" , DataTermino ");
sb.Append(" , QtdLikes ");
sb.Append(" FROM dbo.vParceria ");
sb.Append(" WHERE GETDATE() BETWEEN DataInicio AND DataTermino ");
return(DapperDataAccess.ExecuteCommandReturnList <ParceriaModel>(sb.ToString()));
}
//PARTE 3
public IEnumerable <ParceriaModel> RetornaParceria(int?Codigo)
{
StringBuilder sb = new StringBuilder();
sb.Append(" SELECT ");
sb.Append(" Titulo ");
sb.Append(" , Descricao ");
sb.Append(" , ISNULL(URLPagina,'') URLPagina ");
sb.Append(" , Empresa ");
sb.Append(" , DataTermino ");
sb.Append(" FROM dbo.vParceria ");
sb.Append(" WHERE GETDATE() BETWEEN DataInicio AND DataTermino ");
if (Codigo != null)
{
sb.Append(" AND Codigo = " + Codigo);
}
return(DapperDataAccess.ExecuteCommandReturnList <ParceriaModel>(sb.ToString()));
}
public void Criar(ParceriaModel parceriaModel)
{
try
{
if (parceriaModel == null)
{
throw new Exception("Sem dados de parceria");
}
else
{
var dbArgs = new DynamicParameters(parceriaModel);
dbArgs.Add("Operacao", Operacao.Insert);
DapperDataAccess.ExecuteWhitoutReturn("spParceria", dbArgs);
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Excluir(ParceriaModel parceriaModel)
{
try
{
if ((parceriaModel == null) ||
(parceriaModel.Codigo == 0))
{
throw new Exception("Não há dados de parceria para realizar a exclusão");
}
else
{
var dbArgs = new DynamicParameters(parceriaModel);
dbArgs.Add("Operacao", Operacao.Delete);
DapperDataAccess.ExecuteWhitoutReturn("spParceria", dbArgs);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Performs tasks that happen before each test.
/// </summary>
public virtual void TestInitialize()
{
// Create connections.
PrimaryConnection = new SqlConnection(AssemblyInitialize.dbConnectionString);
PrimaryConnection.Open();
SecondaryConnection = new SqlConnection(AssemblyInitialize.dbConnectionString);
SecondaryConnection.Open();
// create the data access object.
var sharedDB = new SharedDatabase(PrimaryConnection);
MockSchema = new Mock <IDbSchemaConfiguration>();
MockSchema.Setup(s => s.Schema).Returns(DefaultSchema);
dataAccess = new DapperDataAccess(sharedDB, MockSchema.Object);
// start all tests with an Empty DB.
// each test will setup rows it needs.
BeginSecondaryTransaction();
TruncateAll();
CommitSecondaryTransaction();
}
//PARTE 3 FIM
public IEnumerable <ParceriaModel> Obter(int?Codigo)
{
StringBuilder sb = new StringBuilder();
sb.Append(" SELECT ");
sb.Append(" Codigo ");
sb.Append(" , Titulo ");
sb.Append(" , Descricao ");
sb.Append(" , URLPagina ");
sb.Append(" , Empresa ");
sb.Append(" , DataInicio ");
sb.Append(" , DataTermino ");
sb.Append(" , QtdLikes ");
sb.Append(" , DataHoraCadastro ");
sb.Append(" FROM dbo.vParceria ");
if (Codigo != null)
{
sb.Append(" WHERE Codigo = " + Codigo);
}
return(DapperDataAccess.ExecuteCommandReturnList <ParceriaModel>(sb.ToString()));
}
public IEnumerable <ParceriaModel> ObterPorTitulo(string tilulo)
{
StringBuilder sb = new StringBuilder();
sb.Append(" SELECT ");
sb.Append(" Codigo ");
sb.Append(" , Titulo ");
sb.Append(" , Descricao ");
sb.Append(" , URLPagina ");
sb.Append(" , Empresa ");
sb.Append(" , DataInicio ");
sb.Append(" , DataTermino ");
sb.Append(" , QtdLikes ");
sb.Append(" , DataHoraCadastro ");
sb.Append(" FROM dbo.vParceria ");
if (!string.IsNullOrEmpty(tilulo))
{
sb.Append(" WHERE titulo = '" + tilulo + "' ");
}
return(DapperDataAccess.ExecuteCommandReturnList <ParceriaModel>(sb.ToString()));
}
public ReportEditManagement()
{
_dp = new DapperDataAccess();
_indexData = new IndexDBAccess(_dp);
}
/// <summary>
/// 导入店铺
/// </summary>
/// <param name="request"></param>
/// <param name="files"></param>
/// <param name="merchantId"></param>
/// <returns></returns>
public async Task <ResultBase> ImportShops(HttpFileCollectionBase files, int manager)
{
if (files == null || files.Count == 0)
{
return(ResultBase <UploadExcelCheckResultModel> .Fail("请上传文件"));
}
var file = files[0];
if (file.ContentLength == 0)
{
return(ResultBase <UploadExcelCheckResultModel> .Fail("文件内容为空"));
}
string fileName = file.FileName;//取得文件名字
var fileExt = fileName.Substring(fileName.LastIndexOf('.') + 1);
string[] msExcelFiles = { "xlsx", "xls" };
if (!msExcelFiles.Any(m => m == fileExt))
{
return(ResultBase <UploadExcelCheckResultModel> .Fail("只支持EXCEL文件"));
}
var filePath = $"/Upload/Shops/";
var saveFilePath = HttpContext.Current.Server.MapPath($"~{filePath}");
if (!Directory.Exists(saveFilePath))
{
Directory.CreateDirectory(saveFilePath);
}
//改名称
var newFileName = ConvertHelper.ConvertDtToUnixTimeSpan(DateTime.Now) + "." + fileExt;
string path = saveFilePath + newFileName;//获取存储的目标地址
file.SaveAs(path);
//读取excel
var data = ExcelHelper.ReadExcelNoIndex <ExportShopsModel>(path, "店铺上传");
if (data == null || data.Count == 0)
{
return(ResultBase.Fail("没有有效数据"));
}
mLogHelper.Info($"开始执行导入快递单号,总量:{data.Count}");
//分组批量插入数据
var groups = data.GroupBy(m => m.SalemanName);
List <int> taskIds = new List <int>();
foreach (var group in groups)
{
var saleman = await salemanManager.FindByName(group.Key);
if (saleman == null)
{
continue;
}
var items = group.ToList();
List <ShopEntity> entities = new List <ShopEntity>();
var total = 0;
foreach (var item in items)
{
if (string.IsNullOrEmpty(item.Name) || string.IsNullOrEmpty(item.SalemanName))
{
continue;
}
var entity = item.Convert <ShopEntity>();
entity.SalemanId = saleman.Id;
entity.CreatedAt = DateTime.Now;
entity.CreatedBy = manager;
entities.Add(entity);
total += 1;
}
var trans = DapperDataAccess.BeginTransaction(IsolationLevel.ReadCommitted);
try
{
await shopsManager.InsertBatchAsync(entities, trans);
DapperDataAccess.Commit(trans);
}
catch (ShowMessageException ex)
{
DapperDataAccess.Rollback(trans);
return(ResultBase.Fail(ex.Message));
}
catch (Exception ex)
{
DapperDataAccess.Rollback(trans);
return(ResultBase.Fail(ex.Message));
}
}
mLogHelper.Info($"导入执行完毕");
return(ResultBase.Sucess());
}
public void TestInitialize()
{
MockSharedDatabase = new Mock <ISharedDatabase>();
dataAccess = new DapperDataAccess(MockSharedDatabase.Object, null);
}
