//从active表删除数据
public int EmailActiveDelete(EmailOrPhoneActive active)
{
SqlParameter[] parms =
{
data.MakeInParam("@UserName", SqlDbType.VarChar, 50, active.username),
data.MakeInParam("@ActiveCode", SqlDbType.VarChar, 50, active.activecode),
};
return(data.RunProc("delete from activecode where username=@UserName and activecode=@ActiveCode", parms));
}
//从active表查询数据
public DataSet EmailActiveSelect(EmailOrPhoneActive active)
{
SqlParameter[] parms =
{
data.MakeInParam("@UserName", SqlDbType.VarChar, 50, active.username),
data.MakeInParam("@ActiveCode", SqlDbType.VarChar, 50, active.activecode),
};
//return data.RunProcReturn("select * from active where username=@UserName and activecode=@ActiveCode",parms);
return(data.RunProcReturn("SELECT * FROM activecode WHERE username = @UserName and activecode=@ActiveCode", parms, "activecode"));
}
//往activecode表里插入一条数据
public int EmailActivateInsert(EmailOrPhoneActive active)
{
SqlParameter[] parms =
{
data.MakeInParam("@UserName", SqlDbType.VarChar, 50, active.username),
data.MakeInParam("@ActiveCode", SqlDbType.VarChar, 50, active.activecode),
};
data.RunProc("insert into activecode(username,activecode) values(@UserName,@ActiveCode)", parms);
return(0);
}
