/// <summary>
/// 导入数据
/// </summary>
/// <param name="impdto"></param>
/// <returns></returns>
public bool ImportData(List <ExcelImportDataDTO> impdtolst)
{
bool blResult = false;
using (var tcdmse = new Entities.TCDMS_MasterDataEntities())
{
foreach (var p in impdtolst)
{
if (p is ExcelCustomerInfoDTO)
{
ExcelCustomerInfoDTO exrdt = p as ExcelCustomerInfoDTO;
if (exrdt.UpLogic == 2)
{
var pp = tcdmse.master_CustomerInfo.Where(m => m.CustomerID == exrdt.CustomerID).FirstOrDefault();
pp.master_DistributorInfo = tcdmse.master_DistributorInfo.FirstOrDefault(g => g.DistributorName == exrdt.DistributorName);
pp.CustomerName = exrdt.CustomerName;
pp.Province = exrdt.Province;
pp.City = exrdt.City;
pp.OracleNO = exrdt.OracleNO;
pp.OracleName = exrdt.OracleName;
pp.XSWNO = exrdt.XSWNO;
pp.IsActive = true;
pp.ModifyUser = exrdt.Importer;
pp.ModifyTime = DateTime.Now;
}
else
{
master_CustomerInfo mprd = new master_CustomerInfo();
mprd.CustomerID = Guid.NewGuid();
mprd.master_DistributorInfo = tcdmse.master_DistributorInfo.FirstOrDefault(g => g.DistributorName == exrdt.DistributorName);
mprd.CustomerName = exrdt.CustomerName;
mprd.Province = exrdt.Province;
mprd.City = exrdt.City;
mprd.OracleNO = exrdt.OracleNO;
mprd.OracleName = exrdt.OracleName;
mprd.XSWNO = exrdt.XSWNO;
mprd.IsActive = true;
mprd.CreateUser = exrdt.Importer;
mprd.CreateTime = DateTime.Now;
tcdmse.master_CustomerInfo.Add(mprd);
// 记录日志
this.AddLog(tcdmse, new LogData
{
CurrentLogType = LogType.IMPORT,
LogDetails = "导入客户" + exrdt.CustomerName,
OpratorName = exrdt.Importer
});
}
}
}
blResult = tcdmse.SaveChanges() > 0;
}
return(blResult);
}
/// <summary>
/// 客户信息审核成功
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public bool CustomerAuditSuccess(CustomerAuditOperateDTO dto)
{
bool result = false;
using (var tcdmse = new Entities.TCDMS_MasterDataEntities())
{
var pp = tcdmse.master_CustomerApplyInfo.Where(p => p.CustomerApplyID == dto.CustomerApplyID).FirstOrDefault();
if (pp == null)
{
throw new Exception("此条申请信息不存在！");
}
pp.Auditor = dto.Auditor;
pp.AuditReason = null;
pp.AuditTime = dto.AuditTime;
pp.ModifyTime = dto.ModifyTime;
pp.ModifyUser = dto.ModifyUser;
pp.Status = dto.Status;
master_CustomerInfo newitem = new master_CustomerInfo()
{
City = pp.City,
Country = pp.Country,
CreateTime = dto.ModifyTime,
CreateUser = dto.ModifyUser,
CustomerID = pp.CustomerApplyID,
CustomerName = pp.CustomerName,
DistributorID = pp.DistributorID,
IsActive = true,
Province = pp.Province,
};
tcdmse.master_CustomerInfo.Add(newitem);
// 记录日志
this.AddLog(tcdmse, new LogData
{
CurrentLogType = LogType.ADD,
LogDetails = "新增客户" + newitem.CustomerName,
OpratorName = newitem.CreateUser
});
result = tcdmse.SaveChanges() > 0;
}
return(result);
}
/// <summary>
/// 新增客户信息
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public bool AddCustomer(CustomerOperateDTO dto)
{
bool result = false;
using (var tcdmse = new Entities.TCDMS_MasterDataEntities())
{
master_CustomerInfo newitem = new master_CustomerInfo();
Mapper.Map <CustomerOperateDTO, master_CustomerInfo>(dto, newitem);
tcdmse.master_CustomerInfo.Add(newitem);
// 记录日志
this.AddLog(tcdmse, new LogData
{
CurrentLogType = LogType.ADD,
LogDetails = "新增客户" + dto.CustomerName,
OpratorName = dto.CreateUser
});
result = tcdmse.SaveChanges() > 0;
}
return(result);
}
