/// <summary>
/// 查询订单修改历史(默认取订单的Log)
/// </summary>
/// <param name="orderId"></param>
/// <param name="objectType"></param>
/// <returns></returns>
//public List<OprLog> SelectOrderOprLog(int orderId, string objectType = "Order")
//{
// var list = dbManager.Execute(connection => DalOprLog.SelectOrderOprLog(connection, orderId, objectType));
// if (string.Equals(objectType, "Order"))
// {
// var wmsList = new OperationLogManager().SelectOrderOprLog(orderId, objectType);
// foreach (var item in wmsList)
// {
// var oprLog = new OprLog
// {
// PKID = item.PKID,
// Author = item.Operator,
// Operation = item.Operation,
// AfterValue = item.Detail,
// BeforeValue = item.Detail,
// ChangeDatetime = item.LastUpdateTime,
// LogType = "WMS"
// };
// list.Add(oprLog);
// }
// }
// return list.OrderByDescending(x => x.ChangeDatetime).ToList();
//}
//public OprLog SelectLog(int logId, string logType = "OprLog")
//{
// OprLog oprLog = null;
// if (string.Equals(logType, "WMS"))
// {
// var WMSLog = new OperationLogManager().GetOperationLog(logId);
// if (WMSLog != null)
// {
// oprLog = new OprLog
// {
// PKID = WMSLog.PKID,
// ChangeDatetime = WMSLog.LastUpdateTime,
// Author = WMSLog.CreatedBy,
// Operation = WMSLog.Operation,
// BeforeValue = "",
// AfterValue = WMSLog.Detail
// };
// }
// else
// {
// throw new OprLogException(logId, "在WMS.OperationLog中没有找到该日志编号对应的详细信息");
// }
// }
// else
// {
// oprLog = dbManager.Execute(connection => DalOprLog.SelectLog(connection, logId, logType));
// }
// return oprLog;
//}
public List <BizEmailProcess> SelectEmailProcessesByOrderNo(DateTime startDateTime, DateTime endDateTime,
string orderNo, string userTel)
{
ParameterChecker.CheckNull(startDateTime, "startDateTime");
ParameterChecker.CheckNull(endDateTime, "endDateTime");
ParameterChecker.CheckNull(orderNo, "orderNo");
ParameterChecker.CheckNull(userTel, "userTel");
return(DalOprLog.SelectEmailProcessesByOrderNo(startDateTime, endDateTime, orderNo, userTel));
}
/// <summary>
/// 添加营销短信
/// </summary>
/// <param name="emailProcess"></param>
public void AddMarketingSms(BizEmailProcess emailProcess)
{
ParameterChecker.CheckNull(emailProcess.ToMail, "emailProcess.ToMail");
ParameterChecker.CheckNullOrWhiteSpace(emailProcess.Subject, "emailProcess.Subject");
ParameterChecker.CheckNullOrWhiteSpace(emailProcess.Body, "emailProcess.Body");
ParameterChecker.CheckNullOrEmpty(emailProcess.RelatedUser, "emailProcess.RelatedUser");
ParameterChecker.CheckNull(emailProcess.OrderID, "emailProcess.OrderID");
dbManager.Execute(connection => DalOprLog.AddMarketingSms(connection, emailProcess));
}
public void AddShopOprLog <T, D>(int shopId, string objType, int objId, string operation, T beforeValue, D afterValue, string Remark)
where T : class
where D : class
{
ParameterChecker.CheckNullOrEmpty(objType, "objType");
ParameterChecker.CheckNullOrEmpty(operation, "operation");
var oprLog = new ShopEditOprLog();
oprLog.ShopID = shopId;
oprLog.ObjectType = objType;
oprLog.ObjectID = objId;
oprLog.ChangeDatetime = DateTime.Now;
oprLog.Operation = operation;
oprLog.Author = ThreadIdentity.Operator.Name;
oprLog.IPAddress = ThreadIdentity.Operator.IPAddress;
oprLog.Remark = Remark;
if (typeof(T) == typeof(string))
{
oprLog.BeforeValue = (string)(object)beforeValue;
}
else
{
if (beforeValue != null)
{
var valueBuilder = new StringBuilder();
foreach (var property in typeof(T).GetProperties())
{
var value = property.GetValue(beforeValue, null);
valueBuilder.AppendFormat("{0} = {1}", property.Name, value ?? "NULL").AppendLine();
}
oprLog.BeforeValue = valueBuilder.ToString();
}
}
if (typeof(D) == typeof(string))
{
oprLog.AfterValue = (string)(object)afterValue;
}
else
{
if (afterValue != null)
{
var valueBuilder = new StringBuilder();
foreach (var property in typeof(D).GetProperties())
{
var value = property.GetValue(afterValue, null);
valueBuilder.AppendFormat("{0} = {1}", property.Name, value ?? "NULL").AppendLine();
}
oprLog.AfterValue = valueBuilder.ToString();
}
}
dbManager.Execute(connection => DalOprLog.AddShopEditOprLog(connection, oprLog));
}
/// <summary>
/// 拼接保养短信
/// </summary>
/// <param name="orderId"></param>
/// <returns></returns>
//public string GetBaoYangEmailProcess(int orderId)
//{
// var bizOrder = dbManager.Execute(connection => DalOrder.SelectOrderByOrderId(connection, orderId));
// var orderHash =
// WebSecurity.Hash(string.Concat(bizOrder.Refno, bizOrder.UserId,
// bizOrder.OrderDatetime.ToString("yyyy-MM-dd HH:mm")));
// var shortUrl =
// TuhuUtil.GetShortUrl(string.Format(ConfigurationManager.AppSettings["LongUrl"], orderId, orderHash));
// if (bizOrder.OrderChannel.Contains("天猫"))
// {
// bizOrder.OrderChannel = "天猫";
// }
// else
// if (bizOrder.OrderChannel.Contains("淘宝"))
// {
// bizOrder.OrderChannel = "淘宝";
// }
// string message = string.Format(ConfigurationManager.AppSettings["MaintainPackageMessage"], bizOrder.UserName, bizOrder.OrderChannel, bizOrder.Refno, shortUrl);
// //new JobServerManager().SendMaintainPackageMessage(item.OrderId, item.Refno, item.UserId.ToString(),
// // item.OrderDatetime, item.UserName, item.UserTel, item.OrderChannel);
// return message;
//}
///// <summary>
///// 直接发短信
///// </summary>
//public void SendMaintainPackageMessage(int orderId, BizEmailProcess bizEmailProcess)
//{
// var item = dbManager.Execute(connection => DalOrder.SelectOrderByOrderId(connection, orderId));
// new JobServerManager().SendMaintainPackageMessage(item.OrderId, item.OrderNo, item.Refno, item.UserId.ToString(),
// item.OrderDatetime, item.UserName, bizEmailProcess.ToMail, item.OrderChannel);
//}
#region 门店日志
public void AddShopOprLog(ShopEditOprLog oprLog)
{
ParameterChecker.CheckNull(oprLog, "oprLog");
if (string.IsNullOrEmpty(oprLog.Author))
{
oprLog.Author = ThreadIdentity.Operator.Name;
}
if (string.IsNullOrEmpty(oprLog.IPAddress))
{
oprLog.IPAddress = ThreadIdentity.Operator.IPAddress;
}
dbManager.Execute(connection => DalOprLog.AddShopEditOprLog(connection, oprLog));
}
public bool IsExistsEmailSendingMark(int OrderId, string EmailType = "到店短信")
{
return(dbManager.Execute(connection => DalOprLog.IsExistsEmailSendingMark(connection, OrderId, EmailType)));
}
public void AddEmailProcess(int orderId, BizEmailProcess emailProcess)
{
dbManager.Execute(connection => DalOprLog.AddEmailProcess(connection, orderId, emailProcess));
}
public List <BizEmailProcess> SelectSMSHistoryBySearchVal(string searchType, int pageIndex, int pageSize, string toMail, string orderNo)
{
return(DalOprLog.SelectSMSHistoryBySearchVal(searchType, pageIndex, pageSize, toMail, orderNo));
}
public void AddSystemOperationTimeLog(int orderId, string description)
{
dbManager.Execute(
connection => DalOprLog.AddSystemOperationTimeLog(connection, orderId, description));
}
public void InsertOrderInstalledEmailProcess(int orderId)
{
dbManager.Execute(
connection => DalOprLog.InsertOrderInstalledEmailProcess(connection, orderId));
}
public bool CheckEmailIsSent(string body)
{
ParameterChecker.CheckNullOrEmpty(body, "body");
return(DalOprLog.CheckEmailIsSent(body));
}
public bool AddEmailProcessList(List <BizEmailProcess> emailProcess)
{
return(dbManager.Execute(connection => DalOprLog.AddEmailProcessList(connection, emailProcess)));
}
