public static Phone_codemodel GetNoteRecord(string openid, int comid)
{
var list = new Phone_codemodel();
using (var helper = new SqlHelper())
{
list = new Phone_code(helper).GetNoteRecord1(openid, comid);
return(list);
}
}
public static Phone_codemodel code_info(decimal phone, int comid, string openid)
{
var list = new Phone_codemodel();
using (var helper = new SqlHelper())
{
list = new Phone_code(helper).codemodel(phone, comid, openid);
return(list);
}
}
private Phone_codemodel GetNoteRecord1(string openid, int comid)
{
var sqltxt = "";
sqltxt = @"select * from Phone_code where openid=@openid and comid=@comid and codebool=@codebool and DATEDIFF(minute,codetime,GETDATE()) <= 30 order by codetime desc";
var cmd = sqlHelper.PrepareTextSqlCommand(sqltxt);
cmd.CommandType = CommandType.Text;
cmd.AddParam("@comid", comid);
cmd.AddParam("@codebool", 1);
cmd.AddParam("@openid", openid);
using (var reader = cmd.ExecuteReader())
{
Phone_codemodel codeinfo = null;
if (reader.Read())
{
codeinfo = new Phone_codemodel
{
Id = reader.GetValue <int>("Id"),
Comid = reader.GetValue <int>("comid"),
Phone = reader.GetValue <decimal>("phone"),
Code = reader.GetValue <decimal>("code"),
Codebool = reader.GetValue <int>("codebool"),
Codenum = reader.GetValue <int>("codenum"),
Codetime = reader.GetValue <DateTime>("codetime"),
Openid = reader.GetValue <string>("openid")
};
}
reader.Close();
sqltxt = @"update Phone_code set codebool=0 where DATEDIFF(minute,codetime,GETDATE()) > 30 and codebool=1 ";
cmd = sqlHelper.PrepareTextSqlCommand(sqltxt);
cmd.ExecuteNonQuery();
return(codeinfo);
}
}
