public void AddMagForAPPSMS(string tel, string token, string phoneType)
{
using (var ctx = new MetalSmsSendEntities())
{
var sms = new app_sms();
sms.mobile = tel;
sms.SMSTitle = "退出";
sms.content = token;
sms.Mid = "admin";
sms.st = false;
sms.timestamp = DateTime.Now;
sms.Url = phoneType;
ctx.app_sms.Add(sms);
ctx.SaveChanges();
//Log.WriteLog("Login,count>0", "tel=" + tel + ",token=" + token);
}
}
private void sendSms(string mobile, string msg)
{
using (var ctx = new MetalSmsSendEntities())
{
ProvideSm sms = new ProvideSm();
sms.Tel = mobile;
sms.Message = msg;
sms.AddDate = DateTime.Now;
sms.SendInt = 0;
sms.Mid = "admin";
sms.SMSTitle = "上海同鑫";
sms.st = false;
sms.Stop_Flag = false;
ctx.ProvideSms.Add(sms);
ctx.SaveChanges();
}
}
//下拉，获取日期之后的所有
private List <InboxVM> GetInBoxMsgByPullDown(string mobile, DateTime date)
{
var list = new List <InboxVM>();
using (var ctx = new MetalSmsSendEntities())
{
//var log = ctx.App_Log.FirstOrDefault(o => o.mobile.Contains(mobile) && o.ErrCode == "1");
//if (log != null)
//{
// var tel = log.mobile;
list = ctx.App_Log.Where(o => o.mobile == mobile && o.ErrCode == "1" && o.Date > date).OrderByDescending(o => o.Date)
.Select(o => new InboxVM {
Id = o.ID, Date = o.Date, Msg = o.Msg, Url = o.Url
}).ToList();
//}
}
return(list);
}
public List <InboxVM> GetInBoxMsgByMobile(string mobile)
{
var list = new List <InboxVM>();
using (var ctx = new MetalSmsSendEntities())
{
//DateTime end = DateTime.Today.AddDays(1);
//DateTime start = end.AddDays(-2);
//var log = ctx.App_Log.FirstOrDefault(o => o.mobile.Contains(mobile) && o.ErrCode == "1");
//if (log != null)
//{
//var tel = log.mobile;
var count = ctx.App_Log.Count(o => o.mobile == mobile && o.ErrCode == "1");
if (count > 0)
{
list = ctx.App_Log.Where(o => o.mobile == mobile && o.ErrCode == "1").OrderByDescending(o => o.Date).Take(count < 30 ? count : 30)
.Select(o => new InboxVM {
Id = o.ID, Date = o.Date, Msg = o.Msg, Url = o.Url
}).ToList();
}
//}
}
return(list);
}