internal bool BatchAddBeautyCode(SqlConnection conn, List <CreateBeautyCodeTaskModel> list)
{
var dt = new DataTable {
TableName = "Tuhu_groupon.dbo.CreateBeautyCodeTask"
};
dt.Columns.Add(new DataColumn("MobileNumber", typeof(string)));
dt.Columns.Add(new DataColumn("Quantity", typeof(int)));
dt.Columns.Add(new DataColumn("StartTime", typeof(string)));
dt.Columns.Add(new DataColumn("EndTime", typeof(string)));
dt.Columns.Add(new DataColumn("Type", typeof(string)));
dt.Columns.Add(new DataColumn("Status", typeof(string)));
dt.Columns.Add(new DataColumn("BatchCode", typeof(string)));
dt.Columns.Add(new DataColumn("CreateUser", typeof(string)));
dt.Columns.Add(new DataColumn("MappingId", typeof(int)));
list.ForEach(item =>
{
var row = dt.NewRow();
row["MobileNumber"] = item.MobileNumber;
row["Quantity"] = item.Quantity;
row["StartTime"] = item.StartTime;
row["EndTime"] = item.EndTime;
row["Type"] = item.Type;
row["Status"] = item.Status;
row["BatchCode"] = item.BatchCode;
row["CreateUser"] = item.CreateUser;
row["MappingId"] = item.MappingId;
dt.Rows.Add(row);
});
return(DalBeautyCode.BatchAddBeautyCode(conn, dt));
}
/// <summary>
/// 分页查询上传用户批次号
/// </summary>
/// <param name="conn"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="mappingIds"></param>
/// <returns></returns>
internal Tuple <List <string>, int> SelectBatchCodesByMappingIds(SqlConnection conn, int pageIndex, int pageSize, IEnumerable <int> mappingIds)
{
Tuple <List <string>, int> result = null;
if (mappingIds != null && mappingIds.Any())
{
result = DalBeautyCode.SelectBatchCodesByMappingIds(conn, pageIndex, pageSize, mappingIds);
}
return(result);
}
/// <summary>
/// 根据批次号获取上传用户进度统计信息
/// </summary>
/// <param name="conn"></param>
/// <param name="batchCodes"></param>
/// <returns></returns>
internal List <BeautyCodeStatistics> GetBeautyCodeStatistics(SqlConnection conn, IEnumerable <string> batchCodes)
{
var totals = DalBeautyCode.SelectBeautyCodeStatisticsTotalCount(conn, batchCodes);
var counts = DalBeautyCode.SelectBeautyCodeStatisticsCount(conn, batchCodes);
var batchStatus = DalBeautyCode.SelectBeautyCodeBatchTaskStatus(conn, batchCodes);
var result = (from x in totals
join y in counts on new { x.BatchCode, x.Type, x.CreateUser, x.MappingId } equals new { y.BatchCode, y.Type, y.CreateUser, y.MappingId } into temp
from z in temp.DefaultIfEmpty()
select new BeautyCodeStatistics
{
BatchCode = x.BatchCode,
MappingId = x.MappingId,
CreateUser = x.CreateUser,
Count = (z?.Count).GetValueOrDefault(),
TotalCount = x.TotalCount,
Type = x.Type,
BuyoutOrderId = x.BuyoutOrderId,
Status = x.Status
}).ToList();
result.ForEach(x => x.Status = batchStatus?.FirstOrDefault(s => s.BatchCode.Equals(x.BatchCode))?.Status);
return(result.OrderByDescending(x => x.BatchCode).ToList());
}
internal void UpdateBeautyCodeStatus(SqlConnection conn, string batchCode, string status) => DalBeautyCode.UpdateBeautyCodeStatus(conn, batchCode, status);
internal IEnumerable <BeautyServicePackageDetailSimpleModel> GetProductsByPackageId(SqlConnection conn, int packageId) => DalBeautyCode.SelectProductsByPackageId(conn, packageId);
internal IEnumerable <BeautyServicePackageSimpleModel> GetPackagesByPackageType(SqlConnection conn, string packageType) => DalBeautyCode.SelectPackagesByPackageType(conn, packageType);
internal bool InsertCompanyUserSmsRecord(SqlConnection conn, CompanyUserSmsRecord record)
{
return(DalBeautyCode.InsertCompanyUserSmsRecord(conn, record));
}
internal IEnumerable <CompanyUserSmsRecord> SelectCompanyUserSmsRecordByBatchCode(SqlConnection conn, string batchCode)
{
return(DalBeautyCode.SelectCompanyUserSmsRecordByBatchCode(conn, batchCode));
}
