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