internal int InsertLog(ValidCode_SendLog log)
{
string sql = @"INSERT INTO [ValidCode_SendLog]
([mobile]
,[randomcode]
,[Content]
,[sendtime]
,[send_serialnum]
,[returnmsg]
,[source]
,[sendip])
VALUES
(@mobile
,@radomcode
,@Content
,@sendtime
,@send_serialnum
,@returnmsg
,@source
,@sendip)";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.AddParam("@mobile", log.mobile);
cmd.AddParam("@radomcode", log.randomcode);
cmd.AddParam("@Content", log.Content);
cmd.AddParam("@sendtime", log.sendtime);
cmd.AddParam("@send_serialnum", log.send_serialnum);
cmd.AddParam("@returnmsg", log.returnmsg);
cmd.AddParam("@source", log.source);
cmd.AddParam("@sendip", log.sendip);
return(cmd.ExecuteNonQuery());
}
internal ValidCode_SendLog GetLasterLogByMobile(string mobile, string source)
{
string sql = "SELECT top 1 [id] ,[mobile] ,[randomcode] ,[Content] ,[sendtime] ,[send_serialnum] ,[returnmsg] ,[source] ,[sendip] FROM [ValidCode_SendLog] where mobile='" + mobile + "' and source='" + source + "' and CONVERT(varchar(19), sendtime,120)>'" + DateTime.Now.AddMinutes(-30).ToString("yyyy-MM-dd HH:mm:ss") + "' order by id desc";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
ValidCode_SendLog log = null;
using (var read = cmd.ExecuteReader())
{
if (read.Read())
{
log = new ValidCode_SendLog
{
id = read.GetValue <int>("id"),
mobile = read.GetValue <string>("mobile"),
randomcode = read.GetValue <string>("randomcode"),
Content = read.GetValue <string>("content"),
sendtime = read.GetValue <DateTime>("sendtime"),
send_serialnum = read.GetValue <int>("send_serialnum"),
returnmsg = read.GetValue <string>("returnmsg"),
source = read.GetValue <string>("source"),
sendip = read.GetValue <string>("sendip")
};
}
}
return(log);
}
public int InsertLog(ValidCode_SendLog log)
{
using (var helper = new SqlHelper())
{
int r = new InternalValidCode_SendLog(helper).InsertLog(log);
return(r);
}
}
