|
using JiepeiWMS.IServices;
|
using JiepeiWMS.Model.Models;
|
using JiepeiWMS.Services.BASE;
|
using JiepeiWMS.IRepository.Base;
|
using System;
|
|
namespace JiepeiWMS.Services
|
{
|
public class SmsLogServices : BaseServices<SmsLog>, ISmsLogServices
|
{
|
private readonly IBaseRepository<SmsLog> _dal;
|
public SmsLogServices(IBaseRepository<SmsLog> dal)
|
{
|
this._dal = dal;
|
base.BaseDal = dal;
|
}
|
|
/// <summary>
|
/// 短信推送添加日志
|
/// </summary>
|
/// <param name="UserId">员工ID</param>
|
/// <param name="Mobile">接收短信者</param>
|
/// <param name="SendType">发送类型说明</param>
|
/// <param name="content">发送内容</param>
|
/// <param name="ResponseInfo">返回状态</param>
|
/// <param name="SmsFrom">短信接入商</param>
|
/// <param name="BatchSendNo">短信批次号，只有在批量发送有意义。</param>
|
/// <returns></returns>
|
public int AddSmssLog(int UserId, string Mobile, string SendType, string content,string ResponseInfo,string SmsFrom,string BatchSendNo)
|
{
|
|
var sql = string.Format(@"INSERT INTO dbo.[SmsLog]
|
([UserId], [Mobile], [SendType], [Content], [SendTime], [ResponseInfo], [SmsFrom], [BatchSendNo])VALUES
|
({0},'{1}','{2}','{3}','{4}','{5}','{6}','{7}')", UserId, Mobile, SendType, content, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),ResponseInfo
|
,SmsFrom,BatchSendNo
|
);
|
|
return BaseDal.ExecuteSqlCommand(sql);
|
|
}
|
}
|
}
|
