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); } }